SELECT

t.owner AS address,

t.amount,

t.block_timestamp

FROM $query('ee8999b8-1f68-4ccf-9784-8d2a21e3b7ff') t

),

average_weth_price AS (

SELECT

AVG(price) AS avg_price_usd

FROM ethereum.price.ez_prices_hourly

WHERE token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

AND hour >= '2024-12-01'

AND hour <= '2024-12-31'

),

stake_with_prices AS (

SELECT

s.address,

s.amount,

s.block_timestamp,

a.avg_price_usd

FROM stake_stone s, average_weth_price a

),

daily_totals AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS date,

COUNT(DISTINCT address) AS total_users,

SUM(CAST(amount AS DECIMAL(38, 0)) / CAST(1e18 AS DECIMAL(38, 18)) * avg_price_usd) AS total_amount_usd

FROM stake_with_prices

GROUP BY DATE_TRUNC('day', block_timestamp)

SELECT

'stake stone' AS project,

date,

total_users,

total_amount_usd,