bouncefinance_v1_avalanche

Tables

BounceFixedSwap_Created_event

Fixed-price token swap pool creation events from Bounce Finance protocol. Contains pool configuration including token pairs, swap amounts, trading window timestamps, creator address, optional whitelist merkle root, and per-wallet purchase limits.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRUCT<creator STRING, token0 STRING, token1 STRING, amountTotal0 STRING, amountTotal1 STRING, openAt STRING, closeAt STRING, claimAt STRING>`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_whitelistRoot`	`STRING`	Merkle tree root hash for whitelist verification in the fixed swap pool. 66-character hex string including 0x prefix. A value of ‘0x0000000000000000000000000000000000000000000000000000000000000000’ indicates no whitelist is enforced.
`in_maxAmount1PerWallet`	`STRING`	Maximum amount of token1 that can be purchased per wallet address in the fixed swap pool. Numeric string representation in the token’s smallest unit (wei for ETH, base units for ERC20 tokens). A value of ‘0’ indicates no per-wallet limit is enforced.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_avalanche.BounceFixedSwap_Created_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BounceFixedSwap_CreatorClaimed_event

Event emitted when a creator claims proceeds and unsold tokens from a Bounce Finance fixed-price swap pool. Contains swap identifier, creator address, token amounts claimed, and transaction fee deducted by the protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_txFee`	`STRING`	Transaction fee amount collected by the protocol. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	removed	in_index	in_txFee	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x853c97d50604f4c5097d736b2c8b5a5af15b3c02	false	1	0	0x5551eab771073f010a54379498f35f15674a4345	1	700000000000000000000000000000	0	52238853	2024-10-25T18:24:40.000Z	0x16f0a448f8508e76533f6ee53a22d00abe4a2eebab75a4a1e8429d964b70a310
0x853c97d50604f4c5097d736b2c8b5a5af15b3c02	false	0	0	0x5551eab771073f010a54379498f35f15674a4345	2	1000000000000000000000000000000	0	52455700	2024-10-30T22:49:25.000Z	0xb06073262d462cb56da4c46b34b8896c196b44fa14969e2f462205980bb80e26

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_avalanche.BounceFixedSwap_CreatorClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BounceFixedSwap_Reversed_event

Reversal events from Bounce Finance fixed-price swap auctions, recording cancellations or reversals of swap positions. Contains swap index identifier, sender address, and bidirectional token amounts returned to participants.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_avalanche.BounceFixedSwap_Reversed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BounceFixedSwap_Swapped_event

Fixed-price token swap execution events from Bounce Finance protocol contracts. Records sender address, auction index, and bidirectional token amounts exchanged in completed fixed-swap transactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_avalanche.BounceFixedSwap_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BounceFixedSwap_UserClaimed_event

User claim events from Bounce Finance fixed-price token swap auctions. Records successful claims with pool index, claimer address, and token amount received from completed fixed-swap offerings.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_avalanche.BounceFixedSwap_UserClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BounceFixedSwap_Created_event

BounceFixedSwap_CreatorClaimed_event

BounceFixedSwap_Reversed_event

BounceFixedSwap_Swapped_event

BounceFixedSwap_UserClaimed_event

​Tables

​BounceFixedSwap_Created_event

​BounceFixedSwap_CreatorClaimed_event

​BounceFixedSwap_Reversed_event

​BounceFixedSwap_Swapped_event

​BounceFixedSwap_UserClaimed_event

Tables

BounceFixedSwap_Created_event

BounceFixedSwap_CreatorClaimed_event

BounceFixedSwap_Reversed_event

BounceFixedSwap_Swapped_event

BounceFixedSwap_UserClaimed_event