with prices AS (

SELECT

symbol,

price

FROM

ethereum.price.ez_prices_hourly

WHERE

-- symbol IN (

-- 'ENA',

-- 'ETHX',

-- 'CBETH',

-- 'METH',

-- 'RETH',

-- 'SUSDE',

-- 'SFRXETH',

-- 'SWETH',

-- 'WBETH',

-- 'WSTETH'

-- )

-- AND

hour = TO_CHAR(

DATEADD(hour, -2, current_timestamp),

'YYYY-MM-DD HH24:00:00.000'

)

),

deposits AS(

SELECT

from_address AS depositor,

t.symbol,

count(tx_hash) AS deposit_transactions,

SUM(amount) AS deposit_amount,

SUM(amount * price) AS deposit_amount_usd,

FROM

ethereum.core.ez_token_transfers t

INNER JOIN prices p ON (p.symbol = UPPER(t.symbol))