bouncefinance_v1_fantom

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_fantom.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
0x41939809db201c8531d082f95fc5bec187fe2803	false	4	0	0x777beef85e717ab18e44cd054b1a1e33a4a93b83	7	1000000000000000000000	0	73584238	2024-01-02T03:35:38.000Z	0x8485662f0bdd339eaf615af12cc873138f8e9eb87a0d9d8b157934629206cfc5
0x41939809db201c8531d082f95fc5bec187fe2803	false	5	0	0x777beef85e717ab18e44cd054b1a1e33a4a93b83	4	100000000000000000000	0	73584902	2024-01-02T03:56:12.000Z	0x6b83fa377d901388a0db7656b25940988b7a4a0faf20cffb98d323bfbf6bd95a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_fantom.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_fantom.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

address	removed	in_index	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x41939809db201c8531d082f95fc5bec187fe2803	false	2	0x777beef85e717ab18e44cd054b1a1e33a4a93b83	5	100000000000000000000	10000000000000000	73580534	2024-01-02T02:11:04.000Z	0xe6c5643a02953845c9506f6172d2d8fa2923d8c6afa734e373d6f25210809d22
0x41939809db201c8531d082f95fc5bec187fe2803	false	2	0x777beef85e717ab18e44cd054b1a1e33a4a93b83	1	100000000000000000000	10000000000000000	73584565	2024-01-02T03:46:31.000Z	0x57944771a7991d62b66f2ed6d4cc98cce77610eb59c4d58d4153f5915db952fa
0x41939809db201c8531d082f95fc5bec187fe2803	false	2	0x777beef85e717ab18e44cd054b1a1e33a4a93b83	1	800000000000000000000	80000000000000000	73584646	2024-01-02T03:48:33.000Z	0x7fc0bbc6e5989de3224121d021f91845f401368f19c36516f17110df6fbb7972

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_fantom.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_fantom.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