Transactions

Get the 10 most used contracts over the last month

Typical query time: ~60 seconds

SELECT 
  to_address,
  COUNT(*) AS transaction_count
FROM eth.transactions
WHERE block_timestamp > UNIX_TIMESTAMP(NOW()) - 2592000
GROUP BY to_address
ORDER BY transaction_count DESC
LIMIT 10;