bouncefinance_v1_bsc

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

address	in_name	in_pool	removed	in_index	in_sender	log_index	block_number	block_timestamp	in_whitelistRoot	transaction_hash	in_maxAmount1PerWallet
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	TrawlerAI	{“openAt”:“1677979200”,“token0”:“0x8228d995734479c2a61a10f39a814cd5303844a5”,“token1”:“0x0000000000000000000000000000000000000000”,“claimAt”:“1678024800”,“closeAt”:“1678024800”,“creator”:“0xceeac484e8089b8ffcbd57b82d4b4b62900184ce”,“amountTotal0”:“385000000000000000000000000”,“amountTotal1”:“1925000000000000000000”}	false	7	0xceeac484e8089b8ffcbd57b82d4b4b62900184ce	113	26186611	2023-03-05T00:13:42.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0xa9c84601eaf12a9c2f24f4e32b0440aeb4102091a886cb0037a83ec5a0cec4d6	1000000000000000000
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	no limit pool134	{“openAt”:“1678968360”,“token0”:“0x4bd17003473389a42daf6a0a729f6fdb328bbbd7”,“token1”:“0x590d11c0696b0023176f5d7587d6b2f502a08047”,“claimAt”:“1679019360”,“closeAt”:“1679014800”,“creator”:“0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17”,“amountTotal0”:“123456000000000000”,“amountTotal1”:“15241383936000000”}	false	13	0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17	213	26514216	2023-03-16T12:01:57.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x2c98f30b9ada03292f6714f03dbfa5a988f07f1f819808a1953d247d3bc8f445	0
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	POLS FCFS	{“openAt”:“1676761260”,“token0”:“0x7e624fa0e1c4abfd309cc15719b7e2580887f570”,“token1”:“0x0000000000000000000000000000000000000000”,“claimAt”:“1676847660”,“closeAt”:“1676847660”,“creator”:“0x550bd1fe450800a20c8e2c1c514fabb98a7c7739”,“amountTotal0”:“851400000000000”,“amountTotal1”:“85140000000”}	false	4	0x550bd1fe450800a20c8e2c1c514fabb98a7c7739	92	25769463	2023-02-18T08:43:06.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0xce30ea871aa4ed6df52b862a017cd440ac27e681ca24ed017d3ee6f259955f29	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_bsc.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
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	23	30000000000000	0x1ed99d7564b93e9a1086f36ea42bad5b7dc4923f	316	0	1170000000000000	28940172	2023-06-09T03:52:34.000Z	0xdde6317702e628fe725a1935467744fa1df311744b4fdaabbee65ed70b09d4fc
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	14	0	0x9eb3cfcd88c08116e3dcbd51dfb630075f2804e9	81	100000000000000000000000	0	26699907	2023-03-23T00:43:44.000Z	0x047a3b8f3f4b32dd659ee1d6a84b9099e210f7e68dda5074d97bd7bc1252de75
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	42	0	0x828c1e8a9fb0773c70a04612f9d4eed52eea2018	294	15000000000000000000000	0	29543689	2023-06-30T04:10:25.000Z	0xe93532c2f62868be41e342953bf2085445982f906a91a890046fd3668a9f2602

Example Query

Query with partition filter

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

address	removed	in_index	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	35	0xb0157d47836a4cc7a987960ba26138357688d556	248	51398008000	35978605600000000000	29582880	2023-07-01T12:55:42.000Z	0x2cc3b3980d9c35b551e0663aff857434ac2d064bc96d84af909e1f81a1bfc7f3
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	15	0x11179c2d7c94fc091b86d8a64f458906630f4448	161	20000000000000	200000000000	26764521	2023-03-25T07:05:34.000Z	0xb35e46809ba0ea526a2f8c5b8d648ad7650298b623dac2803be2ccb2fd5ef77c
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	15	0x11179c2d7c94fc091b86d8a64f458906630f4448	80	10000000000000000	100000000000000	26764072	2023-03-25T06:42:50.000Z	0xb5b26afe9ab05348bfa287ccbca15280ae92e1269a57a2e15362ced06abdd1da

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_bsc.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
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	35	0xb0157d47836a4cc7a987960ba26138357688d556	286	51398008000	35978605600000000000	29581972	2023-07-01T12:10:09.000Z	0xd49b1f91d1bb85b35c35c5d501cb45532c109ce9da6c194da055963dd7404054
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	35	0xb0157d47836a4cc7a987960ba26138357688d556	199	10000000000	7000000000000000000	29584239	2023-07-01T14:04:02.000Z	0x1789373e3139c8ce38606da80e93fb951f89abdffeb7a1bf01306b9868706049
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	35	0x5abd32773d27f137603925dc681eeccd413936d5	201	2857142857	2000000000000000000	29366833	2023-06-24T00:23:47.000Z	0xca7924a86bd52ddd04758ce0e4456086dcb4ca979433ba67653196c846983164

Example Query

Query with partition filter

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

address	removed	in_index	in_sender	log_index	in_amount0	block_number	block_timestamp	transaction_hash
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	40	0xd4dede1cf6d7dcacf6c3d61addb424056a1cb6f5	187	6039787878650971670742	32337115	2023-10-05T11:50:54.000Z	0x05503331b42a774c4483baf0ca8bd49e81d819fc22b1a5c18301c24b16ecb1a4
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	40	0x980b77e3c433849a6f80f6cd7c386bdb35aa884d	132	25556087658041838365306	32336303	2023-10-05T11:10:18.000Z	0x5c9764945e69506a414ac63fe9a69c8f70e0d6688aa7786f4dbae76c98d32050
0x630f7c658267dc9b9edf3eb92ed56f42fac4c655	false	40	0x5abf14ddcb863e2709201aaf932f826a181cd2e7	251	2662234400000000000000	32339303	2023-10-05T13:40:24.000Z	0x45b5996e7825fc1d765952f8e2000453316a57d4c30eb352565df4d889128873

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BounceFixedSwap_Created_event

BounceFixedSwap_CreatorClaimed_event

BounceFixedSwap_Reversed_event

BounceFixedSwap_Swapped_event

BounceFixedSwap_UserClaimed_event

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