PapasotSTBL USDC trading swaps
    Updated 2022-05-18
    select
    date_trunc('day',block_timestamp) as block_day,
    count(tx_group_id) as swaps,
    sum(swap_from_amount) as STBL_volume,
    sum(swap_to_amount) as USDC_volume
    from algorand.swaps
    where
    swap_from_asset_id = '465865291' AND
    swap_to_asset_id = '31566704' AND
    block_timestamp >= '2022-05-08'
    group by block_day
    order by block_day
    Run a query to Download Data