Tables
FRIEND_claimA_function
Token claim transactions from Friend.techβs airdrop contract on Base. Contains Merkle proof verification data, claim amounts in wei, and recipient addresses for analyzing airdrop distribution patterns.Columns
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_proof | ARRAY<STRING> | Merkle proof array for verifying claim eligibility or settlement authenticity. Array of hex-encoded hash strings used in cryptographic verification. |
in_recipient | STRING | Address designated to receive the output tokens from a swap or 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. |
in_giftRecipients | ARRAY<STRING> | Array of recipient addresses for gift allocations associated with this claim transaction. Typically empty when no gifts are being distributed alongside the primary claim. |
in_giftAmount | STRING | Token amount allocated for gifting to other recipients in the claim transaction, denominated in wei (18 decimals). Typically zero when users claim only for themselves without distributing gifts. |
Sample Data
Sample Data
| gas | value | status | gas_used | in_proof | in_amount | signature | to_address | block_number | from_address | in_recipient | in_giftAmount | trace_address | block_timestamp | transaction_hash | in_giftRecipients |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88216 | 0 | true | 87287 | [β0xf4c636424e7695b9840cdd105450c67f5b9fd74549912990bf9ba3f046d8e866β,β0x70ee176e847bb7edff3a75101a97c8905e23492f336484e17eea17677510f0b3β,β0x428dac8e7967384400553838b7495d405c70dece6c47b3f392bc473042ac55d9β,β0x56c8884d6b28de1badc7573d4dde63f3a04ee24a296bf77727c12e908a784732β,β0x79632b00262c3734482f5b7205bcd4b3a92ba40b268be2592c45976bad19baf4β,β0x33728be35527f0a089afd25e1861f74ce90288eb857fa28cd6eab8e10c2fe41eβ,β0x6d4a8edb254218929e1ff6bc334ef109fff1c1032d5021dc5fba4bc08f6a10b4β,β0xa66bca7173d751f66818a26e0d8132357d6d3b83bc90629966f92c5a2d60e584β,β0x86b5b5067ffaedd859ce32c8ad8b2b990bb21c04344531ab82ff958839d8fcadβ,β0x8bc6f810984e7de71358ecbefb8c980756e40271730794413769ad42c9563b67β,β0x1abae03b1b2032f2a4bd30f5ff28141d1a13cbab1ece18a29208072b7331f5f2β,β0xd41f79009c685dd1a6aa28e8a8c970056465e200244b7d09f329af93566a6375β,β0x913d03d3f8a845d9127b8563c6aa01d7ef914617f559d5ac88742e1bb8015c3bβ,β0xfca37afe5c6ff10f000f6b167af73ce566caaf4f3d2ea82509e32c08d7eb70a0β,β0x1c544bc2cb77e3d06fef4db9ae427ac4cccb726e939d90949eb14bec8dc2ad73β,β0x77ac3958e5c60cc331d017efe71fd9c01b95ec4e97e87c995a58419b88906015β,β0xdc7206ce6b274134ca83c8c7b3339dc617a0f85cd4f2e379ce824e3e4da044aaβ,β0x8d2e2f12a45c4dc6a1096f3d17ef41591d96e5d7159bba22fac950d55007c67bβ,β0x8adc8e22e6c33e1e72e4d70e2928a1d24525a67dc379c8f47f49b13e4a35464fβ] | 500000000000000000 | 0x9d194d18 | 0x0bd4887f7d41b35cd75dff9ffee2856106f86670 | 27862631 | 0xcbfa06c5ba79529d6909cfe2458a131cb0b306e7 | 0xcbfa06c5ba79529d6909cfe2458a131cb0b306e7 | 0 | 2025-03-20T23:50:09.000Z | 0x776af8114213b104fd679b11bed30a89b855c192c1e653ace3f01353e0545213 | [] | |
| 87568 | 0 | true | 86641 | [β0xdcc86bd7e298adbfe677836494745b5fe87f6480c8023056ea5ed309f11d69c5β,β0x1308c6674766bf239fa98d43565581037b8ebcff601d596888c03e3e7fca5acfβ,β0x1ccd47938871295a6d8784a020babee04e885588f1aa3e140f3aad022fc62270β,β0xf96c8e55e1cf140e2da2b78e46120ca8a7adddefdabff15a2f28c24081c9eb31β,β0xb386b841e85bf88236c750864c5212811c19ea41a877cee82b5e4daafec69c59β,β0x34e69a979a6101c3aba9297955ade6ee1884f9f43df49dc06ba0383ec97fb7ceβ,β0x649f1f68ef4f415c14d0020033a3a649641277f6cd175fe656804f71912a98eaβ,β0x821cda1b6c39cad8a2eea71eef2bf98b5a7e8941aead78ba381180533d002405β,β0x7ef539fc4b8f05d1e9a6bce55dca485c3d4e7fac09e364bc30acb3ae35349e54β,β0xa9fad900effe3e7848ba40f7dccf034bc15d2495ed040847b37d9e2e017d7305β,β0x429fdf086cf7f1b0505158a09a2be521c53b2e65431c0a1fa6c5476e6631022eβ,β0x26603ddbb9617a42af1162a9046dac0ff856ea86d3b9dbbb3d10d5e82403187fβ,β0x47d9273ecde6af01b5eca2aec9ff09bdeea7029e52bab81f46110de27b63d26dβ,β0x0a282dac38c5c78361c6ae413809a6345c5ac52a6e5eb6ee8c147e85ba80e938β,β0xec9d532f4b687b6e2f43da880926855572a262e3c9bbb96ae5347400bf8c0672β,β0x89c6054afc24ca0e0704d94c8a2ec433fe49e56b2c82320f31e6d2c43ebe62c5β,β0xc75e154afadab3351671324a4300f9c6374f58a27e572d96e0e7e8ee7f73e405β,β0x3787ed30ef33ba6abc49809f97ffe4ce56eadee57bf02129f9e0fb3a30a8b287β] | 400000000000000000 | 0x9d194d18 | 0x0bd4887f7d41b35cd75dff9ffee2856106f86670 | 27862885 | 0x6a6e715190ce80cafd8152d348a0761bc7209c2c | 0x6a6e715190ce80cafd8152d348a0761bc7209c2c | 0 | 2025-03-20T23:58:37.000Z | 0x77c36bf771f587a2740549378e74e09b1611cd7f934cd83ebb0c97343afadd85 | [] | |
| 87592 | 0 | true | 86665 | [β0x400a0ec130ae6b7cb8f44d5e5776218665cb3473d70ea23936be7351f6bcc339β,β0x33bf88ac6c2c7e50adb0ace5490152826d7e74596b90651209dfa14434d032a1β,β0x682c2debe8124d18d197dc5e28c9be7c21cd14701537a4d1979ca5998c16979cβ,β0xf8aec69a2a08c5f013cf7ca277f6d59918ea7d9d6d3e2fc2d0cd8ae63f0498a0β,β0xc9bc656a5724ad2ef4750d43a64881c0e61fa1ddc77bf8932eda86c1a744a6abβ,β0xd0d80db76de4c0afa51776b7ff1e4ea5b0e8394e9a89dab271f6b134f6792129β,β0x820acf394975c94a27acd0cfc1df7547ab4aa6eeb2ab9786c22a9102da4fc60dβ,β0x3b66c9b4f8691f1b983eb034d0ae7154537adb0ee8518a095d12d2ae32ebb100β,β0x990757b3265e6bb38474c0c7d0e68ed4564528b0ab41ce98337d1ec34f5286dbβ,β0xd56fbfacc022d03f1b679897c958b03f71f737167b3e6ac968170289794d6441β,β0x7603fd98d214d6334b8539ce1e4f031cd6a797de9b20e677f698c806bae97420β,β0x28ad290249e90e7bfb810aa4d2b7acf7d2d22bbabef0b48f76a30ccf496a9368β,β0x6b82c61c7080ff3d8a3d3c547f111986a6e8a0a0753f3a3a7e2a1730c2f02d7fβ,β0xbc931a183a7bfd3b75da0bdc8ec21e9fd1cce8aad66721a766768c707e7f0c62β,β0xec9d532f4b687b6e2f43da880926855572a262e3c9bbb96ae5347400bf8c0672β,β0x89c6054afc24ca0e0704d94c8a2ec433fe49e56b2c82320f31e6d2c43ebe62c5β,β0xc75e154afadab3351671324a4300f9c6374f58a27e572d96e0e7e8ee7f73e405β,β0x3787ed30ef33ba6abc49809f97ffe4ce56eadee57bf02129f9e0fb3a30a8b287β] | 1400000000000000000 | 0x9d194d18 | 0x0bd4887f7d41b35cd75dff9ffee2856106f86670 | 27858306 | 0xc7a6f1168db9f0f918162a834c10df649a938c66 | 0xc7a6f1168db9f0f918162a834c10df649a938c66 | 0 | 2025-03-20T21:25:59.000Z | 0x0cddee98158eb9b73a73915c2244925061da56a3e5afc8a0a7f71bab2e12051c | [] |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.friendtech_v1_base.FRIEND_claimA_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
FRIEND_claimB_function
FRIEND token airdrop claims on Base using Merkle proof verification. Records successful claim transactions including recipient addresses, claim amounts in wei, and cryptographic proofs for analyzing token distribution patterns.Columns
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_proof | ARRAY<STRING> | Merkle proof array for verifying claim eligibility or settlement authenticity. Array of hex-encoded hash strings used in cryptographic verification. |
in_recipient | STRING | Address designated to receive the output tokens from a swap or 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. |
in_giftRecipients | ARRAY<STRING> | Array of recipient addresses for gifted tokens during the claim transaction. Typically empty when no gifts are distributed. |
in_giftAmount | STRING | Token amount designated for gifting to other recipients in the same claim transaction. Denominated in wei (1e18 = 1 token), typically zero when users claim only for themselves. |
Sample Data
Sample Data
| gas | value | status | gas_used | in_proof | in_amount | signature | to_address | block_number | from_address | in_recipient | in_giftAmount | trace_address | block_timestamp | transaction_hash | in_giftRecipients |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70411 | 0 | true | 69552 | [β0x4eaa8fb75cc1eef1321449170d47d4ba2cd9f454d0a4f33d065f0e11e9d71763β,β0x6a9b94e8f4bc0955163d2e12ddf4ca718ba594668d5eebbe849f4b6bbf80ba9bβ,β0xff517eee1845c9fb056804b4d094f8831fa447c69aba80c9d4e8c2c1de7e05e5β,β0xe354900888cce5452efb4c9dbe2b54da1500108f67494579671686cb60941cbeβ,β0xb38375e11c70d2fbd250f58b733a37a2c325b01533aabd8664280374aad94dc2β,β0x23dcba8dee8b707f00e917a73e998647b1cd77062e069093d0000d10d25b40a9β,β0x88b68f939d39f44c9c7295f400c2a17401c74a38dce85cc985d11f526d176351β,β0x69e8938f540b863da3d0dda55018b81fe468f335db1285ebe0474bea8589fa60β,β0xf931e16e23904ee29489357dc7e933bb546b7c216e3795ba8b8610b3a43646dfβ,β0x043bcbb1373742f6f3a2b547952fd0224ecc0c927c039179ba8c16b831c4859eβ,β0xf75145291e6fe8cdd12e68ca5018fe3342a427333e4026e90c9811e77df9b41cβ,β0xc3a4d48ec0bdbd8fa92faf8a0e7f9859925fee6737e21852c1303f6c3e1d9d61β,β0x0d3ecae33811f1652a2afbfdfaba1e663d2d3bbc0f56ebcb36ee9279bcea672cβ,β0x941d5da00ce6ab30ae68d2bf5bcbef7d2eca285aa480a511c8ee11456475b7bcβ,β0xe4243b60e779e92eefb73ae50139ee318941bd1b485b92229564d341a5b1f445β,β0x2b0091da01900f17285eb9952a2b7d0008785f563c515cda244c6b86fb769aa5β,β0xdeb650e61a666526518041ab41dc13f1f8f6bb824f42dcd4e5e182222fe42796β,β0x5301c76f171caacfc8cc1d1085134bf0c1d88140245d2757e384dd565a61eea5β] | 4500000000000000000 | 0x1c71f9bc | 0x0bd4887f7d41b35cd75dff9ffee2856106f86670 | 25563513 | 0x1b22b8b5c098c697211b24f280ceb2361914d97f | 0x1b22b8b5c098c697211b24f280ceb2361914d97f | 0 | 2025-01-26T18:32:53.000Z | 0x9f3971a848c8969ab2823cb758d16a2c62f0fe32edc11a0a629e3b9269da06e2 | [] | |
| 70447 | 0 | true | 69588 | [β0x7c68e9bdd513d998ac9c160343c9a34e00192c3b20db4557e9a6c219c8543ea2β,β0x44f97892156fa6cfd4c56cf28c477f5060e417506b959ace7279d5387f6d5060β,β0x20ac147cf0b018620d736c3dff427be67c249b4913979be71627e7d61c973811β,β0x80300cfa7c0a8e3cd8d104cb9cf445e64cee90b8a42a4cc97148ebc74ea20a82β,β0xb97fc8d0a700f79476ea834eaa9d9614154d392d41980813584f62370882b08bβ,β0xd19b71687f612ad658ef3622a1100a64ef6a6e638b52ad557a4345cef4c48ae4β,β0x4d4082de27a4fa80bb7b38529bd8c3adcbc41b125524a4f4ab4fd7ee20975c58β,β0x504fdb796a0261335970b00eb8d2334076e499889f15058bfc0ca8e1b7f516c3β,β0x9670138bc451da07a77f28809ddaf615e5c28c1ab1877bb2220ab9d44ffb3a75β,β0x1a26c0f6141e68dbc6024ca8975433a1ff63d111e105debf514470a658e5b3c8β,β0x0c38b9f8db2acb148589b8444769ba3bc43f5478234b55a967d381447f9ba190β,β0x39f7e161f516c8ada3254de21de6224d869d731144755b272f31582eecab0f42β,β0x0cfa965b76dc1fecd7d4c0c1148038a194b663620b5dc41ecf17717f9fb5c4b3β,β0xbd27d56faec46e08622df499696a42f4eece0fce6c6479cc26e20b174c6957faβ,β0x6b2f7109b60aef21813070d6bea4d7088fc8b8702fe91c23bd4749974ec626b9β,β0x33a096c5c3f56b701733adfbb9983f96d52302de6c57329a9d0a5d2b14f6ad24β,β0x4768bbec222f9c85993cc134de6840932b7278ed60de87601b1d00a7e9c6799cβ,β0x5301c76f171caacfc8cc1d1085134bf0c1d88140245d2757e384dd565a61eea5β] | 1800000000000000000 | 0x1c71f9bc | 0x0bd4887f7d41b35cd75dff9ffee2856106f86670 | 25531068 | 0x17f058bf8831be283caf4ed630997e802a410c07 | 0x17f058bf8831be283caf4ed630997e802a410c07 | 0 | 2025-01-26T00:31:23.000Z | 0x4069e64d4a656fec60cfe5b458b695b15e93834b9f65a21fb6b4078e8160157e | [] | |
| 70459 | 0 | true | 69600 | [β0x7a47dc71e7980130faeae43ee8f1f68ec6bc28a8a71704daaaf0d971c7744341β,β0xac7e2ce0cc489f88331638719a136541bf0586ef1a3b42ed70548b40f206509bβ,β0x7bb26b5456d946794dde8a8cd8c08a05450746e27b71f324e2bd9abcb9367a81β,β0x96f7c3ae035fe3a39c11ff5a2de58bca592b48f45c6e7a7de4a46107728ebe34β,β0x77d52819059475407456a2a1369b90d934c77f5c70c1a87b250a11117d056335β,β0xaf9ce3c1a451a5150dde72d9588ff449cde7f24b32d8b13a780af73ef9da0f68β,β0xec490d8f8e2492c7d7e404733131374f9546ca4d5acec93bdbef76a14f4af2edβ,β0xbe35edbd04545a0a4572b3ebeb7d3881a2df4b0a8c245f7bbb06ed0ee0e77a27β,β0xc003e97b8d2e4fbaf51c9498c8c1caed465452b7c5aef52f9f249c35aea28795β,β0x4426969982ac06b8bfe81a0c2a09da97d905c9eaf1327e23a91aa5fe767736beβ,β0x0083dd1f39876bdd9e2386fe508cc4abe5edd510d99ffe01c7745c8ebb34de23β,β0x07b4fdbf28e625b64b8184e7dda3e631aacfec19496603e94247a14a0f947589β,β0x3e850c13f798ad83d2860eccd3c929bba56add93f11e5dcb69bb34c4d9809b01β,β0x7e46353dd687fbb728db19adf1ed1a20aa144fc35fee651db1bb31a1c736932fβ,β0x229ef40a80e0d55018d9c6220a8e48eab4f88b7b6a0f241762233d1e424b603cβ,β0xd68539c6becc6095644eb3258d64f10127019055afc91a05a7b2220767472003β,β0x4768bbec222f9c85993cc134de6840932b7278ed60de87601b1d00a7e9c6799cβ,β0x5301c76f171caacfc8cc1d1085134bf0c1d88140245d2757e384dd565a61eea5β] | 3600000000000000000 | 0x1c71f9bc | 0x0bd4887f7d41b35cd75dff9ffee2856106f86670 | 25562506 | 0x19b254cdcb74773830da4ecc9f69127b6e29aae8 | 0x19b254cdcb74773830da4ecc9f69127b6e29aae8 | 0 | 2025-01-26T17:59:19.000Z | 0xba5ec9607c1265cad8eec9ddc722dd1cf862fbe2e1f467d6b6913a836d97b8f7 | [] |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.friendtech_v1_base.FRIEND_claimB_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
FriendtechSharesV1_Trade_event
Trade transactions from Friend.tech social token protocol on Base, recording buys and sells of creator shares with ETH pricing, quantities, and fee distributions for analyzing trading activity and token holder behavior.Columns
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_trader | STRING | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_subject | STRING | Address of the subject (social account) whose shares are being traded in this transaction. Typically matches in_trader for initial share creation events where users buy their first self-share. |
in_isBuy | BOOL | Boolean flag indicating the trade direction, where true represents a buy order and false represents a sell order. This field determines whether shares are being purchased or sold in the Friend.tech transaction. |
in_shareAmount | STRING | Quantity of shares minted or redeemed in the protocol operation. Integer value representing the share amount in smallest unit (wei). |
in_ethAmount | STRING | Amount of ETH involved in the transaction. Integer value stored as string, denominated in wei. |
in_protocolEthAmount | STRING | Protocol fee amount in wei collected by Friend.tech from this trade. Represented as a string-encoded integer; commonly β0β for initial share purchases where no fee applies. |
in_subjectEthAmount | STRING | Amount of ETH earned by the share subject (creator) from this trade, denominated in wei. String-encoded integer that is typically zero for initial share purchases at supply of 1. |
in_supply | STRING | Total supply of shares or tokens after the transaction. Integer value stored as string, denominated in the tokenβs smallest unit. |
Sample Data
Sample Data
| address | removed | in_isBuy | in_supply | in_trader | log_index | in_subject | block_number | in_ethAmount | in_shareAmount | block_timestamp | transaction_hash | in_subjectEthAmount | in_protocolEthAmount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4 | false | true | 1 | 0xac254bf1287a7b31a204d343c27d67ec190bee39 | 10 | 0xac254bf1287a7b31a204d343c27d67ec190bee39 | 3321464 | 0 | 1 | 2023-08-30T21:51:15.000Z | 0x08663c6ead5a5f12e3576ce7c566016ece44306e74da6fe12fd093ede15d7875 | 0 | 0 |
| 0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4 | false | true | 1 | 0x28ce48bb66a096271488e9c12bed2c4b3975255e | 0 | 0x28ce48bb66a096271488e9c12bed2c4b3975255e | 3286310 | 0 | 1 | 2023-08-30T02:19:27.000Z | 0x1b54e16bc3a2880a2b4fb65f80a728bb9580daff538b17f2927575915e72f1ff | 0 | 0 |
| 0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4 | false | true | 1 | 0x9bee0ff49e0100aedf07a9c4ff590ce8db4e5d65 | 0 | 0x9bee0ff49e0100aedf07a9c4ff590ce8db4e5d65 | 3297012 | 0 | 1 | 2023-08-30T08:16:11.000Z | 0x3ae7129cc19c81594fb2b21c2158a58c112f4b7fe269d712ef528597f0a51936 | 0 | 0 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.friendtech_v1_base.FriendtechSharesV1_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100