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
| 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