KaskoazulNew_addresses_ALGO
Updated 2022-02-16
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
address
FROM
algorand.account
WHERE
created_at>= 18363444 AND created_at<=18974008 -- 18363444 January first block 18974008 January last block
),
ALGO_Addresses AS(
SELECT
address,
balance as balance_ALGO,
rewardsbase,
rewards_total,
account_data
FROM
algorand.account
WHERE
address IN ( SELECT address from New_wallets )
),
ASA_Addresses AS(
SELECT
address,
amount,
asset_name
FROM
algorand.account_asset
WHERE
address IN ( SELECT address from New_wallets )
)
SELECT
A.Address,
A.balance_ALGO,