bufferfinance_v1_polygon

Tables

BufferBinaryOptions1_Create_event

Binary options creation events from Buffer Finance protocol on Polygon. Captures option opening transactions with account addresses, fee structures (total and settlement fees), and sequential option identifiers for tracking derivatives 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
17	0xaa911d19763e8df01896b541997d664caa17798d	false	247	0x8d9ea22a3af8685c3af5c68f36086a9704857505	100000000	41304759	2023-04-08T21:38:52.000Z	20000000	0xfb935b9ef752bfe307d262c6fb058d46c7c998a7feecfbbb290f974c9b27aaec
18	0xaa911d19763e8df01896b541997d664caa17798d	false	354	0x8d9ea22a3af8685c3af5c68f36086a9704857505	100000000	41304776	2023-04-08T21:39:28.000Z	20000000	0x0c7d44f528fa3bc0e8b3e27594cd8c0f150fba314e9bf7b0510cfb9ffa047e17
19	0xaa911d19763e8df01896b541997d664caa17798d	false	335	0x8d9ea22a3af8685c3af5c68f36086a9704857505	37000000	41304801	2023-04-08T21:40:22.000Z	7400000	0x3351252cf053afb1b55774e70e2f4258f07da9781cd793bc842d497d543bc34e

Example Query

Query with partition filter

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

BufferBinaryOptions10_Create_event

Binary options contract creation events from Buffer Finance protocol on Polygon. Records option position openings with unique identifiers, user accounts, and fee breakdowns for tracking 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
0	0xa4538a05333fa64ef38ea699fa8972fdccae62f8	false	192	0x42a0eef97019bf6f15796fc9a015f681c581f77a	1000000	39920009	2023-03-03T14:25:30.000Z	150000	0x6dfc7ee5c0be534ccadd64ca5ac9c0319e9fc9925ccd356fd759186b3ec2abb1
1	0xa4538a05333fa64ef38ea699fa8972fdccae62f8	false	264	0x42a0eef97019bf6f15796fc9a015f681c581f77a	1000000	39920139	2023-03-03T14:30:45.000Z	150000	0xca526431528b1decbec55dbb552e23fe0e050403a042bab36aaeae85bd2399c0
3	0xa4538a05333fa64ef38ea699fa8972fdccae62f8	false	396	0xf35bb0619b0d78613c42dbc9e44d535749649dcb	337000000	40543924	2023-03-19T23:22:11.000Z	50549857	0x24d30753725fff5f95c6ad8d31fb0db3d8a2998167df818d1ee2066f43eb3b16

Example Query

Query with partition filter

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

BufferBinaryOptions11_Create_event

Binary options creation events from Buffer Finance on Polygon, capturing option ID, trader account, total fee, and settlement fee when new options positions are opened. Used for analyzing trading fees, position creation 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
24	0x07dc81a0fa3a1cac30ea2aa50be623a0be4bb758	false	336	0xddb904e2eb18ebd6ced1fad91b42e72ef17a2d78	1000000	40636627	2023-03-22T12:22:20.000Z	100000	0xf911e413e78c802ca3a6e73cf103e3a4d95b3c055c87b0d9025ffcdd5b365016
25	0x07dc81a0fa3a1cac30ea2aa50be623a0be4bb758	false	561	0xddb904e2eb18ebd6ced1fad91b42e72ef17a2d78	1000000	40636784	2023-03-22T12:28:58.000Z	100000	0xa212c8c8ac8ecd78aa622ef9f20c89b6ff747d8bbd2c126c757bf3630aa0f3e7
23	0x07dc81a0fa3a1cac30ea2aa50be623a0be4bb758	false	176	0xddb904e2eb18ebd6ced1fad91b42e72ef17a2d78	1000000	40635689	2023-03-22T11:41:50.000Z	100000	0xd3ed3568d316c2e10f5ce1fac2db8149a5679a64e9b7d76d8e761a6ec87db8ef

Example Query

Query with partition filter

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

BufferBinaryOptions12_Create_event

