PapasotgAlgo3 swaps
    Updated 2023-01-03
    -- What are the top 10 most popular to swap to from gALGO3?

    select
    swap_to_asset_id as ASA,
    asset_name as ASA_name,
    count(swap_to_asset_id) as Swaps
    from algorand.swaps
    left join algorand.asset on asset_id = swap_to_asset_id
    where block_timestamp >= '2022-01-01' AND
    swap_from_asset_id = '694432641' -- gAlgo3 asset id
    group by swap_to_asset_id, asset_name
    order by Swaps DESC
    Run a query to Download Data