-- DISTINCT chain

date,

CASE

WHEN date < '2022-10-11' THEN 'Before hack'

ELSE 'After hack' END AS period,

CASE

-- WHEN date_trunc(month, date) = '2020-03-01' THEN 'Mainet Beta Launch'

-- WHEN date_trunc(month, date) = '2020-09-01' THEN 'Serum Launch'

WHEN date_trunc(month, date) BETWEEN '2020-09-01' AND '2021-03-01' THEN 'Serum Launch'

WHEN date_trunc(month, date) BETWEEN '2021-04-01' AND '2021-08-01' THEN '$SAMO Launch & First Solana Hackathon'

WHEN date_trunc(month, date) IN ('2021-09-01', '2022-01-01', '2022-03-01', '2022-04-01', '2022-05-01', '2022-06-01', '2022-09-30', '2022-10-01', '2023-02-25', '2024-02-06') THEN 'Network Outage'

WHEN date_trunc(month, date) BETWEEN '2021-10-01' AND '2021-12-01' THEN 'Solana Pay Launch'

WHEN date_trunc(month, date) BETWEEN '2022-02-01' AND '2023-03-01' THEN 'Network Improvements'

WHEN date_trunc(month, date) BETWEEN '2023-01-01' AND '2023-12-01' THEN 'Helium Network Migration'

WHEN date_trunc(month, date) BETWEEN '2023-12-01' AND CURRENT_DATE THEN 'Bonk Mania & Solana Mobile Saga Launch'

END AS milestones,

tvl_usd

FROM external.defillama.fact_chain_tvl

WHERE chain = 'Solana'