flipside

    fastest speed and slowest speeed
    datavortexfastest speed and slowest speeed
    Updated 2025-04-29
    WITH tx_receipt_times AS (
    SELECT
    tx_hash,
    MIN(block_timestamp) AS tx_initiated_time,
    MAX(block_timestamp) AS tx_finalized_time,
    TIMESTAMPDIFF(MILLISECOND,
    MIN(block_timestamp),
    MAX(block_timestamp)
    ) / 1000.0 AS finality_seconds
    FROM near.core.fact_receipts
    WHERE block_timestamp >= '2025-04-01' AND block_timestamp < '2026-01-01'
    GROUP BY tx_hash
    )
    SELECT *
    FROM tx_receipt_times
    ORDER BY finality_seconds asc
    LIMIT 500;

    Last run: 25 days ago
    TX_HASH
    TX_INITIATED_TIME
    TX_FINALIZED_TIME
    FINALITY_SECONDS
    1
    		DRdiMApQephtg53v1vhgEWwMw7bPFwRUSaogdFPQUZKV2025-04-23 20:57:52.9052025-04-23 20:57:52.9050
    2
    		D8yT3YDdrHD1giwjmRcDviVv7T3DEQZi3rzimeSqEP3U2025-04-20 11:36:04.0582025-04-20 11:36:04.0580
    3
    		2DeSFtby8eRYxmeHptpapqgvTP7zQFpkhB98A1LhgqFu2025-04-28 02:45:43.8562025-04-28 02:45:43.8560
    4
    		C2fy6Vb5vMJSZb9YsjyrcpvBq7dP8pVAWH7o3KFeSQ4B2025-04-19 14:55:18.4552025-04-19 14:55:18.4550
    5
    		HUBnwYse8P6pMaZm23t7ZqUfsMP8JinC5q7pWpXfDi982025-04-21 11:07:27.8622025-04-21 11:07:27.8620
    6
    		GDMzB8oTEtbAvPxePdzQYBWp5PvyMMDH8VQ4RMb4BLBB2025-04-24 12:45:04.3802025-04-24 12:45:04.3800
    7
    		EthPUp2oS8xTH3KmRzhzFtUiy7NnaAF4Wm7J4duPyg1M2025-04-26 02:00:01.5572025-04-26 02:00:01.5570
    8
    		AKbcu1gaz9goNBtajLm7DMGZF8pY1s9SK2xipUQr9GXS2025-04-16 07:55:02.3032025-04-16 07:55:02.3030
    9
    		Cn4SVovqQiSDbEYE4iQjWsgGmSFNZxkRYU5AsUrMHKa62025-04-24 01:00:13.9972025-04-24 01:00:13.9970
    10
    		BYsZXDPDb8ixTkcaxtTGhYQBiyuSLo3vNMMTMtJihcSi2025-04-15 16:07:51.3382025-04-15 16:07:51.3380
    11
    		85JBV1f2L3zpLvhuwTkN8MEwJjfunzP8M7tDDwppyfhk2025-04-14 17:58:54.2012025-04-14 17:58:54.2010
    12
    		4mtDPKCJZSgKC3fuiMuL92F44JjmF7r9vzqkMajswiTr2025-04-18 08:06:22.3822025-04-18 08:06:22.3820
    13
    		29UKGS5xFyzH4M5CNmB3wm59qqwmtCLQ3eLa4ePbiWGC2025-04-22 01:30:09.0042025-04-22 01:30:09.0040
    14
    		Dua2XZSmZoGTSCcYb73Q7AhBcWAEPDV4EKTampxP12h82025-04-18 18:01:19.3632025-04-18 18:01:19.3630
    15
    		HszCnBqvDzMBf32b5B58Hf8kuLw58fRBB1hwfNsbEPC82025-04-17 16:56:52.4552025-04-17 16:56:52.4550
    16
    		KKudvLTHAAwFgPwr7PitDDjyuF93EfYsSHoZzntLhno2025-04-28 02:18:36.2492025-04-28 02:18:36.2490
    17
    		C4yd8wXMzLHMpnsuBxLtwSRqbsrv8r2Z33MbraVzUDBY2025-04-15 06:41:30.7992025-04-15 06:41:30.7990
    18
    		5UwjrgVAzWXPYmVztnGeh6gPGVJeYX2h19FrckD72xDP2025-04-06 15:30:02.7732025-04-06 15:30:02.7730
    19
    		8pWVSK7Z2aj6iFYonwfTmZRUXthBE6Vk2V1PxN12ynBR2025-04-18 02:03:50.2132025-04-18 02:03:50.2130
    20
    		Nqp7v979Ukx6eH6wwMvjcrurxsbdtev1t9LY24Z9G7L2025-04-27 21:52:17.8532025-04-27 21:52:17.8530
    ...
    500
    50KB
    72s