bouncefinance_v1_ethereum

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
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	Black Finance	{“openAt”:“1676984580”,“token0”:“0x9c39c8163693db6fa45f6955bccfad4ba7888b22”,“token1”:“0x0000000000000000000000000000000000000000”,“claimAt”:“1677592800”,“closeAt”:“1677592800”,“creator”:“0x58eae5eca3d582fd490da59ae7373db7bbe3c3a0”,“amountTotal0”:“23187600000000000000000”,“amountTotal1”:“2318760000000000000”}	false	17	0x58eae5eca3d582fd490da59ae7373db7bbe3c3a0	168	16676936	2023-02-21T12:40:35.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x267e5363dd849c8014fefa3e9eb8ca663ffafc124e281a9682d396f6981e4316
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	DOGE/ETH	{“openAt”:“1682956800”,“token0”:“0x754b66949ed6bed65e4a56c9279d032529d3df03”,“token1”:“0x0000000000000000000000000000000000000000”,“claimAt”:“1703952000”,“closeAt”:“1703952000”,“creator”:“0x490b4b64285e45b3b83b0ff53a099399c467ba2c”,“amountTotal0”:“30845157000000000000000000”,“amountTotal1”:“987045024000000000000”}	false	27	0x490b4b64285e45b3b83b0ff53a099399c467ba2c	303	17161182	2023-04-30T20:16:59.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0xbf3eef2217997b5008a9f85de864df97d43b41478f072858083f24f3656a2797
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	DOGE/ETH	{“openAt”:“1682956800”,“token0”:“0x754b66949ed6bed65e4a56c9279d032529d3df03”,“token1”:“0x0000000000000000000000000000000000000000”,“claimAt”:“1703995200”,“closeAt”:“1703995200”,“creator”:“0x490b4b64285e45b3b83b0ff53a099399c467ba2c”,“amountTotal0”:“18181818000000000000000000”,“amountTotal1”:“999999990000000000000”}	false	26	0x490b4b64285e45b3b83b0ff53a099399c467ba2c	207	17161170	2023-04-30T20:14:35.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x825c51d42b131c611150ecc6f9e03afb708b162f96025299730e01a2090f7019

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_ethereum.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_sender	log_index	in_amount0	block_number	block_timestamp	transaction_hash
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	28	0xdb3622af8faa16f3c6b2708fad503f6c08a26fd1	114	200000000000000000000000000000	17676635	2023-07-12T09:37:47.000Z	0x05ad0948c6cbce2d86cc01a25189d3cdb7d3821f023ee7288e05a6ebf02b263d
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	24	0x6cb51d84ab399291e1db3b5289089efed3923944	210	20000000	16944674	2023-03-31T04:01:11.000Z	0xa3d3799e6db08c1039100d3a7cb1495f7474d008d57ddc935879a0ad399bfbbe
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	26	0x490b4b64285e45b3b83b0ff53a099399c467ba2c	288	18181818000000000000000000	17161198	2023-04-30T20:20:11.000Z	0x7d2bfa996e74cfcd3c580c2a865805f0d21041d441345c79efd8d1f2fcedc8c9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_ethereum.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
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	10	0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17	180	50000000000000000	10000	16571257	2023-02-06T17:31:35.000Z	0xb5e5cb62d47e079630c40cda92d85accbf7716b29e30aeef1a8a7639a6840cc2
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	74	0x322f482b77ecee57e9b7a6d47877e822ee710be8	79	1706484641638225255972	1000000000000000000	20811724	2024-09-23T07:14:11.000Z	0x1d895b2bd9dc2cdd8604787ec8f61d344fab75bfcf1922725d368f044323d2ce

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_ethereum.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
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	32	0xb10393453df4d543bad5d211fb864dbaabb9d724	168	1162790697	500000000000000	17966353	2023-08-21T23:22:35.000Z	0x2001864c0bd42e38bbf569b38cd01f4234f85776679becc20bec7140ceb316ba
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	32	0x24554ac1a6bedf6fc6e63a1326568d7f84af39dd	243	2325581395	1000000000000000	17965622	2023-08-21T20:55:59.000Z	0xeae709b51879e94573e5b3623e42f3bedba60a54ace96ca70c75b1b2cea0eca2
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	11	0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17	215	500000000000000000	100000	16571261	2023-02-06T17:32:23.000Z	0xda3c14172b31bc5aa7af1539aee8f2d9d32619eaa7e085c6a82ef32f518afa9c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_ethereum.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
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	29	0x9f8c5ec6564096d2108958b06b253b77771f2016	405	15091504251206896551724	18049981	2023-09-02T16:20:23.000Z	0x43baf2eecca9bda32852600738e722a7f5ab29a15f768f6539e1fde3db7e47e8
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	30	0x97e3aed7d21db0887067ead03474488c702c332d	273	6638667622961538461538	18045486	2023-09-02T01:12:35.000Z	0x1d068c7cd7e6144a99bc23bd8682946619dad666d4a7f5118b5a8fe7491e38ec
0x9e2c12d9240bf267fbebd510d47ac3abd4d9d9ee	false	10	0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17	264	950000000000000000	16574091	2023-02-07T03:01:35.000Z	0xeb5b1657403cb1301b0b7e0a186269f461d6a84586af15ceb38cb1c8536e3d21

Example Query

Query with partition filter

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