case

when block_timestamp::date < '2024-11-13' then 'before 30 days'

else 'After 30 days'

end as Fableborne,

count(distinct tx_hash) as tx_count,

count(distinct from_address) as user_count,

sum(tx_fee) as fees

from ronin.core.fact_transactions

where block_timestamp::date between '2024-10-13' and '2024-12-13'

group by 1