freemartian7. [Hard] ENS vs Gas
Updated 2021-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with gas as (select fee_usd, tx_id as fee_tx_id from ethereum.transactions),
register as (
select * from ethereum.udm_events
where to_label = 'ens'
and symbol = 'ETH'
)
,
lastly as (
select * from register
left join gas on
gas.fee_tx_id = register.tx_id
)
select date_trunc('day', block_timestamp) as dayz, count(distinct(fee_tx_id)), sum(AMOUNT_USD), sum(FEE_USD) from lastly
group by dayz
order by dayz desc
Run a query to Download Data