Tables
FungibleAsset_Deposit_event
Fungible asset deposit events from the Aptos blockchain, capturing token transfers into store addresses with deposit amounts and transaction context. Used for tracking token inflows, wallet activity, and asset accumulation patterns across Aptos-based applications.Columns
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. |
sequence_number | STRING | Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination). |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
event_type | STRING | Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons. |
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. |
event_guid_account_address | STRING | Account address component of the eventβs globally unique identifier. Hex-encoded string with 0x prefix. |
event_guid_creation_number | INT64 | Creation number component of the eventβs globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address. |
data | JSON | Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data. |
in_store | STRING | Fungible asset store identifier where the asset is held. Hex-encoded, 0x-prefixed, 66-character string. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| data | in_store | in_amount | event_type | event_index | block_height | block_timestamp | sequence_number | transaction_hash | event_guid_account_address | event_guid_creation_number |
|---|---|---|---|---|---|---|---|---|---|---|
| {βamountβ:β10β,βstoreβ:β0x90f1b7d6d9a032f5d65384cac9384b6c242ddee3028d3a74d1efe59dfb14875eβ} | 0x90f1b7d6d9a032f5d65384cac9384b6c242ddee3028d3a74d1efe59dfb14875e | 10 | 0x1::fungible_asset::Deposit | 2 | 190703993 | 2024-06-15T00:00:00.192Z | 0 | 0x54883aea85f3719d37215f444970f57e74e9af63ec4a10a348aaef33f4b31fb7 | 0x0 | 0 |
| {βamountβ:β10β,βstoreβ:β0x90f1b7d6d9a032f5d65384cac9384b6c242ddee3028d3a74d1efe59dfb14875eβ} | 0x90f1b7d6d9a032f5d65384cac9384b6c242ddee3028d3a74d1efe59dfb14875e | 10 | 0x1::fungible_asset::Deposit | 2 | 190704011 | 2024-06-15T00:00:04.708Z | 0 | 0x977f464a89bef5671d5016a5ed8bc1a67e29d09dced0dd87d4a759de49a598bc | 0x0 | 0 |
| {βamountβ:β9639711825β,βstoreβ:β0x33481efff7c1153d50a545ff5f2f5090df5e7d5f54b135bbf4afd95d10bc1214β} | 0x33481efff7c1153d50a545ff5f2f5090df5e7d5f54b135bbf4afd95d10bc1214 | 9639711825 | 0x1::fungible_asset::Deposit | 2 | 190704014 | 2024-06-15T00:00:05.454Z | 0 | 0xeb135e20be0044d5ec500664732ba79436828fb0f430050789c8dba09c564b5e | 0x0 | 0 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.aptos_v1_aptos.FungibleAsset_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
FungibleAsset_Withdraw_event
Withdrawal events for fungible assets on Aptos blockchain, capturing token amounts removed from specific store addresses with transaction context. Used for tracking token outflows, analyzing wallet activity, and monitoring liquidity movements across Aptos fungible asset protocols.Columns
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. |
sequence_number | STRING | Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination). |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
event_type | STRING | Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons. |
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. |
event_guid_account_address | STRING | Account address component of the eventβs globally unique identifier. Hex-encoded string with 0x prefix. |
event_guid_creation_number | INT64 | Creation number component of the eventβs globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address. |
data | JSON | Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data. |
in_store | STRING | Fungible asset store identifier where the asset is held. Hex-encoded, 0x-prefixed, 66-character string. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| data | in_store | in_amount | event_type | event_index | block_height | block_timestamp | sequence_number | transaction_hash | event_guid_account_address | event_guid_creation_number |
|---|---|---|---|---|---|---|---|---|---|---|
| {βamountβ:β276322054β,βstoreβ:β0x14875a239e95a772fc83b901aefae81c74bb70dd98a0b11b6a391c730e8af48cβ} | 0x14875a239e95a772fc83b901aefae81c74bb70dd98a0b11b6a391c730e8af48c | 276322054 | 0x1::fungible_asset::Withdraw | 0 | 217946388 | 2024-08-25T00:00:00.415Z | 0 | 0x0937dd08e52d3673b5f8763a89da9a85e10d6226b3646980b5ed42ff8d929b02 | 0x0 | 0 |
| {βamountβ:β9567388244β,βstoreβ:β0xa6cc934e614b9f6c4947b05201c32618a4fa66ed42f39068c1e7a5385f891103β} | 0xa6cc934e614b9f6c4947b05201c32618a4fa66ed42f39068c1e7a5385f891103 | 9567388244 | 0x1::fungible_asset::Withdraw | 11 | 217946390 | 2024-08-25T00:00:00.808Z | 0 | 0x04ccac8d01d38ffb12ad57a32b6f98a139464fc705c95f6c0adfdef8c5d91669 | 0x0 | 0 |
| {βamountβ:β1693077β,βstoreβ:β0x76a207142b833e23ef855663194fbaa3ec3e12eda8344f1dfb69025ab59f87c0β} | 0x76a207142b833e23ef855663194fbaa3ec3e12eda8344f1dfb69025ab59f87c0 | 1693077 | 0x1::fungible_asset::Withdraw | 11 | 217946509 | 2024-08-25T00:00:25.645Z | 0 | 0x513bf0f54c6c851cc135e1889c35ef3d5e54d1eb6459fe820480893455964c0d | 0x0 | 0 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.aptos_v1_aptos.FungibleAsset_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100