ramses_v1_arbitrum

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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_stable`	`BOOL`	Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon4`	`STRING`	Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.

Sample Data

address	in_pair	removed	in_anon4	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xaaa20d08e59f6561f242b08513d36266c5a29415	0x7a492402bfe4362a17db3c38b04d17545e08a396	false	8	false	0x2cab3abfc1670d1a452df502e216a66883cdf079	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	26	69982182	2023-03-15T06:06:10.000Z	0x047a878f3267642360f97d27c85e78dcd12f2464925777bdb9225b5fb7122baa
0xaaa20d08e59f6561f242b08513d36266c5a29415	0x040da64a9347c9786069eee1d191a1b9062edc0f	false	4	false	0x539bde0d7dbd336b79148aa742883198bbf60342	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	9	69979870	2023-03-15T05:56:18.000Z	0x00725f180650e51c25ebcaae45046ccabb829aa787c605e071173aefddf2f224
0xaaa20d08e59f6561f242b08513d36266c5a29415	0xce63c58c83ed2aff21c1d5bb85bad93869c632f7	false	10	false	0x03e8d118a1864c7dc53bf91e007ab7d91f5a06fa	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	3	69984892	2023-03-15T06:17:38.000Z	0x911dc625a4afce93c519e5a1983e73b6ceb5481a4bd839f5511c85f45fc34eed

Example Query

Query with partition filter

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

FeeCollector_FeesCollected_event

