Popex404Hourly Total Volume USDC minted/Burned in Avalanche
    Updated 2022-12-07
    Select date_trunc('hour',block_timestamp) as "Date",
    event_name as "Transaction Type",
    sum (event_inputs:value/1e6) as "Total Volume"
    from avalanche.core.fact_event_logs
    where tx_status = 'SUCCESS'
    and event_name in ('Mint','Burn')
    and contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'
    and block_timestamp >= '2022-07-01'
    group by 1,2
    Run a query to Download Data