Data Sources

Create lightning-fast pipelines with your subgraphs or live streams by Goldsky and the community.

Dataset

Decoded Traces

Select a chain

Example data

1

Column	Type	Value
`from_address`	string	0x62b8b11039fcfe5ab0c56e502b1c372a3d2a9c7a
`id`	string	decoded_trace_v2_0x0f747e4d5fcd178be6caea3d3261cda34aaee6a4d4bb0b71cb6f0f2b0b5ae97f_447
`method_params`	array
`method_signature`	string	getNow()
`raw_trace`	record	{"block_hash":"0x0f747e4d5fcd178be6caea3d3261cda34aaee6a4d4bb0b71cb6f0f2b0b5ae97f","block_number":22651854,"block_timestamp":1700928857,"call_type":"staticcall","error":null,"from_address":"0x62b8b11039fcfe5ab0c56e502b1c372a3d2a9c7a","gas":"236363","gas_used":"5175","id":"trace_v2_0x0f747e4d5fcd178be6caea3d3261cda34aaee6a4d4bb0b71cb6f0f2b0b5ae97f_447","input":"0xbbe4fd50","output":"0x0000000000000000000000000000000000000000000000000000000065621d59","reward_type":null,"status":1,"subtraces":1,"to_address":"0xa4ff07cf81c02cfd356184879d953970ca957585","trace_address":"0,3,0,1","trace_id":"call_0x09df3734412f9a4061f18e1f24591203107882208151b9fb9be9a979be468aec_0_3_0_1","trace_type":"call","transaction_hash":"0x09df3734412f9a4061f18e1f24591203107882208151b9fb9be9a979be468aec","transaction_index":89,"value":null}
`to_address`	string	0xa4ff07cf81c02cfd356184879d953970ca957585
`transaction_hash`	string	0x09df3734412f9a4061f18e1f24591203107882208151b9fb9be9a979be468aec

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 celo-decoded-traces.yaml to create the pipeline.

celo-decoded-traces.yaml

name: celo-decoded-traces
apiVersion: 3
sources:
  celo.decoded_traces:
    dataset_name: celo.decoded_traces
    type: dataset
    version: 1.1.0
transforms:
  celo_decoded_traces:
    primary_key: id
    sql: |-
      SELECT 
      id, 
      method_signature, 
      method_params, 
      from_address, 
      to_address, 
      transaction_hash, 
      raw_trace.id AS raw_trace_id, 
      raw_trace.block_number AS raw_trace_block_number, 
      raw_trace.block_hash AS raw_trace_block_hash, 
      raw_trace.transaction_hash AS raw_trace_transaction_hash, 
      raw_trace.transaction_index AS raw_trace_transaction_index, 
      raw_trace.from_address AS raw_trace_from_address, 
      raw_trace.to_address AS raw_trace_to_address, 
      `raw_trace`.`value` AS raw_trace_value, 
      raw_trace.input AS raw_trace_input, 
      `raw_trace`.`output` AS raw_trace_output, 
      raw_trace.trace_type AS raw_trace_trace_type, 
      raw_trace.call_type AS raw_trace_call_type, 
      raw_trace.reward_type AS raw_trace_reward_type, 
      raw_trace.gas AS raw_trace_gas, 
      raw_trace.gas_used AS raw_trace_gas_used, 
      raw_trace.subtraces AS raw_trace_subtraces, 
      raw_trace.trace_address AS raw_trace_trace_address, 
      raw_trace.error AS raw_trace_error, 
      raw_trace.status AS raw_trace_status, 
      raw_trace.trace_id AS raw_trace_trace_id, 
      raw_trace.block_timestamp AS raw_trace_block_timestamp 
      FROM celo.decoded_traces}
    description: Unnesting raw_trace
sinks:
  postgres_celo_decoded_traces:
    type: postgres
    table: celo_decoded_traces
    schema: public
    secret_name: YOUR_DATABASE_SECRET
    description: 'Postgres sink for: celo_decoded_traces'
    from: celo_decoded_traces

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Foundational

Dataset

Decoded Traces

Create Pipeline

Select a chain

Celo

Linea

Optimism

Zora

Example data

1

Column

Type

Value

Configuration

Docs

Pricing

Data Sources

Created by you

DeFi

Governance

Social

Foundational

0 more