vahid-2jsEENTop wallet with the most ALGO
    Updated 2022-06-15
    with block as (
    select
    distinct block_id
    from algorand.block
    where date(block_timestamp) >= '2022-05-01' and block_timestamp < '2022-05-31'
    ), unique_address as (
    select
    a.address
    from flipside_prod_db.algorand.account a
    inner join block b
    on a.created_at = b.block_id
    where a.created_at = b.block_id
    order by a.balance desc limit 100
    ), algo_bal as (
    select
    address,
    'ALGOS' as asset_name,
    a.balance as balance
    from flipside_prod_db.algorand.account a inner join block b
    on a.created_at = b.block_id where a.created_at = b.block_id and a.balance != 0
    and address in (select distinct address from unique_address)
    )

    select
    *
    from algo_bal
    order by balance desc
    limit 20
    Run a query to Download Data