Skip to content
OnchainQueries

OQ — D01 · DEX & Trading

19 typed tables generated from the BonkSwap IDL — 0 event tables and 19 instruction tables. Every column name comes from the program's own interface definition.

Tables
19
Event tables
0
Instruction tables
19
Account types
5

Program ID

BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p
OQ — D01·1Event tables

BonkSwap declares no events in its IDL, so it has no evt_ tables. That is a property of the program, not a gap in coverage — use the 19 instruction tables below to read what it did and which accounts were involved.

OQ — D01·2Instruction tables

One table per instruction. OnchainQueries also exposes verified account_<name> aliases for instruction account columns when the bundled IDL and the live schema agree.

19/19
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_add_supplybonkswap_bonkswap.call_add_supply
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_add_tokensbonkswap_bonkswap.call_add_tokens
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_close_poolbonkswap_bonkswap.call_close_pool
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_create_dual_farmbonkswap_bonkswap.call_create_dual_farm
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_create_farmbonkswap_bonkswap.call_create_farm
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_create_poolbonkswap_bonkswap.call_create_pool
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_create_providerbonkswap_bonkswap.call_create_provider
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_create_statebonkswap_bonkswap.call_create_state
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_create_triple_farmbonkswap_bonkswap.call_create_triple_farm
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_reset_farmbonkswap_bonkswap.call_reset_farm
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_swapbonkswap_bonkswap.call_swap
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_update_feesbonkswap_bonkswap.call_update_fees
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_update_reward_tokensbonkswap_bonkswap.call_update_reward_tokens
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_withdraw_buybackbonkswap_bonkswap.call_withdraw_buyback
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_withdraw_lp_feebonkswap_bonkswap.call_withdraw_lp_fee
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_withdraw_mercanti_feebonkswap_bonkswap.call_withdraw_mercanti_fee
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_withdraw_project_feebonkswap_bonkswap.call_withdraw_project_fee
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_withdraw_rewardsbonkswap_bonkswap.call_withdraw_rewards
  • bonkswap_bonkswap_solana.bonkswap_bonkswap_call_withdraw_sharesbonkswap_bonkswap.call_withdraw_shares
OQ — D01·3Example

Typed parameters keep values out of the SQL text. Save the file, then pass each value with its type.

bonkswap_bonkswap.sql
SELECT  date_trunc('hour', ts) AS hour,  count(*) AS eventsFROM bonkswap_bonkswap_solana.bonkswap_bonkswap_call_create_dual_farmWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;
shell
query sql \  --file bonkswap_bonkswap.sql \  --param 'start_time:timestamp=2026-08-01 00:00:00' \  --output ./results

OnchainQueries selects an engine, queues the query, and downloads checksum-verified Parquet parts plus a manifest. See the CLI guide.

Pro includes every engine class and 50,000 query credits a month.