friendtech_v2_base

Tables

BestFriend_Deposit_event

Deposit events from the Friend.tech v2 BestFriend contract on Base, recording user deposits with amounts in wei and depositor addresses. Used for tracking liquidity inflows and user participation in the social trading protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x1d2dff13e7f4109fdcaf4ddb59fbd853abfc4208	0x3bba80c95624d6481ac640b89a1cdcc4e0616d6b	false	2577878567594893962	258	14783967	2024-05-22T05:54:41.000Z	0x946597bd43ea0c24f97f3ec8ed1e0a772be0381a7eaa53507c4b48d5a945383b
0x1d2dff13e7f4109fdcaf4ddb59fbd853abfc4208	0x40a648383b751e81ce0d5b593b80c0d141eebd94	false	4558621219645144419	259	14775236	2024-05-22T01:03:39.000Z	0x6801b9d43eb2ff93e9cebfc455afaeb57155d2ba60cad5d2cbae43c768e1f57d
0x1d2dff13e7f4109fdcaf4ddb59fbd853abfc4208	0xfe44a3f977d8ecd4e1c6c5fa3615bfc0fa12826a	false	2412536633938119709	8	14785242	2024-05-22T06:37:11.000Z	0xb77dea1be25f1efde63660afc1fc25f3e26e230d79d0b579c074852aafdb7f1a

Example Query

Query with partition filter

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

BestFriend_Withdraw_event

Withdrawal events from the Friend.tech v2 BestFriend contract on Base, recording when users withdraw funds with user addresses and withdrawal amounts. Used for tracking fund movements and user liquidity management in the Friend.tech social token protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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	log_index	block_number	block_timestamp	transaction_hash
0x1d2dff13e7f4109fdcaf4ddb59fbd853abfc4208	0xfe44a3f977d8ecd4e1c6c5fa3615bfc0fa12826a	false	3	15419654	2024-06-05T23:04:15.000Z	0x4453908746084ff75bfc7175bcb09c2f7e944f8c916257dfb734b3ad78be6359
0x1d2dff13e7f4109fdcaf4ddb59fbd853abfc4208	0xe921a688a5a68066976cf371d6cb96f98c0014c4	false	259	15380860	2024-06-05T01:31:07.000Z	0x9551f79ed911dacf2f8b378eb7466cdfd2d992bb9dfa2118a8b7a323f0ae4ee2
0x1d2dff13e7f4109fdcaf4ddb59fbd853abfc4208	0x1d58de2bc26308c4c7ac71b82f356c463be66cf7	false	265	15396168	2024-06-05T10:01:23.000Z	0x557393bf45b573a5532fd895514d94d661546a5babc649b02907c11ab59b9393

Example Query

Query with partition filter

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

Clubs_bestFriend_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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`	`FLOAT64`	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.
`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

No sample data available.

Example Query

Query with partition filter

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

Clubs_Buy_event

Buy transactions for Friend.tech V2 club memberships on Base, tracking points spent, keys (shares) received, and protocol fees. Used for analyzing club membership acquisition patterns 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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_pointsIn`	`STRING`	Points allocated to the buyer in this Friend.tech club purchase transaction. String-formatted integer value, commonly ‘0’ in most transactions based on sample data.
`in_keysOut`	`STRING`	Number of club keys (shares) received by the buyer in this purchase transaction. String-encoded integer value, typically greater than zero for successful buys.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.

Sample Data

in_id	address	removed	log_index	block_number	block_timestamp	transaction_hash
227738	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	79	14704176	2024-05-20T09:34:59.000Z	0x005a8f041e53b5c5127bdd5045c7352583cd31ed5f22107ef94a352a1dcbcb98
226921	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	149	14691051	2024-05-20T02:17:29.000Z	0x05c5023465f8fabefd1789f670eb2efef03ac17807d4951a198fb692c4250651
227607	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	159	14704022	2024-05-20T09:29:51.000Z	0x0a75488fc51c20fef834ad6bd93ae8c0c56a11135b5d822c8b126a07dbe9df07

Example Query

Query with partition filter

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

Clubs_buyToken_function

Token purchase transactions from Friend.tech V2 club membership system on Base. Records social token buys with key amounts, referrals, and token costs for tracking club membership 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.
`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`	`FLOAT64`	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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_maxTokensIn`	`STRING`	Maximum amount of tokens the buyer is willing to spend for the purchase, specified in wei (smallest token unit). Acts as a slippage protection parameter; transaction reverts if actual cost exceeds this value.
`in_keysOut`	`STRING`	Number of club membership keys being purchased in this transaction. Null when the transaction fails.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
`out_amountIn`	`STRING`	Token amount paid by the buyer to purchase the specified keys, denominated in the smallest unit (wei-equivalent) of the payment token. This output reflects the actual cost after bonding curve calculation, which may differ from the maximum specified in `in_maxTokensIn`.

