SELECT

*,

TRY_PARSE_JSON(clean_log):"data" AS data,

data[0]:"amount" / POW(10, 18) AS tokens_burnt

FROM near.core.fact_logs

WHERE

predecessor_id = 'vote1.sweat'

AND receiver_id = 'token.sweat'

AND signer_id = 'treasury.sweat'

AND TRY_PARSE_JSON(clean_log):"data" IS NOT NULL

AND data[0]:"amount" IS NOT NULL

),

prices AS (

SELECT

TRUNC(hour, 'week') AS day,

AVG(price) AS price_usd

FROM near.price.ez_prices_hourly

WHERE symbol = 'SWEAT'

GROUP BY 1

),

burn_events AS (

SELECT DISTINCT

TRUNC(block_timestamp, 'week') AS burn_date

FROM info

),

price_impact AS (

SELECT

p.day,

CASE

WHEN p.day IN (SELECT burn_date FROM burn_events) THEN 'Burn Event'

ELSE 'Non Burn Event'

END AS period,

p.price_usd,

LAG(p.price_usd) OVER (ORDER BY p.day) AS prev_day_price,

(p.price_usd - LAG(p.price_usd) OVER (ORDER BY p.day)) AS price_change,