PapasotSelling goBTC, goETH (april 2022)
    Updated 2023-01-03
    select
    asset_name as ASA_name,
    swap_from_asset_id as ASA_id,
    count(swap_from_asset_id) as Swaps,
    swap_program as DEX,
    count(DISTINCT(swapper)) as Users,
    sum(swap_from_amount) as Selling_Volume
    from algorand.swaps a
    left join algorand.asset b on b.asset_id = a.swap_from_asset_id

    where block_timestamp >= '2022-04-01' AND
    swap_to_amount > 1 AND
    (swap_from_asset_id = '386192725' OR
    swap_from_asset_id = '386195940')
    group by swap_from_asset_id,asset_name,swap_program
    order by Swaps DESC
    Run a query to Download Data