kaibladeTotal Hourly Transactions
    Updated 2022-06-27
    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

    Run a query to Download Data