x2y2_v1_ethereum

Tables

Exchange_EvInventory_event

NFT order execution events from X2Y2 marketplace on Ethereum, capturing maker-taker trades with prices, token details, and settlement parameters. Used for analyzing trading activity, order matching behavior, and marketplace 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_itemHash`	`STRING`	Hash identifier for the specific NFT item being traded in the X2Y2 order. Hex-encoded 0x-prefixed 64-character string used to uniquely reference the item within the exchange protocol.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_orderSalt`	`STRING`	Random nonce value used to create unique order identifiers on the X2Y2 marketplace. Prevents order hash collisions when the same maker creates multiple orders with identical parameters.
`in_settleSalt`	`STRING`	Settlement nonce used to ensure unique order execution and prevent replay attacks on X2Y2. Large numeric value that varies per transaction.
`in_intent`	`STRING`	Order type identifier specifying whether this is a buy (1) or sell (2) order on the X2Y2 marketplace. All sample values show ‘1’ indicating buy-side intent.
`in_delegateType`	`STRING`	Delegation type indicator for the X2Y2 order execution. Typically ‘1’ for ERC-721 tokens, defining which delegate contract handles the NFT transfer.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_dataMask`	`STRING`	Hexadecimal data mask parameter from the X2Y2 order structure, typically empty (0x) for standard orders. Used to modify or filter specific data fields during order settlement.
`in_item`	`STRUCT<price STRING, data STRING>`	NFT asset and pricing details for the order, including token contract, token ID, and sale price in wei. This structured field contains the specific item being traded in the X2Y2 marketplace transaction.
`in_detail`	`STRUCT<op INT64, orderIdx STRING, itemIdx STRING, price STRING, itemHash STRING, executionDelegate STRING, dataReplacement STRING, bidIncentivePct STRING, aucMinIncrementPct STRING, aucIncDurationSecs STRING, fees ARRAY<STRUCT<percentage STRING,` to `STRING>>>`	Settlement details for the X2Y2 marketplace order including price, fees, delegate contract, and auction parameters. Nested structure contains execution metadata such as operation type (op), item/order indices, and bidding incentive percentages.

Sample Data

address	in_item	removed	in_maker	in_taker	in_detail	in_intent	log_index	in_currency	in_dataMask	in_deadline	in_itemHash	block_number	in_orderSalt	in_settleSalt	block_timestamp	in_delegateType	transaction_hash
0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	{“data”:“0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000bd3531da5cf5857e7cfaa92426877b022e612cf80000000000000000000000000000000000000000000000000000000000001492”,“price”:“6800000000000000000”}	false	0xf7c4254af77f6688217502f0c54d9253a60b8eec	0xaab53d5b3eb632f7d40dc0cdd72aa78105bcb36b	{“op”:1,“fees”:[],“price”:“6800000000000000000”,“itemIdx”:“0”,“itemHash”:“0xfe5bfdb5659d1e1c1878c376a3402282756e4f43ef1610366f0dda9674da8ceb”,“orderIdx”:“0”,“bidIncentivePct”:“0”,“dataReplacement”:“0x”,“executionDelegate”:“0xf849de01b080adc3a814fabe1e2087475cf2e354”,“aucIncDurationSecs”:“0”,“aucMinIncrementPct”:“0”}	1	74	0x0000000000000000000000000000000000000000	0x	1660942974	0xfe5bfdb5659d1e1c1878c376a3402282756e4f43ef1610366f0dda9674da8ceb	15373313	119021041238139302770562231699169845952	286467791213200	2022-08-19T20:06:43.000Z	1	0x812e0c6f213f2b993361936ff6b25554875dd77f6cbe123ddbceebc022ebf2d2
0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	{“data”:“0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000059edd72cd353df5106d2b9cc5ab83a52287ac3a0000000000000000000000000000000000000000000000000000000000002524”,“price”:“14000000000000000000”}	false	0xf1f31431e9c46a4b3aba6491f873be993b9d43d0	0x79c5104e69aedd9077edf068be86a391bcfa7b74	{“op”:1,“fees”:[],“price”:“14000000000000000000”,“itemIdx”:“0”,“itemHash”:“0x2877daedcefce9ae1a46dac8152d0bfb33cdefd2619a39028795436e7ca16410”,“orderIdx”:“0”,“bidIncentivePct”:“0”,“dataReplacement”:“0x”,“executionDelegate”:“0xf849de01b080adc3a814fabe1e2087475cf2e354”,“aucIncDurationSecs”:“0”,“aucMinIncrementPct”:“0”}	1	1421	0x0000000000000000000000000000000000000000	0x	1660946202	0x2877daedcefce9ae1a46dac8152d0bfb33cdefd2619a39028795436e7ca16410	15373059	60902912681473251296377130840240073632	23320359100056	2022-08-19T19:08:54.000Z	1	0x07959704a43517dbe05877058a5e3c11130069c0557facbb4201c8f67b930769
0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	{“data”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000100000000000000000000000075e95ba5997eb235f40ecf8347cdb11f18ff640b00000000000000000000000000000000000000000000000000000000000014fb”,“price”:“1300000000000000000”}	false	0xf41a3bb52d1e88d253079e2dc7092935730f2bf6	0x865eda02ee16b83ca34d8aa5a94341ccd90228d4	{“op”:1,“fees”:[],“price”:“1300000000000000000”,“itemIdx”:“0”,“itemHash”:“0x3a0e48bc4dd4e0b2e3f5c96590a2dfeb7947c4d9a012d8ce40baa1983ec9b955”,“orderIdx”:“0”,“bidIncentivePct”:“0”,“dataReplacement”:“0x”,“executionDelegate”:“0xf849de01b080adc3a814fabe1e2087475cf2e354”,“aucIncDurationSecs”:“0”,“aucMinIncrementPct”:“0”}	1	519	0x0000000000000000000000000000000000000000	0x	1660951548	0x3a0e48bc4dd4e0b2e3f5c96590a2dfeb7947c4d9a012d8ce40baa1983ec9b955	15368208	313129937544839772966521410590774617366	774145339097708	2022-08-19T00:34:53.000Z	1	0xd905988f6a29fae76e7c35626c1a0d181339344cb2a8cb00e74af521e7cbe1d0

Example Query

Query with partition filter

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

Exchange_EvProfit_event

Profit distribution events from X2Y2 NFT marketplace on Ethereum, tracking fee payments to recipients with currency and amount details. Useful for analyzing marketplace revenue flows and fee structures per transaction.

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_itemHash`	`STRING`	Unique identifier hash for the specific NFT or item being traded in the X2Y2 marketplace transaction. Hex-encoded, 0x-prefixed 64-character string that remains consistent across related profit events for the same item.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. 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

