kirastudioArbitrum Monthly Data
    Updated 2023-08-15
    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