adriaparcerisas1M New Algorand Wallets In May 3
Updated 2022-05-18
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
›
⌄
-- From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at:
-- Using the account table, show the distribution of ALGOs these wallets have?
--Are these wallets swapping assets?
-- If so, what assets are these wallets swapping for?
--What assets do these wallets hold using the account_asset table?
--Do we see any commonalities our patterns across these wallets?
WITH
list as (
SELECT
distinct address as wallets
from algorand.account x
join algorand.block y on x.created_at =y.block_id
where block_timestamp between '2022-05-04' and '2022-05-10'
)--,
-- swaps as (
SELECT
distinct asset_name,
--swap_from_asset_id,
count(distinct swapper) as n_swappers,
count(distinct tx_group_id) as n_swaps
from algorand.swaps x
join algorand.account_asset a on x.swap_to_asset_id=a.asset_id
where swapper in (select * from list)
group by 1
order by 2 desc, 3 desc
-- )
-- SELECT
--distinct concat(asset_to,'-',asset_name) as swap_pair,
--sum(swappers),
--sum(swaps)
-- from swaps x
--join algorand.account_asset a on x.swap_from_asset_id=a.asset_id
-- group by 1
--order by 2 desc, 3 desc
Run a query to Download Data