Skip to main content
Schema: ethereum.beacon_chain Table: fact_pending_deposits Type: View

​
What

This model details the pending deposits that have been made to the beacon chain of Ethereum. Note on Projected Processing Calculations: The projected processing slot, epoch, and timestamp are calculated using Ethereum’s protocol specification that the deposit queue processes up to 256 ETH per epoch. The calculation sums the ETH amounts of all deposits ahead in the queue (based on queue order from the API’s array_index) and divides by 256 ETH per epoch to determine processing time. These calculations are designed to match external sources like BeaconScan. Calculation Formula:
  • For deposits with submit_slot_number > 0: eth_ahead_at_submission = eth_ahead_at_request + (epochs_passed * 256), where epochs_passed = request_epoch - submit_epoch. Processing epoch = submit_epoch + CEIL(eth_ahead_at_submission / 256).
  • For deposits with submit_slot_number = 0 or NULL: Processing epoch = request_epoch + CEIL(eth_ahead_at_request / 256).
  • Processing slot = processing_epoch * 32 (first slot of the epoch, calculated from epoch for precision).
  • Processing timestamp = genesis_timestamp + (processing_epoch * 32 * 12 seconds).
Important Notes:
  • Deposits can be any amount, not just 32 ETH, so the calculation uses actual ETH amounts rather than deposit counts.
  • Queue position is based on array_index from the API response (1-based, converted from 0-based).
  • Slot and timestamp are calculated directly from epoch to ensure precision and consistency.

​
Columns

Column NameData TypeDescription
REQUEST_SLOT_NUMBERNUMBERThe slot number that the queue was read at.
SUBMIT_SLOT_NUMBERNUMBERThe slot number that the deposit was submitted to the beacon chain at. May be 0 or NULL for deposits that are in the queue but haven’t been assigned a submission slot yet.
PUBKEYTEXTThe public key of the validator that made the deposit.
SIGNATURETEXTThe signature of the deposit.
WITHDRAWAL_CREDENTIALSTEXTThe withdrawal credentials of the deposit.
AMOUNTFLOATThe amount of the deposit, adjusted for the 9 decimal places.
ESTIMATED_PROCESSING_SLOTFLOATThe estimated slot number when the deposit is estimated to be processed, calculated as estimatedprocessingepoch * 32 (first slot of the epoch). The calculation is based on the sum of ETH amounts ahead in the queue and uses Ethereum’s protocol rate of 256 ETH per epoch. For deposits with submitslotnumber > 0, it accounts for ETH processed since submission. For deposits with submitslotnumber = 0 or NULL, it calculates from the request time. Note that deposits can be any amount, not just 32 ETH,…
ESTIMATED_PROCESSING_EPOCHFLOATThe estimated epoch number when the deposit is estimated to be processed, calculated based on the sum of ETH amounts ahead in the queue. For deposits with submitslotnumber > 0, it accounts for ETH processed since submission (epochspassed * 256 ETH). For deposits with submitslot_number = 0 or NULL, it calculates from the request time. Uses Ethereum’s protocol rate of 256 ETH per epoch. Note that deposits can be any amount, not just 32 ETH, so the calculation uses actual ETH amounts rather than…
ESTIMATED_PROCESSING_SLOT_TIMESTAMPTIMESTAMP_NTZThe estimated slot timestamp when the deposit is estimated to be processed, calculated directly from estimatedprocessingepoch for precision: genesistimestamp (2020-12-01T12:00:23Z) + (estimatedprocessing_epoch 32 slots 12 seconds per slot). This ensures consistency with the epoch calculation.
QUEUE_POSITIONNUMBERThe position of this deposit in the queue at the requestslotnumber, based on the array_index from the API response (1-based). This represents how many deposits are ahead in the queue at the time the queue was queried.
TOTAL_QUEUE_SIZENUMBERThe total number of deposits in the queue at the requestslotnumber.
DEPOSIT_IDTEXTThe unique identifier for the deposit. This can be used to find when the deposit processed on the beacon chain. Hash of the submitted slot number and validator public key.
FACT_PENDING_DEPOSITS_IDTEXTThe unique identifier for a row.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp when the pending deposit was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe timestamp when the pending deposit was modified.