twinfault
  • Overview
  • Payments
  • Failures & fees
  • Data health
  • Investigations
  • Unusual days
  • dbt docs
  • Dataset
Data health

Days covered

1,004

of 1,004 expected, Jan 2024 to Sep 2026

Missing or duplicate blocks

0

across 7.18M blocks checked

Days late or rewritten

61

slowest row written over 48 hours after its block (twice the usual)

dbt tests per month

21

every month on this site passed all of them before it was published

Blocks per day (one block every 12 seconds would be 7,200)
Load delay per day (hours from block to file, slowest row, log scale)
Stablecoins’ share of all token transfers on Ethereum (7-day average)
Source files per day (all three source tables)
Days to check before explaining any move
Day Verdict Missing / duplicate blocks Slowest row Transfers
Fri 19 Apr 2024 Late or rewritten 0 / 0 9,546 h 267k
Mon 13 Jan 2025 Late or rewritten 0 / 0 8,805 h 371k
Wed 23 Oct 2024 Late or rewritten 0 / 0 1,149 h 250k
Sat 19 Apr 2025 Late or rewritten 0 / 0 786 h 588k
Sun 28 Dec 2025 Late or rewritten 0 / 0 422 h 1.58M
Wed 13 Mar 2024 Late or rewritten 0 / 0 375 h 226k
Mon 17 Nov 2025 Late or rewritten 0 / 0 352 h 1M
Thu 14 Mar 2024 Late or rewritten 0 / 0 351 h 244k
Wed 07 May 2025 Late or rewritten 0 / 0 350 h 553k
Fri 15 Mar 2024 Late or rewritten 0 / 0 327 h 269k
Thu 08 May 2025 Late or rewritten 0 / 0 326 h 529k
Sat 16 Mar 2024 Late or rewritten 0 / 0 303 h 220k
Fri 09 May 2025 Late or rewritten 0 / 0 302 h 539k
Thu 28 Nov 2024 Late or rewritten 0 / 0 299 h 305k
Sun 17 Mar 2024 Late or rewritten 0 / 0 279 h 210k

61 days in total; the 15 shown are block problems first, then the longest delays.

What is checked, and where
  1. Extract (monthly, from AWS): seven checks on every month, including continuous block numbers, no duplicate blocks, and transfers with no missing amount or address.
  2. dbt (monthly): 21 tests per month, including unique keys, accepted values, no block gaps and a reconciliation that the daily cube adds up to the raw transfers exactly. A month that fails is not uploaded.
  3. Freshness: the load log for last month must be less than 35 days old (warning) or 62 days old (error).
  4. This page: a day is late or rewritten if its slowest row was written more than twice the usual delay (24 hours) after its block. Either the data arrived late, or the source rewrote that day afterwards; both mean the day's numbers may have changed after they were first published. What these days look like is shown on the Investigations page.

The source data is AWS Public Blockchain Data, which AWS labels experimental. That is why completeness is checked from the data itself: block numbers are sequential, so a gap is visible without trusting the loader.

Built by Andreas Othonos · Data: AWS Public Blockchain Data (MIT-0)

 

Rebuilt from the published data on every run · €0 to run