in_to	address	removed	in_amount	log_index	in_currency	in_itemHash	block_number	block_timestamp	transaction_hash
0xa2f20b41c8954f1803a7804a8dd5e97e0cba2eb6	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	false	102900000000000	150	0x0000000000000000000000000000000000000000	0xaf81e4ca110c90a80ea653bfb72dac562170b6b250696b2cf0bb1167a1bfe56d	14382331	2022-03-14T03:33:43.000Z	0xd268dd1c05448aaa74f6c200d201c9c19a192e220682f6bb8dcf9a1d6f54fa5e
0xa2f20b41c8954f1803a7804a8dd5e97e0cba2eb6	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	false	102900000000000	153	0x0000000000000000000000000000000000000000	0xf8243de498687f13745d2cfaf34da26c66267daec29d98320df638bd67b21290	14382331	2022-03-14T03:33:43.000Z	0xd268dd1c05448aaa74f6c200d201c9c19a192e220682f6bb8dcf9a1d6f54fa5e
0x9c27c3aa042a608f67d19bda36b099a062185a65	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	false	196000000000000	258	0x0000000000000000000000000000000000000000	0x5b90eb9994f32a8404b622441812504970a5770ac3736f8c490e68cde5f9d537	14384335	2022-03-14T11:01:53.000Z	0x6abdbdd54dda476af61fe3c7905f6eb3bdc34ed7d2df4a3c2e7f303342fa40d8

Example Query

Query with partition filter

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

Exchange_run_function

Exchange function call traces from X2Y2 NFT marketplace on Ethereum. Contains order execution details including bids, asks, prices, and cryptographic signatures for analyzing trading patterns and order matching 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_input`	STRUCT<orders ARRAY<STRUCT<salt STRING, user STRING, network STRING, intent STRING, delegateType STRING, deadline STRING, currency STRING, dataMask STRING, items ARRAY<STRUCT<price STRING, data STRING>>, r STRING, s STRING, v INT64, signVersion INT64>>, details ARRAY<STRUCT<op INT64, orderIdx STRING, itemIdx STRING, price STRING, itemHash STRING, executionDelegate STRING, dataReplacement STRING, bidIncentivePct STRING, aucMinIncrementPct STRING, aucIncDurationSecs STRING, fees ARRAY<STRUCT<percentage STRING, to `STRING>>>>, shared STRUCT<salt STRING, deadline STRING, amountToEth STRING, amountToWeth STRING, user STRING, canFail BOOL>, r STRING, s STRING, v INT64>`	Decoded input parameters containing order details, signatures, and execution instructions for X2Y2 marketplace transactions. Null for failed transactions; contains nested structures with buyer/seller addresses, NFT contract addresses, token IDs, prices, fees, and cryptographic signatures for successful trades.

Sample Data

gas	value	status	gas_used	in_input	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
289606	100000000000000000	false	21236		0x357a150b	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	14173575	0x3bd5cdc9ed27bd983bf0492d4fbf7195d0a1f11b	2022-02-09T18:48:27.000Z	0xcd0cb0f208e941c09e797962babf4978ec66278bfe863c93563f49cc037e3c84
209991	10000000000000000	false	21236		0x357a150b	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	14174815	0xfefaee993de8f60551f3805391b5673dc21082a1	2022-02-09T23:25:04.000Z	0xd89545fb59f814c76784badbb32325d4821d1e97720b15b7ab90ac44e504b7cf
301207	1000000000000000	true	185297	{“r”:“0xb4f2ee720c512fd00b773eb38074bdf66c2a14d0eb7d328d51dd344b69d78d56”,“s”:“0x45508d23921f01c5266c82a155bb1387f4044207c7eeff0c079427ee97dd9c5b”,“v”:27,“orders”:[{“r”:“0x127b142d7c26720d6958eaeb6342b456ebde1eea49f016865e872b97a234b316”,“s”:“0x5efc5b909f3c424de4e6d4cc469407bdf224a1a3a2f1413dfa34cabe03972f78”,“v”:27,“salt”:“94647603028997846648572301503883114600”,“user”:“0x427aaf8b39b2bd24cdc86dad870bc0dc25863a7b”,“items”:[{“data”:“0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000009525c4fe14addba627db8e45036767895181e5590000000000000000000000000000000000000000000000000000000000000d6c”,“price”:“1000000000000000”}],“intent”:“1”,“network”:“1”,“currency”:“0x0000000000000000000000000000000000000000”,“dataMask”:“0x”,“deadline”:“1647005318”,“signVersion”:1,“delegateType”:“1”}],“shared”:{“salt”:“767198022856073”,“user”:“0xb34bd1d3ce820b56ab9adc2ebc81b819080a6403”,“canFail”:false,“deadline”:“1644415271”,“amountToEth”:“0”,“amountToWeth”:“0”},“details”:[{“op”:1,“fees”:[],“price”:“1000000000000000”,“itemIdx”:“0”,“itemHash”:“0x34c714babcf6ce05e71ebf1ab4197f709068ee62c34ad2fac8995ea6b8cc58db”,“orderIdx”:“0”,“bidIncentivePct”:“0”,“dataReplacement”:“0x”,“executionDelegate”:“0xf849de01b080adc3a814fabe1e2087475cf2e354”,“aucIncDurationSecs”:“0”,“aucMinIncrementPct”:“0”}]}	0x357a150b	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	14172190	0xb34bd1d3ce820b56ab9adc2ebc81b819080a6403	2022-02-09T13:32:38.000Z	0xc51f3942cba2328519a7f7421120bb61eb7bdcea5d07226ec1c27c3cc52046f4

Example Query

Query with partition filter

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

Exchange_run1_function

X2Y2 NFT marketplace run1 function call traces on Ethereum. Records individual function executions within marketplace transactions, useful for analyzing failed operations and internal contract interactions.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<salt STRING, user STRING, network STRING, intent STRING, delegateType STRING, deadline STRING, currency STRING, dataMask STRING, items ARRAY<STRUCT<price STRING, data STRING>>, r STRING, s STRING, v INT64, signVersion INT64>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_shared`	`STRUCT<salt STRING, deadline STRING, amountToEth STRING, amountToWeth STRING, user STRING, canFail BOOL>`	Structured input parameter containing shared marketplace data for X2Y2 NFT exchange transactions. This field is null in all sample rows, suggesting it may only be populated for specific transaction types or marketplace configurations.
`in_detail`	`STRUCT<op INT64, orderIdx STRING, itemIdx STRING, price STRING, itemHash STRING, executionDelegate STRING, dataReplacement STRING, bidIncentivePct STRING, aucMinIncrementPct STRING, aucIncDurationSecs STRING, fees ARRAY<STRUCT<percentage STRING,` to `STRING>>>`	Structured input parameters containing detailed specifications for an X2Y2 NFT marketplace order execution. Null in these samples indicates failed transaction attempts where order details were not successfully processed.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
843684	false	12941	0xd95e3c54	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	14301442	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	0,1	2022-03-01T13:39:05.000Z	0x280a2208d768e9e0e78e622075bdf48c47a972c02cc03fd4ae510f33b7e00095
1768038	false	12941	0xd95e3c54	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	14301473	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	0,0	2022-03-01T13:45:04.000Z	0xcb4959f1224f03a10f9bab75eb4563e381bf2d5ae572840f5adb04f9011b5998
824938	false	12941	0xd95e3c54	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	14301442	0x74312363e45dcaba76c59ec49a7aa8a65a67eed3	0,2	2022-03-01T13:39:05.000Z	0x280a2208d768e9e0e78e622075bdf48c47a972c02cc03fd4ae510f33b7e00095