Sample Data

gas	status	gas_used	signature	in_keysOut	in_tokenId	to_address	in_referral	block_number	from_address	out_amountIn	in_maxTokensIn	block_timestamp	transaction_hash
125023	true	112627	0xb291b729	1	219486	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x915c3b59d925dea06b2a55d5660a61ad96cc43a8	30057502	0x26ef54761d104ad4b260232939a2e0d4cf05c0ae	164000000000000000160	164001600000000000000	2025-05-10T19:12:31.000Z	0xe6128e96c887f9f05553f40e86d2103f553f04b7920177e65066030d3c5f9867
143908	true	129727	0xb291b729	1	27784	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x307fd068b042515f784d3e93aacd43c053b56c03	30057600	0x26ef54761d104ad4b260232939a2e0d4cf05c0ae	178596000000000000174	178597742400000000000	2025-05-10T19:15:47.000Z	0x2b350c952c092649136a913717e1aa144b505e79457cfb82dd99109542fc0d3e
143908	true	129727	0xb291b729	1	36829	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x9ad51c56b3ae98b88d1ef81b54142fb7f594a5f4	30057473	0x26ef54761d104ad4b260232939a2e0d4cf05c0ae	106641000000000000104	106642040400000000000	2025-05-10T19:11:33.000Z	0xb864632c84229e6918444f28cc44028b7f98c8982064c92359bbc710d29044eb

Example Query

Query with partition filter

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

Clubs_changeBestFriend_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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`	`FLOAT64`	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_newBestFriend`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Clubs_changeBestFriendFee_function

Function calls to update the “best friend” fee parameter in Friend.tech V2 clubs on Base. Tracks fee adjustments made by club owners for analyzing monetization strategies and club 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.
`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`	`FLOAT64`	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_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

gas	value	status	gas_used	in_newFee	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
63267	0	true	45805	15000000000000000	0x6a07043e	0x201e95f275f39a5890c976dc8a3e1b4af114e635	13939659	0xc1e747389c47ee3f0046969291e42023d9567934		2024-05-02T16:51:05.000Z	0xc1b483772543891cd0d88cb21c710a676fc2ed202d22b5cac6623b7e7f6a0144

Example Query

Query with partition filter

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

Clubs_changeProtocolFee_function

Protocol fee adjustment events from Friend.tech v2 Clubs contract on Base, tracking administrative changes to platform fee rates (shown in wei, typically 1-1.5% range). Used for monitoring fee policy updates and protocol 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.
`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`	`FLOAT64`	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_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

gas	value	status	gas_used	in_newFee	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
63265	0	true	45804	15000000000000000	0xfe687475	0x201e95f275f39a5890c976dc8a3e1b4af114e635	13939659	0xc1e747389c47ee3f0046969291e42023d9567934		2024-05-02T16:51:05.000Z	0xc4327e987f9d83cc21a6892d301b3c8f8971fcf97d13a85ace5cba8313b6214c
9407	0	true	7440	10000000000000001	0xfe687475	0x201e95f275f39a5890c976dc8a3e1b4af114e635	16625410	0x831be9e08185eba7d88aab1efc059336babef430	0,2,2	2024-07-03T20:56:07.000Z	0x64083948947a3c1567bd6dd204e4697af4eeb63b8f4d56a0391e2846f3fa1c4b

