2min

Historical Data Glossary

trades
Column
unit
Precision
description
Ext. Link
id
int
﻿
﻿
﻿
programId
pubkey
﻿
the on-chain program interacted with 
(damm* == drift protocol mainnet)
﻿
recordId
int
﻿
sequential count of all trades that ever occured (ensures proper ordering vs by the second timestamp)
﻿
userAuthority
publickey
﻿
﻿
﻿
user
publickey
﻿
﻿
﻿
baseAssetAmount
int
1e13
BASE amt of swap (e.g. SOL-PERP)
﻿
quoteAssetAmount
int
1e6
USDC of swap
﻿
markPriceBefore
int
1e10
﻿
﻿
markPriceAfter
int
1e10
﻿
﻿
fee
int
1e6
fee paid to vAMM by user for swap
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
liquidation
bool
﻿
was trade a forced liquidation
﻿
direction
Long | Short
﻿
did user go Long (buy) or Short (sell) the Base amt
﻿
blockChainTimeStamp
int
seconds
(since 1970)
unix on-chain time stamp 
﻿
serverTimeStamp
int
seconds
(since 1970)
exchange history server off-chain time stamp 
(can be delayed due to outages)
﻿
marketIndex
int
﻿
market Index in Markets Account that user swapped
﻿markets﻿
﻿
﻿
﻿
﻿
﻿
oraclePrice
int
1e10
oracle price at time of swap 
(provided by pyth/switchboard)
﻿
﻿
﻿
﻿
﻿

Updated 12 Apr 2022

Did this page help?

Yes

UP NEXT

API

Documentation powered by archbee

Updated 12 Apr 2022

Did this page help?

Yes

UP NEXT

API

Column	unit	Precision	description	Ext. Link
id	int
programId	pubkey		the on-chain program interacted with (damm* == drift protocol mainnet)
recordId	int		sequential count of all trades that ever occured (ensures proper ordering vs by the second timestamp)
userAuthority	publickey
user	publickey
baseAssetAmount	int	1e13	BASE amt of swap (e.g. SOL-PERP)
quoteAssetAmount	int	1e6	USDC of swap
markPriceBefore	int	1e10
markPriceAfter	int	1e10
fee	int	1e6	fee paid to vAMM by user for swap



liquidation	bool		was trade a forced liquidation
direction	Long \| Short		did user go Long (buy) or Short (sell) the Base amt
blockChainTimeStamp	int	seconds (since 1970)	unix on-chain time stamp
serverTimeStamp	int	seconds (since 1970)	exchange history server off-chain time stamp (can be delayed due to outages)
marketIndex	int		market Index in Markets Account that user swapped	markets

oraclePrice	int	1e10	oracle price at time of swap (provided by pyth/switchboard)