block_timestamp::date as date,

count(tx_id)/86400 as tps,

count(tx_id) as transactions

FROM solana.core.fact_transactions

WHERE block_timestamp::date >= CURRENT_DATE - interval '30 days'

AND succeeded = True

GROUP BY 1

ORDER BY 1 DESC