kirastudioEthereum L2 set-off from Polygon PoS
    Updated 2023-08-17

    SELECT
    date_trunc('month', block_timestamp) AS month,
    sum((((LENGTH(input_data) - 2) / 2) + {{fixed_data}}) / (1024 * 1024)) AS data_size_in_MB
    FROM ethereum.core.fact_transactions ft
    WHERE block_timestamp >= '{{from_date}}'
    AND block_timestamp < '{{to_date}}'
    and to_address = lower('0x86E4Dc95c7FBdBf52e33D563BbDB00823894C287')
    and origin_function_signature like '0x4e43e495%' -- Root Chain Proxy
    GROUP BY 1
    ORDER BY 1 desc

    Run a query to Download Data