Raw Blocks Data Source

Select a chain

Example data

1

Column	Type	Value
`id`	string	block_v3_0x0c814e782909d257032c95f5303242627c4585e3edd44b5fe6ac6b796922319f_0
`number`	long	17
`hash`	string	0x0c814e782909d257032c95f5303242627c4585e3edd44b5fe6ac6b796922319f
`parent_hash`	string	0x5e87f4033e80c8b68356c5eee72832b5b4a106fc283a1bef6b3da4b6f663ce0d
`nonce`	string	0x0000000000000000
`sha3_uncles`	string	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347
`logs_bloom`	string	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
`transactions_root`	string	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421
`state_root`	string	0x780d8a60ab5504345428cd86c9f6a923dbeed241893aef6cddd58d17d078fbec
`receipts_root`	string	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421
`miner`	string	0x711b0ecb072c27de0e50c9944d7195a51b202522
`size`	long	773
`extra_data`	string	0xd883010f0b846765746888676f312e32332e35856c696e7578
`gas_limit`	long	29505850
`gas_used`	long	0
`timestamp`	long	1755912001
`transaction_count`	long	0
`base_fee_per_gas`	long	103308703
`withdrawals_root`	string	0x2473656fb8056a4e84ed41bb3ba7a6354088f8e45b115917e1297dfaadcdf38a
`blob_gas_used`	long	0
`excess_blob_gas`	long	0
`difficulty`	decimal
`total_difficulty`	decimal	null
`withdrawals`	string	[{"index": "0xffffffffffffffff", "validatorIndex": "0xffffffffffffffff", "address": "0x8ee1af5b2791c7fa6065a02e4b579a9cc78388fb", "amount": "0x3c710450"}, {"index": "0xffffffffffffffff", "validatorIndex": "0xffffffffffffffff", "address": "0x0000000000000000000000000000000000000000", "amount": "0x0"}, {"index": "0xffffffffffffffff", "validatorIndex": "0xffffffffffffffff", "address": "0x711b0ecb072c27de0e50c9944d7195a51b202522", "amount": "0x78e208a"}]

Configuration

To create a pipeline with this configuration, download the configuration below and replace YOUR_DATABASE_SECRET with your database secret. Then, run goldsky pipeline apply 0g-raw-blocks.yaml to create the pipeline.

0g-raw-blocks.yaml

Loading editor...

name: 0g-raw-blocks
apiVersion: 3
sources:
  0g.raw_blocks:
    dataset_name: 0g.raw_blocks
    type: dataset
    version: 1.0.0
transforms: {}
sinks:
  postgres_0g_raw_blocks:
    type: postgres
    table: 0g_raw_blocks
    schema: public
    secret_name: YOUR_DATABASE_SECRET
    description: 'Postgres sink for: 0g.raw_blocks'
    from: 0g.raw_blocks

Docs

Pricing

Data Sources

Dataset

Raw Blocks

Create pipeline

Select a chain

Example data

1

Configuration