Query editor
SELECTdate_trunc('hour', block_time) AS hour,contract_address,symbol,COUNT(*) AS transfer_events,COUNT(DISTINCT tx_hash) AS tx_count,SUM(amount) AS amount_mintedFROM tokens.transfersWHERE contract_address = 0x1219c409fabe2c27bd0d1a565daeed9bd9f271deAND "from" = 0x0000000000000000000000000000000000000000AND block_time >= TIMESTAMP '2026-07-06 00:00:00'AND block_time < TIMESTAMP '2026-07-08 00:00:00'GROUP BY 1, 2, 3ORDER BY hour DESC;