WITH price_details AS (

SELECT

DATE_TRUNC('week', hour) AS week,

AVG(price) AS avg_price,

token_address

FROM base.price.ez_prices_hourly

WHERE token_address = lower('0xff0c532fdb8cd566ae169c1cb157ff2bdc83e105')

AND hour::date >= '2023-08-31'

GROUP BY week, token_address

),

staking AS (

SELECT

DATE_TRUNC('week', block_timestamp) AS week,

tx_hash,

contract_address

FROM base.core.fact_event_logs

WHERE

block_timestamp >= '2023-11-10'

AND contract_address = lower('0x0e22B5f3E11944578b37ED04F5312Dfc246f443C')

AND topics[0] = '0x89cd37504c2ba7aa0ffe54ae7b0c9b6f873bd3fcec00adcaecbed99fae006041' -- stake

),

staking_details AS (

SELECT

tx_hash,

contract_address,

from_address AS stakers,

raw_amount/1e18 AS amount_staked

FROM base.core.ez_token_transfers

WHERE

block_timestamp >= '2023-11-10'

AND raw_amount > 0

AND contract_address = lower('0xff0c532fdb8cd566ae169c1cb157ff2bdc83e105')