bufferfinance_v1_arbitrum - Token Terminal Docs

Tables

ARBBufferBinaryOptions1_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum, capturing option ID, trader account, total fees, and settlement fees. Used for analyzing trading volume, fee structures, and user behavior in Buffer’s binary options contracts.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
3205	0xbe4e89945db947abb4f931f9239bb9de8f662b27	false	7	0x073f8e2d22c2c74dfe98ad998741bcce2c399152	25000000000000000000	115378040	2023-07-27T07:04:11.000Z	4062499999999999989	0x907717322a13897880fc1874ca6a59108beec1e462c30fd22241a8afee94a571
3209	0xbe4e89945db947abb4f931f9239bb9de8f662b27	false	16	0x073f8e2d22c2c74dfe98ad998741bcce2c399152	30000000000000000000	115454783	2023-07-27T12:25:29.000Z	4874999999999999987	0xb3f307b84ab3e617046164fd08cae47bf67048710ae6392f55ea2c6393c4d212
3208	0xbe4e89945db947abb4f931f9239bb9de8f662b27	false	18	0x073f8e2d22c2c74dfe98ad998741bcce2c399152	50000000000000000000	115416596	2023-07-27T09:45:03.000Z	8124999999999999978	0x236e7ab0d14fa1413e94220480d8bcc3bf4af5df9bc54a33681306a88c11d35e

Example Query

Query with partition filter

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

ARBBufferBinaryOptions10_Create_event

Binary options contract creation events from Buffer Finance on Arbitrum, capturing option IDs, trader accounts, and fee structures. Used for tracking option origination activity and fee analysis across Buffer’s prediction market 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
6	0x2578a97ad34c837ea4296190a122bbcf868d9970	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	75264573	2023-03-30T13:33:27.000Z	69999999999999999760	0xf4f20f5b36257c7d5b02cecf9f2e2817b5f42f92b49e5bc57015389010b8138d
5	0x2578a97ad34c837ea4296190a122bbcf868d9970	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	800000000000000000000	75257029	2023-03-30T13:02:43.000Z	111999999999999999615	0x75301b1040ebe35f11fcded00bde741a58e0651a97c53477f6ea1dd35aeabf93
4	0x2578a97ad34c837ea4296190a122bbcf868d9970	false	5	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	800000000000000000000	75254192	2023-03-30T12:51:05.000Z	111999999999999999615	0xacdc739fba770c0e86ba218a3f23ad7949071a27384de0f396b8a1270a958472

Example Query

Query with partition filter

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

ARBBufferBinaryOptions11_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option IDs, trader accounts, total fees paid, and settlement fees. Used for analyzing options trading activity, fee structures, and user participation patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
6	0x254f94ee41a3b6228f2a191f2c964789f0dcdc31	false	4	0x7285e0b39921c4329c28e67f4e941e80328772d2	94000000000000000000	76385627	2023-04-02T20:35:22.000Z	13159999999999999955	0xda3ded1256369beea802f4adaa9460c2c65685657215aa66d4fa45019b9504fb
3	0x254f94ee41a3b6228f2a191f2c964789f0dcdc31	false	4	0x7285e0b39921c4329c28e67f4e941e80328772d2	70000000000000000000	76377576	2023-04-02T20:01:20.000Z	9799999999999999967	0xe2887523709beedcfe09a99e5f702135ca500e072f5c99975989ec9afb841a1a
4	0x254f94ee41a3b6228f2a191f2c964789f0dcdc31	false	5	0x7285e0b39921c4329c28e67f4e941e80328772d2	70000000000000000000	76384267	2023-04-02T20:29:33.000Z	9799999999999999967	0x8e21223fd6f1c8b2b738d15785453ef11965f4b225886545fc7cdd27e9a4aaf7

Example Query

Query with partition filter

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

ARBBufferBinaryOptions12_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum. Captures user accounts, position IDs, total fees paid, and settlement fees for analyzing options trading activity and fee structure.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
2	0xa5f3bd207eafab401571751ecfa83278edb1fd8c	false	22	0x7285e0b39921c4329c28e67f4e941e80328772d2	200000000000000000000	75026767	2023-03-29T21:00:30.000Z	27999999999999999904	0xe1794b03ff4b9a548920d78e49fbd314c458f258d6abd7bd7fd69ea528ac88a2
3	0xa5f3bd207eafab401571751ecfa83278edb1fd8c	false	15	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	700000000000000000000	75102398	2023-03-30T02:23:03.000Z	97999999999999999663	0xcc20624d28c102aa7a19b19ce00730b976be84d0420cb083d86acc1937ca6441
4	0xa5f3bd207eafab401571751ecfa83278edb1fd8c	false	15	0x8907623e09502a19cdf825e75dd834d48fa1914e	1000000000000000000	76556286	2023-04-03T08:48:31.000Z	140000000000000000	0xe78bb130f95f76356b56613debf0887c13ab63418a8bcb54660952ca6d116ef4

Example Query

Query with partition filter

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

ARBBufferBinaryOptions13_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing each new options position with account details, option ID, total fees, and settlement fees denominated in wei.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
1	0xf2bef06229cd20fbad9c5a64bf04fccfc8f088a9	false	13	0x7285e0b39921c4329c28e67f4e941e80328772d2	100000000000000000000	75372106	2023-03-30T21:00:14.000Z	13999999999999999952	0x1375f1e07a20d9c0f0d7ef9ce858bb5c6f4ea5f49769ab0b43add448dd1cc127
0	0xf2bef06229cd20fbad9c5a64bf04fccfc8f088a9	false	4	0x7285e0b39921c4329c28e67f4e941e80328772d2	18000000000000000000	73987392	2023-03-26T20:33:39.000Z	2519999999999999992	0xf5efac3a1021f7b6092c3a6ee58b28ee1fab18189b5b910d7028cc37e737c318

Example Query

Query with partition filter

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

ARBBufferBinaryOptions14_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, tracking new option positions with user accounts, sequential IDs, and fee amounts. Used for analyzing option creation activity and fee structures on the platform.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
1	0x2700ea9458a0e7a9ebd0936a0f9c20db3038ad55	false	18	0x7285e0b39921c4329c28e67f4e941e80328772d2	200000000000000000000	75372258	2023-03-30T21:00:52.000Z	27999999999999999904	0x32a707ec940bd0f9dca9197128a087cf308ae356ce4a4258f0fe89a1f6e91413
2	0x2700ea9458a0e7a9ebd0936a0f9c20db3038ad55	false	24	0x7285e0b39921c4329c28e67f4e941e80328772d2	40000000000000000000	75372383	2023-03-30T21:01:24.000Z	5599999999999999981	0x37f6a7cebb47d62e004020bf71c232ea07f5dc130db9a19c8a30d6f87fcdb8a4
0	0x2700ea9458a0e7a9ebd0936a0f9c20db3038ad55	false	16	0x7285e0b39921c4329c28e67f4e941e80328772d2	20000000000000000000	73980993	2023-03-26T20:06:45.000Z	2799999999999999991	0x2afdf559598c69bdd799944a7fb2dc6366b4a20a309c8aa534f0dc9a07488e3d

Example Query

Query with partition filter

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

ARBBufferBinaryOptions15_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option positions with associated fees and user accounts. Used for tracking option issuance activity, fee structures, and trader participation in the binary options market.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
6	0x5ee2352d01f3c3e29f06ad0cc99692b43d2814fa	false	6	0x20197bef251be2a7932dcd7cb2b341c8e31e095e	10000000000000000000	76587804	2023-04-03T10:59:51.000Z	1149999999999999992	0x2745c217ad7fc072bda419202ded59b1b746abe2623b99239626501f3c18f484
7	0x5ee2352d01f3c3e29f06ad0cc99692b43d2814fa	false	7	0x7285e0b39921c4329c28e67f4e941e80328772d2	300000000000000000000	76732567	2023-04-03T21:02:58.000Z	41999999999999999856	0x7395ea0c617c6219bf258af91fcb00f346388af8fbaaddd457e098b0b9753aca
3	0x5ee2352d01f3c3e29f06ad0cc99692b43d2814fa	false	4	0x7285e0b39921c4329c28e67f4e941e80328772d2	70000000000000000000	76378075	2023-04-02T20:03:25.000Z	9799999999999999967	0xa9bf500d704b2eacef142c44f491bce1cf69196ff051839a15daf5e0dcf62938

Example Query

Query with partition filter

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

ARBBufferBinaryOptions16_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, tracking option IDs, user accounts, total fees, and settlement fees. Used for analyzing options trading activity, fee structures, and user participation patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
191	0xaa633fb6299ed56b0e408fd3b36c37ed892fa7b5	false	44	0xeb10d6081915c6c180eb81a6125a6ff29b8d8f36	8000000000000000000	135357241	2023-09-28T07:00:04.000Z	1600000000000000000	0x3a49951833c1994d7cf7fc3cf72e9a77a0bea532298485d54adbc11f882f946c
192	0xaa633fb6299ed56b0e408fd3b36c37ed892fa7b5	false	11	0xeb10d6081915c6c180eb81a6125a6ff29b8d8f36	15000000000000000000	135358526	2023-09-28T07:05:26.000Z	3000000000000000000	0x4c5f1be7f7900176aeae9e2459329ebe7c31cd55dc9b483b55c14b5bc7b3bdb0
12	0x0c250bdecd596a53d1c7363482f078ef9e6da867	false	10	0x08f518870ec33bc96cc251692b79a745c1af78b5	5000000000000000000	128629702	2023-09-06T16:41:04.000Z	587499999999999994	0xb67e5a37de6530b9ed173ec4d4ac2c7056bf3a82615f65259b11106bbb4d6aee

