kiichiUntitled Query
Updated 2022-06-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
count (a.address) as wallet_amount,
b.created_at,
date_trunc(month,c.block_timestamp) as date
from flipside_prod_db.algorand.account_asset a
join flipside_prod_db.algorand.account b
ON a.address=b.address
join flipside_prod_db.algorand.block c
on b.created_at=c.block_id
where a.asset_name like 'Warrior Croc%'
and a.amount>0
group by date, created_at
Run a query to Download Data