mariya DEXes Prices
    Updated 2022-05-09
    select
    date_trunc(day,block_timestamp) as date,
    swap_program,
    median(
    case when swap_from_asset_id = '441139422' then swap_from_amount/swap_to_amount else swap_to_amount/swap_from_amount end
    ) as per_algo
    from algorand.swaps
    where ((swap_from_asset_id = '441139422' and swap_to_asset_id='0' ) or (swap_to_asset_id = '441139422' and swap_from_asset_id = '0'))
    and swap_from_amount > 0
    and swap_to_amount > 0
    group by 1,2
    Run a query to Download Data