theericstoneMint/Burn Template
    with d as (
    select amount, block_timestamp, block_number from gold.ethereum_events
    where contract_address = lower('0xBC6DA0FE9aD5f3b0d58160288917AA56653660E9')
    and from_address = '0x0000000000000000000000000000000000000000'
    and block_number >= 11937214
    and amount > 0
    and event_name = 'transfer'
    union
    select amount * -1, block_timestamp, block_number from gold.ethereum_events
    where contract_address = lower('0xBC6DA0FE9aD5f3b0d58160288917AA56653660E9')
    and to_address in ('0x0000000000000000000000000000000000000000')
    and block_number >= 11937214
    and amount > 0
    and event_name = 'transfer'
    ),
    g as (
    select date_trunc('hour', block_timestamp) as t, sum(amount) as hour_sum
    from d group by 1 order by 1
    )
    select t, sum(hour_sum) over (order by t asc rows between unbounded preceding and current row) as alusd
    from g
    order by 1


    Run a query to Download Data