shadil1M New Algorand Wallets In May - swappers
Updated 2022-05-15
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 new_wallets as (
select
sender
from (
select
sender,
min(date(block_timestamp)) as min_date
from algorand.transactions
group by sender
)
where min_date BETWEEN '2022-05-04' and '2022-05-10'
GROUP by sender
),
all_new_wallets as (
SELECT COUNT(DISTINCT sender) as new_wallets FROM new_wallets
),
new_swappers as (
SELECT COUNT(DISTINCT swapper) as swappers
from flipside_prod_db.algorand.swaps
where SWAPPER in (SELECT sender FROM new_wallets)
and date(BLOCK_TIMESTAMP) >= '2022-05-04'
),
all_swappers as (
SELECT COUNT(DISTINCT swapper) as swappers
from flipside_prod_db.algorand.swaps
where date(BLOCK_TIMESTAMP) >= '2022-05-04'
)
SELECT
nsw.swappers as new_wallet_swappers, aw.new_wallets, asw.swappers as all_swappers,
(nsw.swappers/aw.new_wallets) * 100 as percent_new_wallet_swapped_to_new, -- what percent of new wallets, have at least one swapper
(nsw.swappers/asw.swappers) * 100 as percent_new_wallet_swapped_to_all -- what percent of all swappers are from the new wallets
from new_swappers nsw
join all_new_wallets aw
join all_swappers asw
Run a query to Download Data