SELECT

DATE_TRUNC('day', hour) AS day,

AVG(price) AS avg_wbtc_price

FROM

ethereum.price.ez_prices_hourly

WHERE

symbol = 'WBTC'

GROUP BY

DATE_TRUNC('day', hour)

),

deposit_eth AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

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'),

LOWER('0xD4F56e41E77e2594E89473C7ec03f3F8f6Ed315B')