nitsDaily and Cumulative Transactions
    Updated 2022-07-11
    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


    Run a query to Download Data