maybeyonasalgo_stable_swap_to_daily
    Updated 2022-06-01
    select
    date(block_timestamp) as date,
    case swap_to_asset_id
    when 31566704 then 'usdc'
    when 312769 then 'usdt'
    when 465865291 then 'stbl'
    else null end as asset,
    count(distinct swapper) as user,
    count(distinct tx_group_id) as swaps,
    sum(swap_to_amount) as volume
    from algorand.swaps
    where
    (
    swap_to_asset_id in (
    31566704, --usdc
    312769, --usdt
    465865291 --stbl
    )
    )
    and date(block_timestamp) >= '2022-04-01'
    group by 1,2
    limit 100
    Run a query to Download Data