Example Query

Query with partition filter

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

ListingRewardDistributorV2_Reward_event

Reward distribution events from X2Y2 NFT marketplace’s listing incentive program on Ethereum. Tracks token reward payouts to users by round for analyzing marketplace incentive economics 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_round`	`STRING`	Sequential identifier for vault or auction rounds. Numeric string representing the round number in the protocol’s lifecycle.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_round	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xc4ccddcd0239d8425b54322e8e5f99d19fb7ba43	0x2b220fc563571dee5eb1985a84d217fe34b5403b	false	9	24727917353879151000	242	14280192	2022-02-26T06:55:31.000Z	0xf34c1a3e84715d574de97732cd2db50632b3dd0e72f30548dca370446ed78016
0xc4ccddcd0239d8425b54322e8e5f99d19fb7ba43	0x2b220fc563571dee5eb1985a84d217fe34b5403b	false	9	38186987639771955000	243	14280192	2022-02-26T06:55:31.000Z	0xf34c1a3e84715d574de97732cd2db50632b3dd0e72f30548dca370446ed78016
0xc4ccddcd0239d8425b54322e8e5f99d19fb7ba43	0x2b220fc563571dee5eb1985a84d217fe34b5403b	false	9	13354757674438829000	244	14280192	2022-02-26T06:55:31.000Z	0xf34c1a3e84715d574de97732cd2db50632b3dd0e72f30548dca370446ed78016

Example Query

Query with partition filter

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

LoanFacet_borrow_function

NFT-collateralized loan origination events from X2Y2’s lending protocol on Ethereum. Records borrow transactions with loan terms including NFT collateral details, borrow/repay amounts in WETH, loan duration, and lender/borrower signatures for analyzing NFT lending 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__offer`	`STRUCT<itemType INT64, borrowAmount STRING, repayAmount STRING, nftAsset STRING, borrowAsset STRING, tokenId STRING, borrowDuration STRING, validUntil STRING, amount STRING, signature STRUCT<signer STRING, signature STRING>>`	Loan offer details submitted by the lender, including NFT collateral specification, borrow/repay amounts in the borrowAsset token, loan duration in seconds, and cryptographic signature authorizing the terms. Nested structure contains nftAsset contract address, tokenId (or max uint256 for any token), borrowAmount and repayAmount in wei, borrowDuration, validUntil timestamp, and signer’s signature.
`in__nftId`	`STRING`	Token identifier of the NFT being used as collateral for the loan. Can be a simple numeric ID or a large integer hash depending on the NFT collection’s token standard.
`in__brokerSignature`	`STRUCT<signer STRING, signature STRING>`	Cryptographic signature from the X2Y2 broker authorizing the loan transaction. Contains the broker’s signer address and their signed approval of the lending terms.
`in__extraData`	`STRUCT<target STRING, selector STRING, data STRING, referral STRING, onBehalf STRING, proof ARRAY<STRING>>`	Additional data passed with the transaction or function call. Hex-encoded byte string, typically empty (0x) or containing protocol-specific metadata.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in__nftId	in__offer	out_anon0	signature	to_address	block_number	from_address	in__extraData	block_timestamp	transaction_hash	in__brokerSignature
402529	true	394242	9723	{“amount”:“2”,“tokenId”:“340282366920938463463374607431768211455”,“itemType”:0,“nftAsset”:“0x160c404b2b49cbc3240055ceaee026df1e8497a0”,“signature”:{“signer”:“0x00c26fc0853e9023b195c509cdd2a7cd0e054101”,“signature”:“0x404550e29d9629436efb9ac384daeff7ff5df8dd9e3c87ad7c0c65804c7975051a59fb7dc53e7814464fc5978a2f24b63577b139e4e88aecb8a7e112f38bc6591c”},“validUntil”:“1684925412”,“borrowAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“repayAmount”:“60180000000000000”,“borrowAmount”:“60000000000000000”,“borrowDuration”:“259200”}	30002	0x1cbf940a	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17278882	0x7447c3c14db5ec3329e32eb910a13c084d351b45	{“data”:“0x”,“proof”:[],“target”:“0x0000000000000000000000000000000000000000”,“onBehalf”:“0x0000000000000000000000000000000000000000”,“referral”:“0”,“selector”:“0x00000000”}	2023-05-17T10:51:11.000Z	0xd1d2f9257fba7589df4c805cb043e50624e390fce6574193c82150e60cbfd9d5	{“signer”:“0xfe02d4e2accb4248ce1d3f016c0b5bb43d50dde0”,“signature”:“0x946062be0b93290ef1fcb37b49fed419adf3cbd4a92619753d03260fe89fca4b01186b21574dc9f618f6a5c33ff9c1e9c5866a410e31a58014933217f8a5a0491b”}
409439	true	401044	104449871028227509994395222886914617778376648311665745719970974452550607244207	{“amount”:“1”,“tokenId”:“104449871028227509994395222886914617778376648311665745719970974452550607244207”,“itemType”:0,“nftAsset”:“0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85”,“signature”:{“signer”:“0x369d63d5fbdcc18d149b51fc0ec4b56230b478d2”,“signature”:“0xd4bfce3213fa91706d75ef75b4313bf2320d863a4756aa03da0e2c3783f5abf975263d5fb753184bc06d6baa18d1220d095fc0d09a3b8e077713af3df26b699d1c”},“validUntil”:“1684917553”,“borrowAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“repayAmount”:“50150000000000000”,“borrowAmount”:“50000000000000000”,“borrowDuration”:“259200”}	1	0x1cbf940a	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17278239	0x369d63d5fbdcc18d149b51fc0ec4b56230b478d2	{“data”:“0x”,“proof”:[],“target”:“0x0000000000000000000000000000000000000000”,“onBehalf”:“0x0000000000000000000000000000000000000000”,“referral”:“0”,“selector”:“0x00000000”}	2023-05-17T08:40:59.000Z	0x40f6e73ab13745176ad70425d52f102d81f36de7795c25d6835114bccd1eaecf	{“signer”:“0xfe02d4e2accb4248ce1d3f016c0b5bb43d50dde0”,“signature”:“0x6ddb555fcd6eaa027622f37979ab40a5023a6bdd0c8e145abf065b71a38d4da50986afde9ac5a0f5677743f2e61797ff86dc749ee025e5b7c70eeda3d4d65e631c”}
392067	true	383944	104449871028227509994395222886914617778376648311665745719970974452550607244207	{“amount”:“1”,“tokenId”:“104449871028227509994395222886914617778376648311665745719970974452550607244207”,“itemType”:0,“nftAsset”:“0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85”,“signature”:{“signer”:“0x369d63d5fbdcc18d149b51fc0ec4b56230b478d2”,“signature”:“0xdc10b7f7ecb243ca9a0ce39b920f071ff788cc63c877594a3f5b0c9e5c6c1f181d934f318afcd9e983d29d4332edb0b4cf0374daf03e67fc249fa656765ab51f1b”},“validUntil”:“1684919449”,“borrowAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“repayAmount”:“60084000000000000”,“borrowAmount”:“60000000000000000”,“borrowDuration”:“604800”}	30001	0x1cbf940a	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17278393	0x369d63d5fbdcc18d149b51fc0ec4b56230b478d2	{“data”:“0x”,“proof”:[],“target”:“0x0000000000000000000000000000000000000000”,“onBehalf”:“0x0000000000000000000000000000000000000000”,“referral”:“0”,“selector”:“0x00000000”}	2023-05-17T09:11:47.000Z	0xe4d1312557ac37ea9c0d15e8b8790864fa0119b5d4c0ab01df22c607a6b16ba1	{“signer”:“0xfe02d4e2accb4248ce1d3f016c0b5bb43d50dde0”,“signature”:“0x1639fc9d1f7d22df7935831bd64875e7c4f15fc062450e158ae0407f58cbe24c50c41fd26943407d1297b0acfc5f9af7beea653f787cf041c356982cfe2841201c”}

