Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_proofARRAY<STRING>Merkle proof array for verifying claim eligibility or settlement authenticity. Array of hex-encoded hash strings used in cryptographic verification.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_giftRecipientsARRAY<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_giftAmountSTRINGToken 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.
gasvaluestatusgas_usedin_proofin_amountsignatureto_addressblock_numberfrom_addressin_recipientin_giftAmounttrace_addressblock_timestamptransaction_hashin_giftRecipients
882160true87287[“0xf4c636424e7695b9840cdd105450c67f5b9fd74549912990bf9ba3f046d8e866”,“0x70ee176e847bb7edff3a75101a97c8905e23492f336484e17eea17677510f0b3”,“0x428dac8e7967384400553838b7495d405c70dece6c47b3f392bc473042ac55d9”,“0x56c8884d6b28de1badc7573d4dde63f3a04ee24a296bf77727c12e908a784732”,“0x79632b00262c3734482f5b7205bcd4b3a92ba40b268be2592c45976bad19baf4”,“0x33728be35527f0a089afd25e1861f74ce90288eb857fa28cd6eab8e10c2fe41e”,“0x6d4a8edb254218929e1ff6bc334ef109fff1c1032d5021dc5fba4bc08f6a10b4”,“0xa66bca7173d751f66818a26e0d8132357d6d3b83bc90629966f92c5a2d60e584”,“0x86b5b5067ffaedd859ce32c8ad8b2b990bb21c04344531ab82ff958839d8fcad”,“0x8bc6f810984e7de71358ecbefb8c980756e40271730794413769ad42c9563b67”,“0x1abae03b1b2032f2a4bd30f5ff28141d1a13cbab1ece18a29208072b7331f5f2”,“0xd41f79009c685dd1a6aa28e8a8c970056465e200244b7d09f329af93566a6375”,“0x913d03d3f8a845d9127b8563c6aa01d7ef914617f559d5ac88742e1bb8015c3b”,“0xfca37afe5c6ff10f000f6b167af73ce566caaf4f3d2ea82509e32c08d7eb70a0”,“0x1c544bc2cb77e3d06fef4db9ae427ac4cccb726e939d90949eb14bec8dc2ad73”,“0x77ac3958e5c60cc331d017efe71fd9c01b95ec4e97e87c995a58419b88906015”,“0xdc7206ce6b274134ca83c8c7b3339dc617a0f85cd4f2e379ce824e3e4da044aa”,“0x8d2e2f12a45c4dc6a1096f3d17ef41591d96e5d7159bba22fac950d55007c67b”,“0x8adc8e22e6c33e1e72e4d70e2928a1d24525a67dc379c8f47f49b13e4a35464f”]5000000000000000000x9d194d180x0bd4887f7d41b35cd75dff9ffee2856106f86670278626310xcbfa06c5ba79529d6909cfe2458a131cb0b306e70xcbfa06c5ba79529d6909cfe2458a131cb0b306e702025-03-20T23:50:09.000Z0x776af8114213b104fd679b11bed30a89b855c192c1e653ace3f01353e0545213[]
875680true86641[“0xdcc86bd7e298adbfe677836494745b5fe87f6480c8023056ea5ed309f11d69c5”,“0x1308c6674766bf239fa98d43565581037b8ebcff601d596888c03e3e7fca5acf”,“0x1ccd47938871295a6d8784a020babee04e885588f1aa3e140f3aad022fc62270”,“0xf96c8e55e1cf140e2da2b78e46120ca8a7adddefdabff15a2f28c24081c9eb31”,“0xb386b841e85bf88236c750864c5212811c19ea41a877cee82b5e4daafec69c59”,“0x34e69a979a6101c3aba9297955ade6ee1884f9f43df49dc06ba0383ec97fb7ce”,“0x649f1f68ef4f415c14d0020033a3a649641277f6cd175fe656804f71912a98ea”,“0x821cda1b6c39cad8a2eea71eef2bf98b5a7e8941aead78ba381180533d002405”,“0x7ef539fc4b8f05d1e9a6bce55dca485c3d4e7fac09e364bc30acb3ae35349e54”,“0xa9fad900effe3e7848ba40f7dccf034bc15d2495ed040847b37d9e2e017d7305”,“0x429fdf086cf7f1b0505158a09a2be521c53b2e65431c0a1fa6c5476e6631022e”,“0x26603ddbb9617a42af1162a9046dac0ff856ea86d3b9dbbb3d10d5e82403187f”,“0x47d9273ecde6af01b5eca2aec9ff09bdeea7029e52bab81f46110de27b63d26d”,“0x0a282dac38c5c78361c6ae413809a6345c5ac52a6e5eb6ee8c147e85ba80e938”,“0xec9d532f4b687b6e2f43da880926855572a262e3c9bbb96ae5347400bf8c0672”,“0x89c6054afc24ca0e0704d94c8a2ec433fe49e56b2c82320f31e6d2c43ebe62c5”,“0xc75e154afadab3351671324a4300f9c6374f58a27e572d96e0e7e8ee7f73e405”,“0x3787ed30ef33ba6abc49809f97ffe4ce56eadee57bf02129f9e0fb3a30a8b287”]4000000000000000000x9d194d180x0bd4887f7d41b35cd75dff9ffee2856106f86670278628850x6a6e715190ce80cafd8152d348a0761bc7209c2c0x6a6e715190ce80cafd8152d348a0761bc7209c2c02025-03-20T23:58:37.000Z0x77c36bf771f587a2740549378e74e09b1611cd7f934cd83ebb0c97343afadd85[]
875920true86665[“0x400a0ec130ae6b7cb8f44d5e5776218665cb3473d70ea23936be7351f6bcc339”,“0x33bf88ac6c2c7e50adb0ace5490152826d7e74596b90651209dfa14434d032a1”,“0x682c2debe8124d18d197dc5e28c9be7c21cd14701537a4d1979ca5998c16979c”,“0xf8aec69a2a08c5f013cf7ca277f6d59918ea7d9d6d3e2fc2d0cd8ae63f0498a0”,“0xc9bc656a5724ad2ef4750d43a64881c0e61fa1ddc77bf8932eda86c1a744a6ab”,“0xd0d80db76de4c0afa51776b7ff1e4ea5b0e8394e9a89dab271f6b134f6792129”,“0x820acf394975c94a27acd0cfc1df7547ab4aa6eeb2ab9786c22a9102da4fc60d”,“0x3b66c9b4f8691f1b983eb034d0ae7154537adb0ee8518a095d12d2ae32ebb100”,“0x990757b3265e6bb38474c0c7d0e68ed4564528b0ab41ce98337d1ec34f5286db”,“0xd56fbfacc022d03f1b679897c958b03f71f737167b3e6ac968170289794d6441”,“0x7603fd98d214d6334b8539ce1e4f031cd6a797de9b20e677f698c806bae97420”,“0x28ad290249e90e7bfb810aa4d2b7acf7d2d22bbabef0b48f76a30ccf496a9368”,“0x6b82c61c7080ff3d8a3d3c547f111986a6e8a0a0753f3a3a7e2a1730c2f02d7f”,“0xbc931a183a7bfd3b75da0bdc8ec21e9fd1cce8aad66721a766768c707e7f0c62”,“0xec9d532f4b687b6e2f43da880926855572a262e3c9bbb96ae5347400bf8c0672”,“0x89c6054afc24ca0e0704d94c8a2ec433fe49e56b2c82320f31e6d2c43ebe62c5”,“0xc75e154afadab3351671324a4300f9c6374f58a27e572d96e0e7e8ee7f73e405”,“0x3787ed30ef33ba6abc49809f97ffe4ce56eadee57bf02129f9e0fb3a30a8b287”]14000000000000000000x9d194d180x0bd4887f7d41b35cd75dff9ffee2856106f86670278583060xc7a6f1168db9f0f918162a834c10df649a938c660xc7a6f1168db9f0f918162a834c10df649a938c6602025-03-20T21:25:59.000Z0x0cddee98158eb9b73a73915c2244925061da56a3e5afc8a0a7f71bab2e12051c[]
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_proofARRAY<STRING>Merkle proof array for verifying claim eligibility or settlement authenticity. Array of hex-encoded hash strings used in cryptographic verification.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_giftRecipientsARRAY<STRING>Array of recipient addresses for gifted tokens during the claim transaction. Typically empty when no gifts are distributed.
in_giftAmountSTRINGToken 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.
gasvaluestatusgas_usedin_proofin_amountsignatureto_addressblock_numberfrom_addressin_recipientin_giftAmounttrace_addressblock_timestamptransaction_hashin_giftRecipients
704110true69552[“0x4eaa8fb75cc1eef1321449170d47d4ba2cd9f454d0a4f33d065f0e11e9d71763”,“0x6a9b94e8f4bc0955163d2e12ddf4ca718ba594668d5eebbe849f4b6bbf80ba9b”,“0xff517eee1845c9fb056804b4d094f8831fa447c69aba80c9d4e8c2c1de7e05e5”,“0xe354900888cce5452efb4c9dbe2b54da1500108f67494579671686cb60941cbe”,“0xb38375e11c70d2fbd250f58b733a37a2c325b01533aabd8664280374aad94dc2”,“0x23dcba8dee8b707f00e917a73e998647b1cd77062e069093d0000d10d25b40a9”,“0x88b68f939d39f44c9c7295f400c2a17401c74a38dce85cc985d11f526d176351”,“0x69e8938f540b863da3d0dda55018b81fe468f335db1285ebe0474bea8589fa60”,“0xf931e16e23904ee29489357dc7e933bb546b7c216e3795ba8b8610b3a43646df”,“0x043bcbb1373742f6f3a2b547952fd0224ecc0c927c039179ba8c16b831c4859e”,“0xf75145291e6fe8cdd12e68ca5018fe3342a427333e4026e90c9811e77df9b41c”,“0xc3a4d48ec0bdbd8fa92faf8a0e7f9859925fee6737e21852c1303f6c3e1d9d61”,“0x0d3ecae33811f1652a2afbfdfaba1e663d2d3bbc0f56ebcb36ee9279bcea672c”,“0x941d5da00ce6ab30ae68d2bf5bcbef7d2eca285aa480a511c8ee11456475b7bc”,“0xe4243b60e779e92eefb73ae50139ee318941bd1b485b92229564d341a5b1f445”,“0x2b0091da01900f17285eb9952a2b7d0008785f563c515cda244c6b86fb769aa5”,“0xdeb650e61a666526518041ab41dc13f1f8f6bb824f42dcd4e5e182222fe42796”,“0x5301c76f171caacfc8cc1d1085134bf0c1d88140245d2757e384dd565a61eea5”]45000000000000000000x1c71f9bc0x0bd4887f7d41b35cd75dff9ffee2856106f86670255635130x1b22b8b5c098c697211b24f280ceb2361914d97f0x1b22b8b5c098c697211b24f280ceb2361914d97f02025-01-26T18:32:53.000Z0x9f3971a848c8969ab2823cb758d16a2c62f0fe32edc11a0a629e3b9269da06e2[]
704470true69588[“0x7c68e9bdd513d998ac9c160343c9a34e00192c3b20db4557e9a6c219c8543ea2”,“0x44f97892156fa6cfd4c56cf28c477f5060e417506b959ace7279d5387f6d5060”,“0x20ac147cf0b018620d736c3dff427be67c249b4913979be71627e7d61c973811”,“0x80300cfa7c0a8e3cd8d104cb9cf445e64cee90b8a42a4cc97148ebc74ea20a82”,“0xb97fc8d0a700f79476ea834eaa9d9614154d392d41980813584f62370882b08b”,“0xd19b71687f612ad658ef3622a1100a64ef6a6e638b52ad557a4345cef4c48ae4”,“0x4d4082de27a4fa80bb7b38529bd8c3adcbc41b125524a4f4ab4fd7ee20975c58”,“0x504fdb796a0261335970b00eb8d2334076e499889f15058bfc0ca8e1b7f516c3”,“0x9670138bc451da07a77f28809ddaf615e5c28c1ab1877bb2220ab9d44ffb3a75”,“0x1a26c0f6141e68dbc6024ca8975433a1ff63d111e105debf514470a658e5b3c8”,“0x0c38b9f8db2acb148589b8444769ba3bc43f5478234b55a967d381447f9ba190”,“0x39f7e161f516c8ada3254de21de6224d869d731144755b272f31582eecab0f42”,“0x0cfa965b76dc1fecd7d4c0c1148038a194b663620b5dc41ecf17717f9fb5c4b3”,“0xbd27d56faec46e08622df499696a42f4eece0fce6c6479cc26e20b174c6957fa”,“0x6b2f7109b60aef21813070d6bea4d7088fc8b8702fe91c23bd4749974ec626b9”,“0x33a096c5c3f56b701733adfbb9983f96d52302de6c57329a9d0a5d2b14f6ad24”,“0x4768bbec222f9c85993cc134de6840932b7278ed60de87601b1d00a7e9c6799c”,“0x5301c76f171caacfc8cc1d1085134bf0c1d88140245d2757e384dd565a61eea5”]18000000000000000000x1c71f9bc0x0bd4887f7d41b35cd75dff9ffee2856106f86670255310680x17f058bf8831be283caf4ed630997e802a410c070x17f058bf8831be283caf4ed630997e802a410c0702025-01-26T00:31:23.000Z0x4069e64d4a656fec60cfe5b458b695b15e93834b9f65a21fb6b4078e8160157e[]
704590true69600[“0x7a47dc71e7980130faeae43ee8f1f68ec6bc28a8a71704daaaf0d971c7744341”,“0xac7e2ce0cc489f88331638719a136541bf0586ef1a3b42ed70548b40f206509b”,“0x7bb26b5456d946794dde8a8cd8c08a05450746e27b71f324e2bd9abcb9367a81”,“0x96f7c3ae035fe3a39c11ff5a2de58bca592b48f45c6e7a7de4a46107728ebe34”,“0x77d52819059475407456a2a1369b90d934c77f5c70c1a87b250a11117d056335”,“0xaf9ce3c1a451a5150dde72d9588ff449cde7f24b32d8b13a780af73ef9da0f68”,“0xec490d8f8e2492c7d7e404733131374f9546ca4d5acec93bdbef76a14f4af2ed”,“0xbe35edbd04545a0a4572b3ebeb7d3881a2df4b0a8c245f7bbb06ed0ee0e77a27”,“0xc003e97b8d2e4fbaf51c9498c8c1caed465452b7c5aef52f9f249c35aea28795”,“0x4426969982ac06b8bfe81a0c2a09da97d905c9eaf1327e23a91aa5fe767736be”,“0x0083dd1f39876bdd9e2386fe508cc4abe5edd510d99ffe01c7745c8ebb34de23”,“0x07b4fdbf28e625b64b8184e7dda3e631aacfec19496603e94247a14a0f947589”,“0x3e850c13f798ad83d2860eccd3c929bba56add93f11e5dcb69bb34c4d9809b01”,“0x7e46353dd687fbb728db19adf1ed1a20aa144fc35fee651db1bb31a1c736932f”,“0x229ef40a80e0d55018d9c6220a8e48eab4f88b7b6a0f241762233d1e424b603c”,“0xd68539c6becc6095644eb3258d64f10127019055afc91a05a7b2220767472003”,“0x4768bbec222f9c85993cc134de6840932b7278ed60de87601b1d00a7e9c6799c”,“0x5301c76f171caacfc8cc1d1085134bf0c1d88140245d2757e384dd565a61eea5”]36000000000000000000x1c71f9bc0x0bd4887f7d41b35cd75dff9ffee2856106f86670255625060x19b254cdcb74773830da4ecc9f69127b6e29aae80x19b254cdcb74773830da4ecc9f69127b6e29aae802025-01-26T17:59:19.000Z0xba5ec9607c1265cad8eec9ddc722dd1cf862fbe2e1f467d6b6913a836d97b8f7[]
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_subjectSTRINGAddress 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_isBuyBOOLBoolean 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_shareAmountSTRINGQuantity of shares minted or redeemed in the protocol operation. Integer value representing the share amount in smallest unit (wei).
in_ethAmountSTRINGAmount of ETH involved in the transaction. Integer value stored as string, denominated in wei.
in_protocolEthAmountSTRINGProtocol 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_subjectEthAmountSTRINGAmount 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_supplySTRINGTotal supply of shares or tokens after the transaction. Integer value stored as string, denominated in the token’s smallest unit.
addressremovedin_isBuyin_supplyin_traderlog_indexin_subjectblock_numberin_ethAmountin_shareAmountblock_timestamptransaction_hashin_subjectEthAmountin_protocolEthAmount
0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4falsetrue10xac254bf1287a7b31a204d343c27d67ec190bee39100xac254bf1287a7b31a204d343c27d67ec190bee393321464012023-08-30T21:51:15.000Z0x08663c6ead5a5f12e3576ce7c566016ece44306e74da6fe12fd093ede15d787500
0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4falsetrue10x28ce48bb66a096271488e9c12bed2c4b3975255e00x28ce48bb66a096271488e9c12bed2c4b3975255e3286310012023-08-30T02:19:27.000Z0x1b54e16bc3a2880a2b4fb65f80a728bb9580daff538b17f2927575915e72f1ff00
0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4falsetrue10x9bee0ff49e0100aedf07a9c4ff590ce8db4e5d6500x9bee0ff49e0100aedf07a9c4ff590ce8db4e5d653297012012023-08-30T08:16:11.000Z0x3ae7129cc19c81594fb2b21c2158a58c112f4b7fe269d712ef528597f0a5193600
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