strawbettyAssets whales swapping from
    Updated 2022-04-19
    with whale as (select
    distinct address as whales
    from algorand.account where balance > 100000)

    select
    date_trunc(day,s.block_timestamp) as day,
    l.asset_name,
    count(s.swapper) as swap_number
    from algorand.swaps s
    inner join
    algorand.asset l on s.swap_from_asset_id = l.asset_id
    where swapper in (select * from whale)
    and block_timestamp >= '2022-01-01'
    group by 1,2 order by 3 desc
    Run a query to Download Data