Fee collection events from Ramses V1 DEX on Arbitrum, tracking trading fee distributions split between fee distributors and treasury per liquidity pool. Used for analyzing protocol revenue allocation and pool-level fee generation patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeDistAmount0`	`STRING`	Amount of the first token allocated to the fee distribution contract, denominated in the token’s smallest unit. Typically represents ~94% of collected fees based on the protocol’s fee split.
`in_feeDistAmount1`	`STRING`	Amount of token1 allocated to fee distribution for liquidity providers, denominated in smallest token units (wei). This field represents the portion of collected trading fees that will be distributed to protocol participants after treasury allocation.
`in_treasuryAmount0`	`STRING`	Amount of token0 allocated to the protocol treasury from collected fees. Denominated in the smallest unit of token0 (wei-equivalent) before decimal adjustment.
`in_treasuryAmount1`	`STRING`	Amount of the second token (token1) allocated to the protocol treasury from collected fees. Denominated in the smallest unit of token1 (e.g., wei for 18-decimal tokens).

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeDistAmount0	in_feeDistAmount1	in_treasuryAmount0	in_treasuryAmount1
0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	0xdf63268af25a2a69c07d09a88336cd9424269a1f	false	25	167699294	2024-01-06T14:00:17.000Z	0x02d07d9b01a2c16972e39d7d8c4c656340acbd8eadb2c6020874ad3402fcfa70	37435206	46988145	2495680	3132543
0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	0xee5f2e39d8abf28e449327bfd44317fc500eb4d8	false	39	167699294	2024-01-06T14:00:17.000Z	0x02d07d9b01a2c16972e39d7d8c4c656340acbd8eadb2c6020874ad3402fcfa70	42384532112269246207	59554088	2825635474151283080	3970272
0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	0x688547381eec7c1d3d9eba778fe275d1d7e03946	false	12	167699294	2024-01-06T14:00:17.000Z	0x02d07d9b01a2c16972e39d7d8c4c656340acbd8eadb2c6020874ad3402fcfa70	52394114255250315	31424562052564731530	3492940950350021	2094970803504315435

Example Query

Query with partition filter

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

LegacyPair_Burn_event

Liquidity removal events from Ramses V1 automated market maker (AMM) pools on Arbitrum, recording the token amounts withdrawn when liquidity providers burn their LP tokens. Used for tracking liquidity exits and analyzing provider behavior in decentralized exchange 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_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
0xda1d9534bef3344fa5be3b644b767b349e7415c7	0x6e0ced11922386900be369cbbf3cdb971dc58487	false	0xaaa87963efeb6f7e0a2711f397663105acb1805e	5	20908925717380988599	30046887876621950349	174529472	2024-01-26T23:49:16.000Z	0xf5f42df7f024041dca02151d95cbeaeafccce6f2cb4a070b3229cba35beb6743
0xaaa87963efeb6f7e0a2711f397663105acb1805e	0x7903da45ae39dfe6f332192e48cde75c74826ab2	false	0xaaa87963efeb6f7e0a2711f397663105acb1805e	6	156106551713993294	303355892586651958959187	174389763	2024-01-26T13:45:19.000Z	0x3d249290bebb8cc44597c2293b44cce7cd897b2c735cb5752cc9076fd74c4dd6
0xd5f4a300ab7a786245281452be9039abc8cc8e40	0xf1a5444a7ed5f24962a118512b076a015b0e6c0b	false	0xaaa87963efeb6f7e0a2711f397663105acb1805e	6	4660962748	1487891874882615004	174335645	2024-01-26T09:56:20.000Z	0x6d43da201ca44a113a126ff255b9c57f5517ed54fb2c533060088a4c46780094

Example Query

Query with partition filter

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

LegacyPair_Claim_event

Fee claim events from Ramses v1 liquidity pools on Arbitrum, recording token0 and token1 amounts withdrawn by liquidity providers. Used for analyzing fee collection patterns and liquidity provider earnings across deprecated pool contracts.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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	in_recipient	block_timestamp	transaction_hash
0x1542d005d7b73c53a75d4cd98a1a6bf3dc27842b	false	0x21798560d203d5127e2ff443ed0ce388907be5de	34	460569973647743147279	5827446802576467	208196347	0x21798560d203d5127e2ff443ed0ce388907be5de	2024-05-05T19:55:12.000Z	0xcd87853de1a5fe74c1e324b44213f1c49ca0f3964cddb8949170d4960329b7df
0x1e50482e9185d9dac418768d14b2f2ac2b4daf39	false	0xafe267681312ed76f0b7aedfe54c8b200ec32cfa	45	0	487178328217732053491	208196347	0xafe267681312ed76f0b7aedfe54c8b200ec32cfa	2024-05-05T19:55:12.000Z	0xcd87853de1a5fe74c1e324b44213f1c49ca0f3964cddb8949170d4960329b7df
0x1e50482e9185d9dac418768d14b2f2ac2b4daf39	false	0xafe267681312ed76f0b7aedfe54c8b200ec32cfa	15	0	626999342117091242957	208009710	0xafe267681312ed76f0b7aedfe54c8b200ec32cfa	2024-05-05T06:55:10.000Z	0x61e9e370b49d7eafd2caec88596548909dfe993839ccf87f60201ceb6e6c115f

Example Query

Query with partition filter

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

LegacyPair_Fees_event

Fee collection events from Ramses V1 legacy liquidity pairs on Arbitrum, tracking trading fee amounts accrued in token0 and token1 for each pair. Used for analyzing fee revenue distribution and liquidity provider earnings across the protocol’s legacy 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_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
0x8e78f0f6d116f94252d3bcd73d8ade63d415c1bf	false	0x0000900e00070d8090169000d2b090b67f0c1050	86	3633373283891208	0	89326247	2023-05-10T17:17:12.000Z	0xe5936b81ece484c053ec917370f5095454cee783073f97b08dc2f802889846cf
0x0f9a90636c778f6a583f7d2212e4921715af4900	false	0x0000900e00070d8090169000d2b090b67f0c1050	31	0	294485681582856501	89260366	2023-05-10T12:43:00.000Z	0xdd1a496662d58964e35d205d9fa54328b018d4f853a3da0de568b165e816174c
0x8e78f0f6d116f94252d3bcd73d8ade63d415c1bf	false	0x0000900e00070d8090169000d2b090b67f0c1050	45	0	497277489827046347	89260366	2023-05-10T12:43:00.000Z	0xdd1a496662d58964e35d205d9fa54328b018d4f853a3da0de568b165e816174c

Example Query

Query with partition filter

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

LegacyPair_Mint_event

Liquidity provision events from Ramses v1 automated market maker (AMM) pools on Arbitrum, capturing token amounts deposited when liquidity providers mint LP (liquidity provider) tokens. Used for tracking liquidity additions, pool growth patterns, and provider behavior 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.
`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
0x8ac36fbce743b632d228f9c2ea5e3bb8603141c7	false	0x11876c56204b2e1e9763a802b7f15fc942ebf1ac	8	23999999999999995805696	882782275415086947	107644299	2023-07-04T02:11:05.000Z	0x979dd1d34abe82c0109d528c5f067d836860f2dc3a4fd8569f827036214e860e
0x8ac36fbce743b632d228f9c2ea5e3bb8603141c7	false	0x11876c56204b2e1e9763a802b7f15fc942ebf1ac	8	11472881029116048965632	422002334185402161	107633798	2023-07-04T01:25:26.000Z	0xbf3e24e44bbdc0d8078932ef2489b5d72b2bf1e557c643d7764825d609f94f9e
0x8ac36fbce743b632d228f9c2ea5e3bb8603141c7	false	0x11876c56204b2e1e9763a802b7f15fc942ebf1ac	36	52152777777777777573888	1918314493161835678	107630389	2023-07-04T01:10:08.000Z	0xc1b76598b6ece57b8c2a41cb61a236fe9cb956164daa6b4a6068c7682bcf351a