Example Query

Query with partition filter

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

ARBBufferBinaryOptions17_Create_event

Binary options contract creation events from Buffer Finance on Arbitrum, capturing option ID, trader account, total fees paid, and settlement fees. Used for tracking options issuance activity and fee analysis across Buffer’s binary options contracts.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
68	0x31f20a37e096a6ac552446e6a073eb49a580ea4b	false	10	0x352f09110eadfcd5fd46bfa7b56770c04d3cfbbb	5000000000000000000	139671843	2023-10-11T12:59:27.000Z	624999999999999996	0x0ab38aba19b749ebdcf012094d23752a1e3f5ed3cf087edc7f57e5f8f6087fed
0	0x41216c52821624d0417bfabf628757453329b2f3	false	11	0x77e5428700ac0a9e712611d79a38dde9ea141da8	5300000000000000000	136599599	2023-10-01T23:58:18.000Z	662499999999999996	0xd3a52f52e8d79a8b1d322f37e01b5709c4c55d390e70858bf256f84729dc113b
11	0x31f20a37e096a6ac552446e6a073eb49a580ea4b	false	7	0x3e5d00bbea6048a9bf7fc1e00cfcebac71ecfb20	16510000000000000000	136596672	2023-10-01T23:43:52.000Z	2476499999999999981	0x57e830841eb87e9c8294926dc0e591c2d0c79424d05f19b439c2f7a6a63364aa

Example Query

Query with partition filter

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

ARBBufferBinaryOptions18_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing account addresses, position IDs, and fee amounts (total and settlement) charged at option initiation. Used for analyzing trading activity, fee economics, and user behavior in the Buffer binary options market.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
352	0x39aef1cb9d2be4c41a57b67d258c018dedcc893f	false	34	0x0e8d670d40f8784c7ebb1f1a67902a6086f5f87c	14800000000000000000	170114472	2024-01-13T17:29:44.000Z	739999999999999986	0x8ad39d1b41e2ecfd71f111720f31bfca8670e3629afaed965a4c89f913cc0f52
615	0x39aef1cb9d2be4c41a57b67d258c018dedcc893f	false	7	0x3445bf2664c254a50dab069bc512e6341095254d	5000000000000000000	192560841	2024-03-21T04:18:20.000Z	249999999999999996	0x398a2f9c5f66a72986816c61db394e8683a46147eebe0c0203d35dbef483a28a
616	0x39aef1cb9d2be4c41a57b67d258c018dedcc893f	false	24	0x74be3727bff63c9b1117ce142d441989bfdf1155	15000000000000000000	192770225	2024-03-21T18:52:39.000Z	749999999999999986	0x2abbc436680b7c226c6482f2fcf9bda4712d5650e9c2740be7f32c842ff6ae82

Example Query

Query with partition filter

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

ARBBufferBinaryOptions2_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum, capturing trader accounts, sequential option IDs, total fees paid, and settlement fees. Used for analyzing trading activity, fee structures, and user participation in the options platform.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
1911	0x5b58cc39360472c908a26b129cf19f533ff00ace	false	9	0xd494b0357f510010f7044270a96373afe1f1b5df	25000000000000000000	92848386	2023-05-21T06:30:00.000Z	3249999999999999980	0x9b5916fbd9efa4502d6b97bc7775aefb02509eec7c8debac1dce16d04da69222
1910	0x5b58cc39360472c908a26b129cf19f533ff00ace	false	5	0xd494b0357f510010f7044270a96373afe1f1b5df	25000000000000000000	92844905	2023-05-21T06:15:13.000Z	3249999999999999980	0x5fe9301ba9d40bfdf18aa1f06f8cbe4b624491b1558e372813f88283dcd8a39a
1913	0x5b58cc39360472c908a26b129cf19f533ff00ace	false	4	0xd494b0357f510010f7044270a96373afe1f1b5df	40000000000000000000	92866161	2023-05-21T07:45:00.000Z	5199999999999999968	0x70b8ac613b53238dc1fb36c350a066c117611d744ff0c9a8d23952b6032c0afe

Example Query

Query with partition filter

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

ARBBufferBinaryOptions3_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum, tracking option ID, trader account, total fees paid, and settlement fees. Used for analyzing trading activity, fee structures, and user positions in the binary options market.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
2	0x32f6ba7bb3f0436fcc080308d1398a3fc2fef3be	false	12	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000000000000000	76638637	2023-04-03T14:29:47.000Z	177499999999999999	0x07c844c2a3bd4ba1bf0cdb2d36a530a82924ee4e9078d5f7bb8c5791d8b620c6
0	0x32f6ba7bb3f0436fcc080308d1398a3fc2fef3be	false	12	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	75890495	2023-04-01T09:31:01.000Z	94999999999999999595	0x37b545a25652678a577a37ed4def7572c254316c032ff3636f33280ca07e19ab
1	0x32f6ba7bb3f0436fcc080308d1398a3fc2fef3be	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	76132016	2023-04-02T02:45:51.000Z	94999999999999999595	0x438c07dc65d0989d5cf18d04a4e06e844cab43dce9d41f667de8fc6e4635b196

Example Query

Query with partition filter

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

ARBBufferBinaryOptions4_Create_event

No description available.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

ARBBufferBinaryOptions5_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option ID, trader account, total fees, and settlement fees. Used for tracking options issuance activity and fee structures across different position sizes.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
154	0x37a42a8841fff3d47351e68a2c31add4a1080358	false	7	0xcdc66a141b94af6d47030bef7c2209ff3ef23bb7	50000000000000000000	84678222	2023-04-27T01:53:38.000Z	5374999999999999997	0x5c1707f19b3f54abefd61e6de6ca4b8e118be7e5d5a4f93eb0b1bbd9061bf9e0
153	0x37a42a8841fff3d47351e68a2c31add4a1080358	false	6	0xcdc66a141b94af6d47030bef7c2209ff3ef23bb7	50000000000000000000	84678093	2023-04-27T01:53:06.000Z	5374999999999999997	0xf4f2a2e7350a34722b0cbdb8e708daf53c65675ea66b3ea166d6e7010edbdbd0
150	0x37a42a8841fff3d47351e68a2c31add4a1080358	false	6	0xcdc66a141b94af6d47030bef7c2209ff3ef23bb7	50000000000000000000	84653661	2023-04-27T00:10:24.000Z	5374999999999999997	0x17ea96d24f4097fa85e90cb80acc3dcbe24a08a8f620f17b9bf15529a8f01bdb

Example Query

Query with partition filter

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

ARBBufferBinaryOptions6_Create_event

Binary options creation events from Buffer Finance on Arbitrum, capturing new option positions with user accounts, fee amounts (total and settlement), and sequential option IDs. Used for tracking option initiation activity and fee structures in Buffer’s prediction markets.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
78	0x175e5ce07ad6a15e9cbb49e27ff94ec8e2fc0562	false	4	0x73670c53d79ed4dfaec0451fcee5ea32eea49536	25000000000000000000	81386891	2023-04-17T11:48:22.000Z	3749999999999999971	0x18b4917b38aa2a7ec4f660e0794c1045729ebf756a9498baf1daaa044117e256
79	0x175e5ce07ad6a15e9cbb49e27ff94ec8e2fc0562	false	6	0x9cbc96150f8dd62aab7f5f7a68128e21a4106018	25000000000000000000	81432166	2023-04-17T14:55:44.000Z	3437499999999999988	0xa6bce6838087633c68ae27e073009d08b0868ebafe3ae997247904199bda0bc0
81	0x175e5ce07ad6a15e9cbb49e27ff94ec8e2fc0562	false	6	0xc59d9bde86f712a45cbf086445fd6c1e6f6e5045	100000000000000000000	81525107	2023-04-17T21:19:53.000Z	14999999999999999881	0x204b8eaa2a0799fb29e6ad89101dc4decaa08b8e2990ae1e06ee8c81a0b47d6c

Example Query

Query with partition filter

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

ARBBufferBinaryOptions7_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option initialization with position identifiers, trader accounts, total fees, and settlement fees. Used for tracking option opening activity and fee analysis across the platform.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
5	0x65d01535f16b9d08513b2d11c8f6b93e7d58e946	false	12	0x8885c09a635b28f7c4437c1b987e4635cd4f456b	50000000000000000000	75270173	2023-03-30T13:56:27.000Z	6999999999999999976	0x44516b87e621295394d1b20dcfccc6c2766f9281322e48d947e7c7073f008f74
1	0x65d01535f16b9d08513b2d11c8f6b93e7d58e946	false	12	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	75097498	2023-03-30T02:02:34.000Z	69999999999999999760	0x8d08b334c75134ab817021ac16dae46041c56e271af5fd10eae2e669b005248b
0	0x65d01535f16b9d08513b2d11c8f6b93e7d58e946	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	75096124	2023-03-30T01:56:48.000Z	69999999999999999760	0x6c5b100a9f81842a851fa1d01552a1b7e5326cb3397c720ec6acd34551a817e7

Example Query

Query with partition filter

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

