Ali3NDately New and Total Users on Kaia vs Avalanche Over Time
Updated 2024-10-29
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
33
34
›
⌄
select 'Kaia' 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 kaia.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 12 hours
QueryRunArchived: QueryRun has been archived