SELECT

date_trunc('week', SLOT_TIMESTAMP) AS week, -- Assuming SLOT_TIMESTAMP is the timestamp

median(staked_eth) AS staked_eth,

median(validators) as validators

FROM (

SELECT

SLOT_TIMESTAMP, -- Ensure this is the timestamp column

count(*) AS validators,

sum(BALANCE) AS staked_eth

FROM ethereum.beacon_chain.fact_validator_balances AS a

LEFT JOIN ethereum.beacon_chain.fact_blocks AS b

ON a.slot_number = b.slot_number

GROUP BY SLOT_TIMESTAMP

) AS subquery

GROUP BY week

), live_data AS (

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/00bdf088-ea6d-45e4-bf60-10267e2b9b0f/data/latest'):"data" AS data

), all_data as (

SELECT --*

FLATTENED.VALUE:DT as week,

FLATTENED.VALUE:MEV as MEV

FROM

live_data,

LATERAL FLATTEN(INPUT => live_data.data) AS FLATTENED

), tab11 as (

SELECT

date(block_timestamp) as day,

sum(GAS_USED * (BLOCK_HEADER_JSON:baseFeePerGas / power(10, 18))) as base_fee,

sum(base_fee) over (ORDER BY day) as total_base_fee

FROM ethereum.core.fact_blocks

WHERE block_timestamp > '2022-09-15'

GROUP BY 1

), tab12 as (