Skip to main content

​
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.
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.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_taker_addressSTRINGStarknet 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_addressSTRINGToken contract address being sold by the taker in this swap transaction. Hex-encoded Starknet address format without 0x padding to full length.
in_sell_amountSTRINGToken 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_addressSTRINGContract address of the token being purchased in the swap on Starknet. Hex-encoded Starknet address format without 0x prefix padding.
in_buy_amountSTRINGAmount 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_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexsignatureevent_nameblock_numberin_buy_amountin_beneficiaryin_buy_addressin_sell_amountblock_timestampin_sell_addressin_taker_addresstransaction_hash
0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0ffalse100xe316f0d9d2a3affa97de1d99bb2aac0538e2666d0d8545545ead241ef0ccabSwap27194468274517588918320x28a278910b2e3d5fcf80c4202942630cc8c0cd5491155356856bea805a5c37d0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc71098679834802185952992023-09-29T00:29:52.000Z0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b490x28a278910b2e3d5fcf80c4202942630cc8c0cd5491155356856bea805a5c37d0x71e971d9fb4c253289b996b9d06af43fd7132a96518d26fcaa126fd81cb4ca
0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0ffalse80xe316f0d9d2a3affa97de1d99bb2aac0538e2666d0d8545545ead241ef0ccabSwap27197019766186157531660x30b6b5efd0f7e85166a7c5818dec0f3db71e24d29b63d2c42eda7330daec2060x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7320000000000000000002023-09-29T00:48:08.000Z0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b490x30b6b5efd0f7e85166a7c5818dec0f3db71e24d29b63d2c42eda7330daec2060x26c307eec176252735c6a37f41e45866ceb664ce7220e426c95dba29ef407f4
0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0ffalse100xe316f0d9d2a3affa97de1d99bb2aac0538e2666d0d8545545ead241ef0ccabSwap27197117598608433814825210x46b97def096e0e3b04775155945211485e35f763fd214cd227cc4824154cca20xda114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3171910800000000000002023-09-29T00:48:55.000Z0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b490x46b97def096e0e3b04775155945211485e35f763fd214cd227cc4824154cca20x5cff383908c90b79748ed4ef4a9136cf3113e5f05844a35cac1840ee7962a37
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