Example Query

Query with partition filter

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

Clubs_changeProtocolFeeTo_function

Protocol fee recipient change events from Friend.tech v2 Clubs contract on Base. Tracks administrative updates to the protocol fee destination address for revenue distribution 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.
`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`	`FLOAT64`	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_newReceiver`	`STRING`	New protocol fee receiver address being set by this function call. Hex-encoded, 0x-prefixed 40-character Ethereum address on Base chain.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	in_newReceiver	block_timestamp	transaction_hash
63641	0	true	46076	0x4beccd4c	0x201e95f275f39a5890c976dc8a3e1b4af114e635	13939659	0xc1e747389c47ee3f0046969291e42023d9567934		0x831be9e08185eba7d88aab1efc059336babef430	2024-05-02T16:51:05.000Z	0xa21bc26507352abb3612128c03f81698c0b4ecf2bd687fed3a2b58df8f82a656

Example Query

Query with partition filter

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

Clubs_changeReferralFee_function

Friend.tech referral fee update events from the Clubs contract on Base. Captures when club owners modify their referral fee percentage through the changeReferralFee function.

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`	`FLOAT64`	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_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

gas	value	status	gas_used	in_newFee	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
28042	0	true	26686	10000000000000000	0x78a6743b	0x201e95f275f39a5890c976dc8a3e1b4af114e635	14520615	0x831be9e08185eba7d88aab1efc059336babef430	0,1	2024-05-16T03:36:17.000Z	0x837e8a9564da227beee0956a84d228d370d017da46e2859833da0c9fb2e7766d
40917	0	true	27978	0	0x78a6743b	0x201e95f275f39a5890c976dc8a3e1b4af114e635	13939659	0xc1e747389c47ee3f0046969291e42023d9567934		2024-05-02T16:51:05.000Z	0xd6c057e4a0ce7f249d3f1b351f82a4633166167f1d074c05659a187f8ac90fc8

Example Query

Query with partition filter

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

Clubs_claimReferralFees_function