Example Query

Query with partition filter

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

LoanFacet_BorrowRefferal_event

Referral events for NFT-backed loans on X2Y2’s lending protocol on Ethereum, tracking borrower addresses and loan IDs when referral codes are used. Enables analysis of referral program effectiveness and loan origination sources.

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_loanId`	`STRING`	Unique identifier for the loan within the X2Y2 lending protocol. Numeric string representation.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	removed	in_loanId	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	30376	367	0x016dbc709b8c1667d7303e2c4129167d660dc010	17345416	2023-05-26T19:42:35.000Z	0x128bacaf5f32c96180342141f2b9b0aed6fd4f5a56711381604ae37baa6c71a4
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	30354	96	0x064980edd7d43abee781f49a4e31c06df05ecccb	17340060	2023-05-26T01:38:23.000Z	0x9783a7fd96ca16db8601ebefc977cccfd07439d5be45b0bb2abe1aff2315ff4b
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	30362	420	0x0d11b389003f22d56e5c39104dba80cc59ab17f5	17341311	2023-05-26T05:51:11.000Z	0xeb4be6afda40c4d93c742a37b00930161da3883f6236c4ba6d25626b67d125bc

Example Query

Query with partition filter

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

LoanFacet_increaseCounter_function

Function calls to increaseCounter on X2Y2’s LoanFacet contract on Ethereum, tracking counter increment operations for the NFT lending protocol. Used for analyzing loan workflow progression 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
29318	true	28975	0xb49004e9	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	18131445	0x064980edd7d43abee781f49a4e31c06df05ecccb	2023-09-14T02:08:11.000Z	0xf7f6874f075d018b9809c10596d8f42638b9c8a1af5ffca8d146f7236e8837bc
29318	true	28975	0xb49004e9	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	18131892	0xaafda05109be27b560aa0ff9f00eef9ec48cc670	2023-09-14T03:38:35.000Z	0x310b40b77d5b1581c62163a5827aed00820748a094154e6f06b6393ec8c38634
11947	true	11875	0xb49004e9	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	18131648	0xc4534ea2875c83d4f0245f94c96eb33ef274d833	2023-09-14T02:48:59.000Z	0x3e7f86f1dd1374e4ca0133d5b411c0de82d9f3f874a07db91d852376e7252c0f

Example Query

Query with partition filter

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

LoanFacet_liquidate_function

Loan liquidation events from X2Y2 NFT lending protocol on Ethereum, tracking when undercollateralized positions are seized by liquidators. Used for analyzing lending protocol risk, liquidation activity patterns, and liquidator profitability.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__loanId`	`STRING`	Unique identifier for the loan being liquidated in the X2Y2 NFT lending protocol. Numeric string values range from low five digits (e.g., 32192) to mid five digits (e.g., 36327).