ARBBufferBinaryOptions8_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum, capturing option ID, trader account, total fees paid, and settlement fees. Used for analyzing trading volume, fee structures, and user activity in decentralized binary options markets.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
5	0x54f0cc19f6b71fa70f028230f97bf9cbdd954098	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	74947808	2023-03-29T15:28:56.000Z	69999999999999999760	0x9004592e01e4249d90b04de2f6e39f9fe097dbf6a228d0b6e55082f861371db1
4	0x54f0cc19f6b71fa70f028230f97bf9cbdd954098	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	74892001	2023-03-29T11:37:39.000Z	69999999999999999760	0xb88eca4f80b6897e80f6bbdb149c631f9a31de954e3fb3eb938a730e85837ac3
2	0x54f0cc19f6b71fa70f028230f97bf9cbdd954098	false	4	0x1921fe43d0d6990944f75e1e94317e1fbd32b4d4	8000000000000000000	74601426	2023-03-28T15:12:34.000Z	919999999999999994	0xfa63ea7d63a9ee99500f5afe7c77b0680f9f860cb539e2f2caad8bd8b7e9305c

Example Query

Query with partition filter

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

ARBBufferBinaryOptions9_Create_event

Binary options contract creation events from Buffer Finance protocol on Arbitrum, capturing option ID, user account, and fee structure (total and settlement fees) for each new position. Used for tracking options issuance, fee analysis, and trader participation patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
0	0x99ce137ac1378db2ab91e1132b084f100be9c2e9	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	74793648	2023-03-29T04:48:53.000Z	69999999999999999760	0x95c7b7da2ac39824c9f5ab13cc79c3e179b0f6e8da332cdebdd5b511f379ab39
1	0x99ce137ac1378db2ab91e1132b084f100be9c2e9	false	4	0xf8905baf83728e2e7a53bfc1dae345212fa315a1	500000000000000000000	74795043	2023-03-29T04:54:41.000Z	69999999999999999760	0x0ebe101f1703326c9764c92ac923cafe675b7f56803703e248a4e38336c0fe69
2	0x99ce137ac1378db2ab91e1132b084f100be9c2e9	false	24	0x7285e0b39921c4329c28e67f4e941e80328772d2	100000000000000000000	76733022	2023-04-03T21:04:48.000Z	13999999999999999952	0x1dde4d3869c81ea1d0044e9f1f475de083d3f2d77495b3465697a2f0b25a71c2

Example Query

Query with partition filter

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

BFRBufferBinaryOptions1_Create_event

Binary options contract creation events from Buffer Finance protocol on Arbitrum, capturing option IDs, trader accounts, total fees paid, and settlement fees in wei. Used for analyzing trading volumes, fee structures, and user activity patterns in the options marketplace.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
425	0xdbedc2a1aa21a87879f4cc062e18190d5525c084	false	5	0x81056bb6021d2a26935af97ecb09701ee1cef6f8	1000000000000000000000	107016360	2023-07-02T05:16:56.000Z	129999999999999999183	0x79e3f2741917b1b73e3036010894ec7ae2e5a6b38f4d3f22fd5279504e0afac3
430	0xdbedc2a1aa21a87879f4cc062e18190d5525c084	false	7	0xb61adeccc0683e7df27d531452e381954891becc	321488939371612981882	107150376	2023-07-02T14:45:03.000Z	32952616285590330621	0xfdee6bfdd996625e256db750f838bae73701d9cdea4de6d3726befbe18efa284
429	0xdbedc2a1aa21a87879f4cc062e18190d5525c084	false	7	0xb61adeccc0683e7df27d531452e381954891becc	294739130414313888097	107125252	2023-07-02T13:00:03.000Z	30210760867467173510	0xc70831867f803834836bcb45d2db7b487e226f1d3fc700fd59dc703c24d19b0e

Example Query

Query with partition filter

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

BFRBufferBinaryOptions10_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing position entries with option IDs, user accounts, and fee structures. Used for tracking option creation activity and fee analysis across the platform’s trading pairs.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
1672	0xdbedc2a1aa21a87879f4cc062e18190d5525c084	false	8	0x8aacec3d7077d04f19ac924d2743fc0de1456941	41000000000000000000	157139842	2023-12-05T14:40:16.000Z	7174999999999999967	0xa77ad701d53ecd5ae0e1ae506681550336a8b697810026ed1aaeb39ed2cae260
360	0x5fc7b38f1bc237069145af7acfbb9eb0a8e1b4b5	false	44	0x08f518870ec33bc96cc251692b79a745c1af78b5	100000000000000000000	111216851	2023-07-14T19:04:03.000Z	13249999999999999927	0xd0bebc5e532f0abc194ef770e078a00be3f8e07c737db15be1d915d012bddba2
353	0x5fc7b38f1bc237069145af7acfbb9eb0a8e1b4b5	false	16	0xb61adeccc0683e7df27d531452e381954891becc	147979328878838597421	111101018	2023-07-14T11:00:02.000Z	18867364432051921064	0x4b2ac7b9443859d58e0d6b8455e18e20446a0329e9fbe2741feb9b52a80aa2a6

Example Query

Query with partition filter

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

BFRBufferBinaryOptions2_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option position openings with account addresses, position IDs, total fees, and settlement fees. Used for tracking user activity and fee structure analysis across the platform’s options trading activity.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
474	0x5fc7b38f1bc237069145af7acfbb9eb0a8e1b4b5	false	5	0x0173b11fa1f645d2be989e0aa8a6298d3f4ee15f	40000000000000000000	141418806	2023-10-17T14:05:41.000Z	6999999999999999967	0x4b3de3fa1cdbced185f9b634cc54dd305b86c4d8b6da8aa1a89939aa09a4f8a2
377	0x5fc7b38f1bc237069145af7acfbb9eb0a8e1b4b5	false	5	0x074f6d8ab6bcdf3ceb1521e2c70ab53ddbbb7c69	40000000000000000000	114587780	2023-07-24T21:29:04.000Z	6999999999999999967	0xb2005bc8049a9e7850db70d90c0945cffa1a925ce75ec90daf15fc4291cc3ec0
382	0x5fc7b38f1bc237069145af7acfbb9eb0a8e1b4b5	false	5	0x074f6d8ab6bcdf3ceb1521e2c70ab53ddbbb7c69	50000000000000000000	114591996	2023-07-24T21:47:51.000Z	8749999999999999959	0x902d4e6d213e2628c59113ef36870545051f8e43bd7dd249c5a68e57f2e18e0b

Example Query

Query with partition filter

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

BFRBufferBinaryOptions3_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, tracking new option positions with associated fees and settlement costs. Useful for analyzing option trading volume, fee structure, and user behavior in decentralized binary options markets.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
21	0xac5337d5a53ff32887bf7829a44ae1f5f3166c4b	false	9	0x066adb9a8788d6fc00678551eb3b232158a1c261	202000000000000000000	113538680	2023-07-21T17:36:51.000Z	30299999999999999760	0xf1650c31283171137022c5ee2d71667883d65a9eb631fdfc022997b7de7f3706
20	0xac5337d5a53ff32887bf7829a44ae1f5f3166c4b	false	5	0x066adb9a8788d6fc00678551eb3b232158a1c261	202000000000000000000	113533851	2023-07-21T17:15:26.000Z	30299999999999999760	0x88d70fa038ab5b76faf99ea25cff821fc7bd58f155c0839115b4d33d9b2df72d
18	0xac5337d5a53ff32887bf7829a44ae1f5f3166c4b	false	5	0x066adb9a8788d6fc00678551eb3b232158a1c261	288000000000000000000	113522897	2023-07-21T16:27:29.000Z	43199999999999999658	0xa6ff1e90b898a33c99f183c9cd3604c94a540f1269e56325228ef498c37c3a3d

Example Query

Query with partition filter

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

BFRBufferBinaryOptions4_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing position opens with unique IDs, account addresses, and fee structures including total and settlement fees. Used for tracking user trading activity and fee revenue analysis in the BFR binary options product.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
15	0x12d974e8f0030f002552e0451d750de0c0ed6bc3	false	7	0x08f518870ec33bc96cc251692b79a745c1af78b5	100000000000000000000	115484781	2023-07-27T14:31:03.000Z	10749999999999999993	0xb595a2b67434bf39b25b44b3a9b5defda92e3fca9350464fec14fbfa31ef14bc
17	0x12d974e8f0030f002552e0451d750de0c0ed6bc3	false	13	0x08f518870ec33bc96cc251692b79a745c1af78b5	200000000000000000000	115558210	2023-07-27T19:56:02.000Z	21499999999999999986	0x7ae96f1840be0cc4310e61c4d3eee84c32746a0a1d2bc195fce81213212b6246
16	0x12d974e8f0030f002552e0451d750de0c0ed6bc3	false	34	0x08f518870ec33bc96cc251692b79a745c1af78b5	200000000000000000000	115488819	2023-07-27T14:48:08.000Z	21499999999999999986	0x9931faf280eefb7d545ec1a428ae9cc2c92b9e9dbcbcabdb58354a946ea6dba2

Example Query

Query with partition filter

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

