Raw Blocks
Chain
SankoDataset name
sanko.raw_blocksVersion
1.0.0Description
Metadata for each block on the chain including hashes, transaction count, difficulty, and gas used.
Example data
| id | number | hash | parent_hash | nonce | sha3_uncles | logs_bloom | transactions_root | state_root | receipts_root | miner | size | extra_data | gas_limit | gas_used | timestamp | transaction_count | base_fee_per_gas | withdrawals_root | blob_gas_used | excess_blob_gas | difficulty | total_difficulty | withdrawals |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| block_v3_0x9759c8681cd6b355a34049c12fcd3053d6a8934f66fc9923066b9c0dc091986c_0 | 14 | 0x9759c8681cd6b355a34049c12fcd3053d6a8934f66fc9923066b9c0dc091986c | 0xae14fa3874ea6604692c92e0d92f69ab35e2ec45b1108dcaf81a027fa175efe6 | 0x000000000000000f | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0x9be8a78b3dfd1d2f56bc521bd88195e4151e67901129d760b1d5690c29d56a5d | 0x2b17414bf96ee56fba846078b744e961b55d8def93230045083dad876b4c90be | 0xf08cf5553e1dae52e3df19b356b8320e17c39fb055f635739c31052db5c3e45e | 0x2f4ddad3ab0ac4225fd8023ee07d04e2a758017a | 867 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 1125899906842624 | 0 | 1712962206 | 2 | 100000000 | null | null | null | 1 | 15 | null |
| block_v3_0x5f6591b739078250e3f10af389a0df64ceca891d60bfef25c0f680d3bcbd4399_0 | 21 | 0x5f6591b739078250e3f10af389a0df64ceca891d60bfef25c0f680d3bcbd4399 | 0xefbe465fe070be2bd2721c9c88725bf4dc573fd1f7b3651aebfa9081367b59fd | 0x0000000000000015 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0xaf97d811715fc9ba33b91f5b5974d84743269dec18a02ef001ac3430cfedaace | 0x52d7ed86e27cadab80d92e409a4ec36152d160f0225bdf9ed73dfa46ae2db499 | 0xd7a92f3697d06225df2a55e920d2f7a04a4b78f19a42e774c4a3993e342c61bb | 0x670066e03c076cd77d6166caac7ae589ad09fb8a | 784 | 0xd829bfcbe84de02a85ff462dcfb1f6f217ceedaa03cbfe7015ae92d20cdfd556 | 1125899906842624 | 0 | 1713131626 | 2 | 100000000 | null | null | null | 1 | 22 | null |
| block_v3_0xf161f8d65cf3cc7646b88f13e6214dfc8cd25f7112f428a251866d5d4b62878c_0 | 27 | 0xf161f8d65cf3cc7646b88f13e6214dfc8cd25f7112f428a251866d5d4b62878c | 0x09599afd29b804b937c2f2111f66c8ac2b180484815d4e7766ca9e0cbd69f49a | 0x0000000000000018 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0xca61a31efe00a1d49d4b4df2ea85f3154d6cb74171faa52184e9dfad2fdacf7b | 0x6ffd016f513e53b079bda4902b8b70de9b0ff86712ca804db60d615f863dc5fb | 0x000dac31b55e65d9d21c37cbbb672804468233406cff81c001c2632de93de1d6 | 0xa4b000000000000000000073657175656e636572 | 813 | 0xd829bfcbe84de02a85ff462dcfb1f6f217ceedaa03cbfe7015ae92d20cdfd556 | 1125899906842624 | 21053 | 1713141358 | 2 | 100000000 | null | null | null | 1 | 28 | null |
Schema
| Column | Type |
|---|---|
| id | string |
| number | long |
| hash | string |
| parent_hash | string |
| nonce | string |
| sha3_uncles | string |
| logs_bloom | string |
| transactions_root | string |
| state_root | string |
| receipts_root | string |
| miner | string |
| size | long |
| extra_data | string |
| gas_limit | long |
| gas_used | long |
| timestamp | long |
| transaction_count | long |
| base_fee_per_gas | long |
| withdrawals_root | string |
| blob_gas_used | long |
| excess_blob_gas | long |
| difficulty | decimal |
| total_difficulty | decimal |
| withdrawals | string |