LittlerDataAsat not yet
    Updated 2022-06-17
    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