BFRBufferBinaryOptions5_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum, capturing option IDs, trader accounts, and fee amounts in wei. Used for tracking new binary option positions and analyzing fee structures across trading activity.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
45	0xa1568547ca58ef4c5621e031173e003cabb9b438	false	5	0x4a6727fe58592d02cabd31fb88e9ee1a910d3225	320000000000000000000	129600267	2023-09-09T20:16:38.000Z	55999999999999999736	0x9cdce8e2392dc45e93446559192b6ddf8411901f6dd4cf5a07a90b431bdf2f1d
29	0xa1568547ca58ef4c5621e031173e003cabb9b438	false	5	0x4a6727fe58592d02cabd31fb88e9ee1a910d3225	600000000000000000000	124163705	2023-08-23T11:14:25.000Z	104999999999999999505	0x193288f21519fa600c0c0a1a14b5252734441f1a829caa7a9eeb2c77405382b0
27	0xa1568547ca58ef4c5621e031173e003cabb9b438	false	5	0x4a6727fe58592d02cabd31fb88e9ee1a910d3225	551000000000000000000	124161091	2023-08-23T11:03:28.000Z	96424999999999999546	0x3154b6d76aa2a8f8a138bd0c4d55dc8fc4ce054800d7d7d68a0a3a437bd00796

Example Query

Query with partition filter

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

BFRBufferBinaryOptions6_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option position openings with unique identifiers, user accounts, and fee structures. Useful for analyzing trading volume, fee revenue, and user activity patterns in the protocol’s options markets.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
51	0xa7420114839f487a8dc2f0fc83cc76cc5166e734	false	7	0x3c13a7bb060b05e023b94bc3833e98ea3b1c26c8	40000000000000000000	108123501	2023-07-05T13:09:07.000Z	4099999999999999998	0xd17905f5ccdee0cad1f5e426aaef62ae6976d04445f1bb9ef7bccf1f3f806ab0
48	0xa7420114839f487a8dc2f0fc83cc76cc5166e734	false	7	0x3c13a7bb060b05e023b94bc3833e98ea3b1c26c8	40000000000000000000	108119526	2023-07-05T12:52:32.000Z	4099999999999999998	0xe540a77a7dd6238059da0489b811eac3fcfa22341fcc2065cf871e0a138b89be
42	0xa7420114839f487a8dc2f0fc83cc76cc5166e734	false	7	0x3c13a7bb060b05e023b94bc3833e98ea3b1c26c8	40000000000000000000	108079084	2023-07-05T10:03:12.000Z	4099999999999999998	0x867e507312039c548d1e0510c0a82510797332e4c116a961c891c65f87dc1bb0

Example Query

Query with partition filter

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

BFRBufferBinaryOptions7_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option position opens with account addresses, fees, and unique identifiers. Used for tracking user trading activity and fee analysis across the platform.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
26	0xeec6d471ef314097c3366196c16b9286858c1a44	false	7	0xb61adeccc0683e7df27d531452e381954891becc	239420233125159104282	106266045	2023-06-29T23:15:02.000Z	24540573895328808172	0x66fd6d32e487d752d3030faf4351260a08493aa932b5c898f49998db57aa361a
25	0xeec6d471ef314097c3366196c16b9286858c1a44	false	7	0xb61adeccc0683e7df27d531452e381954891becc	181435422257120129840	106143018	2023-06-29T14:30:10.000Z	18597130781354813297	0x523f8730714e962bf25584551ba43d760e851fa257235617363ceed66d8d589f
23	0xeec6d471ef314097c3366196c16b9286858c1a44	false	10	0xb61adeccc0683e7df27d531452e381954891becc	183027390420098012989	106006322	2023-06-29T05:00:07.000Z	18760307518060046319	0xc7307923e32d3c91028da7820c601c3dd686c76e2862d13f0b9e2d3ea83664bb

Example Query

Query with partition filter

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

BFRBufferBinaryOptions8_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing option ID, account address, total fees, and settlement fees for each new position. Used for tracking options activity, fee analysis, and user trading patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
346	0xf15055aab7c8291d0276a85d9cb34bd23d063600	false	15	0x3e4155f831ba606ed0a6cbdc8886da19965109eb	80000000000000000000	109659915	2023-07-10T04:25:25.000Z	11599999999999999932	0x51bd1290240cb7d7135a07a72e678e3b984a0955d9830edeb23445d3afae3f33
342	0xf15055aab7c8291d0276a85d9cb34bd23d063600	false	5	0x3e4155f831ba606ed0a6cbdc8886da19965109eb	80000000000000000000	109635033	2023-07-10T02:38:12.000Z	11599999999999999932	0x0b60b097ad175f39b43be20eb12f41725c5b73433e0fa76df5e9ca89796dc4e2
348	0xf15055aab7c8291d0276a85d9cb34bd23d063600	false	18	0x3e4155f831ba606ed0a6cbdc8886da19965109eb	80000000000000000000	109663463	2023-07-10T04:40:43.000Z	11599999999999999932	0xf72331fe6dadc4e10e0cbf1948adf56c03dd57fb807c94697a3073c59373f6d3

Example Query

Query with partition filter

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

BFRBufferBinaryOptions9_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum. Records new option positions with unique IDs, account addresses, total fees, and settlement fees for tracking options activity and fee analysis.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
1106	0xdbedc2a1aa21a87879f4cc062e18190d5525c084	false	5	0x19d65d2660b09160ad2de253166d9988350aab2e	51500000000000000000	109570178	2023-07-09T21:49:18.000Z	6952499999999999963	0xe65d702bbc64c986e371053b1c7dd6fa9da6cc2f9a019aaba8da815690d9108c
1103	0xdbedc2a1aa21a87879f4cc062e18190d5525c084	false	5	0x8270f3940138140e40f465c96c0f447ea0e5a9da	50000000000000000000	109550420	2023-07-09T20:23:29.000Z	8749999999999999959	0x3fa9bb82a8b27a6456cae19a39c0ca49221f195bd7e43b91800b9009ac0b8365
1102	0xdbedc2a1aa21a87879f4cc062e18190d5525c084	false	5	0x8270f3940138140e40f465c96c0f447ea0e5a9da	50000000000000000000	109549474	2023-07-09T20:19:28.000Z	8749999999999999959	0xb8a9a6249e799a6bfe078d8f4b3c76b504acf27204c031d054a32bf06d61c13e

Example Query

Query with partition filter

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

StakedBfrTracker_Claim_event

Reward claim events from Buffer Finance (BFR) staking tracker on Arbitrum, recording token amounts and recipient addresses when users claim staking rewards. Used for analyzing reward distribution patterns and staker behavior.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x173817f33f1c09bcb0df436c2f327b9504d6e067	false	105412419626256804368	27	0x9d449ebc1062131d427386ccd1f9d9c7a2ee569b	211488243	2024-05-15T10:41:15.000Z	0x8e4b521cb00be12773f31284c1ece4da67ebc9472fbdf448e43def445ac98782
0x173817f33f1c09bcb0df436c2f327b9504d6e067	false	145822863515511202	32	0x7e5c1a665bfd595a8de3ac91dabb37a65db04096	211575084	2024-05-15T16:52:49.000Z	0x6a827726537ced7568ccdea5a0f15c1c61f4394bfc68d28b957e2c027053bd35
0x173817f33f1c09bcb0df436c2f327b9504d6e067	false	25198808322300456115715	9	0x9bb70bf2938a667ca6f039db35b925e3d3eb9885	211669611	2024-05-15T23:38:58.000Z	0x4445509f92ecc994ae5590ef9187bab9c81b1bc9dd16f79023742db6648bde99

Example Query

Query with partition filter

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

StakedBlpTracker_Claim_event

Reward claim events from Buffer Finance’s staked BLP (Buffer Liquidity Provider) tracker contract on Arbitrum. Records track user addresses claiming accumulated rewards with amounts in wei, useful for analyzing yield distribution and staker behavior.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x7d1d610fe82482412842e8110aff1cb72fa66bc8	false	1030258217580593446	9	0x45232d48033b129571062fb05222ef456353253e	70529128	2023-03-16T21:13:33.000Z	0xfbfc2b72863b7df7562955365a8d12544588355c9075ed5b7be941f80ecfc785
0x7d1d610fe82482412842e8110aff1cb72fa66bc8	false	1754960581368688175	9	0xe09696bcc67b8586eaf2292c43f04059d7de16a5	70279080	2023-03-16T03:43:54.000Z	0x43c7664482ec8a36a3ade95ef7e2d81b72695c7f0cdf74e0d6baf362b79631c7
0x7d1d610fe82482412842e8110aff1cb72fa66bc8	false	17974370888252765091	9	0xd8a30dbb3b8b204b6d8bb800d0f2865d07dc904c	70235640	2023-03-16T00:39:38.000Z	0xa08fd1cfb5a7c2d47e1c9ba9e33a5cf96357ff6e8241d7209cab6a0ead571ce5

Example Query

Query with partition filter

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

USDCBufferBinaryOptions1_Create_event

Binary options creation events from Buffer Finance USDC options contract on Arbitrum, capturing position openings with unique IDs, trader accounts, and fee breakdowns. Used for analyzing trading patterns, fee structures, and user activity in Buffer’s options 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
31679	0x532321e6a2d8a54cf87e34850a7d55466b1ec197	false	7	0xba20c76ca579c01399019608c2282cf53ad9bf67	25000000	128060363	2023-09-04T21:15:11.000Z	3312475	0xac10169962e1d4eeadb774949dc6995401a0f839d1388ead99984fc1782dc4a0
31678	0x532321e6a2d8a54cf87e34850a7d55466b1ec197	false	7	0xba20c76ca579c01399019608c2282cf53ad9bf67	50000000	128052807	2023-09-04T20:35:11.000Z	6624949	0x08d52887cce5c97daaed12b949910f01e29c928895372712b1cc96c2df608053
31676	0x532321e6a2d8a54cf87e34850a7d55466b1ec197	false	7	0xe7bb473e8d9930fbe2d715012a73b1d9c2a8bc8c	5000000	127980560	2023-09-04T14:47:41.000Z	812498	0xf4b11e7dde457dfa5aa0c8b698cbbe7f3a6c35ac19e218e1f546bdd43550deeb

