Flipside Docs
Search…
Osmosis Fact Airdrops

Table Schema

osmosis.fact_airdrops
Field
Type
Field
block_id
integer
Unique sequential number that identifies the current block. Called "height" on block explorers.
block_timestamp
timestamp
The time the block began.
blockchain
string
Cross-chain identifier. In this table, blockchain will always be Osmosis.
chain_id
string
ID of the blockchain to connect to, i.e. Osmosis-1.
tx_id
string
A unique key that identifies a transaction. Called "TxHash" on block explorers.
tx_status
string
"SUCCEEDED" if the transaction went through, "FALSE" if the transaction failed.
transfer_type
string
The type of transfer that occurred (i.e. IBC transfer)
sender
string
The wallet address of the user that sent the transfer.
amount
integer
The quantity of cryptocurrency sent in the transfer.
currency
string
A string identifying the cryptocurrency sent in the transfer.
decimal
integer
Divide amount by POW(10, decimal) to get the actual amount.
receiver
string
The wallet address of the user that received the transfer.
Copy link