Pmisha-bmlMdxdistribution.1
Updated 2022-06-09
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 dtcreate as (
SELECT
block_timestamp,
block_id
from algorand.block
),
t2 as (select
distinct ADDRESS as wallets
from flipside_prod_db.algorand.account s left outer join dtcreate b on s.CREATED_AT=b.block_id
where BALANCE>1
and ACCOUNT_CLOSED='FALSE'
and b.block_timestamp>='2022-05-01'),
wl as (SELECT
distinct(creator_address) as wallets
from algorand.asset
where total_supply = 1
and decimals = 0
and asset_deleted = 'False'
and creator_address in (select wallets from t2)),
NFTs as (
SELECT
asset_id
from algorand.asset
where total_supply = 1
and decimals = 0
and asset_deleted = 'False'
),
ds as (select
distinct address as ww,
sum(amount) as no_nft
from flipside_prod_db.algorand.account_asset
Run a query to Download Data