kirastudioArbitrum Monthly Data
Updated 2023-08-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
date_trunc(month,block_timestamp) AS month,
sum((((LENGTH(input_data)-2) / 2) + {{fixed_data}})/(1024*1024)) AS data_size_in_MB
FROM arbitrum.core.fact_transactions ft
WHERE block_timestamp >= '{{from_date}}'
AND block_timestamp < '{{to_date}}'
group by 1
order by 1 DESC
--l1 info: 20+8+4+20= 52 bytes
--sequencer info: 8+4 = 12 bytes
--chainID: 4 bytes
--total extra bytes: 64
Run a query to Download Data