SwapsNormalizer
Entity:swaps | Table: swaps
Aggregated DEX trade events across all supported Solana protocols. Each row is a single trade with unified fields regardless of the originating protocol.
| Column | Type | Description |
|---|---|---|
block_date | STRING | Block date |
block_time | INT64 | Block timestamp |
block_slot | UINT64 | Slot number |
tx_id | STRING | Transaction signature |
signer | STRING | Transaction signer |
pool_address | STRING | DEX pool address |
base_mint | STRING | Base token mint address |
quote_mint | STRING | Quote token mint address |
base_vault | STRING | Base token vault |
quote_vault | STRING | Quote token vault |
base_amount | DOUBLE | Base token amount |
quote_amount | DOUBLE | Quote token amount |
is_inner_instruction | BOOLEAN | Whether this is an inner instruction |
instruction_index | UINT32 | Instruction index |
instruction_type | STRING | Instruction type |
inner_instruction_index | UINT32 | Inner instruction index |
outer_program | STRING | Outer program ID |
inner_program | STRING | Inner program ID |
txn_fee_lamports | UINT64 | Transaction fee in lamports |
signer_lamports_change | INT64 | Signer SOL balance change |
trader | STRING | Trader address |
spl_token_decimals | INT32 | SPL token decimals |
user_spl_token_pre_balance | UINT64 | Pre-trade token balance (optional) |
user_spl_token_post_balance | UINT64 | Post-trade token balance (optional) |
liquidity_sol | UINT64 | Pool SOL liquidity (optional) |
liquidity_token | UINT64 | Pool token liquidity (optional) |
sequence_number | UINT64 | Sequence number |
protocol_name | STRING | DEX protocol name |
price | DOUBLE | Trade price |
volume | DOUBLE | Trade volume |
price_usd | DOUBLE | Trade price in USD |
volume_usd | DOUBLE | Trade volume in USD |
TransfersNormalizer
Entity:transfers | Table: transfers
SPL token transfers with full source and destination account details.
| Column | Type | Description |
|---|---|---|
slot | UINT64 | Slot number |
tx_hash | STRING | Transaction signature |
mint | STRING | Token mint address |
amount | UINT64 | Transfer amount (raw) |
is_raw_amount | BOOLEAN | Whether amount is in raw units |
token_decimals | UINT32 | Token decimals |
source_address | STRING | Source token account |
source_owner | STRING | Source account owner |
source_pre_balance | UINT64 | Source pre-transfer balance |
source_post_balance | UINT64 | Source post-transfer balance |
source_pre_balance_ui | DOUBLE | Source pre-balance (UI amount) |
source_post_balance_ui | DOUBLE | Source post-balance (UI amount) |
destination_address | STRING | Destination token account |
destination_owner | STRING | Destination account owner |
destination_pre_balance | UINT64 | Dest pre-transfer balance |
destination_post_balance | UINT64 | Dest post-transfer balance |
destination_pre_balance_ui | DOUBLE | Dest pre-balance (UI amount) |
destination_post_balance_ui | DOUBLE | Dest post-balance (UI amount) |