SELECT

to_date(block_timestamp) as date,

CASE WHEN block_timestamp > '2022-11-08' THEN 'After FTX Event' ELSE 'Before FTX Event' END as event,

sum(FROM_AMOUNT_USD) as from_amount_usd,

sum(LIQ_FEE_RUNE_USD) as liquidity_fee_rune,

count(DISTINCT from_address) as address,

count(DISTINCT tx_id) as count_of_swaps

FROM thorchain.core.fact_swaps

WHERE block_timestamp > CURRENT_DATE - 120

GROUP BY date ,2

), average_data as (

SELECT

event,

avg(from_amount_usd) as average_from_amount,

avg(address) as average_users,

avg(count_of_swaps) as average_no_of_swaps

from thorchain_data

group by 1

select * from average_data