Switchboard V2

Switchboard allows builders to unlock the power of Solana by creating high performance data feeds from any API.

switchboard.txns

This table has similar schema as of Solana transactions table

switchboard.parsed

The table contains the parsed instructions data for Switchboard. Data related to instruction type, executing account, account arguments, arguments, etc. is available here.

Column Name	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
dapp	string	Solana program address
inner_instruction_index	int	The order of inner instruction of an instruction in a txns
input_accounts	array<string>	Ordered list of accounts to pass to the program
instruction_index	int	The order of the instruction in a txns
instruction_type	string	Name of the function of a Solana program invoked via an instruction
is_inner_instruction	boolean	Whether the respective instruction of a txns has an inner instruction
tx_id	string	The first signature in the transaction
args	<STRUCT>	The arguments passed to the invoked function. Generated after decoding the instructions data parameter

Some columns in the above table needs to be explained a bit for better understanding. Let's go into what each one of them contains.

input accounts

Field	Column Type
aggregator	string
authority	string
callbackPid	string
crank	string
crankDataBuffer	string
dataBuffer	string
escrow	string
feedPermission	string
funder	string
gcOracle	string
historyBuffer	string
instructionsSysvar	string
lease	string
mint	string
oracle	string
oracleAuthority	string
oraclePermission	string
oracleQueue	string
oracleWallet	string
owner	string
payerAuthority	string
payerWallet	string
payoutWallet	string
permission	string
programState	string
queue	string
queueAuthority	string
queueDataBuffer	string
recentBlockhashes	string
tokenAccount	string
tokenProgram	string
vrf	string

args

Field	Data Type
counter	int
failOpenOnAccountMismatch	bool
leaseBump	int
leaseBumps	string
loadAmount	float
mantissa	float
nonce	int
permissionBump	int
permissionBumps	string
proofEncoded	string
scale	int
stateBump	int

switchboard.events

This table has all the switchboard v2 historically parsed events.

Field	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
tx_id	string	The first signature in the transaction
dapp	string	Solana program address
event_type		The name of the event emitted
args	<STRUCT>	The arguments of the respective event

args

Field	Data Type
alpha	string
amount	bigint
authorityPubkey	string
counter	bigint
existingAmount	bigint
feedPubkey	string
funder	string
jobPubkeys	array<string>
leasePubkey	string
loadAmount	bigint
oraclePubkey	string
oraclePubkeys	array<string>
oracleValues	array<STRUCT>
queueAuthority	string
queuePubkey	string
remainingFunds	bigint
roundSlot	bigint
slot	bigint
timestamp	timestamp
val	<STRUCT>
vrfPubkey	string
walletPubkey	string

oracleValues

Field	Data Type
mantissa	double
scale	int

val

Field	Data Type
mantissa	double
scale	int