SELECT DISTINCT

contract_name,

contract_address,

origin_from_address AS withdrawer,

(decoded_log:assets::int) AS withdrawal_amount,

tx_hash,

block_timestamp

FROM swell.core.ez_decoded_event_logs

WHERE event_name = 'Withdraw'

),

Withdrawal_CTE AS (

SELECT DISTINCT

contract_name,

contract_address,

origin_from_address AS withdrawer,

(decoded_log:wad::int) AS withdrawal_amount,

tx_hash,

block_timestamp

FROM swell.core.ez_decoded_event_logs

WHERE event_name = 'Withdrawal'

),

prices AS (

SELECT

LOWER(name) AS name,

LOWER(symbol) AS symbol,

date_trunc('hour', hour) AS hour,

price,

decimals

FROM ethereum.price.ez_prices_hourly

WHERE LOWER(symbol) IN ('swell', 'weth', 'usde', 'ena')

),

Final_CTE AS (