Example Query

Query with partition filter

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

LegacyPair_Swap_event

Swap events from Ramses v1 automated market maker (AMM) liquidity pairs on Arbitrum, capturing token exchanges with input/output amounts, sender addresses, and recipient addresses. Used for analyzing DEX trading volume, liquidity pool activity, and token swap patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x42bc6dc56063b54bdabd1eadfda1154bc4fb1fa7	0x040da64a9347c9786069eee1d191a1b9062edc0f	false	0xf851d3d46237ec552a4c6e383a973115e781b1a5	13	265293954	48000000000000	356013648585375774	2024-10-19T02:09:16.000Z	0xea7acce86420d28fec63847c4a02b328fc7d551f98d96704a954e8eb9240554d
0x15c20abcbe11fd7f308169e45464d568df5a4f80	0x4bc5744521ec353670d541b10f9fc6e6f9898af1	false	0x350ba4036048d0920dc9378c0a427eb39bc68621	16	265347523	689119010691385945	1010827885840426045	2024-10-19T05:53:08.000Z	0x9bc55d1ca05df21f3f5646c38ff9e9f7faac5d703e14829aeb2699c4d0351cab
0x9c99764ad164360cf85eda42fa2f4166b6cba2a4	0xfb4fe921f724f3c7b610a826c827f9f6ecef6886	false	0xc3f3a07ae7d2a125ef81a5950c4d0dd54c740251	22	265591265	8478718857341914	9109426489218599	2024-10-19T22:54:58.000Z	0xbaf0cd21b4316edb5482c1ee57b6469af795c77d9aadf9ca253aae99f8495764

Example Query

Query with partition filter

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

LegacyPair_Sync_event

Reserve balance updates for Ramses V1 liquidity pairs on Arbitrum, emitted after swaps or liquidity changes. Used for tracking token inventory levels in automated market maker (AMM) pools and calculating price impacts.

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
0x0c59173c17d5c607b291bf470c5da7d2004d7af5	false	4	898821677569480189689575	15838888709190901625	150270267	2023-11-14T08:36:21.000Z	0xbf20758348267f6737ae57b3682dd6612f2c73bc80fe9bfbade8b01622a95858
0x0c59173c17d5c607b291bf470c5da7d2004d7af5	false	4	872774839069811102262943	15379895577941420092	150416619	2023-11-14T19:02:11.000Z	0xc397f6470418e838ebc2790d9027e27f33c67a928c8fa3b699932dfa50d083d9
0x1e50482e9185d9dac418768d14b2f2ac2b4daf39	false	4	4480917486311354049	178772673929922350261108	150319410	2023-11-14T12:04:01.000Z	0xb061bba0f2790cdbb2d61ad5bb9f592b7696e3e4201c844ca552439825b054dd

Example Query

Query with partition filter

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

Minter_Mint_event

