Nansen Query Documentation
Search…
⌃K
🗃

Dex Trader P&L

The Dex Trader P&L table is a running (hourly) calculation of an addresses profit and losses (P&L) by token. The P&L only takes into consideration tokens that have been bought and sold on major Dexes and have had some volume.
In this table, each row represent the P&L each trader has for each token as a result of a trade.
  • Rows are only created when a trader makes an eligible trade
  • Prices are the hourly trade weighted average price
The dex trader P&L table uses the following nomenclature: dex_trader_stats_by_hour_token
Field name
Type
Description
block_hour
TIMESTAMP
Hour in which the trading activity took place
trader
STRING
The trader's address
token
STRING
The traded token's address
symbol
STRING
The traded token's symbol
block_hour_trades
REPEATED STRING
Transaction hashes of all trades in block_hour involving this token
bought_token
FLOAT
Total units of token purchased in block_hour
bought_usd
FLOAT
Total $ value of token purchased in block_hour
sold_token
FLOAT
Total units of token sold in block_hour
sold_usd
FLOAT
Total $ value of token sold in block_hour
valid_sold_token
FLOAT
Total units of token sold in block_hour, up to the total amount purchased on DEXs
valid_sold_usd
FLOAT
Total $ value of token sold in block_hour, up to the total amount purchased on DEXs
block_hour_profit
FLOAT
total_profit difference between current block_hour and block_hour the token was last traded, excluding transaction fees
block_hour_fees_usd
FLOAT
Total $ value of transaction fees spent in the block_hour on trades involving the token
total_fees_usd
FLOAT
All time $ value of transaction fees spent on trades involving the token
total_profit
FLOAT
All time realised PnL for the token up to the block_hour, including transaction fees
end_valid_balance
FLOAT
Total units of token held at the end of the block_hour (only ones purchased on DEXs)
end_valid_balance_usd
FLOAT
$ value of token held at the end of the block_hour, (only ones purchased on DEXs)
Last modified 14d ago