SELECT

hour::date as p_date,

price

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol = 'WETH'

, all_tx as (

SELECT

BLOCK_TIMESTAMP,

'DEPOSITOR' as status,

TX_HASH,

DEPOSITOR as users,

AMOUNT_DEPOSITED as amount

FROM ethereum.maker.ez_deposits

WHERE TX_STATUS = 'SUCCESS'

UNION ALL

SELECT

BLOCK_TIMESTAMP,

'WITHDRAWER' as status,

TX_HASH,

WITHDRAWER as users,

AMOUNT_WITHDRAWN as amount

FROM ethereum.maker.ez_withdrawals

WHERE TX_STATUS = 'SUCCESS'

UNION ALL

SELECT

BLOCK_TIMESTAMP,

'BORROWER' as status,

TX_HASH,

BORROWER as users,

AMOUNT_LOANED as amount