SELECT date(block_timestamp) as day, symbol, count(DISTINCT tx_hash) as total_txs
, sum(total_txs) over (partition by symbol order by day) as cum_txs ,
sum(amount_usd) as total_amt_usd,
sum(total_amt_usd) over (partition by symbol order by day) as cum_amt
from crosschain.ez_lending
where symbol in (
'USDC',
'DAI',
'USDT',
'RAI',
'TUSD',
'sUSD',
'UST',
'FEI' )
GROUP by 1, 2