Referral fee claim transactions from Friend.tech V2 social trading protocol on Base. Tracks when users withdraw accumulated referral rewards by analyzing claim function calls with transaction status and gas consumption.

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`	`FLOAT64`	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
44485	true	39101	0x83a84ba9	0x201e95f275f39a5890c976dc8a3e1b4af114e635	15644092	0x0333a4beaa1b72eac6a1c48a285b94164f68e8aa	2024-06-11T03:45:31.000Z	0x852cdad9dff1012b386e1cd07f5d1e57d6a02b7fc7ed30e3776dbad716446262
44485	true	39101	0x83a84ba9	0x201e95f275f39a5890c976dc8a3e1b4af114e635	15673034	0x0357fbb1524da420fdab58b615feeb061d75bc36	2024-06-11T19:50:15.000Z	0x28a2ace08e8c9cce1c5cf814ba8042d952df35ec1a9317df4d41f84c9ccd1d27
44485	true	39101	0x83a84ba9	0x201e95f275f39a5890c976dc8a3e1b4af114e635	15673401	0x03fbcba037056dc98d157ad31a5d05dc3f25f1b0	2024-06-11T20:02:29.000Z	0xe2ab16a800e272c1b67983a8aa2c27e6872c670f8d4f8dea196497a0d0bf6ff6

Example Query

Query with partition filter

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

Clubs_CoinLaunched_event

Club token launch events from Friend.tech v2 on Base, recording when creators initialize new social tokens with unique club identifiers. Used to track new club creation activity and identify early token launches by creator address.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_id	address	removed	log_index	in_creator	block_number	block_timestamp	transaction_hash
234589	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	1	0xde023edbeb3580b52ba428959a5e39e202cde19b	15401038	2024-06-05T12:43:43.000Z	0xa4f263bb9040d8370d1f80ac3dc1649062a93cf589a7a61ceea48bbe1f790e70
234604	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	260	0x9a5f73196c91fae40286cbc40d3d786fd6ec6fae	15407932	2024-06-05T16:33:31.000Z	0x09b3cacbaf9b7cfd3d1b18fa9512d671941f5421b8dc867f90a0b4f5f9283b92
234620	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	517	0xb9cfa6ca85b17761b24cbe51065c13f8dcdf4f22	15409309	2024-06-05T17:19:25.000Z	0x8b33fbd0ce0b90b21c8dcf55b2aecf282b05ae06a4faebea18f25e7614c61fcf

Example Query

Query with partition filter

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

Clubs_createToken_function

Club token creation events from Friend.tech v2 on Base, including club names, types, metadata URIs, and initial key purchases. Used for tracking new club launches and analyzing creator adoption 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`	`FLOAT64`	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__name`	`STRING`	Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes.
`in_uri`	`STRING`	URL pointing to metadata or asset information stored on external storage systems (IPFS, AWS S3, Arweave) or web servers.
`in__type`	`INT64`	Numeric identifier representing the club type within Friend.tech’s categorization system (e.g., 2, 3, 4). Null for failed transactions.
`in_keysOut`	`STRING`	Initial number of keys (shares) purchased by the creator when minting a new Friend.tech club token. Typically ‘0’ for most tokens, but can be higher when creators pre-purchase keys at launch.
`out_id`	`STRING`	Unique identifier assigned to the newly created club token on Friend.tech. Returns null for failed transactions where token creation did not complete successfully.

Sample Data

gas	in_uri	out_id	status	gas_used	in__name	in__type	signature	in_keysOut	to_address	block_number	from_address	block_timestamp	transaction_hash
296823	https://ft-clubs-public-prod.s3.amazonaws.com/club-pfps/0x5e8802f99214d3fc1d82b05a826622f07a13b414-79850539-mxp3ivh4gp	237228	true	293328	pokemon	3	0x210f5dda	0	0x201e95f275f39a5890c976dc8a3e1b4af114e635	32298284	0x5e8802f99214d3fc1d82b05a826622f07a13b414	2025-07-01T16:05:15.000Z	0x58910a099ea7965b8a5a0186857b5da4b52979fd3e9f0e81902339d63701a8b4
296932	https://ft-clubs-public-prod.s3.amazonaws.com/club-pfps/0xf1d8356475095c0c709af9f76e9a1ac5e9ff5d5d-15623433-ix4xuegabsf	237227	true	293436	Unstoppable VPN	4	0x210f5dda	0	0x201e95f275f39a5890c976dc8a3e1b4af114e635	32284019	0xf1d8356475095c0c709af9f76e9a1ac5e9ff5d5d	2025-07-01T08:09:45.000Z	0x17bc53d4caf89efca2d1b8e3b6ddd11e43ff174d08a9e0715381324b33700a65
311140	https://ft-clubs-public-prod.s3.amazonaws.com/club-pfps/0x1226cd0bd1598542a366f24fe15e67633677ab2d-45434720-2tln0earq15	237229	true	307532	Higher t.co/kGYJquGrAT	4	0x210f5dda	124	0x201e95f275f39a5890c976dc8a3e1b4af114e635	32298743	0x1226cd0bd1598542a366f24fe15e67633677ab2d	2025-07-01T16:20:33.000Z	0xdbe3835c46625a5de9a9ffc1ff549d771e545dc097e9ebd08a188a3d90c830a5

Example Query

Query with partition filter

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

Clubs_Sell_event

Sell transactions for Friend.tech V2 clubs on Base, capturing when users sell keys (shares) including quantity, points earned, and protocol fees. Used for analyzing selling pressure, liquidity patterns, and revenue distribution across Friend.tech social trading clubs.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_pointsOut`	`STRING`	Number of friend.tech club points received by the seller from this sale transaction. Typically zero as most sells do not reward points to sellers.
`in_keysIn`	`STRING`	Number of club keys (shares) being sold in this transaction. Typically represents single-key sales as shown by the constant value of ‘1’ in sample data.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.

Sample Data

