osmosis.core Table: fact_airdrop Type: View
Record of the OSMO airdrop to ATOM stakers.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_ID | TEXT | A unique key that identifies a transaction. Called “TxHash” on block explorers. |
| TX_SUCCEEDED | BOOLEAN | Transaction status is “TRUE” if the transaction was successful, “FALSE” if the transaction failed. |
| TRANSFER_TYPE | TEXT | Details on the type of transfer occurring during the transaction. “IBC_Transfer_In” = depositing tokens onto Osmosis. “IBC_transfer_out” = withdrawing tokens from Osmosis. “Osmosis” = wallet to wallet transfer on Osmosis. |
| SENDER | TEXT | The wallet address of the individual sent tokens in the transfer. |
| AMOUNT | NUMBER | The amount that was used in the transaction message. |
| CURRENCY | TEXT | The currency that was used in the transaction message. |
| DECIMAL | NUMBER | Divide the amount by POW(10, decimal) to get the amount used in the transaction. This value can be NULL, as decimals are hand curated from an outside source and not found on-chain. |
| RECEIVER | TEXT | The wallet address of the individual received tokens in the transfer. |
| FACT_AIRDROPS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |