treasure_v1_arbitrum

Tables

MagicRewardsArbitrum_RewardPaid_event

MAGIC token reward distribution events from Treasure DAO’s staking contract on Arbitrum. Records individual reward claims with user addresses and token amounts in wei for tracking incentive payouts and participant earnings.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x73eb8b2b235f7957f830ea66abe433d9eed9f0e3	0x009d2aef6eded4c1543e9a41cc6f864b5ecfb564	false	42785989390602988108	1	3667086	2021-12-08T07:51:23.000Z	0x7ff926c8b802d723f2dba3d094b3ac6f72eb37ed8c62fac96a792befd87f7ecd
0x73eb8b2b235f7957f830ea66abe433d9eed9f0e3	0x00d29fbc981d05edba69bc0909e391a132271357	false	1174032235033655305918	1	3656027	2021-12-08T00:28:40.000Z	0xba295a75b96246bf7ff4e1a94e0bff7ecaa6a267b2c56c523fe34860b55e2c69
0x73eb8b2b235f7957f830ea66abe433d9eed9f0e3	0x0f045a0d77d24c326316e0315354e7df28b4ac50	false	673472440143191448146	1	3661917	2021-12-08T04:45:04.000Z	0x45e102f0a8b3b7b63427ac6c07e2e04c49aac7c1def18dacdb708f0ef28577c9

Example Query

Query with partition filter

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

MagicSwapFactory_PairCreated_event

Liquidity pool creation events from the MagicSwap decentralized exchange (DEX) factory contract on Arbitrum, recording the deployment of new trading pairs with their token addresses and pool identifiers. Used for tracking DEX liquidity expansion and token pair availability.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x015e379ce0ff195228b3a9ebdfa13f9afc155dd7	0x088f2bd3667f385427d9289c28725d43d4b74ab4	false	2	0x539bde0d7dbd336b79148aa742883198bbf60342	0x872bad41cfc8ba731f811fea8b2d0b9fd6369585	1	40081391	2022-11-21T23:07:39.000Z	0x869b10e76b57a30153941356af8693c0e0d0f0e1d08c671d0627b004cf63634c
0x015e379ce0ff195228b3a9ebdfa13f9afc155dd7	0x3e8fb78ec6fb60575967bb07ac64e5fa9f498a4a	false	5	0x539bde0d7dbd336b79148aa742883198bbf60342	0xeeac5e75216571773c0064b3b591a86253791db6	0	107502861	2023-07-03T15:52:01.000Z	0x3d48107989556efbff739a8b9716f331a7668a7589a041925539191bc4c59ed5
0x015e379ce0ff195228b3a9ebdfa13f9afc155dd7	0x6210775833732f144058713c9b36de09afd1ca3b	false	3	0x0caadd427a6feb5b5fc1137eb05aa7ddd9c08ce9	0x539bde0d7dbd336b79148aa742883198bbf60342	1	91981875	2023-05-18T15:07:05.000Z	0xcfaa19463438b108a99db8a0da456bd91ec33861f5e08e21c70eb382e70af9be

Example Query

Query with partition filter

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

MagicSwapV2Pair_Burn_event

Liquidity removal events from MagicSwap V2 automated market maker (AMM) pairs on Arbitrum’s Treasure ecosystem. Records burn transactions showing withdrawn token amounts, sender and recipient addresses for tracking liquidity provider exits and pool depth 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x9017c92270f465fe35c8adf47ad9b2c344765561	0x088f2bd3667f385427d9289c28725d43d4b74ab4	false	0xf3573bf4ca41b039bc596354870973d34fdb618b	18	102020308086697501443	708144191244077837552	273949649	2024-11-13T06:29:53.000Z	0x0e11fc3b11a862a665a4beecebd96118e77970928add54e3c6436ec22f2ba09a
0x635e13b0f26585f413de9be7fa857b6886182d6b	0x088f2bd3667f385427d9289c28725d43d4b74ab4	false	0x635e13b0f26585f413de9be7fa857b6886182d6b	53	19978511808172400683	144257867677318737066	274161526	2024-11-13T21:18:35.000Z	0x7a04a3fafdf934214a249ce7e837d114cab911a0d35664115f75ffe66932b9af
0x635e13b0f26585f413de9be7fa857b6886182d6b	0x088f2bd3667f385427d9289c28725d43d4b74ab4	false	0x635e13b0f26585f413de9be7fa857b6886182d6b	29	31821175777733647486	229769614912119295706	274161316	2024-11-13T21:17:41.000Z	0x4d7dda2edacdb45169f61c7b633ea9e4a9d2035c0df19fd73bbc20ea4a7f4281

Example Query

Query with partition filter

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

MagicSwapV2Pair_Mint_event

Liquidity provision events from MagicSwapV2 decentralized exchange pools on Arbitrum, recording token amounts added to liquidity pairs. Used for analyzing liquidity provider activity and pool depth changes over time.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x7bc27907ac638dbceb74b1fb02fc154da3e15334	false	0x23805449f91bb2d2054d9ba288fdc8f09b5eac79	5	3499999999999999504492	29018396241059445445723	106619194	2023-07-01T00:11:33.000Z	0xdf9c248912d8baeb4eb2f0f47e190a0495e260b814f9af961c16b8c54c455bb2
0x088f2bd3667f385427d9289c28725d43d4b74ab4	false	0x23805449f91bb2d2054d9ba288fdc8f09b5eac79	6	75963716064405392343	40184040438163509300	106893059	2023-07-01T19:50:19.000Z	0xa4b31db33dc2aca11e7409c0f0446c974215695141a8495cab703e9f40ecd403
0x7bc27907ac638dbceb74b1fb02fc154da3e15334	false	0x23805449f91bb2d2054d9ba288fdc8f09b5eac79	6	104138999999999996394	889321733519765135568	106909185	2023-07-01T21:00:52.000Z	0x08b43487cec77aed5cbe23847a67c90294f778866e9df432aed1fa3d93c3ccc6

Example Query

Query with partition filter

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

MagicSwapV2Pair_Swap_event

Token swap transactions from MagicSwap V2 automated market maker (AMM) pairs on Arbitrum’s Treasure ecosystem. Tracks input/output amounts for both tokens in each pair, enabling analysis of trading volume, liquidity utilization, and price impact across Treasure’s decentralized exchange.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x01227d441634ee059aa73d9315ab4373774c0040	0x6210775833732f144058713c9b36de09afd1ca3b	false	0x23805449f91bb2d2054d9ba288fdc8f09b5eac79	8	168870939	22930000000000000000	21618780039085306367777	2024-01-10T01:52:23.000Z	0xb4b708ef1db9fd693ad6fb884775b5b22124c3e53f01f75cc304c2bb7e613041
0x0309b32c5623fd1921e4720e207d20a259bfddb8	0x088f2bd3667f385427d9289c28725d43d4b74ab4	false	0x23805449f91bb2d2054d9ba288fdc8f09b5eac79	4	169091390	3000000000000000000000	864420320060392756875	2024-01-10T17:19:22.000Z	0x9c83809c6fb2551d475925849196cc8959bc4a6a4588a7ab3331942015e8749b
0x0ceb76379e5c8ad833001beece05e45191cf2dff	0x7bc27907ac638dbceb74b1fb02fc154da3e15334	false	0x23805449f91bb2d2054d9ba288fdc8f09b5eac79	10	169095181	4300000000000000000000	556144756398658567707	2024-01-10T17:35:28.000Z	0xf736089d92f683b30a2cd04b2b6c18d839bc9abe3a8aa9c0adeaadc5801b39a3

Example Query

Query with partition filter

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

MagicSwapV2Pair_Sync_event

Reserve balance updates for MagicSwapV2 liquidity pairs on Arbitrum’s Treasure ecosystem. Tracks token0 and token1 reserve quantities after each swap or liquidity change, enabling liquidity depth analysis and price reconstruction.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x7bc27907ac638dbceb74b1fb02fc154da3e15334	false	2	202264904650177702562824	4458071262366326421633304	185067235	2024-02-27T17:17:47.000Z	0x1ab2da1298e96f10d1cf44646e14429024591567f68cf81a7f91bc8167745ebd
0x7bc27907ac638dbceb74b1fb02fc154da3e15334	false	2	200997003781414642071632	4483318390200487240950328	184960631	2024-02-27T09:48:27.000Z	0x7e81929377e895d194533cc5005d6cd805cf4797e5a44a5d19be5b6f30710f58
0x7bc27907ac638dbceb74b1fb02fc154da3e15334	false	2	202245116410290844681898	4458520943218326421633304	185067843	2024-02-27T17:20:20.000Z	0xddce8dd3925a9ef12f99fcfeb80762661f88ee0b869a145034527a4710ae4ce0

Example Query

Query with partition filter

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

MagicSwapV2Pair_Transfer_event

LP token transfer events from MagicSwap V2 liquidity pairs on Arbitrum, including mints (from zero address), burns, and transfers between addresses. Used for tracking liquidity provision activity and LP position flows across MagicSwap pools.

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_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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x1a33521c61d053c1fdc248dc434109d06fc2ca3e	0x088f2bd3667f385427d9289c28725d43d4b74ab4	0x49909c68aecdfe6512271ecddb1adb6190c8eb2d	false	8307802290000000000	22	77417561	2023-04-05T21:12:27.000Z	0x7a416a842c57ec715932992d0fc5c87256e604ad2402daa240879458f9c1fd83
0x31add546d8e613fc155122f8e9654e7f0aa7f264	0x088f2bd3667f385427d9289c28725d43d4b74ab4	0x0000000000000000000000000000000000000000	false	416491276266036891	3	77417349	2023-04-05T21:11:32.000Z	0x2df524b3ad8a21cbcfff43d9ab8f14ffd00f0358e4e339fe9189486623b84d3f
0x49909c68aecdfe6512271ecddb1adb6190c8eb2d	0x088f2bd3667f385427d9289c28725d43d4b74ab4	0x0000000000000000000000000000000000000000	false	8307802289378857956	4	77417349	2023-04-05T21:11:32.000Z	0x2df524b3ad8a21cbcfff43d9ab8f14ffd00f0358e4e339fe9189486623b84d3f

Example Query

Query with partition filter

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

TreasureMarketplace_BidAccepted_event

Accepted bid events from Treasure NFT marketplace on Arbitrum, capturing successful NFT sales where sellers accepted buyer offers. Records include bidder and seller addresses, NFT contract and token ID, payment token, price per item, quantity, and bid type for analyzing marketplace dynamics and price discovery.

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_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_bidder`	`STRING`	Address of the account that placed the bid in the auction or marketplace. Hex-encoded, 0x-prefixed, 42-character string.
`in_nftAddress`	`STRING`	Contract address of the NFT collection where the bid was accepted. Hex-encoded, 0x-prefixed 40-character string on Arbitrum representing the ERC-721 or ERC-1155 contract.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_pricePerItem`	`STRING`	Price per NFT in the bid, denominated in the payment token’s smallest unit (wei-equivalent). This value represents the bid amount for a single item before multiplying by quantity.
`in_paymentToken`	`STRING`	Contract address of the token used for payment in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_bidType`	`INT64`	Type of bid that was accepted, where 0 indicates a collection-level bid and 1 indicates a token-specific bid. Enumerated integer value used to distinguish between broad collection offers versus targeted individual NFT offers.

Sample Data

address	removed	in_bidder	in_seller	log_index	in_bidType	in_tokenId	in_quantity	block_number	in_nftAddress	block_timestamp	in_paymentToken	in_pricePerItem	transaction_hash
0x09986b4e255b3c548041a30a2ee312fe176731c2	false	0xc049085709fc6581152c1e1edeea53fae58fede1	0x23e56392e605fe5d2edde803be5070ba27a6cae3	8	0	24154	1	130279569	0x0af85a5624d24e2c6e7af3c0a0b102a28e36cea3	2023-09-12T02:36:32.000Z	0x539bde0d7dbd336b79148aa742883198bbf60342	145000000000000000000	0x4a85a3788c24316d0f45aea71bdb3725dc34774cfd94a1f3229565cecec4182b
0x09986b4e255b3c548041a30a2ee312fe176731c2	false	0xc62543032bc439c578c804bb2557e3ed78ac8df2	0xa9af1bead70eef665c88c20f1d2d86229136e10c	8	1	19435	1	130333996	0x0af85a5624d24e2c6e7af3c0a0b102a28e36cea3	2023-09-12T06:50:38.000Z	0x539bde0d7dbd336b79148aa742883198bbf60342	6700000000000000000	0x32c0c89d52defab85f810c189a096bb1d81e427a5d39800b6172c6360160a7ab
0x09986b4e255b3c548041a30a2ee312fe176731c2	false	0x9ffe162b9b7fbca991840b936f95b40808a1a998	0xc51fefb9ef83f2d300448b22db6fac032f96df3f	7	0	20010	1	130310083	0x381227255ef6c5d85966b78d13e4b4a4c8719b5e	2023-09-12T04:59:15.000Z	0x539bde0d7dbd336b79148aa742883198bbf60342	5000000000000000000	0x803919d77ea69d194eb60d80e2a825c4c612b37bcaa5569f2ebfbbc72ed3505e

Example Query

Query with partition filter

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

TreasureMarketplace_ItemSold_event

NFT sale events from Treasure marketplace on Arbitrum, capturing buyer and seller addresses, token IDs, quantities, prices per item, and payment tokens. Used for analyzing gaming/metaverse NFT trading activity and marketplace volume.

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_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_nftAddress`	`STRING`	Contract address of the NFT being sold on the Treasure marketplace. Hex-encoded, 0x-prefixed 40-character string on Arbitrum chain.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_pricePerItem`	`STRING`	Price per individual item in the sale denominated in the payment token’s smallest unit (wei). Typically represented as an 18-decimal integer requiring division by 10^18 to get the human-readable token amount.
`in_paymentToken`	`STRING`	Contract address of the token used for payment in the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_buyer	in_seller	log_index	in_tokenId	in_quantity	block_number	in_nftAddress	block_timestamp	in_paymentToken	in_pricePerItem	transaction_hash
0x09986b4e255b3c548041a30a2ee312fe176731c2	false	0x679c9a7fb9379b3673a1a6687b17131e4599ef3c	0x5d3cf00412cfab03fb9d2878be0bba9054822d7b	24	7953	1	294039385	0x094fa8ae08426ab180e71e60fa253b079e13b9fe	2025-01-10T18:02:22.000Z	0x539bde0d7dbd336b79148aa742883198bbf60342	50000000000000000000	0x081189ea7e82cfeac63ef215b96d3deacf9bb94b6bfb859d78af73d91a976f1b
0x09986b4e255b3c548041a30a2ee312fe176731c2	false	0xcc640f42b0a0fd2948e47035e5b27386d3aa8d1b	0x3201922afef50160a3ec6aca76827143f3e8b720	49	13458	1	293873801	0x094fa8ae08426ab180e71e60fa253b079e13b9fe	2025-01-10T06:31:03.000Z	0x539bde0d7dbd336b79148aa742883198bbf60342	5300000000000000000	0x0d4dce984f6c470f763842df612ef08c1800aa8c0ff0a333a8d465c6fe5fc6c4
0x09986b4e255b3c548041a30a2ee312fe176731c2	false	0xcc640f42b0a0fd2948e47035e5b27386d3aa8d1b	0xf97b0e2be96e1adfe74708ed45d37f8cd6e78935	8	18296	1	293869209	0x094fa8ae08426ab180e71e60fa253b079e13b9fe	2025-01-10T06:11:47.000Z	0x539bde0d7dbd336b79148aa742883198bbf60342	10500000000000000000	0x5e8d52ceddb3c517611b2cfd3f07216fe91efe6ae0555ef3e97da1d0f7fa46ae

Example Query

Query with partition filter

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

TreasureMarketplace_UpdateCollectionOwnerFee_event

Configuration changes for NFT collection owner fees on the Treasure marketplace, recording fee percentage updates, recipient addresses, and whether fees were added or removed for specific collections.

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__collection`	`STRING`	Contract address of the NFT collection having its owner fee updated on the Treasure marketplace. Hex-encoded, 0x-prefixed 40-character Ethereum address on Arbitrum.
`in__recipient`	`STRING`	Address designated to receive the assets or proceeds from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__fee`	`STRING`	Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points.

Sample Data

address	in__fee	removed	log_index	block_number	in__recipient	in__collection	block_timestamp	transaction_hash
0x09986b4e255b3c548041a30a2ee312fe176731c2	750	false	1	19732408	0x27dc208468100ff557a6ef07b2fcb16a5584dfd1	0x00000000016c35e3613ad3ed484aa48f161b67fd	2022-08-08T15:53:57.000Z	0x75550d6ea8cd62bea85baf36bf5e194a47004c0b6b6f717b327214a844818ee3
0x09986b4e255b3c548041a30a2ee312fe176731c2	250	false	2	168375637	0xe6db66725c3f50b8625e76822e0a58871c8a4a91	0xe8fae7ced81341b459832a0ee3148ac608a34f64	2024-01-08T15:10:17.000Z	0xac2b9b3cec97968b9c4c17763c77ff1aab3e956ecf4de82c90e970ddb9aa86ee
0x09986b4e255b3c548041a30a2ee312fe176731c2	169	false	10	24695390	0x6f45f308fc8bb691a665eae3171d72aa3020ba52	0x78baa78f4502818c52497598fa548a9f42de0359	2022-09-15T05:31:18.000Z	0xe304c3483dc120f417603eba5360fdaa16f3e395eef0470af53e66b4e4958b39

Example Query

Query with partition filter

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

TreasureMarketplace_UpdateFee_event

Fee update events from the Treasure NFT marketplace on Arbitrum, recording when platform fees are modified (500 = 5%). Used for tracking marketplace fee structure changes over time.

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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
500	0x09986b4e255b3c548041a30a2ee312fe176731c2	false	2	7764399	2022-03-12T00:54:23.000Z	0x43b348d6e0eee06b25bb184f28399c82f8c9793e6f55c6f80754448dd0a945f5
500	0x09986b4e255b3c548041a30a2ee312fe176731c2	false	0	8851338	2022-03-29T20:43:06.000Z	0xc66db86633b2e59f2c43c99e13aaa663872d7ec0527a8eef8157d6eb4564b5a7

Example Query

Query with partition filter

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

TreasureMarketplace_UpdateFeeWithCollectionOwner_event

Events tracking marketplace fee updates set by NFT collection owners on Treasure marketplace (Arbitrum). Records fee percentage changes with collection addresses for analyzing revenue share configurations and marketplace 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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
250	0x09986b4e255b3c548041a30a2ee312fe176731c2	false	1	8851338	2022-03-29T20:43:06.000Z	0xc66db86633b2e59f2c43c99e13aaa663872d7ec0527a8eef8157d6eb4564b5a7

Example Query

Query with partition filter

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

TreasureMarketplaceLegacy_ItemSold_event

NFT sale events from the legacy Treasure marketplace on Arbitrum, capturing buyer, seller, NFT contract addresses, token IDs, quantities, and prices in wei. Used for analyzing trading volume, price history, and marketplace activity for gaming and metaverse NFTs.

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_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_nftAddress`	`STRING`	Contract address of the NFT collection involved in the sale transaction on Arbitrum. Hex-encoded, 0x-prefixed 40-character string identifying the ERC-721 or ERC-1155 token contract.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_pricePerItem`	`STRING`	Price per individual NFT unit in the sale, denominated in the marketplace’s payment token (typically MAGIC on Arbitrum). Values are wei-denominated integers representing token amounts with 18 decimal places.

Sample Data

address	removed	in_buyer	in_seller	log_index	in_tokenId	in_quantity	block_number	in_nftAddress	block_timestamp	in_pricePerItem	transaction_hash
0x2e3b85f85628301a0bce300dee3a6b04195a15ee	false	0x5426f039c05b65dba6ce6e775f1bc24cd057e51a	0x3ef7411383970b54bedec99ddd04b93159293efb	1	39	1	3416358	0xebba467ecb6b21239178033189ceae27ca12eadf	2021-11-28T22:14:13.000Z	999000000000000000000	0x350c56f3644327717197b6949584bb37e4f2ac63be4de78c44496dcd11996742
0x2e3b85f85628301a0bce300dee3a6b04195a15ee	false	0xdbd296c51b1d32f5d8cc58cd6f8a5f70e6d92d33	0x9b11b6d5eaf7dcc3dc2d65067e585ac814a0e29c	1	39	1	3393621	0xebba467ecb6b21239178033189ceae27ca12eadf	2021-11-28T03:10:16.000Z	1000000000000000000000	0xecd8a45cbac197a34472403fbb09a38aa8899e0fa3e4479a238ebc8acc9e8d8e
0x2e3b85f85628301a0bce300dee3a6b04195a15ee	false	0x5426f039c05b65dba6ce6e775f1bc24cd057e51a	0x3ef7411383970b54bedec99ddd04b93159293efb	1	39	1	3415548	0xebba467ecb6b21239178033189ceae27ca12eadf	2021-11-28T21:50:43.000Z	999000000000000000000	0x401798ffe8578b23bfb88d5b9e3b750f2c3ec24c64c8b56e67975b3b471cbf43

Example Query

Query with partition filter

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

TreasureMarketplaceLegacy_UpdateFee_event

Fee update events from the legacy Treasure NFT marketplace contract on Arbitrum. Records historical changes to marketplace fee percentages (in basis points) for analyzing fee structure evolution.

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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
500	0x2e3b85f85628301a0bce300dee3a6b04195a15ee	false	1	2983469	2021-11-11T23:43:40.000Z	0x0190080661f8bb4b14b524411e8bbaa3d76bacfac7b341f1d7bc07e5f997f27e

Example Query

Query with partition filter

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

TreasureMarketplaceLegacy_UpdatePaymentToken_event

Payment token configuration events from Treasure marketplace’s legacy contract on Arbitrum, tracking which tokens (like MAGIC) are added or removed as accepted payment methods. Used for monitoring marketplace payment policy changes and supported currency evolution.

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_paymentToken`	`STRING`	Contract address of the token used for payment in the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_paymentToken	transaction_hash
0x2e3b85f85628301a0bce300dee3a6b04195a15ee	false	4	2983469	2021-11-11T23:43:40.000Z	0x539bde0d7dbd336b79148aa742883198bbf60342	0x0190080661f8bb4b14b524411e8bbaa3d76bacfac7b341f1d7bc07e5f997f27e

Example Query

Query with partition filter

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

TreasureRewarder_LogOnReward_event

Reward distribution events from Treasure protocol’s staking rewarder contract on Arbitrum, tracking token rewards paid to users for pool participation. Used to analyze yield farming rewards, pool performance (PID), and user earnings from Treasure ecosystem staking programs.

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_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x8f2894459026cae358c4613ed6779e515f1f514e	13	0x1a9c20e2b0ac11ebecbdca626bba566c4ce8e606	0x8f2894459026cae358c4613ed6779e515f1f514e	false	266445723794439108032	4	185454638	2024-02-28T20:50:52.000Z	0x3fbdf9b77ac69c304024109ee4c6f40548f623c658469574d37715447479f148
0x88a0b00bbe918ee00e3482f71962070dc052984b	13	0x1a9c20e2b0ac11ebecbdca626bba566c4ce8e606	0x88a0b00bbe918ee00e3482f71962070dc052984b	false	0	41	185455180	2024-02-28T20:53:16.000Z	0xb6ceba05a6e44be48ccab4f3cb204611ea2a1e5f0fecc6972db9504ae4472ddd
0x88a0b00bbe918ee00e3482f71962070dc052984b	13	0x1a9c20e2b0ac11ebecbdca626bba566c4ce8e606	0x88a0b00bbe918ee00e3482f71962070dc052984b	false	17598517519944087984	14	185455180	2024-02-28T20:53:16.000Z	0xb6ceba05a6e44be48ccab4f3cb204611ea2a1e5f0fecc6972db9504ae4472ddd

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

MagicRewardsArbitrum_RewardPaid_event

MagicSwapFactory_PairCreated_event

MagicSwapV2Pair_Burn_event

MagicSwapV2Pair_Mint_event

MagicSwapV2Pair_Swap_event

MagicSwapV2Pair_Sync_event

MagicSwapV2Pair_Transfer_event

TreasureMarketplace_BidAccepted_event

TreasureMarketplace_ItemSold_event

TreasureMarketplace_UpdateCollectionOwnerFee_event

TreasureMarketplace_UpdateFee_event

TreasureMarketplace_UpdateFeeWithCollectionOwner_event

TreasureMarketplaceLegacy_ItemSold_event

TreasureMarketplaceLegacy_UpdateFee_event

TreasureMarketplaceLegacy_UpdatePaymentToken_event

TreasureRewarder_LogOnReward_event

​Tables

​MagicRewardsArbitrum_RewardPaid_event

​MagicSwapFactory_PairCreated_event

​MagicSwapV2Pair_Burn_event

​MagicSwapV2Pair_Mint_event

​MagicSwapV2Pair_Swap_event

​MagicSwapV2Pair_Sync_event

​MagicSwapV2Pair_Transfer_event

​TreasureMarketplace_BidAccepted_event

​TreasureMarketplace_ItemSold_event

​TreasureMarketplace_UpdateCollectionOwnerFee_event

​TreasureMarketplace_UpdateFee_event

​TreasureMarketplace_UpdateFeeWithCollectionOwner_event

​TreasureMarketplaceLegacy_ItemSold_event

​TreasureMarketplaceLegacy_UpdateFee_event

​TreasureMarketplaceLegacy_UpdatePaymentToken_event

​TreasureRewarder_LogOnReward_event

Tables

MagicRewardsArbitrum_RewardPaid_event

MagicSwapFactory_PairCreated_event

MagicSwapV2Pair_Burn_event

MagicSwapV2Pair_Mint_event

MagicSwapV2Pair_Swap_event

MagicSwapV2Pair_Sync_event

MagicSwapV2Pair_Transfer_event

TreasureMarketplace_BidAccepted_event

TreasureMarketplace_ItemSold_event

TreasureMarketplace_UpdateCollectionOwnerFee_event

TreasureMarketplace_UpdateFee_event

TreasureMarketplace_UpdateFeeWithCollectionOwner_event

TreasureMarketplaceLegacy_ItemSold_event

TreasureMarketplaceLegacy_UpdateFee_event

TreasureMarketplaceLegacy_UpdatePaymentToken_event

TreasureRewarder_LogOnReward_event