nitsWhich DEX's are whales using
    Updated 2022-05-21
    with whales as (SELECT * from algorand.account
    where balance >= 50000 and closed_at is NULL )

    SELECT date(block_timestamp) as day,swap_program, count(DISTINCT swapper) as number_of_wallets_swapping,
    avg(number_of_wallets_swapping) over (partition by swap_program order by day) as avg_number_of_wallets_swapping
    from algorand.swaps
    where block_timestamp >= '2022-04-01'
    and swapper in (SELECT address from whales )
    GROUP by 1,2

    limit 1000
    Run a query to Download Data