Binary options creation events from Buffer Finance protocol on Polygon. Records new options positions with account addresses, option IDs, total fees, and settlement fees for tracking options market 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
2	0x4d7f87d29320d9647e54cee6a77809c2572d7bb6	false	154	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000	39611444	2023-02-23T05:44:53.000Z	200000	0xf491d537915deaccc35c8479ab803ce10193cfef24ef6baea7d43c59e9dd6428
1	0x4d7f87d29320d9647e54cee6a77809c2572d7bb6	false	425	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000	39610990	2023-02-23T05:25:31.000Z	200000	0x18c8ac8a3015ff6e94b8cfe7a0f3b6b769f2f9b3dd5f99b28dfb99bb6d188398
0	0x4d7f87d29320d9647e54cee6a77809c2572d7bb6	false	567	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000	39610979	2023-02-23T05:24:47.000Z	200000	0xbed3bd18e73010c493d52c9a5f8006b592e393249ae5e9d820fc3794cb7ff2c7

Example Query

Query with partition filter

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

BufferBinaryOptions13_Create_event

Binary options contract creation events from Buffer Finance protocol on Polygon. Records include sequential option IDs, user accounts, total fees and settlement fees for tracking 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
617	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	89	0xa0e9ef69a7c173540da2bf8063bc6cc1b1467618	10000000	42597221	2023-05-12T02:21:53.000Z	2000000	0x2a727f9a773e94cf143257915bc543a92336986bf40f5bc81d5e43235d17a472
618	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	399	0xa0e9ef69a7c173540da2bf8063bc6cc1b1467618	12500000	42603729	2023-05-12T06:16:03.000Z	2500000	0x0f5ace577cde42c0ae9744f0df4e23bedc145e6aad0c384954a14b1bfb2e9098
619	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	331	0x87b9d6e007fac40716877101d5dd5950e7321f14	5000000	42609400	2023-05-12T09:38:17.000Z	1000000	0x445f543c93c2784d276eb30eebf4bdb8d6a851c2d653b747e01404be45e0e089

Example Query

Query with partition filter

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

BufferBinaryOptions14_Create_event

Binary options position creation events from Buffer Finance protocol on Polygon. Records account addresses, option IDs, and associated fees (total and settlement) for tracking 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
0	0x5a8f9e2b7bb7a7117ead6245bb37f1c36d88c06a	false	218	0x8d9ea22a3af8685c3af5c68f36086a9704857505	180000000	41109081	2023-04-03T21:20:11.000Z	26999924	0x8db0f85edbcaff9a86dbb907a79b30957fcf681a0b4588ebf144ba1db8cb0078

Example Query

Query with partition filter

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

BufferBinaryOptions15_Create_event

Binary options position creation events from Buffer Finance protocol on Polygon. Records include option identifiers, user accounts, total fees paid, and settlement fees for tracking 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
7	0xbcd8c1585a81133e2bc86a2355d70e3b72afba1a	false	178	0x8d9ea22a3af8685c3af5c68f36086a9704857505	100000000	41308892	2023-04-09T00:16:57.000Z	20000000	0xaa692e64407169c19419d2ced553d02a85e969bfd0c1e4acc3c00eec483bf61a
6	0xbcd8c1585a81133e2bc86a2355d70e3b72afba1a	false	301	0x8d9ea22a3af8685c3af5c68f36086a9704857505	100000000	41308867	2023-04-09T00:16:05.000Z	20000000	0x22a0a442f99f4174c0429f566a875834584f864629c830499e166e7445e419fe
2	0xbcd8c1585a81133e2bc86a2355d70e3b72afba1a	false	90	0x42a0eef97019bf6f15796fc9a015f681c581f77a	1000000	40290072	2023-03-13T07:39:31.000Z	187499	0xfb44ec3259f8fb8eb18292c9cd9012563b5e7b905e62a093f7986ca4a2960fa7

Example Query

Query with partition filter

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

BufferBinaryOptions16_Create_event

