LittlerDataAsat not yet
Updated 2022-06-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
›
⌄
select
count(address),
asset_name
from flipside_prod_db.algorand.account_asset
where address in (
SELECT
address
from flipside_prod_db.algorand.account
where created_at in (
select
block_id
from flipside_prod_db.algorand.block
where block_id in (
select
created_at
from flipside_prod_db.algorand.account
)
and block_timestamp between '2022-05-01' and '2022-05-31'
)
)
and asset_name in (select
asset_name
from flipside_prod_db.algorand.asset
where total_supply = 1
and decimals = 0
group by 2
)
group by 2
Run a query to Download Data