osmosis_v1_osmosis

Tables

Swap_token_swapped_event

Token swap execution events from Osmosis automated market maker (AMM) pools. Contains input/output token amounts with IBC (Inter-Blockchain Communication) denominations and pool identifiers for analyzing DEX trading activity and liquidity routing.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`message_index`	`STRING`	Index position of the message within the transaction that triggered this swap event. Typically ‘0’ for single-message transactions, increments for multi-message batches.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens_in`	`STRING`	Amount and denomination of tokens sent into the pool during the swap. Format is `\{amount\}\{denom\}` where denom is either a native token (e.g., `uosmo`) or IBC token hash.
`in_tokens_out`	`STRING`	Token denomination and amount sent out from the liquidity pool during the swap. Formatted as amount followed by denomination (either native ‘uosmo’ or IBC-prefixed hash for cross-chain tokens).
`in_pool_id`	`STRING`	Unique identifier of the Osmosis liquidity pool where the token swap occurred. Numeric pool ID stored as string, typically ranging from three to four digits.
`source`	`STRING`	Address or identifier of the entity that initiated or originated the transaction or event.

Sample Data

source	in_sender	in_pool_id	event_index	block_height	in_tokens_in	in_tokens_out	block_timestamp	transaction_hash	transaction_index
me	osmo100lk5kh7279k50nvvp907k6kfzwk9z2rp73zn3	565	56	18495743	2597400000ibc/0EF15DF2F02480ADE0BB6E85D9EBB5DAEA2836D3860E9F97F9AADE4F57A31AA0	35578ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2	2024-07-27T08:58:54.643Z	43E9FD5595C2A43FF88A5C3FC4396EB53116C77BE9A1147FAAE4A46B123DA565	2
me	osmo100lk5kh7279k50nvvp907k6kfzwk9z2rp73zn3	1838	51	18495743	35539ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2	222347ibc/498A0751C798A0D9A389AA3691123DADA57DAA4FE165D5C75894505B876BA6E4	2024-07-27T08:58:54.643Z	43E9FD5595C2A43FF88A5C3FC4396EB53116C77BE9A1147FAAE4A46B123DA565	2
me	osmo100lk5kh7279k50nvvp907k6kfzwk9z2rp73zn3	561	60	18495743	23376600000ibc/0EF15DF2F02480ADE0BB6E85D9EBB5DAEA2836D3860E9F97F9AADE4F57A31AA0	4106795uosmo	2024-07-27T08:58:54.643Z	43E9FD5595C2A43FF88A5C3FC4396EB53116C77BE9A1147FAAE4A46B123DA565	2

Example Query

Query with partition filter

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

Transfer_transfer_event

Transfer events from Osmosis blockchain showing token movements between accounts with sender, recipient, and amount data. Used for tracking asset flows and analyzing on-chain transfer activity across the Osmosis DEX ecosystem.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`message_index`	`STRING`	Identifier linking the transfer event to a specific message within the transaction that triggered it. Frequently null when events are not directly associated with individual messages in the transaction payload.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`source`	`STRING`	Address or identifier of the entity that initiated or originated the transaction or event.

Sample Data

source	event_index	block_height	block_timestamp	transaction_hash	transaction_index
me	13	11499304	2023-09-18T00:00:09.524Z	00F6D4BEEF02A9099A6F8C81D1999F40BEF7BD6A3FD4B81D90689CEFB00D0A6B	14
me	7	11499304	2023-09-18T00:00:09.524Z	00F6D4BEEF02A9099A6F8C81D1999F40BEF7BD6A3FD4B81D90689CEFB00D0A6B	14
me	58	11499304	2023-09-18T00:00:09.524Z	09E7CFBA2881497F6B91E62DE60B0671293393A25DDA3891B96BA217771B17DD	8

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Swap_token_swapped_event

Transfer_transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Swap_token_swapped_event

​Transfer_transfer_event

Tables

Swap_token_swapped_event

Transfer_transfer_event