in_id	address	removed	in_keysIn	log_index	block_number	block_timestamp	transaction_hash
232925	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	1	37	15185944	2024-05-31T13:13:55.000Z	0x2d97984a3c77c24dae67e2aeacbf9d86c9c43f22be6e2e257bcc17ec11860073
229877	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	1	209	15166069	2024-05-31T02:11:25.000Z	0x4abcaaa14dfb3211112d430fdb3b79177c30e830433e3a502d7cd9c225a34784
230991	0x201e95f275f39a5890c976dc8a3e1b4af114e635	false	1	149	15195975	2024-05-31T18:48:17.000Z	0xfe46836eeb62857c0098b2e7dc14cf3e96bc839e0f0f718a4d4ef89bb8b2b15c

Example Query

Query with partition filter

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

Clubs_sellToken_function

Token sale transactions from FriendTech V2 Clubs protocol on Base, capturing users selling club tokens (keys) with referral tracking and minimum output amounts. Used for analyzing trading volume, price impact, and referral program effectiveness.

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`	`FLOAT64`	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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_minTokensOut`	`STRING`	Minimum acceptable number of tokens the seller expects to receive from selling their club keys, expressed in wei (smallest unit). Acts as slippage protection; transaction reverts if actual output falls below this threshold.
`in_keysIn`	`STRING`	Number of club tokens (keys) being sold in this transaction. Typically represents single key sales as evidenced by the value ‘1’ across sample transactions.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
`out_amountOut`	`STRING`	Token amount received from selling club keys, denominated in wei (1e18 = 1 token). This represents the actual output after fees and slippage, typically close to but slightly less than the minimum specified in `in_minTokensOut`.

Sample Data

gas	status	gas_used	in_keysIn	signature	in_tokenId	to_address	in_referral	block_number	from_address	out_amountOut	block_timestamp	in_minTokensOut	transaction_hash
111330	true	110309	1	0x0d3faeca	236794	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x9d24c0c8f91847d0e881400c2e5ef00ee77607e0	22149941	0x05b691cb673f95bc7c50f94f123ee70ba8bf5fc4	27387749999999999972	2024-11-08T18:07:09.000Z	27387469100000000000	0x53d478eb5d33258d0b08328130231d4b4bc68398bb3d832eb135e0c26cd860ef
111330	true	110309	1	0x0d3faeca	236794	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x9d24c0c8f91847d0e881400c2e5ef00ee77607e0	22149929	0x05b691cb673f95bc7c50f94f123ee70ba8bf5fc4	27491197499999999972	2024-11-08T18:06:45.000Z	27490915539000000000	0x3c399a265ce1193f2146ccfd5c53fa2ce6bec653f636de1ab18a1d09750fc8ea
111063	true	105509	1	0x0d3faeca	78961	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x8cdb023220418cf7b951e8011fd9826d8a97ba9a	22143763	0x109a67b007a2e3d7a9beef1f4c8eb7d76f9b429e	124497749999999999873	2024-11-08T14:41:13.000Z	124496473100000000000	0x0cb8f136e8640656796e1ab9dbff5f2d75951b28a47fe156e6c9df309df3f52b

Example Query

Query with partition filter

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

Clubs_Transfer_event

Transfer events for Friend.tech v2 club share tokens on Base, tracking ownership changes including mints, burns, and transfers between addresses. Useful for analyzing club membership distribution and secondary 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer 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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	in_to	address	in_from	removed	in_amount	in_caller	log_index	block_number	block_timestamp	transaction_hash
173699	0x0000000000000000000000000000000000000000	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x00033b75bcd16a4df26f74283d6e6f22c0c182e5	false	1	0x00033b75bcd16a4df26f74283d6e6f22c0c182e5	62	15137695	2024-05-30T10:25:37.000Z	0xc2cbf7471ceb05d054f9649df710fe9b3d16c4ff1ccbf9899b3e963592e0c45c
232986	0x0000000000000000000000000000000000000000	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x00443c86d0ed64d0e70e36b097a9d4d6a2ce922a	false	1	0x00443c86d0ed64d0e70e36b097a9d4d6a2ce922a	112	15157553	2024-05-30T21:27:33.000Z	0x324ae25341417853c2cc4d8ed240cb7e31cd6c4f0152149db47c92c01995447c
38832	0x0000000000000000000000000000000000000000	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x00443c86d0ed64d0e70e36b097a9d4d6a2ce922a	false	1	0x00443c86d0ed64d0e70e36b097a9d4d6a2ce922a	200	15131845	2024-05-30T07:10:37.000Z	0xcc647ef1f0599347b33c4064fcf9548dddad6a2835b8a53d10cab16937eb3442

