block_timestamp,

swap_fee_amount_usd as USTswapfeeUSD,

offer_currency,

token_0_amount_usd,

ask_currency,

token_1_amount_usd

from terra.swaps

where 'LUNA' NOT IN (ask_currency, offer_currency) AND tx_status='SUCCEEDED')

select

DATE(block_timestamp) as dayz,

sum(USTswapfeeUSD) as TotalUSTswapfee,

sum(TotalUSTswapfee) over (order by dayz asc rows between unbounded preceding and current row) as cml_value_USD

from ustswaps

group by 1