date_trunc('day', block_date) as dt,

pool_id,

sum(fees) as fees,

sum(fees_usd) as fees_usd,

case when dt> current_date - 30 then '30days'

when dt > current_date - 60 then '60days'

when dt > current_date - 90 then '90days'

else '180days' end as timeframe

from osmosis.core.fact_pool_fee_day

where dt>= current_date - 180 and fees_usd > 0

group by 1,2

order by dt desc