Token minting events from Ramses v1 DEX on Arbitrum, tracking weekly emissions and growth parameters for liquidity mining rewards. Used for analyzing emission schedules and distribution patterns to liquidity providers.

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_weekly`	`STRING`	Weekly token emission amount for the Ramses protocol minting period. Value is expressed in the smallest token unit (wei-equivalent) and occurs on a recurring weekly schedule based on the emission schedule.
`in_growth`	`STRING`	Weekly growth amount of newly minted tokens in the Ramses protocol on Arbitrum. Values are in wei (smallest token unit) and represent the incremental token emission for the period.

Sample Data

address	removed	in_growth	in_sender	in_weekly	log_index	block_number	block_timestamp	transaction_hash
0xaaaa0b6baefaec478eb2d1337435623500ad4594	false	2837346788930297889014665	0xaaa2564deb34763e3d05162ed3f5c2658691f499	4172568807250438072080390	6	112958710	2023-07-20T00:01:33.000Z	0x927def4b97243a985c74d0e7ef7a781e3754d7bfc3ef1bf9aa32ed542fa7681a
0xaaaa0b6baefaec478eb2d1337435623500ad4594	false	2747793102320000770042283	0xaaa2564deb34763e3d05162ed3f5c2658691f499	4431924358580646403294005	7	98872772	2023-06-08T00:00:35.000Z	0x88647cffe55ef8a151bc28761586c4fd17ae69671189b526bd3486089978958a
0xaaaa0b6baefaec478eb2d1337435623500ad4594	false	339842574514853399229398	0xaaa2564deb34763e3d05162ed3f5c2658691f499	1699212872574266996146994	130	259771875	2024-10-03T00:00:04.000Z	0x0702177948806a924c3a86ee80716afb522bbde5f56f9523dd2bfb9dc78b3806

Example Query

Query with partition filter

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

Pair_Claim_event

Claim events from liquidity pool pair contracts recording amounts of both tokens withdrawn by liquidity providers. Tracks sender address, recipient address, and claimed amounts in smallest token denomination for both token0 and token1.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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	block_number	in_recipient	block_timestamp	transaction_hash
0xbd8121b651a9374bdd08a005bc59ff067930dba6	false	0xcabd6a398cb93338c105b40df984da8d91aafe9b	304	123622094	0xcabd6a398cb93338c105b40df984da8d91aafe9b	2023-08-21T18:01:49.000Z	0xacf7a9bac43393968912e9e83711bab070aa130964f1c79af8158c9558edf6de
0xbd8121b651a9374bdd08a005bc59ff067930dba6	false	0xcabd6a398cb93338c105b40df984da8d91aafe9b	525	84173008	0xcabd6a398cb93338c105b40df984da8d91aafe9b	2023-04-25T14:25:47.000Z	0xd8fb55681e2e2f504508fc0b1896cb125d6f88aefd2e5905208805dd39a46067
0xbd8121b651a9374bdd08a005bc59ff067930dba6	false	0xcabd6a398cb93338c105b40df984da8d91aafe9b	525	84257492	0xcabd6a398cb93338c105b40df984da8d91aafe9b	2023-04-25T20:17:49.000Z	0xf888064b25f8d77ef2b4cf9d20419e0d59ddb9f6f61c70e3e6b82be92ca2d9bc

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

FeeCollector_FeesCollected_event

LegacyPair_Burn_event

LegacyPair_Claim_event

LegacyPair_Fees_event

LegacyPair_Mint_event

LegacyPair_Swap_event

LegacyPair_Sync_event

Minter_Mint_event

Pair_Claim_event

​Tables

​Factory_PairCreated_event

​FeeCollector_FeesCollected_event

​LegacyPair_Burn_event

​LegacyPair_Claim_event

​LegacyPair_Fees_event

​LegacyPair_Mint_event

​LegacyPair_Swap_event

​LegacyPair_Sync_event

​Minter_Mint_event

​Pair_Claim_event

Tables

Factory_PairCreated_event

FeeCollector_FeesCollected_event

LegacyPair_Burn_event

LegacyPair_Claim_event

LegacyPair_Fees_event

LegacyPair_Mint_event

LegacyPair_Swap_event

LegacyPair_Sync_event

Minter_Mint_event

Pair_Claim_event