date(block_timestamp) as date,

from polygon.core.fact_transactions

where block_timestamp between '2024-01-01' and '2024-10-01'

group by date,status

order by date

limit 20