Osmo_info as (

SELECT

date_trunc('day', block_timestamp) as day,

sum(amount / power(10, decimal)) as avax_volume,

COUNT(DISTINCT RECEIVER) as my_users,

COUNT(DISTINCT TX_ID) as transaction_count

FROM

osmosis.core.fact_transfers as FT

LEFT outer JOIN osmosis.core.dim_labels as DL ON FT.currency = DL.address

WHERE

project_name LIKE '%AVAX%'

AND sender LIKE 'axelar%'

AND receiver LIKE 'osmo%'

GROUP BY

day

)

CASE

WHEN day > '2023-01-30' THEN 'Incetivsed'

ELSE 'Pre-Incetivsed'

END as time_frime,

avg(avax_volume) as volume,

avg(transaction_count) as transactions,

avg(my_users) as users

Osmo_info

GROUP BY

time_frime