Delamir-6014Untitled Query
Updated 2022-11-17
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
35
36
›
⌄
with sol as (select
date_trunc('week', block_timestamp) as week,
count(distinct(signers[0])) as sol_wallets_count
from solana.fact_transactions
where week >= '2022-01-01'
and succeeded = 'TRUE'
group by 1),
eth as (select date_trunc('week', block_timestamp) as week,
count(distinct(origin_address)) as eth_wallets_count
from ethereum.udm_events
where block_timestamp >= '2022-01-01'
group by 1),
luna as (select date_trunc('week', block_timestamp) as week,
count(distinct(f.value)) as terra_wallets_count
from terra.transactions p,
table(flatten(p.tx_from)) f
where block_timestamp >= '2022-01-01'
group by 1),
algorand as (select date_trunc('week', block_timestamp) as week,
count(distinct(sender)) as algo_wallets_count
from algorand.transactions
where block_timestamp >= '2022-01-01'
group by 1)
select a.week,
sol_wallets_count,
eth_wallets_count,
terra_wallets_count,
algo_wallets_count
from sol a
join eth b
on a.week = b.week
join luna c
Run a query to Download Data