amirozatop 5 swap to
    Updated 2022-06-09
    select case when SWAP_to_ASSET_ID=0 then 'algo' else ASSET_NAME end ASSET_NAME,count(SWAP_to_ASSET_ID) asset_count
    from flipside_prod_db.algorand.swaps
    left join flipside_prod_db.algorand.asset on asset_id=SWAP_to_ASSET_ID
    where date(BLOCK_TIMESTAMP) in ('2022-05-11','2022-05-12')
    group by 1
    order by 2 DESC
    limit 5
    Run a query to Download Data