Example Query

Query with partition filter

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

USDCBufferBinaryOptions10_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing USDC-denominated option positions with associated fees and user accounts. Used for tracking options issuance activity and fee structure analysis.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
2	0xad6b3a99fe957a9e29d5aa6cf2b3ac1b8794efd9	false	5	0xee6a11695a33358b08c75684805770aca89cdb95	1000000	59479814	2023-02-09T19:15:08.000Z	150000	0x01e32e9858ab451a95cc199cb316f01a41d1e658cca59902734299ccede688ab
0	0xad6b3a99fe957a9e29d5aa6cf2b3ac1b8794efd9	false	5	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000	59419420	2023-02-09T14:09:56.000Z	150000	0x2e55f3df717a2a1ae5f77bec1abd0fa90e4a77357867c247189d4e636128202b
1	0xad6b3a99fe957a9e29d5aa6cf2b3ac1b8794efd9	false	5	0xdd365eab9dae93ed01ca31386d15d56aaf456500	90000000	59441399	2023-02-09T15:57:37.000Z	11249922	0x572625a2564c819cfd2f61bccc8491ebb0b3147ef1fe1f8c0fb4d89e8608a571

Example Query

Query with partition filter

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

USDCBufferBinaryOptions11_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, recording USDC-denominated option positions with trader accounts, fees, and unique option identifiers. Used for tracking new option openings and analyzing fee structures in the Buffer options marketplace.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
259	0x63e0af4ec5af8d103c1fb2ab606bd938d3dd27da	false	7	0x07b4000d9629c3ebe87479151923b6f369bb0c11	12700000	75120678	2023-03-30T03:38:35.000Z	1111239	0x2170bb1537208a9aa8112c9ae7ce1762cbc2a0c2902d88def1a00163b6d4373d
203	0x63e0af4ec5af8d103c1fb2ab606bd938d3dd27da	false	7	0x07b4000d9629c3ebe87479151923b6f369bb0c11	18900000	75073263	2023-03-30T00:20:23.000Z	1653733	0x5c6022d2e7cf430212f3464ac225be09b66a46c14692ba31be6eebb2d4d40762
200	0x63e0af4ec5af8d103c1fb2ab606bd938d3dd27da	false	7	0x07b4000d9629c3ebe87479151923b6f369bb0c11	18880000	75069695	2023-03-30T00:05:00.000Z	1651983	0x8019b379623d70b1f93df2bd940c58dac62d5c3a6b166078e21196b93101f558

Example Query

Query with partition filter

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

USDCBufferBinaryOptions12_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, recording USDC-denominated option positions with unique IDs, total fees, and settlement fees. Used for tracking options activity, fee structures, and trader behavior across the platform.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
90	0xa51696a6b909314ce0fb66d180d3f05c21804234	false	7	0x319346eb63054ac5e0f4012dcd2d7a49a4382c7b	25000000	67398799	2023-03-06T20:56:39.000Z	3749990	0x44ed2a4b251fa76e037ca59fe80d9d939bfb0343070dac4d442f35df7998425f
92	0xa51696a6b909314ce0fb66d180d3f05c21804234	false	5	0x319346eb63054ac5e0f4012dcd2d7a49a4382c7b	25000000	67399851	2023-03-06T21:01:33.000Z	3749990	0xe029c15a4519b7e7d2e0a84936775f13427e0838940385dff47f0fff6df62c97
89	0xa51696a6b909314ce0fb66d180d3f05c21804234	false	5	0x319346eb63054ac5e0f4012dcd2d7a49a4382c7b	25000000	67398231	2023-03-06T20:53:54.000Z	3749990	0x0878f00c6028493b8554dbd0608584345e3f2225cda35a6df4a530a518a23cc2

Example Query

Query with partition filter

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

USDCBufferBinaryOptions13_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum with USDC denomination, capturing user positions with fees in 6-decimal USDC format. Records unique option IDs, trader accounts, and fee breakdowns for analyzing trading volumes and settlement costs.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
19	0x7b5e6b8ae5840f5e78f79689b29c441b90803cb0	false	27	0xff4f88c59ed94d8706ce92a043693ca875947d1d	32000000	64092388	2023-02-24T11:29:58.000Z	4799987	0xb7f486b680d04052ccd4458e037864946085bdfba38c57ebc522868481cefe38
18	0x7b5e6b8ae5840f5e78f79689b29c441b90803cb0	false	5	0xff4f88c59ed94d8706ce92a043693ca875947d1d	16000000	64092224	2023-02-24T11:29:17.000Z	2399994	0xaf9e911bceae1bcfe2539e7b612197ad50a9c256c0330dafef3175de0bcc35ce
20	0x7b5e6b8ae5840f5e78f79689b29c441b90803cb0	false	7	0x8c50bc819a91cfb9e8c4a98b54088d969c46b464	20000000	64129896	2023-02-24T14:06:48.000Z	2149977	0x09d6a56ff81b0f89355e97de13ca7973e156575ce76df3c31d2bd4040247cff7

Example Query

Query with partition filter

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

USDCBufferBinaryOptions14_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, tracking USDC-denominated option positions with unique IDs, account addresses, total fees, and settlement fees. Used for analyzing option creation activity and fee structures in the Buffer ecosystem.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
13	0x6c42ce8098ef47a9e2171d931e89f0fb9ff0465d	false	7	0x07b4000d9629c3ebe87479151923b6f369bb0c11	1000000	64075416	2023-02-24T10:19:11.000Z	87500	0x90c14ca02e7b77e457a00c1cabc107fb050da8aec16d62b5e55cf087f056a7c0
28	0x6c42ce8098ef47a9e2171d931e89f0fb9ff0465d	false	45	0xff4f88c59ed94d8706ce92a043693ca875947d1d	24000000	66396125	2023-03-03T14:04:36.000Z	3599990	0x6d14a2a2c8981184bd869a60ce0623b01b6364d43bd667c287223a005eb78709
26	0x6c42ce8098ef47a9e2171d931e89f0fb9ff0465d	false	6	0xff4f88c59ed94d8706ce92a043693ca875947d1d	6000000	66394727	2023-03-03T13:58:45.000Z	899998	0x112f581979fb8349e6c89be82294d3c6dea6493ca006fcd9cd370208ded2f184

Example Query

Query with partition filter

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

USDCBufferBinaryOptions15_Create_event

Binary options position creation events from Buffer Finance USDC options contract on Arbitrum. Tracks option ID, trader account, total premium, and settlement fees for analyzing trading volumes and fee structures.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
17	0xc17ba7e19c383e3710e27b7add64e62379eda0a3	false	5	0x3fa9640c0686414ca3cae605b2ac6811c8e77d40	70000000	65863861	2023-03-01T22:06:20.000Z	10499971	0xb4868750f313dd879693b5f948295c8f26ccbc110778148b75c9272adbf50ad4
16	0xc17ba7e19c383e3710e27b7add64e62379eda0a3	false	13	0x319346eb63054ac5e0f4012dcd2d7a49a4382c7b	10000000	65580972	2023-03-01T01:11:43.000Z	1499996	0xb017f973bad6443982ccf591c6da17647e1f3164b51a1f47ad5f5b1f9fbb869e
104	0xc17ba7e19c383e3710e27b7add64e62379eda0a3	false	5	0x51c85d34bb5f4a2862493a05362a784b1df030c2	4000000	70165936	2023-03-15T19:21:57.000Z	599999	0xf6ac0e00dbe273085e619be5dada77d0fef7689ec057f2ca097adbbfd03813e0

Example Query

Query with partition filter

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

USDCBufferBinaryOptions16_Create_event

Binary options position creation events from Buffer Finance USDC options contract on Arbitrum, capturing option IDs, account addresses, total fees, and settlement fees. Used for tracking options trading activity and fee analysis.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
49	0x8d7a09deb687d0f77f47c8b0b3a44015d8cd31fa	false	5	0x86ef3f177f4ff8870ecd07bfe826754b8d81d604	45000000	68284501	2023-03-09T18:06:37.000Z	6749981	0xede6caa210a92fccc51feedffab8fabc5a2b1531f8a8469c7b475e3f8ed75b8b
48	0x8d7a09deb687d0f77f47c8b0b3a44015d8cd31fa	false	5	0x8a6846c2a4315ac5bb05a9e8adaf771774b3d1f6	100000000	68271334	2023-03-09T17:04:17.000Z	14999958	0x3c27482e1b8a23012a38066e6cafe3df675c7743072ccc1cfa2272c4f7d31568
47	0x8d7a09deb687d0f77f47c8b0b3a44015d8cd31fa	false	19	0x3beb2f44a4bcd4aca6c4b276be68070b1a02f670	5000000	68256709	2023-03-09T15:58:18.000Z	537495	0x7a26d33be246b0f258730d32423c6a516f2c46934098c323abf3dbcaf4378145

Example Query

Query with partition filter

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

