KaskoazulPattern_ALGO-ASA
Updated 2022-02-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
›
⌄
WITH New_wallets AS (
SELECT
address
FROM
algorand.account
WHERE
created_at>= 18363444 AND created_at<=18974008 -- 18363444 January first block 18974008 January last block
),
BAL100K AS (
SELECT
address,
balance as balance_ALGO
FROM
algorand.account
WHERE
address IN ( SELECT address from New_wallets )
AND balance_ALGO > 100000
)
SELECT
AA.address,
AA.amount,
AA.asset_name,
A.balance
FROM
algorand.account_asset AA
INNER JOIN
algorand.account A
ON AA.address = A.address
WHERE
AA.address IN (SELECT address from BAL100K)
ORDER BY 2 desc
LIMIT 25
Run a query to Download Data