avnu_v1_starknet

Tables

Exchange_Swap_event

Token swap execution records from AVNU decentralized exchange aggregator on Starknet. Contains sell/buy token addresses, amounts, taker accounts, and beneficiaries for analyzing DEX trading volume and routing 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_taker_address`	`STRING`	Starknet address of the account initiating the swap transaction on the AVNU v1 exchange. Hex-encoded identifier without 0x prefix, typically matches the beneficiary address in single-user swaps.
`in_sell_address`	`STRING`	Token contract address being sold by the taker in this swap transaction. Hex-encoded Starknet address format without 0x padding to full length.
`in_sell_amount`	`STRING`	Token amount being sold by the taker in the swap transaction, denominated in the smallest unit of the sell token. Values are stored as strings to preserve precision for tokens with high decimal places.
`in_buy_address`	`STRING`	Contract address of the token being purchased in the swap on Starknet. Hex-encoded Starknet address format without 0x prefix padding.
`in_buy_amount`	`STRING`	Amount of tokens received (bought) in the swap transaction, denominated in the token’s smallest unit. Values are large integers representing atomic units before decimal adjustment.
`in_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	signature	event_name	block_number	in_buy_amount	in_beneficiary	in_buy_address	in_sell_amount	block_timestamp	in_sell_address	in_taker_address	transaction_hash
0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f	false	10	0xe316f0d9d2a3affa97de1d99bb2aac0538e2666d0d8545545ead241ef0ccab	Swap	271944	6827451758891832	0x28a278910b2e3d5fcf80c4202942630cc8c0cd5491155356856bea805a5c37d	0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7	109867983480218595299	2023-09-29T00:29:52.000Z	0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49	0x28a278910b2e3d5fcf80c4202942630cc8c0cd5491155356856bea805a5c37d	0x71e971d9fb4c253289b996b9d06af43fd7132a96518d26fcaa126fd81cb4ca
0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f	false	8	0xe316f0d9d2a3affa97de1d99bb2aac0538e2666d0d8545545ead241ef0ccab	Swap	271970	1976618615753166	0x30b6b5efd0f7e85166a7c5818dec0f3db71e24d29b63d2c42eda7330daec206	0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7	32000000000000000000	2023-09-29T00:48:08.000Z	0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49	0x30b6b5efd0f7e85166a7c5818dec0f3db71e24d29b63d2c42eda7330daec206	0x26c307eec176252735c6a37f41e45866ceb664ce7220e426c95dba29ef407f4
0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f	false	10	0xe316f0d9d2a3affa97de1d99bb2aac0538e2666d0d8545545ead241ef0ccab	Swap	271971	1759860843381482521	0x46b97def096e0e3b04775155945211485e35f763fd214cd227cc4824154cca2	0xda114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3	17191080000000000000	2023-09-29T00:48:55.000Z	0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49	0x46b97def096e0e3b04775155945211485e35f763fd214cd227cc4824154cca2	0x5cff383908c90b79748ed4ef4a9136cf3113e5f05844a35cac1840ee7962a37

Example Query

Query with partition filter

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

aurafinance_v1_polygon axelar_v1_arbitrum

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Exchange_Swap_event

​Tables

​Exchange_Swap_event

Tables

Exchange_Swap_event