Sample Data

gas	status	gas_used	signature	in__loanId	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
161356	true	156762	0x5b5b121d	35342	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	18153159	0xc79e5318c609a9ef6890c5a7ac07f70eebe5ee05		2023-09-17T03:38:11.000Z	0x62fd616c57992209e699e6d1ddd888866d1198242a0f8f38b575977b8199323a
189842	true	155232	0x5b5b121d	33153	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17736303	0x5f264625e6400102a2f5e9a5d6e006c7a6d41285	1,2,1,2,0,3	2023-07-20T18:56:11.000Z	0x42895438e588c4f1e18e1a1658490c3a0c0f783f96d035919f8e08978af9090e
149324	true	144918	0x5b5b121d	32192	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	18410257	0x40958d3e21e4fb0fb4ad7baedf6830e9b81d7385		2023-10-23T03:18:59.000Z	0x5406e94121cbf63f56a740eb89948518c9a08bc4bdcda52ecf6e3a45157b5cda

Example Query

Query with partition filter

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

LoanFacet_LoanLiquidated_event

NFT-collateralized loan liquidation events from X2Y2’s lending protocol on Ethereum. Records liquidated positions with borrower/lender addresses, NFT collateral details, loan amounts, and maturity/liquidation timestamps for analyzing lending risk and default 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_loanId`	`STRING`	Unique identifier for the loan within the X2Y2 lending protocol. Numeric string representation.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_lender`	`STRING`	Address of the lender providing funds in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_nftTokenId`	`STRING`	Token ID of the NFT collateral that was liquidated in this loan default event. Represented as a numeric string identifier unique to the NFT within its collection contract.
`in_loanMaturityDate`	`STRING`	Unix timestamp indicating when the NFT-collateralized loan was scheduled to mature and become due for repayment. Loans liquidated after this date suggest default scenarios where the borrower failed to repay by maturity.
`in_loanLiquidationDate`	`STRING`	Unix timestamp when the NFT-backed loan was liquidated after the borrower failed to repay. Represents the actual liquidation time, which occurs after the loan maturity date when the loan remains unpaid.
`in_nftAsset`	`STRING`	Contract address of the NFT collection used as collateral for the liquidated loan. Hex-encoded, 0x-prefixed 40-character string representing the ERC-721 token contract on Ethereum.

Sample Data

address	removed	in_lender	in_loanId	log_index	in_borrower	in_nftAsset	block_number	in_nftTokenId	block_timestamp	in_borrowAmount	transaction_hash	in_loanMaturityDate	in_loanLiquidationDate
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x00c26fc0853e9023b195c509cdd2a7cd0e054101	30616	151	0x2e95e1cd077f29733c65d885ce7afe278d0726a6	0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b	17434136	12637	2023-06-08T07:33:47.000Z	2200000000000000000	0x1f005e58ce344274906acee7843ed98f59e1b799caa702b3f31e386d27a4b1d2	1686207539	1686209627
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x00c26fc0853e9023b195c509cdd2a7cd0e054101	30613	190	0x2e95e1cd077f29733c65d885ce7afe278d0726a6	0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b	17434137	11773	2023-06-08T07:33:59.000Z	2300000000000000000	0x3da6e5b1ec4e29b76c0d946f7dfb9975bb76d570861780cbeea5601750c1739b	1686206807	1686209639
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x5f264625e6400102a2f5e9a5d6e006c7a6d41285	33463	178	0xb284f19ffa703daadf6745d3c655f309d17370a5	0x769272677fab02575e84945f03eca517acc544cc	17798035	4828	2023-07-29T10:15:47.000Z	4812468358781726000	0x915c8be59b0f3e7d6fa61ed10b7a8d5c037d6cab01717e278b30d73eeb82f71c	1690625423	1690625747

Example Query

Query with partition filter

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

LoanFacet_LoanRepaid_event

NFT-collateralized loan repayment events from X2Y2’s lending protocol on Ethereum, capturing borrower repayments with NFT collateral release, borrow/repay amounts, and platform fees. Used for analyzing NFT lending activity, interest rates, and collateral utilization 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_loanId`	`STRING`	Unique identifier for the loan within the X2Y2 lending protocol. Numeric string representation.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_lender`	`STRING`	Address of the lender providing funds in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_nftTokenId`	`STRING`	Token ID of the NFT used as collateral in this loan repayment event. Unique identifier within the NFT collection contract specified in in_nftAsset.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_adminFee`	`STRING`	Platform fee charged by X2Y2 on this loan repayment, denominated in the borrow asset’s smallest unit (wei for ETH). Typically ranges from 0.1% to 1% of the borrowed amount.
`in_nftAsset`	`STRING`	Contract address of the NFT collection used as collateral for the loan on Ethereum. Hex-encoded, 0x-prefixed 40-character string representing the ERC-721 or ERC-1155 token contract.
`in_borrowAsset`	`STRING`	Contract address of the ERC-20 token borrowed in this NFT-backed loan on Ethereum. Typically WETH (0xc02aaa…) based on sample data.

Sample Data

address	removed	in_lender	in_loanId	log_index	in_adminFee	in_borrower	in_nftAsset	block_number	in_nftTokenId	in_borrowAsset	in_repayAmount	block_timestamp	in_borrowAmount	transaction_hash
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x306a9ced7ec13c32fb26424f7fbc82d34928d4b9	34719	106	2912000000000000	0xcf5e233bcb1f1b3536e0879be2d3294049d7bfc7	0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258	18066215	74135	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	546208000000000000	2023-09-04T22:50:59.000Z	520000000000000000	0xc39d5f40d825108c5f507ff2a1301f5a7a445332eaeaea5eb359eff35dc166e6
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x306a9ced7ec13c32fb26424f7fbc82d34928d4b9	34717	140	2968000000000000	0x0d11b389003f22d56e5c39104dba80cc59ab17f5	0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258	18066238	83539	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	556712000000000000	2023-09-04T22:55:35.000Z	530000000000000000	0xd4183612afccd4026ac269ec56b97d0b4f80e84f943228f1b6200d32b8b334cb
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x306a9ced7ec13c32fb26424f7fbc82d34928d4b9	34716	148	3808000000000000	0x0d11b389003f22d56e5c39104dba80cc59ab17f5	0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258	18066238	60448	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	714272000000000000	2023-09-04T22:55:35.000Z	680000000000000000	0xd4183612afccd4026ac269ec56b97d0b4f80e84f943228f1b6200d32b8b334cb

Example Query

Query with partition filter

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

LoanFacet_LoanStarted_event

NFT-collateralized loan origination events from X2Y2 marketplace on Ethereum. Records loan terms including borrow amount, repayment amount, duration, lender/borrower addresses, and NFT collateral details for analyzing peer-to-peer NFT lending 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_loanId`	`STRING`	Unique identifier for the loan within the X2Y2 lending protocol. Numeric string representation.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_lender`	`STRING`	Address of the lender providing funds in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAsset`	`STRING`	Contract address of the asset being borrowed in this loan, typically a token contract. Based on samples, all loans use WETH (Wrapped Ether) at address 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2.
`in_nftAsset`	`STRING`	Contract address of the NFT collection being used as collateral for the loan. Hex-encoded, 0x-prefixed 40-character string representing an ERC-721 or ERC-1155 token contract on Ethereum.
`in_offerType`	`INT64`	Enumerated loan offer type indicator distinguishing between different lending structures on the X2Y2 platform. Values are typically 1 or 2, representing distinct offer configurations for NFT-backed loans.
`in_offerHash`	`STRING`	Unique hash identifier of the loan offer accepted to initiate this loan. Hex-encoded, 0x-prefixed 64-character string used to track the specific lending terms.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_loanDetail`	`STRUCT<state INT64, reserved STRING, loanDuration STRING, adminShare STRING, loanStart STRING, borrowAssetIndex INT64, nftAssetIndex STRING, borrowAmount STRING, repayAmount STRING, nftTokenId STRING>`	Structured record containing core loan parameters including borrow and repay amounts in wei, loan duration in seconds, start timestamp, NFT token ID, and current loan state. Captures financial terms and identifiers for tracking the lifecycle of each NFT-backed loan on X2Y2.
`in_extraData`	`STRUCT<target STRING, selector STRING, data STRING, referral STRING, onBehalf STRING, proof ARRAY<STRING>>`	Additional data passed with the bridge operation. Hex-encoded byte string, empty (0x) or containing protocol-specific parameters.

Sample Data

address	removed	in_amount	in_lender	in_loanId	log_index	in_borrower	in_nftAsset	block_number	in_extraData	in_offerHash	in_offerType	in_loanDetail	in_borrowAsset	block_timestamp	transaction_hash
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	1	0x707f657bfa62835ba6e8de11d2f373bfe543defc	34695	273	0x010acffec14a6413b3efaab0023996559edc4878	0x8a90cab2b38dba80c64b7734e58ee1db38b8992e	17962861	{“data”:“0x”,“proof”:[],“target”:“0x0000000000000000000000000000000000000000”,“onBehalf”:“0x010acffec14a6413b3efaab0023996559edc4878”,“referral”:“1”,“selector”:“0x00000000”}	0x97c725bcf34a9262773e6daa548d19777531dcb33ec4e77553259e32d5336896	1	{“state”:1,“reserved”:“0”,“loanStart”:“1692617915”,“adminShare”:“1000”,“nftTokenId”:“1042”,“repayAmount”:“1159315000000000000”,“borrowAmount”:“1150000000000000000”,“loanDuration”:“259200”,“nftAssetIndex”:“1”,“borrowAssetIndex”:0}	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-08-21T11:38:35.000Z	0xa531b63d210d42e29292e0fb23fc138775c579ab4686b8707429a768175d44e3
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	1	0xbb66b419be2a9faf76afb0725572d39cb95d6300	34692	267	0x6b7a91c6a6832bc3498883ff65268612f67c8119	0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b	17962349	{“data”:“0x”,“proof”:[],“target”:“0x0000000000000000000000000000000000000000”,“onBehalf”:“0x6b7a91c6a6832bc3498883ff65268612f67c8119”,“referral”:“1”,“selector”:“0x00000000”}	0xdf3af733917d63d6712883aba5c6b4e5bbcc419ff28405a6f05bf5edbaa63613	2	{“state”:1,“reserved”:“0”,“loanStart”:“1692611747”,“adminShare”:“1000”,“nftTokenId”:“3930”,“repayAmount”:“627814000000000000”,“borrowAmount”:“616000000000000000”,“loanDuration”:“1209600”,“nftAssetIndex”:“4”,“borrowAssetIndex”:0}	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-08-21T09:55:47.000Z	0xb8d6da78a0f4ef26fabc4bd9c86cc820e997844a3f0e8f86f88ce97166205d36
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	1	0xbb66b419be2a9faf76afb0725572d39cb95d6300	34694	252	0x6b7a91c6a6832bc3498883ff65268612f67c8119	0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b	17962363	{“data”:“0x”,“proof”:[],“target”:“0x0000000000000000000000000000000000000000”,“onBehalf”:“0x6b7a91c6a6832bc3498883ff65268612f67c8119”,“referral”:“1”,“selector”:“0x00000000”}	0x1b815d45c9d2e883f252d0478a638ba6592676cab10e649078d2f889266e5cd5	2	{“state”:1,“reserved”:“0”,“loanStart”:“1692611915”,“adminShare”:“1000”,“nftTokenId”:“2609”,“repayAmount”:“627814000000000000”,“borrowAmount”:“616000000000000000”,“loanDuration”:“1209600”,“nftAssetIndex”:“4”,“borrowAssetIndex”:0}	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-08-21T09:58:35.000Z	0x0204a0fb2f11f86a323d0ec8d8a23e841e7d817af5bbf34b5e5b38aa37605757

Example Query

Query with partition filter

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

LoanFacet_OfferCancelled_event

Loan offer cancellation events from X2Y2’s NFT lending marketplace on Ethereum. Tracks when lenders withdraw their loan offers, identified by lender address, counter (offer nonce), and offer hash for analyzing lending liquidity changes.

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_lender`	`STRING`	Address of the lender providing funds in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_offerHash`	`STRING`	Unique identifier hash for the loan offer being cancelled on the X2Y2 NFT lending platform. Appears as a zero hash in all sample cases, indicating batch or blanket cancellations rather than specific offer cancellations.
`in_counter`	`STRING`	Incremental counter representing the number of offers previously made by the lender address. This value typically starts at 0 for a lender’s first cancelled offer and increments with each subsequent cancellation.

Sample Data

address	removed	in_lender	log_index	in_counter	block_number	in_offerHash	block_timestamp	transaction_hash
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x3079e48b3df5b8b27c0f0e03abd484b764d7fb2f	277	0	17653471	0x0000000000000000000000000000000000000000000000000000000000000000	2023-07-09T03:26:11.000Z	0x001429468ba7646b30142961c636388435d2580ae8c1c74e8deba366646f396e
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0xc4534ea2875c83d4f0245f94c96eb33ef274d833	295	3	17660206	0x0000000000000000000000000000000000000000000000000000000000000000	2023-07-10T02:09:35.000Z	0xaa0109f62d3c3bc52004c767b2b28ac70127247ed5626e534ecbd0fc71cef5f3
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	0x8594aecdfa2c7ef396441e43e7bfb2461dea5523	342	0	17663824	0x0000000000000000000000000000000000000000000000000000000000000000	2023-07-10T14:22:11.000Z	0x160bc374a3219359548534b7361c866cc11aefdb7de4d41c36e60786b091bcdd

Example Query

Query with partition filter

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

LoanFacet_repay_function

Loan repayment function calls from the X2Y2 NFT marketplace lending protocol on Ethereum. Records borrowers repaying loans by loan ID parameter, useful for tracking loan closure activity and protocol liquidity flows.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__sender`	`STRING`	Address of the account initiating the contract function call or event emission. Hex-encoded, 0x-prefixed, 42-character string.
`in__param`	`STRING`	Loan identifier or parameter passed to the X2Y2 LoanFacet repay function, encoded as a 32-byte hex string. This value uniquely identifies the loan being repaid in each transaction.

