data1 as

select DATE(b.BLOCK_TIMESTAMP)AS DATE,COUNT(DISTINCT b.TX_HASH)AS Transactions,SUM(T.TX_FEE) AS FEE,ACTION,COUNT(DISTINCT BORROWER) as users,SUM(b.AMOUNT_USD) as volume,

b.SYMBOL ,'borrowing' as actions from flipside_prod_db.crosschain.ez_borrowing as b join polygon.core.fact_transactions as t using(tx_hash)

where b.BLOCKCHAIN='polygon' and b.PLATFORM='sushi'

GROUP BY 1,4,7,actions

),

data2 as (

select DATE(b.BLOCK_TIMESTAMP)AS DATE,COUNT(DISTINCT b.TX_HASH)AS TRANSACTIONs,SUM(T.TX_FEE) AS FEE,ACTION,COUNT(DISTINCT DEPOSITOR) as users,

SUM(b.AMOUNT_USD ) as volume , b.SYMBOL ,'lending' AS actions from flipside_prod_db.crosschain.ez_lendinG as b join polygon.core.fact_transactions as t on t.tx_hash=b.tx_hash

where b.BLOCKCHAIN='polygon'

and b.PLATFORM='sushi'

GROUP BY 1,4,7,actions

SELECT * FROM data1

UNION ALL

SELECT * FROM data2