Real-time blockchain event monitoring built for builders

SELECT
  t.hash        AS tx_hash,
  l.address     AS contract,
  l.topic0      AS event_sig,
  l.data        AS raw_data
FROM main.logs l
JOIN main.transactions t
  ON t.hash = l.transaction_hash
WHERE l.topic0 = '0xddf252ad...'        -- ERC-20 Transfer
  AND CAST(l.data AS BIGINT) > 1000000  -- > 1M tokens
ORDER BY t.block_number DESC
LIMIT 10