Sample Data

gas	status	gas_used	in__param	signature	in__sender	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
364898	true	170640	0x00000000000000000000000000000000000000000000000000000000000075d2	0x320907b8	0xdbcc6698d4686ee3fba49c2245072460594efe6e	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17358654	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	0,4	2023-05-28T16:18:23.000Z	0xa13e27745f9d131801424b0edddce520f6c42a00f3ea7b0f10b2a645a6d7fb39
390601	true	196583	0x000000000000000000000000000000000000000000000000000000000000768f	0x320907b8	0x371267a1863080c5f39229183350e0d87d39743e	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17356988	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	0,4	2023-05-28T10:41:47.000Z	0x08d09f3d0eb2ddc808f07a2d86d83cbdd9327c0cdce4455c31a266df320415e6
339987	true	150973	0x0000000000000000000000000000000000000000000000000000000000007693	0x320907b8	0x6af1779887327ec9b65ad92d4de8c61385aaaede	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17360437	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	0,5	2023-05-28T22:17:35.000Z	0xab8faa18f05cc725caf40e97ede2050c1632a80bdb4862d3914cd9fa15baa0f8

Example Query

Query with partition filter

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

LoanFacet_repay2_function

Loan repayment transactions from X2Y2 NFT marketplace’s lending protocol on Ethereum. Tracks individual loan closures by loan ID with borrower addresses and execution status for analyzing NFT-backed lending 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__loanId`	`STRING`	Platform-assigned identifier for the specific NFT-backed loan being repaid in this X2Y2 lending transaction. Typically a sequential numeric identifier prefixed with “in__” to denote function input parameter.

Sample Data

gas	status	gas_used	signature	in__loanId	to_address	block_number	from_address	block_timestamp	transaction_hash
230470	true	224794	0xe7610eb1	30619	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17595321	0x927952bc8d9f1ca6c984a84e5f88d8a49adeb101	2023-06-30T23:22:11.000Z	0xdf254a395af91631e28b7af809d4bc25a751b4f371b0ad47c52879cf860fd091
247899	true	241950	0xe7610eb1	32273	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17593718	0xaa101d8eb95d75664947ac3e8e519dba25c0d88c	2023-06-30T17:57:11.000Z	0x19deb2674d8a63ff04c0d6b78fc9a505ef7c7758e59ca65417029f7c871eaf62
219572	true	214066	0xe7610eb1	30808	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	17590912	0xe7e1cd30dd4ec40093ff1a7f514dfa6b1932781e	2023-06-30T08:29:23.000Z	0x7982a2326cd4fb5675c8b1c0f2297d5d8f66aaaace4c277d515a81b66e875584

Example Query

Query with partition filter

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

LoanFacet_ServiceFee_event

Service fee events from X2Y2’s NFT lending protocol (LoanFacet) on Ethereum, recording platform fees charged on loan transactions with borrower addresses, fee amounts, and rate basis points for analyzing lending economics and protocol 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_loanId`	`STRING`	Unique identifier for the loan within the X2Y2 lending protocol. Numeric string representation.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_serviceFeeRate`	`STRING`	Service fee rate applied to the loan, expressed in basis points where 20 equals 0.2%. Appears consistently as ‘20’ across all sample transactions in the X2Y2 lending protocol.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	removed	in_loanId	in_target	log_index	in_borrower	block_number	in_feeAmount	block_timestamp	transaction_hash	in_serviceFeeRate
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	30015	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	322	0x6666201d3520f8e6572368e7701826256231145f	17286134	153020000000000	2023-05-18T11:28:23.000Z	0x687cfb976dea571075669e81b2a953c9f282e0c88029ac8cbd4997c7db2f5dae	20
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	30035	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	327	0x9940f2bb0729df48b270fd6f6021b4e0ce949747	17288793	1522000000000000	2023-05-18T20:25:11.000Z	0x3c67b25a425540bec88c4ce5eda12b78ae53ccce26910d50b5cd7886ed053cb2	20
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	30020	0xb81965ddfdda3923f292a47a1be83ba3a36b5133	407	0x010acffec14a6413b3efaab0023996559edc4878	17286485	3540000000000000	2023-05-18T12:38:47.000Z	0xb795e232dbf41f161ecc60869f5ac306c22511578d4c4c86f0c672eada0f1d3b	20

Example Query

Query with partition filter

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

LoanFacet_UpdateStatus_event

NFT loan status change events from X2Y2 marketplace lending protocol on Ethereum. Tracks loan lifecycle transitions with unique loan identifiers and new status codes for analyzing lending activity and loan state progressions.

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_loanId`	`STRING`	Unique identifier for the loan within the X2Y2 lending protocol. Numeric string representation.
`in_newStatus`	`INT64`	Boolean flag indicating the new enabled or disabled state being set for a pool feature or operation.

