SELECT BLOCK_TIMESTAMP::DATE AS DAYS, SUM(AMOUNT)/1E6 "Provide liquidity",

CASE

WHEN DAYS BETWEEN '2022-12-25' AND '2022-12-31' THEN 'First week of holidays'

WHEN DAYS BETWEEN '2023-01-01' AND '2023-01-06' THEN 'Second week of holidays'

END AS TYPE

FROM terra.core.fact_lp_actions

WHERE DAYS BETWEEN '2022-12-25' AND '2023-01-06' AND ACTION = 'provide_liquidity' AND CURRENCY = 'uluna' AND TX_SUCCEEDED = TRUE

GROUP BY DAYS

ORDER BY DAYS

)

SELECT TYPE, (SUM("Provide liquidity")) AS "Amount of liquidity provided (in LUNA)" FROM ADD_LIQUIDITY GROUP BY TYPE