USDCBufferBinaryOptions17_Create_event

Binary options creation events from Buffer Finance USDC options contract on Arbitrum. Tracks option IDs, trader accounts, total fees, and settlement fees for analyzing options trading activity and fee structures.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
9	0xae10c1434fe50b9c6c65d25a752b43ff43d266ad	false	13	0x07b4000d9629c3ebe87479151923b6f369bb0c11	316000000	65529293	2023-02-28T21:00:05.000Z	27649713	0x6f0189317813e90dfdfda263165bf58d5e03be4712e3d1902a05a244f6647c4f
8	0xae10c1434fe50b9c6c65d25a752b43ff43d266ad	false	18	0x07b4000d9629c3ebe87479151923b6f369bb0c11	344000000	65517313	2023-02-28T20:05:05.000Z	30099687	0xecfdec4ab41967a34c090c7253cc19d75c285706402999cca7f6a06c2f507d4a
49	0xae10c1434fe50b9c6c65d25a752b43ff43d266ad	false	7	0x3beb2f44a4bcd4aca6c4b276be68070b1a02f670	5000000	70119944	2023-03-15T15:57:57.000Z	537495	0x140e731c892bab89d8f4e92793b00c3b6ff78df4d4bc18bcbb1bcda051fe6523

Example Query

Query with partition filter

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

USDCBufferBinaryOptions18_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, tracking option ID, user account, and fee amounts in USDC (6 decimals). Used for analyzing options trading volume, fee structures, and user activity patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
12	0x13779aeb682f922770f1971313f2543e5d5f44e8	false	8	0x07b4000d9629c3ebe87479151923b6f369bb0c11	407000000	63788683	2023-02-23T13:23:06.000Z	35612130	0x9d38398336e76465c50e49a6409ca7c4199acb1051397a26dbcccf6f0d4b7e37
11	0x13779aeb682f922770f1971313f2543e5d5f44e8	false	12	0x07b4000d9629c3ebe87479151923b6f369bb0c11	390000000	63705584	2023-02-23T07:40:05.000Z	34124646	0x050a599c488383c2497d9d998389b2f2a24bb093a34bc75a2061f651fbdcc83d
13	0x13779aeb682f922770f1971313f2543e5d5f44e8	false	7	0xaaaddecf3e8ea971b924e244e16f953e44f193ac	20000000	63903666	2023-02-23T21:39:56.000Z	1749982	0x380a6e03185281e9b3b61ad04dbcc4c9b962b8ce241d0df694b5dddf50549ea5

Example Query

Query with partition filter

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

USDCBufferBinaryOptions19_Create_event

Binary options creation events from Buffer Finance USDC options contract on Arbitrum, tracking option IDs, trader accounts, total fees, and settlement fees. Used for analyzing options trading volume, fee structures, and trader activity patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
17	0xcba232eb6b0d3c81d209c921941ec35f15a9e612	false	8	0x07b4000d9629c3ebe87479151923b6f369bb0c11	1000000	64231084	2023-02-24T21:25:02.000Z	87500	0xe0aa24b92d908f06b4d7f4acf09827e88df63ae2847f1b8dd86315d61989b257
27	0xcba232eb6b0d3c81d209c921941ec35f15a9e612	false	11	0x07b4000d9629c3ebe87479151923b6f369bb0c11	236000000	65778254	2023-03-01T15:38:07.000Z	20649786	0xec6b007bb8f494bcc758e1fdcd2ed627ab78de657a5ff30e6039fdf317e52abf
121	0xcba232eb6b0d3c81d209c921941ec35f15a9e612	false	22	0x2e51f9c98fd49354e31b4446e57aa3c2d7acd070	400000000	72955926	2023-03-23T21:21:55.000Z	59999830	0x1975a7708daa321f1eb641a5a89fd4c985337c179b07fe94e0a789766eb41a55

Example Query

Query with partition filter

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

USDCBufferBinaryOptions2_Create_event

Binary options creation events from Buffer Finance’s USDC options contract on Arbitrum. Captures option ID, trader account, total fee, and settlement fee for analyzing options trading activity and fee structures.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
6337	0x89dd9ba4d290045211a6ce597a98181c7f9d899d	false	15	0x07b4000d9629c3ebe87479151923b6f369bb0c11	10000000	71090725	2023-03-18T12:39:35.000Z	874991	0x1fec40c4f92c0f3c90c5cba540ed483c2cb735a0d354e45d661bf3a529bf89e1
6335	0x89dd9ba4d290045211a6ce597a98181c7f9d899d	false	17	0x07b4000d9629c3ebe87479151923b6f369bb0c11	10000000	71088936	2023-03-18T12:32:15.000Z	874991	0x67b09c877a607e6a98eb3c448ae0d19907e693eed9ba489cd838c54de22b177f
6315	0x89dd9ba4d290045211a6ce597a98181c7f9d899d	false	7	0x07b4000d9629c3ebe87479151923b6f369bb0c11	10000000	70956853	2023-03-18T03:22:15.000Z	874991	0x7fd485f51fd24712bb47c6ede4132375d6d91189674cb7797f6c9eb25243e3c4

Example Query

Query with partition filter

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

USDCBufferBinaryOptions20_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, tracking USDC-denominated option positions with unique IDs, user accounts, total fees (typically 5 USDC), and settlement fees. Used for analyzing options trading activity and fee structures in Buffer’s prediction markets.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
4462	0x243732d25210c8ad4019fb6859bd9b24b249c6fa	false	12	0x26e7745d3a1cab74a85a7779ee470e1a299debbf	5000000	129096858	2023-09-08T05:14:02.000Z	962500	0x29aad3259c0b57f27e8c0d18624254cb6c60f7090b586e581b849c52e4e1735e
4459	0x243732d25210c8ad4019fb6859bd9b24b249c6fa	false	12	0x26e7745d3a1cab74a85a7779ee470e1a299debbf	5000000	129095985	2023-09-08T05:10:01.000Z	962500	0x47ad92329ca9585890b162417fda9aae4bc166a9b05e5412fbf23038536c17c8
4460	0x243732d25210c8ad4019fb6859bd9b24b249c6fa	false	12	0x26e7745d3a1cab74a85a7779ee470e1a299debbf	5000000	129096005	2023-09-08T05:10:06.000Z	962500	0x9a02b4d00beae4408ed45dc52779f831bda15e05719d627b6498c5fc71bec3b5

Example Query

Query with partition filter

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

USDCBufferBinaryOptions21_Create_event

Binary options creation events from Buffer Finance USDC options contract on Arbitrum. Tracks option positions opened by traders with sequential IDs, account addresses, and fee breakdowns in USDC (6 decimals) for analyzing trading volume and fee revenue.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
802	0x82daa9ae205511acb1e860735033871f8d5cae4a	false	17	0x32cf8e7884b904e93961e046564bfd90dd7bc7e8	1000000	138487760	2023-10-07T18:03:13.000Z	49999	0xd90e485f8f0b6fcc6a26d982d9fd570d109a9c707888052f787ea9a65fc7db8d
776	0x82daa9ae205511acb1e860735033871f8d5cae4a	false	10	0xe6be73ebfa5e4cda670148a7a01a1319d692b6e5	1000000	138402550	2023-10-07T12:01:36.000Z	49999	0x232bdb94df032d9f6e5b82be852b4783dc5c5aeb48afaa9148cef6bab6fc1bd7
841	0x82daa9ae205511acb1e860735033871f8d5cae4a	false	10	0x2e8be8ce3d74e237eae7336c3e44e2e6f6afcd03	1000000	138559267	2023-10-07T23:28:25.000Z	49999	0xd99079f4f6d817c6226b5c9c919682f4df7c3961a0ef7d9dfff702ecc5db3474

Example Query

Query with partition filter

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

USDCBufferBinaryOptions22_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, recording USDC-denominated options with position IDs, user accounts, and fee breakdowns. Tracks option opening activity including total and settlement fees for analyzing trading patterns and protocol usage.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
797	0x136662b1742931d614367c533d431e87a2b1aceb	false	10	0xd1add060d1b5fd0ae18008cf3d05bdc63c71c7e3	1000000	155277949	2023-11-29T16:09:00.000Z	49999	0x297e024117891d6ab0919c69f756571c9cc1632e304a85ff425e276becc2b04b
754	0x136662b1742931d614367c533d431e87a2b1aceb	false	29	0x94af518a9bb3da5b3e0292233014b5f2a8659224	2000000	155066093	2023-11-29T00:30:06.000Z	149999	0x14384325906b0d7fc96afad095fd7408a74cd7fabde652a131c17160944741f7
789	0x136662b1742931d614367c533d431e87a2b1aceb	false	12	0x94af518a9bb3da5b3e0292233014b5f2a8659224	4000000	155255066	2023-11-29T14:30:08.000Z	199995	0xfae477a9925420336e7ada2c5d0f1c3b6b44b9eb1402b7233989143a1f384273

Example Query

Query with partition filter

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

