SELECT

date_trunc('day', BLOCK_TIMESTAMP)::date AS date,

'Borrow' AS type,

SUM(LOAN_AMOUNT_USD) AS total_volume

FROM ethereum.compound.ez_borrows

GROUP BY 1

UNION

SELECT

date_trunc('day', BLOCK_TIMESTAMP)::date AS date,

'Liquidations' AS type,

SUM(LIQUIDATION_AMOUNT_USD) AS total_volume

FROM ethereum.compound.ez_liquidations

GROUP BY 1

UNION

SELECT

date_trunc('day', BLOCK_TIMESTAMP)::date AS date,

'Deposit' AS type,

SUM(SUPPLIED_BASE_ASSET_USD) AS total_volume

FROM ethereum.compound.ez_deposits

GROUP BY 1

UNION

SELECT

date_trunc('day', BLOCK_TIMESTAMP)::date AS date,

'Repayment' AS type,

SUM(REPAYED_AMOUNT_USD) AS total_volume

FROM ethereum.compound.ez_repayments

GROUP BY 1

UNION