Updated 2023-01-03

    select block_timestamp::date as date, swap_program as dex, asset.asset_name as SWAP_FROM_ASSET_NAME, asset2.asset_name as SWAP_TO_ASSET_NAME,
    COUNT(
    case when swap_from_amount > 0 then 1
    else 0
    end)
    as swaps, sum(swap_from_amount), sum(swap_to_amount)
    from algorand.swaps swaps
    left join algorand.asset asset on swaps.swap_from_asset_id = asset.asset_id
    left join algorand.asset asset2 on swaps.swap_to_asset_id = asset2.asset_id
    where
    swaps.block_timestamp::Date > '2022-01-01'
    group by date, dex, SWAP_FROM_ASSET_NAME, SWAP_TO_ASSET_NAME
    Run a query to Download Data