case

when block_timestamp::date >= '2022-11-07' then 'After Collapsing'

else 'Before Collapsing'

end as types,

sum(amount/pow(10, decimal)) as total_usd_amount,

count(distinct(sender)) as total_wallet,

count(distinct(tx_id)) as total_transaction

from axelar.core.fact_transfers

where block_timestamp::date >= '2022-11-01'

and amount/pow(10, decimal) < 999999

and tx_succeeded = 'TRUE'

GROUP by types)

select *

from results

order by 1 desc