bouncefinance_v1_arbitrum

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
0x92f742a243904818e9167725ec3b7b992f8eeb2e	Equilibria WhiteList Round	{“openAt”:“1684908000”,“token0”:“0x80b9ad5d275cfa439a8a012d01c548bac1a6313e”,“token1”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“claimAt”:“1685080800”,“closeAt”:“1685080800”,“creator”:“0x41223c547874455272caa7647a71097d39de49c4”,“amountTotal0”:“50000000000000000000000”,“amountTotal1”:“10000000000”}	false	15	0x41223c547874455272caa7647a71097d39de49c4	22	93848621	2023-05-24T05:58:25.000Z	0x6a010f1194f59a23eba1970fcac8e2d8c35127c6de0534d8c976633fa7bdbf86	0xa24ff7ab9d0379e5dfb5519a39c784de93bb7908b1f1c4da4e82ca84ef1ea7a6
0x92f742a243904818e9167725ec3b7b992f8eeb2e	BAL Sale0000001134	{“openAt”:“1679985600”,“token0”:“0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8”,“token1”:“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”,“claimAt”:“1681099200”,“closeAt”:“1681099200”,“creator”:“0x8a7d90aa752fd90d3a7fe6f45b9a172449808561”,“amountTotal0”:“2000000000000000000”,“amountTotal1”:“18000000000000000000”}	false	11	0x8a7d90aa752fd90d3a7fe6f45b9a172449808561	6	74476647	2023-03-28T06:35:31.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x0d100892ad9d9905a321496fcde3afedcd2067ef548aae84f112dcee4a812910
0x92f742a243904818e9167725ec3b7b992f8eeb2e	arb Delayed release pool	{“openAt”:“1677314280”,“token0”:“0xda10009cbd5d07dd0cecc66161fc93d7c9000da1”,“token1”:“0x155f0dd04424939368972f4e1838687d6a831151”,“claimAt”:“1677314880”,“closeAt”:“1677314700”,“creator”:“0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17”,“amountTotal0”:“1000000000000000000”,“amountTotal1”:“100000000000000000”}	false	3	0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17	4	64379348	2023-02-25T08:35:00.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x52063db1e980b031fe9396a01f460423358b5102099683bd1155362b28a5b143

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_arbitrum.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
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	3	2498500000000000	0xe567fc8a6d2d918c50c8d2c3e96ecc0a13430f17	3	600000000000000	97441500000000000	64383446	2023-02-25T08:52:16.000Z	0xfbf562aa5b1f4e6b7c7a8902a0ee772c99f148309e0df391bd2c767513918715
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	43	17500	0x86d38f59c345201c49f389afd0eddace42584b11	8	30000000000000000000	682500	180501862	2024-02-14T00:56:04.000Z	0x87e7a91e6e85577b1914f3bf55f0c1c16f6293bf996e0a2be1fe91e6c10e4de6
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	22	2753100000000	0x7185b9c0c4ffa4eec6ecf100c5bc3583065002ab	1	12324999265840000000002	107370900000000	174210762	2024-01-26T01:05:57.000Z	0x67b30bd8b6d9ff4a5d8c75178f5617bbcb204dfacc22537278b9e77fb700ca16

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_arbitrum.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
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	3	0xfd1b8c5cc66906988fbc324743d3edb9ffb15d26	1	600000000000000	60000000000000	64380958	2023-02-25T08:41:40.000Z	0xcd957530f29c71f3713540770f017548ad144becd6df357b509ff76eb778d305
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	41	0x0adea922ecafeb84e3f586d26ba1ce42432a6eb2	7	3333333333333333333	8000000000	155002581	2023-11-28T19:12:33.000Z	0xe93266bb1b9135e47fcd1240574448aa2d8fe107408e00ee2a6ce571b66736e5
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	41	0x6f106e0ef498a594cce8280976822fa3798a35cb	0	416666666666666666666	1000000000000	154954000	2023-11-28T15:38:22.000Z	0x058a46060d80fb2cb8c0d923b2f9ad516b868101b85365d5d12011a6dadd4c93

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_arbitrum.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
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	16	0x417277f5e6ba2ee4d60259e42b06f6cd0b769490	9	91720770793290300	11006492495194836	113154751	2023-07-20T13:48:42.000Z	0x83ec7af60426397470e9ec50534645a8ca74cad8b9739653ffc6f89cc1a3e08a
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	22	0xfb39b79e97a71e7d8103c5cf708db91390416c6a	1	826666666666	124000000000	135562377	2023-09-28T21:24:36.000Z	0x5e40ace2b12be99ac5e9e527dd916a71a5921efe66c161a1e41168c05ee7f0c2
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	22	0xa09c990e29adf24d040ba5c9518993729da8da9c	81	666666666666666	100000000000000	135398421	2023-09-28T09:52:51.000Z	0xfc8f0bebcecb56a243e61bdd7ea10f50d9c21d15447dbc6da7c687d9ab535151

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bouncefinance_v1_arbitrum.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
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	19	0x70fee4227d63062064b155c4449e9ceef6d5ed99	1	50000000000000000000	128848895	2023-09-07T10:24:17.000Z	0x86ee73c57dee91c2076ba97e3346834512fed90f27f7fd2f593367e6ef2e67a7
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	15	0xd0dd40aa51479b832381fb8403da28be753d4fab	11	212594235000000000000	95728521	2023-05-29T17:21:38.000Z	0xca7d5f9526ff677d70f2fa9e789746259d811d1d98d5c5f5ba78f68373663d94
0x92f742a243904818e9167725ec3b7b992f8eeb2e	false	3	0xfd1b8c5cc66906988fbc324743d3edb9ffb15d26	1	999400000000000000	64383100	2023-02-25T08:50:45.000Z	0xb441ddf3a24d9f7ae71e47c1e36ab26ea660098661c573562c5cb227620ab986

Example Query

Query with partition filter

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