Binary options contract creation events from Buffer Finance protocol on Polygon. Captures option ID, trader account, 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
2	0xe43304218e50b024d3d0d53f52bdbd02bb5110b6	false	506	0x8d9ea22a3af8685c3af5c68f36086a9704857505	150000000	41068793	2023-04-02T20:03:41.000Z	22499937	0x693735611eb4bc57f9eb5f5ef0b5df1b6035e042276537050a342ab4e491f8a5
3	0xe43304218e50b024d3d0d53f52bdbd02bb5110b6	false	116	0x8d9ea22a3af8685c3af5c68f36086a9704857505	150000000	41068842	2023-04-02T20:05:25.000Z	22499937	0xeec97f949264fc2b785c55359f47715569bd3b759b4f516f5dac0b3da989bf3d
4	0xe43304218e50b024d3d0d53f52bdbd02bb5110b6	false	379	0x8d9ea22a3af8685c3af5c68f36086a9704857505	150000000	41068948	2023-04-02T20:09:41.000Z	22499937	0x1fb9a4e033dd58904d1d9c59f6d7c0e743fea0b4d3af15fc76a4fcc26a5c1332

Example Query

Query with partition filter

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

BufferBinaryOptions17_Create_event

Binary options creation events from Buffer Finance protocol on Polygon. Records new option positions with unique identifiers, user accounts, and fee breakdowns for tracking 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
2332	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	162	0x8aacec3d7077d04f19ac924d2743fc0de1456941	10000000	47724310	2023-09-19T08:57:40.000Z	2000000	0xfaf4807ea3dd2dbfbb34c13a55cdb71d381957914576e1db12565f58d1d01998
660	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	266	0x1d9835e7fd95c2a5e77457c8f9f6f9ec910a501a	17290000	42680573	2023-05-14T04:23:09.000Z	3458000	0xa14fbfa133fd9fdfc1c53d8e320bffe12df7ccaed3820145358f37b6d081b992
659	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	246	0x1d9835e7fd95c2a5e77457c8f9f6f9ec910a501a	16540000	42680368	2023-05-14T04:15:40.000Z	3308000	0x6dac8f02ae8cfcd526b8eb4a57c7ee56f75384900c307ac9cff0d18833811979

Example Query

Query with partition filter

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

BufferBinaryOptions18_Create_event

Binary options contract creation events from Buffer Finance protocol on Polygon. Tracks option positions with unique IDs, user accounts, total fees, 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
58	0xdd24edfb0d0cf4b2cb4b627ec20255245b5b0cee	false	353	0x270602c9227c268eaa76af0d25a6391de9345330	50000000	40420871	2023-03-16T18:05:07.000Z	7499979	0xdcd0c92a733e81e2b57523b531bc30bfce37a28e95948e8690fb3f4d036a3556
172	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	153	0x42a0eef97019bf6f15796fc9a015f681c581f77a	1000000	40394618	2023-03-16T02:01:29.000Z	150000	0xaca0fbcfa8aa9fec925052b9da310a00378ba6c1001701776521137cd22d9fda
179	0xd7e11b4c04f4ed0df06b6c66e8a0fe81ff3a12e7	false	338	0x42a0eef97019bf6f15796fc9a015f681c581f77a	1000000	40403438	2023-03-16T07:40:29.000Z	150000	0x694d088bed20debc6eff66831bbe40befa834e263e22f90343bf3a70037d3fef

Example Query

Query with partition filter

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

BufferBinaryOptions2_Create_event

