case when date >= '2023-01-14' then 'After Announcement' else 'Before Announcement' end as timeframe,

action,

count (Distinct tx_id) as Transactions,

count (distinct liquidity_provider_address) as LPers,

sum(amount/pow(10,6)) as LP_Volume

from terra.core.fact_lp_actions

where tx_succeeded = TRUE

and date >= '2023-01-07' and date<= '2023-01-21'

and action in ('provide_liquidity','withdraw_liquidity')

and currency = 'uluna'

group by 1,2,3