SELECT

symbol,

price,

DATE_TRUNC('hour', hour) AS hour_timestamp

FROM

ethereum.price.ez_prices_hourly

WHERE

symbol = 'WBTC'

order by

hour DESC

LIMIT

1

), deposit_eth AS (

SELECT

to_address AS pool_address,

CASE

WHEN to_address = LOWER('0x87428a53e14d24Ab19c6Ca4939B4df93B8996cA9') THEN 'Uniswap LBTC/WBTC'

WHEN to_address = LOWER('0xD4F56e41E77e2594E89473C7ec03f3F8f6Ed315B') THEN 'Uniswap cbBTC/LBTC'

WHEN to_address = LOWER('0x2f3bc4c27a4437aeca13de0e37cdf1028f3706f0') THEN 'Curve LBTC/WBTC'

WHEN to_address = LOWER('0xabaf76590478f2fe0b396996f55f0b61101e9502') THEN 'Curve eBTC/LBTC/WBTC'

END AS pool,

SUM(amount) AS total_deposits

FROM

ethereum.core.ez_token_transfers

WHERE

contract_address IN (

LOWER('0x8236a87084f8B84306f72007F36F2618A5634494'),

LOWER('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599'),

LOWER('0x657e8C867D8B37dCC18fA4Caead9C45EB088C642'),

LOWER('0xcbB7C0000aB88B473b1f5aFd9ef808440eed33Bf')

)

AND to_address IN (

LOWER('0x87428a53e14d24Ab19c6Ca4939B4df93B8996cA9'),

LOWER('0x2f3bc4c27a4437aeca13de0e37cdf1028f3706f0'),

LOWER('0xabaf76590478f2fe0b396996f55f0b61101e9502'),