mo115arbitrum_blob_txns_on_L1 copy copy
Updated 2024-03-18
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 arbitrum_L1_fee as (
select
date_trunc('hour',txns.block_timestamp) as hour
, count(txns.tx_hash) as num_txn
from ethereum.core.fact_transactions txns
where txns.to_address = lower('0x1c479675ad559DC151F6Ec7ed3FbF8ceE79582B6') -- 'Arbitrum: Sequencer Inbox'
and txns.block_timestamp >= '2024-03-10'
and txns.block_timestamp < date_trunc('hour',current_timestamp) -- reduce impact of incomplete hour
group by 1
)
, arbitrum_L2_fee as (
select
date_trunc('hour',txns.block_timestamp) as hour
, count(txns.tx_hash) as num_txn
from arbitrum.core.fact_transactions txns
where txns.block_timestamp >= '2024-03-10'
and txns.block_timestamp < date_trunc('hour',current_timestamp) -- reduce impact of incomplete hour
group by 1
)
select
case
when hour <= timestamp '2024-03-14 14:50' then false
else true
end as after_dencun
, avg(l1.num_txn) as l1_hourly_txns
, avg(l2.num_txn) as l2_hourly_txns
from arbitrum_L1_fee l1
inner join arbitrum_L2_fee l2 using (hour)
QueryRunArchived: QueryRun has been archived