Osmosis Fact Airdrops

Table Schema

osmosis.core.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.