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