select * from $query('f6dfb764-1ad5-4744-b69a-40d8ce173cf0')),

tokens_detail as (

select * from $query('c9ab3d58-26d5-45cd-90df-0247f9fa274b'))

select

case

when swaps is null then 'Exclusive AIDOLS Trader'

when date_trunc(day, AIDOLS_FIRST_SWAP)<=date_trunc(day, FIRST_SWAP) then 'Started Trading From AIDOLS'

else 'Traded On NEAR Platforms Before' end as "Category",

count(*) as "Traders",

sum(AIDOLS_SWAPS) as "Swaps",

sum(AIDOLS_VOLUME) as "Trading $Volume",

avg(AIDOLS_DAYS) as "Average Active Days"

from tokens_detail

group by 1