DATE as "Date",

case when month(date) <= 3 then 'Q1'

when month(date) between 3 and 6 then 'Q2'

when month(date) between 6 and 9 then 'Q3'

when month(date) between 9 and 12 then 'Q4'

end as "Quarter",

case when year(date) = 2022 then '2022'

when year(date) = 2023 then '2023'

when year(date) = 2024 then '2024'

when year(date) = 2025 then '2025'

end as "Year",

TVL_USD as TVL

from external.defillama.fact_chain_tvl

where CHAIN ilike '%aptos%'

order by 1 desc