| block_timestamp | TIMESTAMP_NTZ(9) | UTC timestamp of the block containing this transfer. |
| block_number | NUMBER(38,0) | Height of the block containing this transfer. |
| id | VARCHAR(16777216) | Identifier of the parent transaction (transaction hash) this transfer belongs to. Joins to transactions.id. |
| orchestra_id | VARCHAR(16777216) | Identifier of the Orchestra operation this transfer belongs to, when applicable. |
| output_index | NUMBER(38,0) | Index of the output leg within the parent transaction (UTXO output ordinal). |
| swap_id | VARCHAR(16777216) | Identifier of the swap this transfer is part of, when applicable. |
| transfer_index | NUMBER(38,0) | Sequential index of this transfer within its block. |
| unique_id | VARCHAR(16777216) | Stable primary key of the transfer (derived from transaction id + output index). Key on this to de-duplicate: the same transfer may be re-emitted as its status advances (e.g. sent → confirmed); keep the latest version. |
| asset_type | VARCHAR(16777216) | Asset moved: native (BTC) or token. |
| status | VARCHAR(16777216) | Lifecycle state of the transfer, e.g. sent (pending) or confirmed (final). Treat only confirmed as settled. |
| type | VARCHAR(16777216) | Transfer type, e.g. spark_transfer, lightning_payment, token_transfer, token_multi_transfer, token_mint, token_burn, bitcoin_deposit. |
| transfer_from_address | VARCHAR(16777216) | Canonical sender address. Populated for every transfer type (including multi-transfers) — prefer this over from_address_details for address filters. For Lightning legs this is the sentinel label Lightning Network rather than a Spark address (see transfer_from_type). |
| transfer_from_pubkey | VARCHAR(16777216) | Sender public key, when the sender is a Spark-type endpoint. |
| transfer_from_type | VARCHAR(16777216) | Sender endpoint type, e.g. spark, lightning, issuer. |
| transfer_to_address | VARCHAR(16777216) | Canonical recipient address. Populated for every transfer type — prefer this over to_address_details for address filters. |
| transfer_to_pubkey | VARCHAR(16777216) | Recipient public key, when the recipient is a Spark-type endpoint. |
| transfer_to_type | VARCHAR(16777216) | Recipient endpoint type, e.g. spark, lightning, burn_address. |
| raw_amount_str | VARCHAR(16777216) | Unscaled integer amount in the token’s smallest unit, as a string. Canonical, precision-safe amount — use this for exact math (values can exceed float precision). |
| raw_amount | FLOAT | Unscaled integer amount as a floating-point number. Convenient but lossy for large values; use raw_amount_str when precision matters. |
| amount_str | VARCHAR(16777216) | Decimal-scaled amount (raw_amount_str / 10^token_decimals) as a string. Precision-safe, ready to display. |
| amount | FLOAT | Decimal-scaled amount as a floating-point number. Convenient but lossy; use amount_str when precision matters. |
| token_decimals | NUMBER(38,0) | Number of decimal places for the transferred token (8 for native BTC). Used to scale raw_amount into amount. |
| amount_sats | NUMBER(38,0) | Native BTC amount in satoshis, when the transfer is native. |
| token_amount | NUMBER(38,0) | Token amount in the token’s smallest unit, when the transfer is a token. |
| usd_amount | FLOAT | Indicative USD value of the transfer at scrape time (Sparkscan valueUsd); recomputed per scrape, so treat as approximate rather than a settled value. |
| bitcoin_txid | VARCHAR(16777216) | Underlying Bitcoin L1 transaction id, for transfers that settle on-chain. |
| created_at | TIMESTAMP_NTZ(9) | Timestamp when the transfer was first observed by the indexer. |
| updated_at | TIMESTAMP_NTZ(9) | Timestamp of the most recent indexer update to this transfer (e.g. a sent → confirmed transition). |
| expired_time | TIMESTAMP_NTZ(9) | Expiry timestamp for time-bound transfers (e.g. pending Lightning payments), when applicable. |
| block_timestamp_unix | NUMBER(38,0) | Unix timestamp (seconds) of the block containing this transfer. |
| from_address_details | VARIANT | Structured sender detail (identifier, pubkey, type). Null for token_multi_transfer legs (the API omits a top-level sender there); use transfer_from_address as the canonical sender in all cases. |
| to_address_details | VARIANT | Structured recipient detail (identifier, pubkey, type). Null where the API omits a top-level recipient; use transfer_to_address as the canonical recipient. |
| multi_io_details | VARIANT | Raw UTXO input/output breakdown (inputs[], outputs[], totals) for the parent multi-transfer transaction. |
| token_metadata | VARIANT | Token metadata (name, ticker, decimals, token address/identifier) for token transfers. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
