Raw Blocks Data Source

Select a chain

Example data

1

Column	Type	Value
`id`	string	block_v3_0x94d1150c13a2f11395d0b5df3a52e041ea5b7f2590ddc8699e909737929be5e1_0
`number`	long	30
`hash`	string	0x94d1150c13a2f11395d0b5df3a52e041ea5b7f2590ddc8699e909737929be5e1
`parent_hash`	string	0x3243c33cd12c1c158d413c14b64029728b1a383415534f9c1aba942fb93bd626
`nonce`	string	0x0000000000000000
`sha3_uncles`	string	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347
`logs_bloom`	string	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
`transactions_root`	string	0x0000000000000000000000000000000000000000000000000000000000000000
`state_root`	string	0x0000000000000000000000000000000000000000000000000000000000000000
`receipts_root`	string	0x0000000000000000000000000000000000000000000000000000000000000000
`miner`	string	0x0000000000000000000000000000000000000000
`size`	long	0
`extra_data`	string	0x
`gas_limit`	long	1125899906842624
`gas_used`	long	0
`timestamp`	long	1718728175
`transaction_count`	long	0
`base_fee_per_gas`	long	100000000
`withdrawals_root`	string	null
`blob_gas_used`	long	null
`excess_blob_gas`	long	null
`difficulty`	decimal
`total_difficulty`	decimal
`withdrawals`	string	null

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 abstract-testnet-raw-blocks.yaml to create the pipeline.

abstract-testnet-raw-blocks.yaml

name: abstract-testnet-raw-blocks
apiVersion: 3
sources:
  abstract_testnet.raw_blocks:
    dataset_name: abstract_testnet.raw_blocks
    type: dataset
    version: 1.0.0
transforms: {}
sinks:
  postgres_abstract_testnet_raw_blocks:
    type: postgres
    table: abstract_testnet_raw_blocks
    schema: public
    secret_name: YOUR_DATABASE_SECRET
    description: 'Postgres sink for: abstract_testnet.raw_blocks'
    from: abstract_testnet.raw_blocks

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Social

Foundational

0 more