prices AS (

SELECT

symbol AS token,

decimals,

AVG(price) AS price

FROM

ethereum.core.fact_hourly_token_prices

WHERE

hour BETWEEN (CURRENT_DATE - 31) AND (CURRENT_DATE - 1)

AND (symbol IN ('WBTC', 'WETH', 'USDC', 'LINK', 'GNO') OR token_address = '0xc770eefad204b5180df6a14ee197d99d808ee52d')

GROUP BY

token,

decimals

),

inflows AS (

SELECT

CASE

WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x8e5bbbb09ed1ebde8674cda39a0c169401db4252' THEN 'WBTC'

WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1' THEN 'WETH'

WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0xddafbb505ad214d7b80b1f830fccc89b60fb7a83' THEN 'USDC'

WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0xe2e73a1c69ecf83f464efce6a5be353a37ca09b2' THEN 'LINK'

WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x9c58bacc331c9aa871afd802db6379a98e80cedb' THEN 'GNO'

WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x21a42669643f45bc0e086b8fc2ed70c23d67509d' THEN 'FOX'

ELSE COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve)

END AS token,

SUM(event_inputs:amount) AS amount

FROM

gnosis.core.fact_event_logs

WHERE

block_timestamp::date BETWEEN (CURRENT_DATE - 31) AND (CURRENT_DATE - 1) AND event_removed = FALSE AND tx_status = 'SUCCESS'

AND origin_to_address = '0x5e15d5e33d318dced84bfe3f4eace07909be6d9c' AND contract_address = origin_to_address

AND event_name IN ('Deposit', 'Repay')

GROUP BY

token

),