Blocks
Gets the number of the latest block in the chain.
Typical query time: < 1 second.
SELECT max(number) as latest_block_number
FROM btc.recent_blocks
Gets basic information for the last 5000 blocks in the chain
Typical query time: 2 seconds
SELECT number, "timestamp", hash, transaction_count
FROM btc.blocks
ORDER BY number DESC
LIMIT 5000
Gets the list of blocks with the highest number of transactions that were included in that block, sorted in descending order.
Typical query time: 3 seconds
SELECT number, "timestamp", transaction_count
FROM btc.blocks
ORDER BY transaction_count DESC
LIMIT 500
Last modified 10mo ago