Crazy_Kid1M New Algorand Wallets In May 2
Updated 2022-05-19
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
WITH block AS (SELECT address, created_at FROM algorand.account),
time AS (SELECT block_timestamp, block_id FROM algorand.block WHERE date(block_timestamp) BETWEEN '2022-05-04' AND '2022-05-10'),
wallets AS (SELECT * FROM block JOIN time on created_at = block_id),
assets AS (SELECT swapper, swap_to_asset_id FROM algorand.swaps WHERE swapper IN (SELECT address FROM wallets))
SELECT DISTINCT swap_to_asset_id, asset_name
FROM assets JOIN algorand.asset on swap_to_asset_id = asset_id
ORDER BY swap_to_asset_id
Run a query to Download Data