mariya DEXes Prices
Updated 2022-05-09
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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