KaskoazulAlgorand Stablecoins swap to
    Updated 2022-04-04
    select block_timestamp::date as fecha,
    case swap_to_asset_id
    when 312769 then 'USDT'
    when 31566704 then 'USDC'
    when 465865291 then 'STBL'
    end as asset_to,
    count(tx_group_id) as daily_swaps_to,
    sum(daily_swaps_to) over (partition by asset_to order by fecha) as cum_swaps_to,
    sum(swap_to_amount) as daily_amount_to,
    sum(daily_amount_to) over (partition by asset_to order by fecha) as cum_amount_to
    from algorand.swaps
    where fecha >= '2022-03-01'
    and fecha < '2022-04-01'
    and swap_to_asset_id in (312769, 31566704, 465865291)
    group by 1, 2




    Run a query to Download Data