date(block_timestamp) as date,

count(*) as txns

from eclipse.core.fact_transactions

where block_timestamp > date('2024-11-01')

group by 1