select block_timestamp::date as date, count(distinct tx_id) / 86400 as TPS -- 1 Day = 86400 seconds

from solana.transactions

where block_timestamp::date >='2022-02-01' and pre_mint is null and post_mint is null

and succeeded = 'TRUE'

group by date