Historical Data Glossary

Historical Data Glossary

trades

ColumnunitPrecisiondescriptionExt. Link
idint
programIdpubkeythe on-chain program interacted with (AMM* == drift protocol mainnet)
recordIdintsequential count of all trades that ever occured (ensures proper ordering vs by the second timestamp)
userAuthoritypublickey
userpublickey
baseAssetAmountint1e13BASE amt of swap (e.g. SOL-PERP)
quoteAssetAmountint1e6USDC of swap
markPriceBeforeint1e10
markPriceAfterint1e10
feeint1e6fee paid to AMM by user for swap
liquidationboolwas trade a forced liquidation
directionLong | Shortdid user go Long (buy) or Short (sell) the Base amt
blockChainTimeStampintseconds(since 1970)unix on-chain time stamp
serverTimeStampintseconds(since 1970)exchange history server off-chain time stamp (can be delayed due to outages)
marketIndexintmarket Index in Markets Account that user swappedmarkets (opens in a new tab)
oraclePriceint1e10oracle price at time of swap (provided by pyth/switchboard)