Finding Centralized Exchange Flows

Let's explore using Flipside's base label system to identify Centralized Exchange deposits and withdrawals.

Leveraging Flipside's base labeling system and on-chain events, you can easily see deposits and withdrawals from key exchanges.

Let's start by learning about ethereum.core.dim_labels.

select
  distinct label_subtype
from
  ethereum.core.dim_labels
where
  label_type = 'cex'
order by
  label_subtype;

As you can see, there are several types of cex labels in dim_labels. Let's look at flows to deposit wallets of Native ETH in the last week.

select
  block_timestamp :: date as block_date,
  label,
  label_subtype,
  sum(amount) as inflows,
  sum(amount_usd) as inflows_usd
from
  ethereum.core.ez_native_transfers t
  join ethereum.core.dim_labels l on to_address = address
  and label_type = 'cex'
  and label_subtype = 'deposit_wallet'
where
  block_timestamp >= current_date() - 7
group by
  all
order by
  block_date desc,
  inflows desc;

Here we can see large flows to popular exchanges such as binance and coinbase. The labels data is extensive and this sample hardly scratches the surface of whats possible with dim_labels.