kiichiUntitled Query
    Updated 2022-06-20
    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