0xaimanSwap: USD Valuation of oSQTH over time
    Updated 2022-06-30
    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