granadohoTop 200 Wallets with Most Algos
    Updated 2022-02-15
    with block as (
    select
    distinct block_id
    from algorand.block
    where date(block_timestamp) >= '2022-01-01'
    ), unique_address as (
    select
    a.address
    from 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 200 -- top 200 richest wallet in algo
    ), algo_bal as (
    select
    address,
    'ALGOS' as asset_name,
    a.balance as balance
    from 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 50
    Run a query to Download Data