210 rows yesterday at 12:44 PM
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
with
'0xae7ab96520de3a18e5e111b5eaab095312d7fe84' as steth,
'0xd15a672319cf0352560ee76d9e89eab0889046d3' as burner,
'0x0000000000000000000000000000000000000000' as nil,
'Transfer(address,address,uint256)' as sig_transfer,
'StETHBurnt(bool,uint256,uint256)' as sig_burnt,
minted as (
select
date_trunc('week', timestamp) as time,
sum(sum(input_2_value_uint256)) over (order by time) as amount
from
evm_events_ethereum_mainnet
where
address = steth
and signature = sig_transfer
and input_0_value_address = nil
group by
time
),
burnt as (
select
date_trunc('week', timestamp) as time,
sum(sum(input_1_value_uint256)) over (order by time) as amount
from
evm_events_ethereum_mainnet
where
address = burner
and signature = sig_burnt
group by
time
)
select
minted.time as chart_x,
token_usd_amount('ethereum', 'mainnet', steth, chart_x, minted.amount - burnt.amount) as chart_y
from
minted left join burnt on minted.time = burnt.time
order by
minted.time