maybeyonasalgo_galgo_dex
    Updated 2022-04-27
    select
    date(block_timestamp) as date,
    swap_program,
    count(distinct tx_group_id) as swaps,
    sum(
    case when swap_from_asset_id = '694432641' then swap_from_amount else swap_to_amount end
    ) as volume
    from algorand.swaps
    where swap_from_asset_id = '694432641' or swap_to_asset_id = '694432641'
    group by 1,2
    -- limit 100
    Run a query to Download Data