maybeyonasalgo_asa_swap_from_algo
    Updated 2022-04-12
    select
    swap_to_asset_id,
    asset_name,
    sum(swap_from_amount) as algo_swapped,
    count(tx_group_id) as txs,
    count(distinct swapper) as users,
    avg(swap_from_amount) as avg_algo_swapped,
    median(swap_from_amount) as med_algo_swapped
    from algorand.swaps s join algorand.asset a on s.swap_to_asset_id = a.asset_id
    where swap_from_asset_id = 0
    and block_timestamp >= '2022-01-01'
    group by 1,2
    order by algo_swapped desc
    limit 10
    Run a query to Download Data