Binary options creation events from Buffer Finance protocol on Polygon. Records new option positions with option ID, account address, total fees, and settlement fees for tracking user activity and fee economics.

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	0xaf8c7374ec533239dfa4b346c1282aa740898f9a	false	326	0xb66127377ff3618b595177b5e84f8ee9827cd061	15224	39590061	2023-02-22T14:23:08.000Z	2283	0x1fcf58a5b6c4231523af5a02951adbe885db4a7f575e340d832f2832b94d75dc
1	0xaf8c7374ec533239dfa4b346c1282aa740898f9a	false	202	0xe661d3be482b379d491c43e4a5c1f5f7d138bb7d	72000000	40613459	2023-03-21T21:21:20.000Z	10799970	0x46e7868d6a1166d69925898b30fb2ea5a8ed53e9d912e1b77e86f0a5389216d0
4	0xaf8c7374ec533239dfa4b346c1282aa740898f9a	false	254	0x8d9ea22a3af8685c3af5c68f36086a9704857505	250000000	41108669	2023-04-03T21:03:05.000Z	37499894	0x41aaa4a9ff461fd0ca337314f6701ba97134cbf33ea2e20bf89fe8e33d6030d9

Example Query

Query with partition filter

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

BufferBinaryOptions3_Create_event

Binary options creation events from Buffer Finance protocol on Polygon, recording new option positions with unique IDs, account addresses, and fee structures (total and settlement fees). Used for tracking option opening 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
22	0x409fd2b70fdbf61dc1a3695875b92ead90ae39d1	false	311	0xa7a3de4ddc92dbba0788c51e9e57778b42f6eb07	5000000	40952776	2023-03-30T21:01:58.000Z	749998	0x264e6f2b9fce1048ebd43016cf3b0fc39a70109cfa6aa67d5b9985285951f6f1
20	0x409fd2b70fdbf61dc1a3695875b92ead90ae39d1	false	201	0x8d9ea22a3af8685c3af5c68f36086a9704857505	160000000	40952744	2023-03-30T21:00:50.000Z	23999932	0x2ac9043f83b384769231043adbc3e1a835aca85065b730c21c60150b06de6beb
21	0x409fd2b70fdbf61dc1a3695875b92ead90ae39d1	false	235	0x8d9ea22a3af8685c3af5c68f36086a9704857505	160000000	40952772	2023-03-30T21:01:50.000Z	23999932	0xbf7fa16d5ccaf77e859f9cdb3a8dc0c08aacba395e375fb08208eb85a0db8397

Example Query

Query with partition filter

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

BufferBinaryOptions4_Create_event

Binary options position creation events from Buffer Finance protocol on Polygon. Records option openings with account addresses, sequential position IDs, and fee breakdowns including settlement costs for tracking 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
3	0x7184b170fda4871ab8ad82fc81d57cf24c4099fe	false	281	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000	40409279	2023-03-16T11:08:52.000Z	150000	0xf5d6a1cab3402b4c8d299f4af063cc54d1b2896562081426d7030e250b992f9c
4	0x7184b170fda4871ab8ad82fc81d57cf24c4099fe	false	283	0xe661d3be482b379d491c43e4a5c1f5f7d138bb7d	100000000	40838351	2023-03-27T21:11:49.000Z	14999958	0x4f40bd6e1b5de15f6459d7a3ce7ed61f6d2cdd4cf813c4afae9b95bb8be7796b
1	0x7184b170fda4871ab8ad82fc81d57cf24c4099fe	false	266	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000	39906274	2023-03-03T05:55:34.000Z	150000	0x52c284f6f3bed0d8418dafef7e7256532e3980aefe43c9470be4a777070cb6ca

Example Query

Query with partition filter

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

BufferBinaryOptions5_Create_event

Binary options creation events from Buffer Finance protocol on Polygon. Records each new option position with user account, fees (total and settlement), and unique option identifiers for tracking 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
3	0x01532fb7cbead7c5cf8f58ead92e7ce027e19f75	false	394	0x8d9ea22a3af8685c3af5c68f36086a9704857505	250000000	41108696	2023-04-03T21:04:35.000Z	37499894	0x40f8004aab9caf9f2b86ca52292553fcf3f01965c2f2fcac76ae3176f1d79224
0	0x01532fb7cbead7c5cf8f58ead92e7ce027e19f75	false	314	0xe661d3be482b379d491c43e4a5c1f5f7d138bb7d	30000000	40539034	2023-03-19T20:05:33.000Z	4499988	0xee635e035681c328ee3a55abb4872ca518cbaa542914e672a83f1a2577c65f8a
2	0x01532fb7cbead7c5cf8f58ead92e7ce027e19f75	false	378	0x8d9ea22a3af8685c3af5c68f36086a9704857505	150000000	41068877	2023-04-02T20:06:39.000Z	22499937	0x34ee9f1b4807970151b0e091a66949c128a2c4925acb71310f0b8b1a5694668f

