maybeyonasens_gas_corr_pre_nov
    Updated 2021-12-11
    -- with ens_reg as (
    -- select *
    -- from ethereum.events_emitted
    -- where
    -- event_removed = 'FALSE'
    -- and event_name='NameRegistered'
    -- and contract_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5'
    -- -- and tx_id = '0xb0ebf6f4d9fc4f1067a61816e7d095a35a46f9a9df16ce346fa8a844a94b8efa'
    -- order by block_timestamp desc
    -- )
    -- -- 0xc08a0550baa705c09cfee90a38856d35618082eff969c3a8724de505b94ff1e4
    -- select *
    -- from ethereum.transactions
    -- where tx_id in (select tx_id from ens_reg)
    -- order by block_timestamp desc
    -- limit 100
    with gas as (
    select
    date(block_timestamp) as date,
    median(gas_price)/pow(10,9) as avg_gas,
    median(tx_fee) as avg_tx_fee,
    count(tx_id) as txs
    from ethereum.transactions
    where
    to_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5'
    and function_name = 'registerWithConfig'
    and date >= '2021-07-01'
    and date <= '2021-11-01'
    group by 1
    ),
    corr_gas as (
    select corr(txs,avg_gas) as gas_corr
    from gas
    ),
    corr_fee as (
    select corr(txs,avg_tx_fee) as fee_corr
    Run a query to Download Data