Sample Data

address	removed	in_loanId	log_index	block_number	in_newStatus	block_timestamp	transaction_hash
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	35940	257	18244812	2	2023-09-30T00:01:35.000Z	0x2a8d14f957edc1ea97d723a68823548214840aab72a6a79bd2aaac18f6ab1ee6
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	35949	5	18248988	2	2023-09-30T14:02:47.000Z	0x3fa3f550abb15f6ae241e9e85b06c3d015581b3d46f674acf6c155653c1e0b79
0xb81965ddfdda3923f292a47a1be83ba3a36b5133	false	35876	288	18246858	2	2023-09-30T06:53:11.000Z	0x81e4abefb9f02b9ee4e421089a66fae2cded1c1ac2487c24c263453103a1dbff

Example Query

Query with partition filter

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

RewardDistributorV3_Reward_event

Reward distribution events from X2Y2 NFT marketplace on Ethereum, tracking token payouts to user addresses with amounts in wei. Used for analyzing marketplace incentive programs and trader reward claims.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. 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	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x897249fef87fa6d1e7fedcb960c2a01ec99ecc6c	0xfc82416000ba248684a4f7b9fbb56a17dbb72c3e	false	142407140000000000000000	303	17373847	2023-05-30T19:34:23.000Z	0x05a2803b28f051d4711cc045aca43536f4aee3518642b7d99af36cefe5b210cc
0x897249fef87fa6d1e7fedcb960c2a01ec99ecc6c	0x04169b3e0ad298d2bc30edea5ff0e052699abf1a	false	208290000000000000000	323	17374543	2023-05-30T21:54:23.000Z	0xf6b2d6fc99c3947b5e9398ecbde3dac40e96692dc69b736b46ce92dfee25aadd
0x897249fef87fa6d1e7fedcb960c2a01ec99ecc6c	0xb5425ebed48d8c859a19a34463b6df9437974d1b	false	61260000000000000000	435	17369055	2023-05-30T03:23:23.000Z	0xe373feb40a56a88f5b2b671cc74b15002c56b735e507476ee439f251e5d3b3a6

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Exchange_EvInventory_event