Example Query

Query with partition filter

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

Clubs_transfer_function

Friend.tech V2 club share transfer function calls on Base, recording club ID, share amounts, sender and receiver addresses for tracking ownership changes. Used for analyzing club share distribution and transfer patterns across the social trading platform.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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`	`FLOAT64`	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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	in_id	status	gas_used	in_amount	signature	to_address	in_receiver	block_number	from_address	block_timestamp	transaction_hash
55642	236189	true	54841	4	0x095bcdb6	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x963844596aa1bfb1b1ff9c6a17be6dfcaab86453	23801900	0x306dd2b26f1383c62925f58151263d9e5656e86e	2024-12-16T23:52:27.000Z	0x6f1250d0796e6448f8ff87b34a3642c1d3b8495b54ee718f04b1689a719206da
200000	230037	true	37741	1	0x095bcdb6	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0xa6bbecdfec5b90cfd8fe6ec3e0b93d148041f6dc	23791710	0x4a518a8d33f16bc076fd3081deab8c298f4a7472	2024-12-16T18:12:47.000Z	0xf282b23943191c2c982dbce9a70c5dfe7f40cc34143fd9e73e30b509fc581a5f
200000	230037	true	37741	1	0x095bcdb6	0x201e95f275f39a5890c976dc8a3e1b4af114e635	0x5ffc88d66b65e56ff0049729eee639a9ff786dd0	23791822	0x4a518a8d33f16bc076fd3081deab8c298f4a7472	2024-12-16T18:16:31.000Z	0xd6ad1823d58a1fd0b3c8d0c2baba423f3797a09b8ba9249f77cdd229b07b7a59

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BestFriend_Deposit_event

BestFriend_Withdraw_event

Clubs_bestFriend_function

Clubs_Buy_event

Clubs_buyToken_function

Clubs_changeBestFriend_function

Clubs_changeBestFriendFee_function

Clubs_changeProtocolFee_function

Clubs_changeProtocolFeeTo_function

Clubs_changeReferralFee_function

Clubs_claimReferralFees_function

Clubs_CoinLaunched_event

Clubs_createToken_function

Clubs_Sell_event

Clubs_sellToken_function

Clubs_Transfer_event

Clubs_transfer_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​BestFriend_Deposit_event

​BestFriend_Withdraw_event

​Clubs_bestFriend_function

​Clubs_Buy_event

​Clubs_buyToken_function

​Clubs_changeBestFriend_function

​Clubs_changeBestFriendFee_function

​Clubs_changeProtocolFee_function

​Clubs_changeProtocolFeeTo_function

​Clubs_changeReferralFee_function

​Clubs_claimReferralFees_function

​Clubs_CoinLaunched_event

​Clubs_createToken_function

​Clubs_Sell_event

​Clubs_sellToken_function

​Clubs_Transfer_event

​Clubs_transfer_function

Tables

BestFriend_Deposit_event

BestFriend_Withdraw_event

Clubs_bestFriend_function

Clubs_Buy_event

Clubs_buyToken_function

Clubs_changeBestFriend_function

Clubs_changeBestFriendFee_function

Clubs_changeProtocolFee_function

Clubs_changeProtocolFeeTo_function

Clubs_changeReferralFee_function

Clubs_claimReferralFees_function

Clubs_CoinLaunched_event

Clubs_createToken_function

Clubs_Sell_event

Clubs_sellToken_function

Clubs_Transfer_event

Clubs_transfer_function