Whale vs Retail Flow Divergence
SQL of the Week 019
Who Is Really Moving Bitcoin Right Now?
What Is This?
Whale vs Retail Flow Divergence - a model that shows not the direction of price, but who is behind the move.
Standard exchange flow only tells you about volume. This model answers a different question: is institutional capital and retail moving in the same direction - or in opposite ones?
The model compares two flows: the average transaction size on Coinbase Prime (institutional desk) and on Binance (retail-dominant platform). From this, two indicators are built - Institutional Flow Dominance and Retail Flow Divergence - and a market regime based on their relationship.
The core idea: price can rise on retail FOMO just as it can on institutional accumulation - but these are fundamentally different quality moves. This model separates them.
Data is representative from January 11, 2024 - the launch date of Bitcoin ETFs in the US and the beginning of full institutional activity through Coinbase Prime. Data prior to this date is not representative.
Two Components of the Model
Institutional Flow Dominance (IFD) - 30-day moving average of the ratio of the average transaction size on Coinbase Prime to the average transaction size on Binance.
Shows how much larger institutional transactions are on average relative to retail. A high value means institutions dominate by transaction size.
IFD = AVG(CP_inflow_mean / BNB_inflow_mean) over 30 daysRetail Flow Divergence (RFD) - 30-day moving average of the ratio of total Binance inflow to total Coinbase Prime inflow.
Shows how active retail flow is relative to institutional by volume. Rising - the crowd is activating. Falling - institutions are ahead.
RFD = AVG(BNB_inflow_total / CP_inflow_total) over 30 days