saeedmzngroup by
Updated 2024-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with new_users as (
select FROM_ADDRESS ,
min (BLOCK_TIMESTAMP)::date min_date,
count (tx_hash) num_transactions
from blast.core.fact_transactions
group by FROM_ADDRESS having min_date >= current_date - 1
)
select case
when num_transactions = 1 then 'Only one transaction'
when num_transactions BETWEEN 1 and 5 then '1 - 5 transactions'
when num_transactions BETWEEN 5 and 10 then '5 - 10 transactions'
else 'More than 10 transactions' end range ,
count (FROM_ADDRESS) num_new_users
from new_users
group by range
-- select BLOCK_TIMESTAMP::date ,
-- count (tx_hash) num_transactions ,
-- count (DISTINCT FROM_ADDRESS) num_wallets
-- from blast.core.fact_transactions
-- where BLOCK_TIMESTAMP::date >= '2024-05-01'
-- group by BLOCK_TIMESTAMP::date
-- order by BLOCK_TIMESTAMP::date
QueryRunArchived: QueryRun has been archived