Example Query

Query with partition filter

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

BufferBinaryOptions6_Create_event

Binary options contract creation events from Buffer Finance v1 protocol on Polygon. Tracks option IDs, trader accounts, total fees paid, 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
2	0xb3d1ffe9cbc03d363ebc7ee3027359a7f6b6f9c9	false	175	0x8d9ea22a3af8685c3af5c68f36086a9704857505	114000000	40952793	2023-03-30T21:02:34.000Z	17099952	0xb2fd510a8e108c7cb5dba90375401dbd0aef4158aa101901c48e3ab55e7d9bc2
0	0xb3d1ffe9cbc03d363ebc7ee3027359a7f6b6f9c9	false	315	0xdc1326b2ba4feac0e894389066f8d69f8759a337	30000000	40274797	2023-03-12T22:02:23.000Z	4499988	0x862e046c65e48c6b15a629811a6e23772a0a4da3c2d20d88b32d49d4b1b27f49
1	0xb3d1ffe9cbc03d363ebc7ee3027359a7f6b6f9c9	false	238	0x8d9ea22a3af8685c3af5c68f36086a9704857505	64000000	40800396	2023-03-26T20:27:42.000Z	9599973	0x2f32562a10c7bb799876a48ca9f296a1ae20602a3725f073f06f066dd62ba457

Example Query

Query with partition filter

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

BufferBinaryOptions7_Create_event

Binary options position creation events from Buffer Finance protocol on Polygon. Records option opening transactions with unique position IDs, user accounts, and fee breakdowns for tracking 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
0	0x24e7beb042a804974963b8ea3fa42e6ab5ea8b35	false	356	0xe661d3be482b379d491c43e4a5c1f5f7d138bb7d	60000000	40426399	2023-03-16T21:30:27.000Z	8999975	0x9fd1b6d235f33b855ca574f56d2a8d3c762f7f16b43aad684788b78329160dcd
1	0x24e7beb042a804974963b8ea3fa42e6ab5ea8b35	false	434	0xe661d3be482b379d491c43e4a5c1f5f7d138bb7d	100000000	40875994	2023-03-28T21:21:37.000Z	14999958	0x0cf18a73ef85bb4fe49b074776c09f319bd65a4149832855c2301260a3db10a8
5	0x24e7beb042a804974963b8ea3fa42e6ab5ea8b35	false	199	0xc1a3c2a446b7bc4b21f8ce14621c0684f0ba21a3	1000000	40986166	2023-03-31T17:18:05.000Z	150000	0xdd774de462e7728e9aeb33b316d11f9c4367c97afc3195062732201f580f1b0e

Example Query

Query with partition filter

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

BufferBinaryOptions8_Create_event

Binary options creation events from Buffer Finance protocol on Polygon, capturing option ID, trader account, total fees, and settlement fees. Used for analyzing option creation patterns and fee structures 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
250	0xdd24edfb0d0cf4b2cb4b627ec20255245b5b0cee	false	179	0x066dc3ff62c9c356e2d602d1156cee762acda921	5000000	42241147	2023-05-03T03:47:28.000Z	1000000	0x5585257051091fe795bca8dc94f9cef94af68ff6d8fed43e08aa0dc5e57c7d8b
52	0xdd24edfb0d0cf4b2cb4b627ec20255245b5b0cee	false	271	0xe63b6a571390d9c6589097cf18ef8d60f57a3308	1000000	40362867	2023-03-15T05:44:02.000Z	137500	0xc37990817ee22093346bc365167165bf0b1cefefee42f250b8db20cea8fd2bbd
57	0xdd24edfb0d0cf4b2cb4b627ec20255245b5b0cee	false	240	0xb66127377ff3618b595177b5e84f8ee9827cd061	1000000	40374327	2023-03-15T12:57:07.000Z	137500	0xee34c778dd4caf934cd70bd0e876814ca10d3ccbf14055562b032c5c258a9ff8