USDCBufferBinaryOptions3_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing USDC-denominated options with account addresses, fee amounts, and unique option identifiers. Used for tracking options issuance activity and fee structure analysis.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
423	0xbcd52d37f41da2277af92617d70931a787f66fd5	false	7	0x77c66d0457b6bd390c1824b3e44d6f9c31fa4166	1000000	59642946	2023-02-10T08:42:30.000Z	87500	0x3f716d31863110ff6dcbd4d500a99da9f470d0b0d8a3158fee03a3eecbd085da
425	0xbcd52d37f41da2277af92617d70931a787f66fd5	false	6	0x77c66d0457b6bd390c1824b3e44d6f9c31fa4166	1000000	59645904	2023-02-10T08:55:12.000Z	87500	0x8c87c99ed46e80251ca74e35ef7f548f26bd19c4bbfbbdf1f17b5f682d7c08f9
424	0xbcd52d37f41da2277af92617d70931a787f66fd5	false	5	0x77c66d0457b6bd390c1824b3e44d6f9c31fa4166	1000000	59645569	2023-02-10T08:53:51.000Z	87500	0x0d5952a6f718646614084f6ad6488ab3f7e4e8056231f8806dd1071e4531286c

Example Query

Query with partition filter

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

USDCBufferBinaryOptions4_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum, denominated in USDC. Tracks option IDs, trader accounts, total fees, and settlement fees for analyzing trading costs and position opening activity.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
203	0x5d61fe708c9d41acf59009013f14496d559aad09	false	5	0x1c17257368a549095b57a77dde9e51bb10e27575	40000000	57670332	2023-02-03T11:56:23.000Z	3999964	0xd6210885f5f72bfa7933026b6b47364d2b1b6876e6b59a7d3e8ae3162c679d28
209	0x5d61fe708c9d41acf59009013f14496d559aad09	false	20	0x1c17257368a549095b57a77dde9e51bb10e27575	50000000	57689382	2023-02-03T13:32:10.000Z	4999955	0x60d8d57b184d8adf6d4b3fcf77724953bdc8588e60d5b7ea6860f6a835e38289
205	0x5d61fe708c9d41acf59009013f14496d559aad09	false	6	0x1c17257368a549095b57a77dde9e51bb10e27575	50000000	57673817	2023-02-03T12:13:55.000Z	4999955	0x67551bc8f43eb0edc4168c0ea124b12379e7104b85808d30e2b87b92d12f8eb6

Example Query

Query with partition filter

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

USDCBufferBinaryOptions5_Create_event

Binary options creation events from Buffer Finance USDC options pool on Arbitrum, capturing option IDs, trader accounts, total fees (in USDC with 6 decimals), and settlement fees for analyzing trading activity and fee structures.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
45	0xfe9faeaa880a6109f2adf0e4257dc535c7a5ba20	false	11	0xf20052b43eeaacde7a1b7225d649265a37910ef7	2000000	62480118	2023-02-19T16:17:33.000Z	400000	0x1a0ad62326cfa0bae2c0e50d0e36cb0955f93e458a6a603c603777e0b356aa41
42	0xfe9faeaa880a6109f2adf0e4257dc535c7a5ba20	false	5	0xf20052b43eeaacde7a1b7225d649265a37910ef7	2000000	62473580	2023-02-19T15:50:25.000Z	400000	0xf36ebf69dcc7bf3768e9cffa9c3db6bb2cb09636aeaddb327b710d0a764461cc
41	0xfe9faeaa880a6109f2adf0e4257dc535c7a5ba20	false	6	0xf20052b43eeaacde7a1b7225d649265a37910ef7	2000000	62471745	2023-02-19T15:42:47.000Z	400000	0xd2276840fa08ca8fca4c70fd72c21eeabcaef6a61afdf992717d39586894423a

Example Query

Query with partition filter

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

USDCBufferBinaryOptions6_Create_event

No description available.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

USDCBufferBinaryOptions7_Create_event

Binary options position creation events from Buffer Finance protocol on Arbitrum, recording USDC-denominated trades with option IDs, trader accounts, and settlement fees. Used for analyzing trading volume, fee structures, and user activity in Buffer’s decentralized options markets.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
103	0x5d6f1d376e5ea088532ae03dbe8f46177c42b814	false	24	0xfdf1bff1850f05641075588e380622d25774a7ec	50000000	72454810	2023-03-22T11:38:12.000Z	8624959	0xafab3ff953189977b41c8f5ba08af783023f69d95b73daa464903683ea9765f3
79	0x5d6f1d376e5ea088532ae03dbe8f46177c42b814	false	11	0x2ffb0ef286951e58e392f81e3cbdc769eb3ea30d	10000000	62959327	2023-02-21T03:06:51.000Z	1749992	0x25b7f15a6f36e38e79555cf0e998153777cdb6217cd3702c424d2e9f1fd820f2
80	0x5d6f1d376e5ea088532ae03dbe8f46177c42b814	false	5	0x2ffb0ef286951e58e392f81e3cbdc769eb3ea30d	24000000	62963097	2023-02-21T03:22:41.000Z	4199981	0x0948e341730c318bcee2020e6767ed6fd8a42954c2a74c15a9957673584c304e

Example Query

Query with partition filter

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

USDCBufferBinaryOptions8_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum showing USDC-denominated option positions with unique IDs, user accounts, and associated fees. Used for tracking new option trades and analyzing fee structures across settlement and total costs.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
68	0xd384131b8697f28e8505cc24e1e405962b88b21f	false	5	0x63e62588330657c99ba79139e7c21af0c0db1e7e	25000000	74517616	2023-03-28T09:25:32.000Z	5000000	0x994c7ad19d008cfc4ea9f7eb6970dd00aa1db691eabda65f5412877dd58410c2
55	0xd384131b8697f28e8505cc24e1e405962b88b21f	false	7	0x07b4000d9629c3ebe87479151923b6f369bb0c11	10000000	70841763	2023-03-17T19:13:30.000Z	1374995	0x417f8d11493d26a2935a04cb34a1c5d19a85b74659aea5c03daba2e760bce7e0
56	0xd384131b8697f28e8505cc24e1e405962b88b21f	false	7	0x07b4000d9629c3ebe87479151923b6f369bb0c11	10000000	70858318	2023-03-17T20:23:28.000Z	1374995	0xa679442d16dde1b9e28bfd9d46e9e40b223d1c9d7e9f05247d93d76f4c18a38a

Example Query

Query with partition filter

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

USDCBufferBinaryOptions9_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, capturing position opens with USDC fees and settlement costs. Tracks user accounts, option identifiers, and fee breakdowns for analyzing trading patterns and protocol fee generation.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
20	0x5c61a87c2e3cf9e2bf996e0cf93a7b084557e468	false	5	0x1636be94b64ce8a3f63951b746be08616cd4d3b5	5000000	59678684	2023-02-10T11:21:40.000Z	749998	0xcb95b95a4f8976385260de30b90b341fb710f39a58fceb1c307ec7aa8bce0938
35	0x5c61a87c2e3cf9e2bf996e0cf93a7b084557e468	false	7	0x70ad81d18f2838b8650d88740d8e337032c9baac	36500000	59707000	2023-02-10T13:25:41.000Z	5018732	0x4e3bd78b6d5bdcb70c136ebcf601eb65fe104399153e103e544d67a20b75984c
28	0x5c61a87c2e3cf9e2bf996e0cf93a7b084557e468	false	9	0x70ad81d18f2838b8650d88740d8e337032c9baac	45600000	59702580	2023-02-10T13:06:18.000Z	6269977	0xef1670f4e1e8236d5b6e87927a1cd0de415b38dfab4d76c59a88c218b6431169

Example Query

Query with partition filter

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

USDCBufferBinaryOptionsPOL1_Create_event

Binary options creation events from Buffer Finance protocol on Arbitrum, tracking USDC-denominated positions with unique identifiers, user accounts, and associated fees. Records option openings for analyzing trading volume, fee structures, and user activity patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
236	0x824f6209b6c022be9ac2c121604a509a3ed3960e	false	22	0xb06dcff74b96fd73152bb9fb4c64bb220eb0c646	5000000	93636630	2023-05-23T14:50:47.000Z	749998	0xc2ae8f9159ab1cbb6d0362d0f0f60a5b559c16db08dde665044f7b54bc9ff854
307	0x824f6209b6c022be9ac2c121604a509a3ed3960e	false	5	0xb1ff5a769acc629873d7538e7eaad08a0c016f6b	11000000	102814873	2023-06-19T17:00:09.000Z	1154997	0xa99bec5ff6bbc5362463cd5cf5d8c2b0e0014fbc4fd2205be7d51c4954a6a797
303	0x824f6209b6c022be9ac2c121604a509a3ed3960e	false	5	0xb1ff5a769acc629873d7538e7eaad08a0c016f6b	11000000	102807699	2023-06-19T16:30:07.000Z	1154997	0xe894d0a82c71be3bb5b4d0413f9cde189e677796c4ee031e581594334c61acf8

Example Query

Query with partition filter

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

USDCBufferBinaryOptionsPOL2_Create_event

Binary options position creation events from Buffer Finance’s USDC-denominated Protocol Owned Liquidity (POL) contract on Arbitrum. Tracks option IDs, trader accounts, total fees, and settlement fees for analyzing options trading activity and fee structures.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
151	0x69359690ae2f6d8bfcab5f4fb30d3d2ecbfbb3ef	false	5	0xe6be73ebfa5e4cda670148a7a01a1319d692b6e5	20000000	96358572	2023-05-31T13:38:07.000Z	2999992	0xea5ea51a52191b25bc84fb3504819c10107ea30ea0733d7e29f3c0d697f0ab5b
152	0x69359690ae2f6d8bfcab5f4fb30d3d2ecbfbb3ef	false	5	0xe6be73ebfa5e4cda670148a7a01a1319d692b6e5	40000000	96358992	2023-05-31T13:39:52.000Z	5999983	0xa178d7019d2622153a2f8c7baa0bf501f1d772cbfab0294fde7d79009dec41eb
194	0x69359690ae2f6d8bfcab5f4fb30d3d2ecbfbb3ef	false	14	0x4b655510bfe2cbec53f0cb7a3edf3a041372deab	8197836	106380821	2023-06-30T07:25:09.000Z	922248	0xb865b4f25a37bfc5afa347da94ae8ac1449ba86d551384ed147287a43ee073c8

