theericstoneMint/Burn Template
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
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