headitmanageravg size
Updated 2022-06-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select '1.average swap from size' as lbl ,avg(swap_from_amount) as val from algorand.swaps where block_timestamp::date>='2022-05-01' and block_timestamp::date<='2022-05-31'
UNION
select '2.average swap from size 11 and 12 May' as lbl,avg(swap_from_amount) as val from algorand.swaps
UNION
select '3.average swap to size' as lbl , avg(swap_to_amount) as val from algorand.swaps where block_timestamp::date>='2022-05-01' and block_timestamp::date<='2022-05-31'
UNION
select '4.average swap to size 11 and 12 May' as lbl , avg(swap_to_amount) as val from algorand.swaps
UNION
select '5.average swap size' as lbl , avg(swap_from_amount + swap_to_amount) as val from algorand.swaps
UNION
select '6.average swap size 11 and 12 May' as lbl , avg(swap_from_amount + swap_to_amount) as val from algorand.swaps where block_timestamp::date>='2022-05-11' and block_timestamp::date<='2022-05-12'
order by lbl