SELECT 1000 AS value_1, 100 AS value_2

SELECT

year,

category,

COUNT(DISTINCT address) AS whale_count,

SUM(balance) AS whale_inventory

FROM (

SELECT

PUBKEY_SCRIPT_ADDRESS AS address,

DATE_TRUNC('day', TO_TIMESTAMP(block_timestamp)) AS year,

SUM(value) AS balance,

CASE

WHEN value >= wt.value_1 THEN '1000+'

WHEN value >= wt.value_2 THEN '100+'

ELSE NULL

END AS category

FROM bitcoin.core.fact_outputs

CROSS JOIN whale_thresholds wt

WHERE PUBKEY_SCRIPT_ADDRESS IS NOT NULL

AND value >= wt.value_2

AND TO_TIMESTAMP(block_timestamp) >= CURRENT_DATE - INTERVAL '60 days'

GROUP BY 1, 2, 4

) AS whale_outputs

GROUP BY 1, 2

ORDER BY 1, 2;