Trades

The bsc.dex.trades contains successful swaps made on major decentralized exchanges (DEXs), consolidated into a single table.

Project Coverage:

Protocol	Project
uniswap_v3	pancakeswap, sheepdex, apeswap, uniswap, sushiswap
kyberswap_elastic	kyberswap
uniswap_v2	apeswap, demaxswap, julswap, mdex, pancakeswap, biswap, fstswap, bakeryswap, babyswap, sushiswap, bscswap, babydogeswap

Sample Query

Finding the swap volume of indexed projects on Bsc in the last 7 days.

select 
  date(block_timestamp) as date,
  project, 
  sum(usd_amount) as usd_volume 
from bsc.dex.trades
  where current_date - date(block_timestamp) < 7
  group by date, project
  order by date desc 

Table Columns

_str columns are numeric fields casted as varchar to retain precision when summing.

Column Name	Description	Example
project	The project (decentralized exchange) of the liquidity pool that the swap occurred from.	pancakeswap
protocol	Version of the protocol.	uniswap_v2
liquidity_pool_address	Contract address of the liquidity pool holding the asset. For protocol without the concept of LP such as airswap, this will be null.	0xc57ec9ca0449d62c9d5317e28a5f071b02482424
sender_address	The address of the sender emitted on the swap event logs. This can be a router or pool address, which is different from the transaction initiator transaction_from_address that initiated the swap.	0x10ed43c718714eb63d5aa57b78b54704e256024e
to_address	Address of the recipient emitted on the swap event logs. For example, we use the to_address from the uniswap v2 swap event log and the recipient_address from the uniswap v3 swap event log.	0xe8a06830ef55013df00b3d75e514929cc612bb0c
token_sold_address	Token address of the token sold.	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c
token_sold_name	Name of the token sold.	Wrapped BNB
token_sold_symbol	Symbol of the token sold.	WBNB
token_sold_amount_raw	Raw amount of tokens sold (unnormalized).	1e+17
token_sold_amount_raw_str	Raw amount of tokens sold (unnormalized) in string.	100000000000000000
token_sold_amount	Amount of tokens sold.	0.1
token_sold_amount_str	Amount of tokens sold in string.	0.1
usd_sold_amount	Amount of token sold in USD value.	41.89
token_bought_address	Token address of the token bought, i.e. the asset acquired from the trade.	0x8806a68bc665baaefae1f716da42a2443c15bb2f
token_bought_name	Name of the token bought.	Pitch Finance
token_bought_symbol	Symbol of the token bought.	PFT
token_bought_amount_raw	Raw amount of tokens bought (unnormalized).	3.895776739274113e+16
token_bought_amount_raw_str	Raw amount of tokens bought (unnormalized) in string.	38957767392741130
token_bought_amount	Amount of tokens bought.	38957767.39274113
token_bought_amount_str	Amount of tokens bought in string.	38957767.39274113
usd_bought_amount	Amount of token bought in USD value.	nan
usd_amount	USD value of the swap. This field preferentially selects the USD value of ETH and Stablecoin (USDT/USDC) tokens, as spam token prices may conflate the true swap value.	41.89
transaction_from_address	Transaction sender address. I.e. the address of the transaction initiator. (from_address in the raw.transactions field for the transaction_hash of this swap).	0xe8a06830ef55013df00b3d75e514929cc612bb0c
transaction_to_address	Transaction receiver. (to_address in the raw.transactions field for the transaction_hash of this swap).	0x10ed43c718714eb63d5aa57b78b54704e256024e
transaction_hash	Transaction hash that this swap belongs to.	0x2bb21030e7eddf0755adf9390d0919dd7c73c9fa69498fe54c10cb6b3d7591cb
transaction_index	The position of this transaction in the block that it belongs to. The first transaction has index 0.	83
log_index	The position of the swap event log in the transaction.	310
block_timestamp	Block timestamp of the swap event.	2021-10-10 10:37:46+00:00
block_number	Block number of the swap event.	11649329
block_hash	Block hash of the swap event.	0xd28be15b1a3a027394e04bc654935e1885f21fe21d723c6be6b06974c0bb849c
unique_id	Unique ID of the swap.	txn-0x2bb21030e7eddf0755adf9390d0919dd7c73c9fa69498fe54c10cb6b3d7591cb_log_index-310