SELECT DATE_TRUNC('HOUR', block_timestamp) AS hourly_timestamp,
COUNT(tx_hash) AS tx_count
FROM avalanche.core.fact_event_logs
-- WHERE (contract_address = lower('0x152b9d0FdC40C096757F570A51E494bd4b943E50')
-- OR origin_from_address = lower('0x152b9d0FdC40C096757F570A51E494bd4b943E50')
-- OR origin_to_address = lower('0x152b9d0FdC40C096757F570A51E494bd4b943E50'))
-- event_name = 'Transfer'
WHERE block_timestamp >= '2022-06-20 00:00:00.000'
GROUP BY hourly_timestamp
ORDER BY hourly_timestamp