Select Date_trunc('day',BLOCK_TIMESTAMP) AS Date,

BLOCKCHAIN, AMOUNT_USD, COLLATERAL_SYMBOL, 'Deposit as Collateral' AS Status

FROM flipside_prod_db.crosschain.ez_borrowing

WHERE ACTION = 'Borrow'

AND COLLATERAL_SYMBOL IN ('DAI','sUSD','TUSD','USDC','USDT','UST')

UNION ALL

Select Date_trunc('day',BLOCK_TIMESTAMP) AS Date,

BLOCKCHAIN, AMOUNT_USD, SYMBOL, 'Deposit as Lending' AS Status

FROM flipside_prod_db.crosschain.ez_lending

WHERE ACTION = 'Deposit'

AND SYMBOL IN ('DAI','sUSD','TUSD','USDC','USDT','UST') )

SELECT Date, BLOCKCHAIN, SUM(AMOUNT_USD) AS Amount, Count(AMOUNT_USD) AS tx_count, COLLATERAL_SYMBOL AS SYMBOL, Status

FROM t1

GROUP BY 1,2,5,6 ;