0xaimanSwap: USD Valuation of oSQTH over time
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
Select
date(block_timestamp) as dt, sum(amount_out) as sum_amt_osqth,
sum(sum_amt_osqth) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_sum_amt_osqth,
sum(amount_usd) as sum_amt_USD ,
sum(sum_amt_USD) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_sum_amt_usd
from ethereum.dex_swaps
where --tx_id='0x7cb81dc0fb135d3eefdfac0afdbf397206af74950a6cea6951bd06e1d01eea08' and
token_address='0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b' and direction='OUT'
group by 1
limit 1000
Run a query to Download Data