superflynet amount of lona
Updated 2022-12-14
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date_Trunc('day',block_timestamp) as date,
sum(CASE WHEN from_currency = 'uluna' THEN from_Amount/pow(10,6) ELSE 0 end) as amnt_out,
sum(CASE WHEN to_currency ='uluna' THEN from_amount/pow(10,6) ELSE null end) as amnt_in,
amnt_in-amnt_out as net_amnt,
sum(net_amnt)over(order by date) as cs
from terra.core.ez_swaps
GROUP BY date
ORDER BY date desc
Run a query to Download Data