kirastudioAvalanche Monthly Data
    Updated 2023-08-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 avalanche.core.fact_transactions ft
    WHERE block_timestamp >= '{{from_date}}'
    AND block_timestamp < '{{to_date}}'
    group by 1
    order by 1 DESC

    Run a query to Download Data