WITH deposits AS(

SELECT

a.block_timestamp AS block_timestamp,

decoded_log:token AS token,

decoded_log:user :: VARCHAR AS depositor,

COALESCE(symbol, decoded_log:token :: STRING) AS symbol,

decoded_log:amount / POW(10, COALESCE(b.decimals, 18)) AS volume

FROM ethereum.core.ez_decoded_event_logs AS a

LEFT JOIN ethereum.core.dim_contracts AS b ON a.decoded_log:token = b.address

WHERE a.contract_address = '0x19b5cc75846bf6286d599ec116536a333c4c2c14'

AND event_name = 'Deposit'

AND decoded_log:token <> '0x0000000000000000000000000000000000000000'

AND symbol NOT IN('Re7LRT','rstETH','rsUSDe','mUSD','amphrETH','mBTC')

),

deposits_adj AS(

SELECT

a.block_timestamp AS block_timestamp,

decoded_log:token AS token,

decoded_log:user :: VARCHAR AS depositor,

COALESCE(symbol, decoded_log:token :: STRING) AS symbol,

decoded_log:amount / POW(10, COALESCE(b.decimals, 18)) AS volume

FROM ethereum.core.ez_decoded_event_logs AS a

LEFT JOIN ethereum.core.dim_contracts AS b ON a.decoded_log:token = b.address

WHERE a.contract_address = '0x19b5cc75846bf6286d599ec116536a333c4c2c14'

AND event_name = 'Deposit'

AND decoded_log:token <> '0x0000000000000000000000000000000000000000'

AND symbol IN('Re7LRT','rstETH','rsUSDe','mUSD','amphrETH','mBTC')

),

prices1 AS(

SELECT

hour ,

token_address,

price AS price

FROM ethereum.price.ez_prices_hourly