# Assets registered per year

**URL:** <https://forums.counterparty.io/t/assets-registered-per-year/6596>\
**Category:** Assets\
**Created:** [May 5, 2023, 7:02am UTC](https://forums.counterparty.io/t/assets-registered-per-year/6596 "2023-05-05T07:02:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![JPJA](https://yyz2.discourse-cdn.com/flex004/user_avatar/forums.counterparty.io/jpja/32/1324_2.png) [@JPJA](https://forums.counterparty.io/u/JPJA)\
**Post date:** [May 5, 2023, 7:02am UTC](https://forums.counterparty.io/t/assets-registered-per-year/6596/1 "2023-05-05T07:02:50Z")

</div>

Research notes:

The Counterparty DB has a `blocks` table that keeps info on each Bitcoin block.

Timestamp per year  
[https://www.epochconverter.com/timestamp-list](https://www.epochconverter.com/timestamp-list)

| Date | Timestamp | |
| --- | --- | --- |
| 2014, January 1 | 1388534400 | |
| 2015, January 1 | 1420070400 | |
| 2016, January 1 | 1451606400 | |
| 2017, January 1 | 1483228800 | |
| 2018, January 1 | **1514764800** | |
| 2019, January 1 | 1546300800 | |
| 2020, January 1 | 1577836800 | |
| 2021, January 1 | 1609459200 | |
| 2022, January 1 | 1640995200 | |
| 2023, January 1 | 1672531200 | |
| 2024, January 1 | 1704067200 | |

To get the first block of 2018, do the following DB query:

`SELECT * FROM blocks where block_time >= 1514764800 LIMIT 1`

Result **501961**.

Similarly for 2019 gives block **556459**.

To get all assets registered in 2018:

`SELECT COUNT(*) FROM assets where block_index >= 501961 and block_index < 556459`

Result **3610** assets were registered in 2018.

To exclude numeric assets, ignore those that begin with an A:

`SELECT COUNT(*) FROM assets where block_index >= 501961 and block_index < 556459 and asset_name NOT LIKE 'A%'`

Result **3033**.

For my research I need 2014 and 2015. Relevant blocks  
1st 2014: 278270  
1st 2015: 336861  
1st 2016: 391182

Non-numerical assets registered  
2014: 6531  
2015: 35361