Abbas_ra21Blast over Time 3
Updated 2024-09-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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