Exchange_EvProfit_event

Exchange_run_function

Exchange_run1_function

ListingRewardDistributorV2_Reward_event

LoanFacet_borrow_function

LoanFacet_BorrowRefferal_event

LoanFacet_increaseCounter_function

LoanFacet_liquidate_function

LoanFacet_LoanLiquidated_event

LoanFacet_LoanRepaid_event

LoanFacet_LoanStarted_event

LoanFacet_OfferCancelled_event

LoanFacet_repay_function

LoanFacet_repay2_function

LoanFacet_ServiceFee_event

LoanFacet_UpdateStatus_event

RewardDistributorV3_Reward_event

​Tables

​Exchange_EvInventory_event

​Exchange_EvProfit_event

​Exchange_run_function

​Exchange_run1_function

​ListingRewardDistributorV2_Reward_event

​LoanFacet_borrow_function

​LoanFacet_BorrowRefferal_event

​LoanFacet_increaseCounter_function

​LoanFacet_liquidate_function

​LoanFacet_LoanLiquidated_event

​LoanFacet_LoanRepaid_event

​LoanFacet_LoanStarted_event

​LoanFacet_OfferCancelled_event

​LoanFacet_repay_function

​LoanFacet_repay2_function

​LoanFacet_ServiceFee_event

​LoanFacet_UpdateStatus_event

​RewardDistributorV3_Reward_event

Tables

Exchange_EvInventory_event

Exchange_EvProfit_event

Exchange_run_function

Exchange_run1_function

ListingRewardDistributorV2_Reward_event

LoanFacet_borrow_function

LoanFacet_BorrowRefferal_event

LoanFacet_increaseCounter_function

LoanFacet_liquidate_function

LoanFacet_LoanLiquidated_event

LoanFacet_LoanRepaid_event

LoanFacet_LoanStarted_event

LoanFacet_OfferCancelled_event

LoanFacet_repay_function

LoanFacet_repay2_function

LoanFacet_ServiceFee_event

LoanFacet_UpdateStatus_event

RewardDistributorV3_Reward_event