axelar.axelscan Table: ez_gmp_activity Type: Base Table
What
Enhanced Combined EZ GMP Model - The definitive model for all GMP transfer analysis This model provides a complete, unified view of user-initiated GMP transfers across the Axelar network by intelligently combining three complementary data sources. Child GMPs (routing hops with parent_message_id) are excluded to match the metrics API counting methodology, resulting in 99.95% accuracy vs ez_bridge_metrics.-
interchain_transfers (array) - Multiple transfers within a single GMP transaction
- Primarily from Fantom multi-hop transfers
- Contains embedded prices from the API
- ~3% of total transfers (448 records over 7 days)
-
interchain_transfer (singular object) - Single transfer within a GMP transaction
- Primarily from XRPL, Axelar hub, and cross-chain transfers
- Requires price lookups (added in this enhanced version)
- ~21% of total transfers (3,059 records over 7 days)
-
standard_gmp - Traditional GMP transactions without interchain transfer metadata
- All other GMP transactions
- Uses price lookups from ez_gmp_activity
- ~76% of total transfers
- ✅ Price lookups added for singular interchain_transfers (previously NULL)
- ✅ Callback chain information included
- ✅ Parent-child relationship tracking for multi-hop GMPs
- ✅ Excludes child GMPs (parent_message_id IS NULL) to match metrics methodology
- ✅ Accurate destination chains from interchain transfer objects
- ✅ One row per individual transfer (proper granularity)
- ✅ No double-counting (exclusion logic prevents overlap)
- ✅ Transparent data source tracking
- Volume analysis by path (source → destination)
- Multi-hop transfer analysis
- Callback pattern analysis (especially XRPL)
- Cross-chain token flow tracking
- Emerging chain adoption tracking
Columns
| Column Name | Data Type | Description |
|---|---|---|
| GMP_ID | TEXT | GMP_ID column |
| EZ_GMP_ACTIVITY_ID | TEXT | EZ_GMP_ACTIVITY_ID column |
| CREATED_AT | TIMESTAMP_NTZ | CREATED_AT column |
| STATUS | TEXT | STATUS column |
| SIMPLIFIED_STATUS | TEXT | SIMPLIFIED_STATUS column |
| SOURCE_CHAIN | TEXT | SOURCE_CHAIN column |
| DESTINATION_CHAIN | TEXT | DESTINATION_CHAIN column |
| CALLBACK_CHAIN | TEXT | CALLBACK_CHAIN column |
| CALLBACK_DESTINATION_ADDRESS | TEXT | CALLBACK_DESTINATION_ADDRESS column |
| PARENT_MESSAGE_ID | TEXT | PARENT_MESSAGE_ID column |
| TOKEN_SYMBOL | TEXT | TOKEN_SYMBOL column |
| TOKEN_AMOUNT | VARIANT | TOKEN_AMOUNT column |
| TOKEN_AMOUNT_USD | VARIANT | TOKEN_AMOUNT_USD column |
| TOKEN_PRICE_USD | VARIANT | TOKEN_PRICE_USD column |
| PRICE_SOURCE | TEXT | PRICE_SOURCE column |
| SENDER_ADDRESS | TEXT | SENDER_ADDRESS column |
| DESTINATION_CONTRACT_ADDRESS | TEXT | DESTINATION_CONTRACT_ADDRESS column |
| RECIPIENT_ADDRESS | TEXT | RECIPIENT_ADDRESS column |
| TOKEN_CONTRACT_ADDRESS | TEXT | TOKEN_CONTRACT_ADDRESS column |
| SOURCE_TX_HASH | TEXT | SOURCE_TX_HASH column |
| SOURCE_EVENT | TEXT | SOURCE_EVENT column |
| SOURCE_BLOCK_NUMBER | NUMBER | SOURCE_BLOCK_NUMBER column |
| DATA_SOURCE | TEXT | DATA_SOURCE column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |