SQL

Example Queries

Queries against live tables. Copy them into the console when it opens; until then they document the schema.

Blocks per hour

sql

SELECT toStartOfHour(timestamp) AS hour,
       count() AS blocks,
       sum(transaction_count) AS txns
FROM arc.blocks
WHERE timestamp > now() - INTERVAL 1 DAY
GROUP BY hour
ORDER BY hour;

Top tokens by transfer count

sql

SELECT token_address, count() AS transfers
FROM token.transfers
WHERE block_number > (SELECT max(block_number) FROM arc.blocks) - 7200
GROUP BY token_address
ORDER BY transfers DESC
LIMIT 20;

Failed transactions

sql

SELECT count() AS failed,
       count() / (SELECT count() FROM arc.transactions WHERE block_number > 2910000) AS rate
FROM arc.transactions
WHERE status = 0 AND block_number > 2910000;