flipside

    ERC-20 CEX flow (eth chain)
    onchain_shinobiERC-20 CEX flow (eth chain)
    Updated 2025-03-14
    WITH cex_addresses AS (
    SELECT
    DISTINCT address
    FROM
    ethereum.core.dim_labels
    WHERE
    label_type = 'cex'
    ),
    hourly_flows AS (
    SELECT
    DATE_TRUNC('hour', block_timestamp) as hour,
    contract_address,
    -- Inflows to CEX
    SUM(
    CASE
    WHEN to_address IN (
    SELECT
    address
    FROM
    cex_addresses
    ) THEN amount
    ELSE 0
    END
    ) as cex_inflow,
    -- Outflows from CEX
    SUM(
    CASE
    WHEN from_address IN (
    SELECT
    address
    FROM
    cex_addresses
    ) THEN amount
    ELSE 0
    END
    ) as cex_outflow,
    Last run: about 1 month ago
    HOUR
    CONTRACT_ADDRESS
    CEX_INFLOW
    CEX_OUTFLOW
    NET_FLOW
    TOKEN_PRICE
    INFLOW_USD
    OUTFLOW_USD
    NET_FLOW_USD
    1
    		2025-03-14 14:00:00.0000xba5bde662c17e2adff1075610382b9b6912963507081459.107020615553191.002074261868268.474946350.119955849456.427182657666133.026653818224108.14491219
    2
    		2025-03-14 13:00:00.0000xba5bde662c17e2adff1075610382b9b6912963503626960.579359382675033.082305252948999.250747370.120777438053.417893288323082.470581581356171.282507515
    3
    		2025-03-14 12:00:00.0000xba5bde662c17e2adff1075610382b9b6912963503497023.813504614092109.56266827619840.02896370.121198423832.292149132495955.49477626975123.371830343
    4
    		2025-03-14 11:00:00.0000xba5bde662c17e2adff1075610382b9b6912963506395685.290721995026510.216343173318992.349334030.111524713272.40636248560576.525367456370147.302767129
    5
    		2025-03-14 10:00:00.0000xba5bde662c17e2adff1075610382b9b6912963505427641.205841487766037.23277552251175.0984561510.107798585088.8667073837163.28161873627076.173263376
    6
    		2025-03-14 09:00:00.0000xba5bde662c17e2adff1075610382b9b69129635010352534.84046239025330.984026473634190.381775750.0926958644.72622681835745.649120851336526.029352435
    7
    		2025-03-14 08:00:00.0000xba5bde662c17e2adff1075610382b9b69129635019795050.337774910012766.037180616675731.28407210.0887381756573.17687347888512.8326073331479771.04268599
    8
    		2025-03-14 07:00:00.0000xba5bde662c17e2adff1075610382b9b69129635014618009.348653313722511.76706299937622.824077410.085341247500.917814081171079.15420115848076.731806766
    9
    		2025-03-14 06:00:00.0000xba5bde662c17e2adff1075610382b9b691296350612524.6327627812692.83049-8882.286588340.08548252359.83065782169470.608535946-759.275622144
    10
    		2025-03-14 05:00:00.0000xba5bde662c17e2adff1075610382b9b6912963500346771.75795928-346771.757959280.084391029264.415425942-29264.415425942
    11
    		2025-03-14 04:00:00.0000xba5bde662c17e2adff1075610382b9b691296350046.86584651-46.865846510.08478303.973427065-3.973427065
    12
    		2025-03-14 03:00:00.0000xba5bde662c17e2adff1075610382b9b691296350359230.84312837381415.5542275-22184.711099130.08460230391.64779034632268.518718755-1876.870928409
    13
    		2025-03-14 02:00:00.0000xba5bde662c17e2adff1075610382b9b691296350154349.70744367154359.93539997-10.22795630.08476813083.91600058513084.783003985-0.8670033996
    14
    		2025-03-14 01:00:00.0000xba5bde662c17e2adff1075610382b9b691296350159755.81480159755.81480.08576513701.457456322013701.457456322
    15
    		2025-03-14 00:00:00.0000xba5bde662c17e2adff1075610382b9b691296350123461.17144360429.56122274-236968.389782740.0860510623.83380241231014.963743217-20391.129940805
    16
    		2025-03-13 23:00:00.0000xba5bde662c17e2adff1075610382b9b691296350230653.55520230653.55520.08481619563.111937843019563.111937843
    17
    		2025-03-13 22:00:00.0000xba5bde662c17e2adff1075610382b9b691296350171522.59370171522.59370.08551314667.411555068014667.411555068
    18
    		2025-03-13 21:00:00.0000xba5bde662c17e2adff1075610382b9b691296350541384.9343796.2465483.90.0882947798.87282130353.76649841097.573531
    19
    		2025-03-13 20:00:00.0000xba5bde662c17e2adff1075610382b9b691296350442196.296869954.89846826-422725.042468260.09038439967.47001766478630.003543155-38207.580238451
    20
    		2025-03-13 19:00:00.0000xba5bde662c17e2adff1075610382b9b691296350525066.01633098980640.33687098-240582.144209020.08795946184.28173045786256.143390835-21161.364822481
    ...
    241
    38KB
    12s