freemartian7. [Hard] ENS vs Gas
    Updated 2021-12-14
    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