🗃

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, where available
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)

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)

Dex Trades

Dex Trader Use Cases

Last modified 1mo ago