Abbas_ra21Blast over Time 3
    Updated 2024-09-16
    select
    Date_trunc('{{Interval}}',BLOCK_TIMESTAMP) AS Date,
    sum(Value) AS "ETH Transfers Volume",
    sum("ETH Transfers Volume") over (order by Date) AS "Cumulative Volume",
    "ETH Transfers Volume"/count(DISTINCT from_Address) AS "Average Volume Per User"
    from blast.core.fact_transactions where BLOCK_TIMESTAMP >= '2024-02-29 00:00:00.000'
    group by 1



    QueryRunArchived: QueryRun has been archived