# Pulling active assets via the APi?

**URL:** <https://forums.counterparty.io/t/pulling-active-assets-via-the-api/444>\
**Category:** Counterparty\
**Created:** [September 23, 2014, 4:40pm UTC](https://forums.counterparty.io/t/pulling-active-assets-via-the-api/444 "2014-09-23T16:40:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![celticwarrior72](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@celticwarrior72](https://forums.counterparty.io/u/celticwarrior72)\
**Post date:** [September 23, 2014, 4:40pm UTC](https://forums.counterparty.io/t/pulling-active-assets-via-the-api/444/1 "2014-09-23T16:40:15Z")

</div>

I've been figuring out the counterblockd API and could use some advice on how to how to simply pull a list of assets that have more than 10 transactions in the past two weeks.&nbsp; Any advice on the most efficient way to accomplish this?

---

<div class="post-metadata">

**Author:** ![something](https://yyz2.discourse-cdn.com/flex004/user_avatar/forums.counterparty.io/something/32/240_2.png) [@something](https://forums.counterparty.io/u/something)\
**Post date:** [September 24, 2014, 8:00am UTC](https://forums.counterparty.io/t/pulling-active-assets-via-the-api/444/2 "2014-09-24T08:00:34Z")

</div>

[quote author=celticwarrior72 link=topic=664.msg3518#msg3518 date=1411504815]  
I've been figuring out the counterblockd API and could use some advice on how to how to simply pull a list of assets that have more than 10 transactions in the past two weeks.&nbsp; Any advice on the most efficient way to accomplish this?  
[/quote]  
  
  
One option from CLI is to directly query the CP database  
[https://counterparty.freshdesk.com/support/solutions/articles/5000011676-can-i-use-sqlite-to-read-database-of-counterparty](https://counterparty.freshdesk.com/support/solutions/articles/5000011676-can-i-use-sqlite-to-read-database-of-counterparty)  
Select all asset transactions from last 10 days, group by asset name and count those with more than 10 transactions.   
I haven't done this, but i think that could be one easy approach.

---

<div class="post-metadata">

**Author:** ![mtbitcoin](https://yyz2.discourse-cdn.com/flex004/user_avatar/forums.counterparty.io/mtbitcoin/32/389_2.png) [@mtbitcoin](https://forums.counterparty.io/u/mtbitcoin)\
**Post date:** [September 24, 2014, 9:09am UTC](https://forums.counterparty.io/t/pulling-active-assets-via-the-api/444/3 "2014-09-24T09:09:39Z")

</div>

[quote author=celticwarrior72 link=topic=664.msg3518#msg3518 date=1411504815]  
I've been figuring out the counterblockd API and could use some advice on how to how to simply pull a list of assets that have more than 10 transactions in the past two weeks.&nbsp; Any advice on the most efficient way to accomplish this?  
[/quote]  
  
Define by what do you mean 'transactions'. As in send/receives only?

---

<div class="post-metadata">

**Author:** ![weex](https://avatars.discourse-cdn.com/v4/letter/w/41988e/32.png) [@weex](https://forums.counterparty.io/u/weex)\
**Post date:** [September 24, 2014, 7:44pm UTC](https://forums.counterparty.io/t/pulling-active-assets-via-the-api/444/4 "2014-09-24T19:44:50Z")

</div>

Can't speak for OP but if I were looking for most active, I would include assets that have done sends, issuances, or dividends with sorted by the amount of value created or transferred (in XCP) in the transactions.