SELECT

DATE_TRUNC('day', HOUR) AS dt,

AVG(price) AS price

FROM ethereum.price.ez_prices_hourly

WHERE TOKEN_ADDRESS = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'

GROUP BY 1

),

user_v3 AS (

SELECT

DATE_TRUNC('{{granularity}}', block_timestamp) AS dt,

BORROWER AS user_address

FROM ethereum.defi.ez_lending_borrows

WHERE platform ILIKE 'Aave V3%'

UNION ALL

SELECT

DATE_TRUNC('{{granularity}}', block_timestamp) AS dt,

DEPOSITOR AS user_address

FROM ethereum.defi.ez_lending_deposits

WHERE platform ILIKE 'Aave V3%'

UNION ALL

SELECT

DATE_TRUNC('{{granularity}}', block_timestamp) AS dt,

INITIATOR AS user_address

FROM ethereum.defi.ez_lending_flashloans

WHERE platform ILIKE 'Aave V3%'

UNION ALL

SELECT

DATE_TRUNC('{{granularity}}', block_timestamp) AS dt,