maybeyonasens_gas_corr_pre_nov
Updated 2021-12-11
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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