Pine AnalyticsBlast 2
Updated 2024-08-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with tab1 as (
select
date_trunc('day', block_timestamp) as Date,
case when block_timestamp > '2024-06-27' then 'b. After Airdrop' else
'a. Before Airdrop' end as Time_Period,
count(distinct tx_hash) as Transactions,
count(distinct from_address) as Users,
sum(tx_fee) as Fee_Volume_ETH
from blast.core.fact_transactions
where Status = 'SUCCESS'
group by 1,2
)
SELECT
Time_Period,
avg(Transactions) as Avg_Transactions,
avg(Users) as Avg_Users,
avg(Fee_Volume_ETH) as Avg_Fee_Volume_ETH
from tab1
group by 1
QueryRunArchived: QueryRun has been archived