alitaslimiArbitrum CEXs Net Flow Exchange Daily
    Updated 2024-01-30
    with
    cexs as (
    select
    address,
    case project_name
    when 'binance' then 'Binance'
    when 'bitfinex' then 'Bitfinex'
    when 'bitstamp' then 'Bitstamp'
    when 'bybit' then 'Bybit'
    when 'coinbase' then 'Coinbase'
    when 'gate.io' then 'Gate.io'
    when 'gemini' then 'Gemini'
    when 'huobi' then 'Huobi'
    when 'kraken' then 'Kraken'
    when 'kucoin' then 'KuCoin'
    when 'okex' then 'OKX'
    when 'okx' then 'OKX'
    when 'mexc' then 'MEXC'
    when 'mxc' then 'MEXC'
    end as exchange
    from
    arbitrum.core.dim_labels
    where
    label_type = 'cex'
    ),
    transfers_raw as (
    select
    block_timestamp,
    tx_hash,
    eth_from_address as sender,
    eth_to_address as receiver,
    amount_usd
    from
    arbitrum.core.ez_eth_transfers
    where
    block_timestamp::date >= (current_date - 10)
    Last run: about 1 year agoAuto-refreshes every 6 hours
    Date
    Exchange
    Values
    1
    2024-01-28 00:00:00.000Binance19562841.2805953
    2
    2024-01-28 00:00:00.000Bitfinex-29049.569
    3
    2024-01-28 00:00:00.000Bybit-4208207.60965846
    4
    2024-01-28 00:00:00.000Gate.io1355832.7445596
    5
    2024-01-28 00:00:00.000KuCoin145238.184005795
    6
    2024-01-28 00:00:00.000OKX-5608278.76534192
    7
    2024-01-27 00:00:00.000Binance14072894.4021104
    8
    2024-01-27 00:00:00.000Bitfinex1884.5147
    9
    2024-01-27 00:00:00.000Bybit-8022462.00505657
    10
    2024-01-27 00:00:00.000Coinbase8.67099879
    11
    2024-01-27 00:00:00.000Gate.io2657530.50079023
    12
    2024-01-27 00:00:00.000KuCoin-7366.248977139
    13
    2024-01-27 00:00:00.000OKX3572163.45429924
    14
    2024-01-26 00:00:00.000Binance20624998.5007203
    15
    2024-01-26 00:00:00.000Bitfinex-166122.540196
    16
    2024-01-26 00:00:00.000Bybit-7436706.59168971
    17
    2024-01-26 00:00:00.000Gate.io3106932.51209892
    18
    2024-01-26 00:00:00.000Kraken0
    19
    2024-01-26 00:00:00.000KuCoin59655.408467378
    20
    2024-01-26 00:00:00.000OKX9543150.07063099
    57
    3KB
    23s