Example Query

Query with partition filter

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

USDCBufferBinaryOptionsPOL3_Create_event

Binary options creation events from Buffer Finance USDC pool on Arbitrum capturing option IDs, trader accounts, and fee breakdowns. Used for tracking binary options activity and fee analysis.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
4180	0xeacaa1f47a90df6d284ddefe6d148c814de1a17c	false	8	0x1012cf93d25ec44c280a8a5713a7402ce2032ecc	10000000	89892794	2023-05-12T09:22:13.000Z	1499996	0x3377b1aca43064f6ee9f47724e6409390df2ca7f0ab2ea17ce2ae2e309acf64b
4206	0xeacaa1f47a90df6d284ddefe6d148c814de1a17c	false	5	0x19d65d2660b09160ad2de253166d9988350aab2e	5000000	89960980	2023-05-12T14:05:51.000Z	549995	0xb9716c59163ad877a614ae03a5afeddef54aefd936f68f91910b9e525cb333e1
4207	0xeacaa1f47a90df6d284ddefe6d148c814de1a17c	false	5	0x19d65d2660b09160ad2de253166d9988350aab2e	5000000	89962533	2023-05-12T14:12:22.000Z	549995	0x50a80cc43ef29533d8ca121f17a259fb650d11172830e2a3934e4bac3a2b1318

Example Query

Query with partition filter

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

USDCBufferBinaryOptionsPOL4_Create_event

Binary options creation events from Buffer Finance’s USDC-denominated pool (POL4) on Arbitrum, capturing option ID, user account, total fees, and settlement fees. Used for analyzing options trading activity and fee structure in Buffer’s prediction markets.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_settlementFee`	`STRING`	Fee amount charged for settling the binary option contract. String-encoded integer value representing the settlement fee in the smallest denomination of the token.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

in_id	address	removed	log_index	in_account	in_totalFee	block_number	block_timestamp	in_settlementFee	transaction_hash
3447	0x8cf36930ee277f537c5e815b3893a1ea8c54a3b3	false	6	0x060d2ed5c447e194e7a107d2009847e1e475da06	20000000	95997308	2023-05-30T12:24:55.000Z	2999992	0x476fd23829caa8852adcb3766320f58fc90a1c3e88c96c344740147ad186b11b
3449	0x8cf36930ee277f537c5e815b3893a1ea8c54a3b3	false	8	0x060d2ed5c447e194e7a107d2009847e1e475da06	20000000	95999209	2023-05-30T12:32:48.000Z	2999992	0xa6134f3fc4e08a47a69964edccf2090ea2c11ca15bcaa34ead36b47d491ea1a8
3450	0x8cf36930ee277f537c5e815b3893a1ea8c54a3b3	false	24	0x060d2ed5c447e194e7a107d2009847e1e475da06	20000000	96000039	2023-05-30T12:36:16.000Z	2999992	0x7ee93e284aaf653e19f7ccb0271e378c9757553ebfdf39f6b45e7d311cb0afe4

Example Query

Query with partition filter

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

bsc_v1_bsc bufferfinance_v1_polygon

⌘I

​Tables

​ARBBufferBinaryOptions1_Create_event

​ARBBufferBinaryOptions10_Create_event

​ARBBufferBinaryOptions11_Create_event

​ARBBufferBinaryOptions12_Create_event

​ARBBufferBinaryOptions13_Create_event

​ARBBufferBinaryOptions14_Create_event

​ARBBufferBinaryOptions15_Create_event

​ARBBufferBinaryOptions16_Create_event

​ARBBufferBinaryOptions17_Create_event

​ARBBufferBinaryOptions18_Create_event

​ARBBufferBinaryOptions2_Create_event

​ARBBufferBinaryOptions3_Create_event

​ARBBufferBinaryOptions4_Create_event

​ARBBufferBinaryOptions5_Create_event

​ARBBufferBinaryOptions6_Create_event

​ARBBufferBinaryOptions7_Create_event

​ARBBufferBinaryOptions8_Create_event

​ARBBufferBinaryOptions9_Create_event

​BFRBufferBinaryOptions1_Create_event

​BFRBufferBinaryOptions10_Create_event

​BFRBufferBinaryOptions2_Create_event

​BFRBufferBinaryOptions3_Create_event

​BFRBufferBinaryOptions4_Create_event

​BFRBufferBinaryOptions5_Create_event

​BFRBufferBinaryOptions6_Create_event

​BFRBufferBinaryOptions7_Create_event

​BFRBufferBinaryOptions8_Create_event

​BFRBufferBinaryOptions9_Create_event

​StakedBfrTracker_Claim_event

​StakedBlpTracker_Claim_event

​USDCBufferBinaryOptions1_Create_event

​USDCBufferBinaryOptions10_Create_event

​USDCBufferBinaryOptions11_Create_event

​USDCBufferBinaryOptions12_Create_event

​USDCBufferBinaryOptions13_Create_event

​USDCBufferBinaryOptions14_Create_event

​USDCBufferBinaryOptions15_Create_event

​USDCBufferBinaryOptions16_Create_event

​USDCBufferBinaryOptions17_Create_event

​USDCBufferBinaryOptions18_Create_event

​USDCBufferBinaryOptions19_Create_event

​USDCBufferBinaryOptions2_Create_event

​USDCBufferBinaryOptions20_Create_event

​USDCBufferBinaryOptions21_Create_event

​USDCBufferBinaryOptions22_Create_event

​USDCBufferBinaryOptions3_Create_event

​USDCBufferBinaryOptions4_Create_event

​USDCBufferBinaryOptions5_Create_event

​USDCBufferBinaryOptions6_Create_event

​USDCBufferBinaryOptions7_Create_event

​USDCBufferBinaryOptions8_Create_event

​USDCBufferBinaryOptions9_Create_event

​USDCBufferBinaryOptionsPOL1_Create_event

​USDCBufferBinaryOptionsPOL2_Create_event

​USDCBufferBinaryOptionsPOL3_Create_event

​USDCBufferBinaryOptionsPOL4_Create_event

Tables

ARBBufferBinaryOptions1_Create_event

ARBBufferBinaryOptions10_Create_event

ARBBufferBinaryOptions11_Create_event

ARBBufferBinaryOptions12_Create_event

ARBBufferBinaryOptions13_Create_event

ARBBufferBinaryOptions14_Create_event

ARBBufferBinaryOptions15_Create_event

ARBBufferBinaryOptions16_Create_event

ARBBufferBinaryOptions17_Create_event

ARBBufferBinaryOptions18_Create_event

ARBBufferBinaryOptions2_Create_event

ARBBufferBinaryOptions3_Create_event

ARBBufferBinaryOptions4_Create_event

ARBBufferBinaryOptions5_Create_event

ARBBufferBinaryOptions6_Create_event

ARBBufferBinaryOptions7_Create_event

ARBBufferBinaryOptions8_Create_event

ARBBufferBinaryOptions9_Create_event

BFRBufferBinaryOptions1_Create_event

BFRBufferBinaryOptions10_Create_event

BFRBufferBinaryOptions2_Create_event

BFRBufferBinaryOptions3_Create_event

BFRBufferBinaryOptions4_Create_event

BFRBufferBinaryOptions5_Create_event

BFRBufferBinaryOptions6_Create_event

BFRBufferBinaryOptions7_Create_event

BFRBufferBinaryOptions8_Create_event

BFRBufferBinaryOptions9_Create_event

StakedBfrTracker_Claim_event

StakedBlpTracker_Claim_event

USDCBufferBinaryOptions1_Create_event

USDCBufferBinaryOptions10_Create_event

USDCBufferBinaryOptions11_Create_event

USDCBufferBinaryOptions12_Create_event

USDCBufferBinaryOptions13_Create_event

USDCBufferBinaryOptions14_Create_event

USDCBufferBinaryOptions15_Create_event

USDCBufferBinaryOptions16_Create_event

USDCBufferBinaryOptions17_Create_event

USDCBufferBinaryOptions18_Create_event

USDCBufferBinaryOptions19_Create_event

USDCBufferBinaryOptions2_Create_event

USDCBufferBinaryOptions20_Create_event

USDCBufferBinaryOptions21_Create_event

USDCBufferBinaryOptions22_Create_event

USDCBufferBinaryOptions3_Create_event

USDCBufferBinaryOptions4_Create_event

USDCBufferBinaryOptions5_Create_event

USDCBufferBinaryOptions6_Create_event

USDCBufferBinaryOptions7_Create_event

USDCBufferBinaryOptions8_Create_event

USDCBufferBinaryOptions9_Create_event

USDCBufferBinaryOptionsPOL1_Create_event

USDCBufferBinaryOptionsPOL2_Create_event

USDCBufferBinaryOptionsPOL3_Create_event

USDCBufferBinaryOptionsPOL4_Create_event