SELECT

symbol,

price

FROM

ethereum.price.ez_prices_hourly

WHERE

-- symbol IN ('WBTC','tBTC','LsETH','wBETH','ETHx','wstETH','osETH','sfrxETH','sUSDe','ENA','swETH','rETH','ETHFI','cbETH','FXS','mETH')

-- AND

hour = TO_CHAR(

DATEADD(hour, -2, current_timestamp),

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

)

),

deposits AS(

SELECT

origin_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))

WHERE

to_address IN (

'0xc329400492c6ff2438472d4651ad17389fcb843a',

'0xb26ff591f44b04e78de18f43b46f8b70c6676984',

'0x422f5accc812c396600010f224b320a743695f85',

'0x03bf48b8a1b37fbead1ecabcf15b98b924ffa5ac',

'0x475d3eb031d250070b63fa145f0fcfc5d97c304a',

'0x38b86004842d3fa4596f0b7a0b53de90745ab654',

'0x5198cb44d7b2e993ebdda9cad3b9a0eaa32769d2',

'0xbdea8e677f9f7c294a4556005c640ee505be6925',

'0xe39b5f5638a209c1a6b6cdffe5d37f7ac99fcc84',

'0x19d0d8e6294b7a04a2733fe433444704b791939a',