block_timestamp::date as date,

case when date < '2022-11-08' then 'before ftx and alemmeda failure'

when date >= '2022-11-08' then 'during ftx & Alameda failure'

end as timespan,

count (distinct tx_id) as TX_Count

from osmosis.core.fact_transfers

where tx_status = 'SUCCEEDED'

and transfer_type = 'IBC_TRANSFER_IN'

and block_timestamp >= CURRENT_DATE - 60

group by 1,2

order by 1