lagandispenserTop 10 Asa's Hold
    Updated 2022-06-14
    with top_ten as (
    select distinct asset_name, count(distinct address) as holders, asset_added_at

    from algorand.account_asset where
    amount>0 and amount is not null
    and (
    asset_name = 'PLANET'
    or
    asset_name = 'Yieldly'
    or
    asset_name = 'Tinyman Pool USDC-ALGO'
    or
    asset_name = 'Tether USDt'
    or
    asset_name = 'USDC'
    or
    asset_name = 'Boom'
    or
    asset_name = 'Kitsune Inu'
    or
    asset_name = 'Crypto Knight'
    or
    asset_name = 'KittenCoin'
    or
    asset_name = 'Boobs'
    )
    group by 1, 3
    ),
    datetimes as (

    select
    trunc(a.block_timestamp,'day') as date,
    b.asset_name,
    b.holders
    from top_ten b, algorand.block a where a.block_id = b.asset_added_at
    group by 1,2,3
    Run a query to Download Data