case when date < '2021-03-07' then 'first round of airdrop companion '

when date between '2021-03-08' and '2021-06-24' then 'second round of airdrop companion '

when date between '2021-04-12' and '2021-06-27' then 'claiming prriod '

when date between '2021-11-04' and '2021-11-11' then 'trading companion '

else ' other'

end as companion,

count (distinct tx_hash) as Swaps_Count,

count (distinct origin_from_address) as Swappers_Count

from bsc.core.fact_event_logs t1

where t1.origin_to_address in ('0x6352a56caadc4f1e25cd6c75970fa768a3304e64','0x6679800c37e2f7eb072a7af3fb3b81b17a0af153')

and event_name = 'Swap'

group by 1,2