Example Query

Query with partition filter

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

BufferBinaryOptions9_Create_event

Binary options contract creation events from Buffer Finance protocol on Polygon. Captures option opening transactions with unique identifiers, user accounts, and fee structures for analyzing 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
7	0xb681b91546bb63ca9b3d6042106a0bd8a29d5095	false	315	0xe63b6a571390d9c6589097cf18ef8d60f57a3308	1000000	40152217	2023-03-09T16:48:39.000Z	100000	0xa6b36eeaaca941db587ac341a7ad4c279b4d29971436bd41f16c7f6a8a929d28
6	0xb681b91546bb63ca9b3d6042106a0bd8a29d5095	false	344	0xe63b6a571390d9c6589097cf18ef8d60f57a3308	1000000	40144947	2023-03-09T12:15:28.000Z	100000	0x73f278922b708e6260ac72ea48fb7135dfff9a554cf8dd455db396ac14e1724c
27	0xb681b91546bb63ca9b3d6042106a0bd8a29d5095	false	442	0xe63b6a571390d9c6589097cf18ef8d60f57a3308	1000000	40362174	2023-03-15T05:17:52.000Z	87500	0xc8458026ecf8fdfcb5b68c7c609a195f47753ea15884943a102a4b74e0c9e102

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BufferBinaryOptions1_Create_event

BufferBinaryOptions10_Create_event

BufferBinaryOptions11_Create_event

BufferBinaryOptions12_Create_event

BufferBinaryOptions13_Create_event

BufferBinaryOptions14_Create_event

BufferBinaryOptions15_Create_event

BufferBinaryOptions16_Create_event

BufferBinaryOptions17_Create_event

BufferBinaryOptions18_Create_event

BufferBinaryOptions2_Create_event

BufferBinaryOptions3_Create_event

BufferBinaryOptions4_Create_event

BufferBinaryOptions5_Create_event

BufferBinaryOptions6_Create_event

BufferBinaryOptions7_Create_event

BufferBinaryOptions8_Create_event

BufferBinaryOptions9_Create_event

​Tables

​BufferBinaryOptions1_Create_event

​BufferBinaryOptions10_Create_event

​BufferBinaryOptions11_Create_event

​BufferBinaryOptions12_Create_event

​BufferBinaryOptions13_Create_event

​BufferBinaryOptions14_Create_event

​BufferBinaryOptions15_Create_event

​BufferBinaryOptions16_Create_event

​BufferBinaryOptions17_Create_event

​BufferBinaryOptions18_Create_event

​BufferBinaryOptions2_Create_event

​BufferBinaryOptions3_Create_event

​BufferBinaryOptions4_Create_event

​BufferBinaryOptions5_Create_event

​BufferBinaryOptions6_Create_event

​BufferBinaryOptions7_Create_event

​BufferBinaryOptions8_Create_event

​BufferBinaryOptions9_Create_event

Tables

BufferBinaryOptions1_Create_event

BufferBinaryOptions10_Create_event

BufferBinaryOptions11_Create_event

BufferBinaryOptions12_Create_event

BufferBinaryOptions13_Create_event

BufferBinaryOptions14_Create_event

BufferBinaryOptions15_Create_event

BufferBinaryOptions16_Create_event

BufferBinaryOptions17_Create_event

BufferBinaryOptions18_Create_event

BufferBinaryOptions2_Create_event

BufferBinaryOptions3_Create_event

BufferBinaryOptions4_Create_event

BufferBinaryOptions5_Create_event

BufferBinaryOptions6_Create_event

BufferBinaryOptions7_Create_event

BufferBinaryOptions8_Create_event

BufferBinaryOptions9_Create_event