Query editor
/* Calculate weekly holder growth *//* Calculate weekly unique holders of GOAT */WITH weekly_holder_growth AS (SELECTDATE_TRUNC('week', block_time) AS week_start, /* Start of the week */COUNT(DISTINCT trader_id) AS unique_holders /* Unique traders per week */FROM dex_solana.tradesWHEREtoken_bought_symbol = 'GOAT' OR token_sold_symbol = 'GOAT'GROUP BY1ORDER BYweek_start)SELECTweek_start,unique_holders,COALESCE(unique_holders - LAG(unique_holders) OVER (ORDER BY week_start), 0) AS holder_growth /* Week-over-week growth */FROM weekly_holder_growth