SocioCryptoavg tps over time GNOSIS
    Updated 2023-03-15
    SELECT date_trunc('day',block_timestamp) as hours,
    count(DISTINCT tx_hash)/3600 as TPS
    FROM gnosis.core.fact_transactions
    WHERE status = 'SUCCESS'
    GROUP by hours
    ORDER by hours
    Run a query to Download Data