Ali3NDately New and Total Users on Blast vs Avalanche Over Time
Updated 2024-06-09
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
27
28
29
30
31
32
›
⌄
select 'Blast' as network,
date_trunc ({{Time_Interval}},mindate) as date,
count (Distinct from_address) as "New Wallets",
sum ("New Wallets") over (order by date) as "Total Wallets"
from (
select from_address,
min (block_timestamp) as mindate
from blast.core.fact_transactions
group by 1)
where mindate >= '{{Start_Date}}' and mindate <= '{{End_Date}}'
group by 1,2
union all
select 'Avalanche' as network,
date_trunc ({{Time_Interval}},mindate) as date,
count (Distinct from_address) as "New Wallets",
sum ("New Wallets") over (order by date) as "Total Wallets"
from (
select from_address,
min (block_timestamp) as mindate
from avalanche.core.fact_transactions
group by 1)
where mindate >= '{{Start_Date}}' and mindate <= '{{End_Date}}'
group by 1,2
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived