🗃️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)