# Sol TopUps vs. Sol Funding vs. Transfers — what is the difference?

> A worked guide to SOL top-ups, native SOL funding and token transfers, with real transactions, queries and results.

**Education · Solana wallets**

Three families of tables answer the question "who paid this wallet?". They record different things. Pick the wrong one and your query runs fine but tells you the wrong story. This page shows what each table stores, with queries you can copy.

17 Nov 2026 · 12 min read · Beginner

**The short version**

- **Top-ups**. `sol_top_ups` gets a row when a SOL balance goes from zero to above zero. Use it to find fresh wallets.
- **Fundings**. `indexer3_sol_fundings` gets a row when one wallet loses SOL and another gains it, whatever the balances were before. Small amounts are left out.
- **Token transfers**. `token_transfers` gets a row when a token (USDC, wSOL, any mint) moves from one owner to another.

## The same wallet, seen three ways

All three tables are built from successful transactions only. A failed transaction changes nothing, so it leaves no row.

<div className="wallet-walkthrough-figure">
  <figure className="oa-figure">
    <div className="oa-figure__frame">
      <div className="oa-figure__head">
        <div>
          <div className="oa-figure__title">What makes a row in each table</div>
          <div className="oa-figure__sub">Illustration.</div>
        </div>
      </div>
      <div>
        <div className="oa-lane oa-topup">
          <div>
            <div className="oa-lane__name"><svg className="oa-glyph oa-topup" viewBox="0 0 16 16" fill="none" stroke="currentColor" strokeWidth="1.75" strokeLinecap="round" strokeLinejoin="round" aria-hidden="true"><circle cx="8" cy="8" r="6.25" /><path d="M8 5.1v5.8M5.1 8h5.8" /></svg>Top-ups</div>
            <div className="oa-lane__table">sol_top_ups</div>
            <div className="oa-lane__note">A SOL balance goes from zero to above zero.</div>
          </div>
          <svg className="oa-svg" viewBox="0 0 400 84" role="img" aria-label="A signer sends SOL to a wallet whose balance was zero">
            <path className="edge" d="M118,42 L274,42" strokeWidth="3" />
            <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(280 42) rotate(0)" />
            <circle className="packet" r="4">
              <animateMotion path="M118,42 L274,42" dur="2.6s" begin="0s" repeatCount="indefinite" />
            </circle>
            <g>
              <rect className="node" x="6" y="24" width="112" height="36" rx="18" />
              <text className="t-ink" x="62" y="46.5" textAnchor="middle" fontSize="13">Signer</text>
            </g>
            <g>
              <rect className="node node--new" x="282" y="24" width="112" height="36" rx="18" />
              <text className="t-ink" x="338" y="46.5" textAnchor="middle" fontSize="13">Empty wallet</text>
            </g>
            <text className="t-ink" x="200" y="30" textAnchor="middle" fontSize="13">0 → 0.0035 SOL</text>
            <text x="200" y="64" textAnchor="middle" fontSize="12">any amount</text>
          </svg>
        </div>
        <div className="oa-lane oa-funding">
          <div>
            <div className="oa-lane__name"><svg className="oa-glyph oa-funding" viewBox="0 0 16 16" fill="none" stroke="currentColor" strokeWidth="1.75" strokeLinecap="round" strokeLinejoin="round" aria-hidden="true"><circle cx="8" cy="8" r="6.25" strokeDasharray="2.6 2.3" /><circle cx="8" cy="8" r="2.4" fill="currentColor" stroke="none" /></svg>Fundings</div>
            <div className="oa-lane__table">indexer3_sol_fundings</div>
            <div className="oa-lane__note">One wallet loses SOL and another gains it, whatever the balance was.</div>
          </div>
          <svg className="oa-svg" viewBox="0 0 400 120" role="img" aria-label="A wallet that already holds SOL receives more, several times; each change above 0.09 SOL is recorded">
            <path className="edge" d="M118,50 C168,16 232,16 275,47" strokeWidth="2" />
            <path className="edge" d="M118,60 L274,60" strokeWidth="2" />
            <path className="edge" d="M118,70 C168,104 232,104 275,73" strokeWidth="2" />
            <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(280 51) rotate(36)" />
            <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(280 60) rotate(0)" />
            <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(280 69) rotate(-36)" />
            <circle className="packet" r="4">
              <animateMotion path="M118,50 C168,16 232,16 275,47" dur="2.4s" begin="0s" repeatCount="indefinite" />
            </circle>
            <circle className="packet" r="4">
              <animateMotion path="M118,60 L274,60" dur="2.4s" begin="0.8s" repeatCount="indefinite" />
            </circle>
            <circle className="packet" r="4">
              <animateMotion path="M118,70 C168,104 232,104 275,73" dur="2.4s" begin="1.6s" repeatCount="indefinite" />
            </circle>
            <g>
              <rect className="node" x="6" y="42" width="112" height="36" rx="18" />
              <text className="t-ink" x="62" y="64.5" textAnchor="middle" fontSize="13">Wallet A</text>
            </g>
            <g>
              <rect className="node" x="282" y="42" width="112" height="36" rx="18" />
              <text className="t-ink" x="338" y="64.5" textAnchor="middle" fontSize="13">Wallet B</text>
            </g>
            <text className="t-ink" x="200" y="14" textAnchor="middle" fontSize="13">every change above 0.09 SOL</text>
            <text x="200" y="115" textAnchor="middle" fontSize="12">balance before can be anything</text>
          </svg>
        </div>
        <div className="oa-lane oa-transfer">
          <div>
            <div className="oa-lane__name"><svg className="oa-glyph oa-transfer" viewBox="0 0 16 16" fill="none" stroke="currentColor" strokeWidth="1.75" strokeLinecap="round" strokeLinejoin="round" aria-hidden="true"><path d="M2 5.25h11.5M10.75 2.5 13.5 5.25 10.75 8" /><path d="M14 10.75H2.5M5.25 8 2.5 10.75 5.25 13.5" /></svg>Token transfers</div>
            <div className="oa-lane__table">token_transfers</div>
            <div className="oa-lane__note">A token moves from one owner to another.</div>
          </div>
          <svg className="oa-svg" viewBox="0 0 400 96" role="img" aria-label="Two owners send tokens to each other">
            <path className="edge" d="M118,38 L274,38" strokeWidth="2" />
            <path className="edge" d="M282,58 L126,58" strokeWidth="2" />
            <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(280 38) rotate(0)" />
            <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(120 58) rotate(180)" />
            <circle className="packet" r="4">
              <animateMotion path="M118,38 L274,38" dur="2.8s" begin="0s" repeatCount="indefinite" />
            </circle>
            <circle className="packet" r="4">
              <animateMotion path="M282,58 L126,58" dur="2.8s" begin="1.4s" repeatCount="indefinite" />
            </circle>
            <g>
              <rect className="node" x="6" y="30" width="112" height="36" rx="18" />
              <text className="t-ink" x="62" y="52.5" textAnchor="middle" fontSize="13">Owner A</text>
            </g>
            <g>
              <rect className="node" x="282" y="30" width="112" height="36" rx="18" />
              <text className="t-ink" x="338" y="52.5" textAnchor="middle" fontSize="13">Owner B</text>
            </g>
            <text className="t-ink" x="200" y="26" textAnchor="middle" fontSize="13">USDC, wSOL, any mint</text>
            <text x="200" y="82" textAnchor="middle" fontSize="12">Token and Token-2022</text>
          </svg>
        </div>
      </div>
    </div>
    <figcaption>
      <span className="oa-label">Fig. 1</span>
      <span>Top-ups look for a balance that starts at zero. Fundings look for any large SOL change between wallets. Token transfers follow tokens, not SOL.</span>
    </figcaption>
  </figure>
</div>

The difference is easiest to see on one wallet over time. In the chart below the wallet is paid three times, trades once, and is emptied once. Only some of these events become rows.

<WalletTimeline>
  <figure className="oa-figure">
    <div className="oa-figure__frame">
      <div className="oa-figure__head">
        <div>
          <div className="oa-figure__title">One wallet, six balance changes</div>
          <div className="oa-figure__sub">SOL balance. Illustration.</div>
        </div>
      </div>
      <ul className="oa-legend oa-legend--block">
        <li className="oa-topup"><i className="oa-swatch" />Top-up row + funding row</li>
        <li className="oa-funding"><i className="oa-swatch" />Funding row only</li>
        <li className="oa-none"><i className="oa-swatch" />No row</li>
      </ul>
      <div className="oa-chart oa-chart--wide">
        <svg className="oa-svg" viewBox="0 0 690 310" role="img" aria-label="Step chart of one wallet&#x27;s SOL balance over 14 days. It is topped up from zero to 2.00 SOL on day 1, receives 0.50 SOL on day 5 and 0.05 SOL on day 7, is emptied on day 9 and topped up from zero again on day 12.">
          <g>
            <line className="axis" x1="38" x2="672" y1="282" y2="282" />
            <text x="30" y="286" textAnchor="end" fontSize="12">0.0</text>
          </g>
          <g>
            <line className="grid" x1="38" x2="672" y1="227.2173913043478" y2="227.2173913043478" />
            <text x="30" y="231.2173913043478" textAnchor="end" fontSize="12">0.5</text>
          </g>
          <g>
            <line className="grid" x1="38" x2="672" y1="172.43478260869563" y2="172.43478260869563" />
            <text x="30" y="176.43478260869563" textAnchor="end" fontSize="12">1.0</text>
          </g>
          <g>
            <line className="grid" x1="38" x2="672" y1="117.65217391304347" y2="117.65217391304347" />
            <text x="30" y="121.65217391304347" textAnchor="end" fontSize="12">1.5</text>
          </g>
          <g>
            <line className="grid" x1="38" x2="672" y1="62.86956521739128" y2="62.86956521739128" />
            <text x="30" y="66.86956521739128" textAnchor="end" fontSize="12">2.0</text>
          </g>
          <text x="38" y="304" textAnchor="middle" fontSize="12">Day 0</text>
          <text x="128.57142857142856" y="304" textAnchor="middle" fontSize="12">2</text>
          <text x="219.14285714285714" y="304" textAnchor="middle" fontSize="12">4</text>
          <text x="309.7142857142857" y="304" textAnchor="middle" fontSize="12">6</text>
          <text x="400.2857142857143" y="304" textAnchor="middle" fontSize="12">8</text>
          <text x="490.8571428571429" y="304" textAnchor="middle" fontSize="12">10</text>
          <text x="581.4285714285714" y="304" textAnchor="middle" fontSize="12">12</text>
          <text x="672" y="304" textAnchor="middle" fontSize="12">14</text>
          <path className="area" d="M38,282 H83.28571428571428 V62.86956521739128 H173.85714285714286 V128.6086956521739 H264.42857142857144 V73.82608695652175 H355 V68.3478260869565 H445.5714285714286 V282 H581.4285714285714 V172.43478260869563 H672 V282 H38 Z" />
          <path className="line" d="M38,282 H83.28571428571428 V62.86956521739128 H173.85714285714286 V128.6086956521739 H264.42857142857144 V73.82608695652175 H355 V68.3478260869565 H445.5714285714286 V282 H581.4285714285714 V172.43478260869563 H672" />
          <g className="oa-topup">
            <line className="riser" x1="83.28571428571428" x2="83.28571428571428" y1="282" y2="62.86956521739128" />
            <circle className="dot" cx="83.28571428571428" cy="62.86956521739128" r="5" />
          </g>
          <g className="oa-none">
            <line className="riser" x1="173.85714285714286" x2="173.85714285714286" y1="62.86956521739128" y2="128.6086956521739" />
            <circle className="dot" cx="173.85714285714286" cy="128.6086956521739" r="5" />
          </g>
          <g className="oa-funding">
            <line className="riser" x1="264.42857142857144" x2="264.42857142857144" y1="128.6086956521739" y2="73.82608695652175" />
            <circle className="dot" cx="264.42857142857144" cy="73.82608695652175" r="5" />
          </g>
          <g className="oa-none">
            <line className="riser" x1="355" x2="355" y1="73.82608695652175" y2="68.3478260869565" />
            <circle className="dot" cx="355" cy="68.3478260869565" r="5" />
          </g>
          <g className="oa-funding">
            <line className="riser" x1="445.5714285714286" x2="445.5714285714286" y1="68.3478260869565" y2="282" />
            <circle className="dot" cx="445.5714285714286" cy="282" r="5" />
          </g>
          <g className="oa-topup">
            <line className="riser" x1="581.4285714285714" x2="581.4285714285714" y1="282" y2="172.43478260869563" />
            <circle className="dot" cx="581.4285714285714" cy="172.43478260869563" r="5" />
          </g>
          <text className="t-ink" x="94.28571428571428" y="53.86956521739128" fontSize="12">Top-up: 0 → 2.00</text>
          <text className="t-ink" x="264.42857142857144" y="61.82608695652175" textAnchor="middle" fontSize="12">+0.50</text>
          <text x="361" y="85.3478260869565" textAnchor="start" fontSize="12">+0.05, dust</text>
          <text className="t-ink" x="455.5714285714286" y="139.56521739130434" fontSize="12">−1.95, wallet emptied</text>
          <text className="t-ink" x="672" y="160.43478260869563" textAnchor="end" fontSize="12">Top-up again: 0 → 1.00</text>
          <rect className="hit" x="38" y="22" width="90.57142857142856" height="260" data-wallet-event="Day 1 · Receives 2.00 SOL · +2.00 SOL · Balance 0.00 → 2.00 · Top-up row + funding row" aria-label="Day 1 · Receives 2.00 SOL · +2.00 SOL · Balance 0.00 → 2.00 · Top-up row + funding row" tabIndex="0" />
          <rect className="hit" x="128.57142857142856" y="22" width="90.57142857142858" height="260" data-wallet-event="Day 3 · Buys a token from a pool · -0.60 SOL · Balance 2.00 → 1.40 · No row" aria-label="Day 3 · Buys a token from a pool · -0.60 SOL · Balance 2.00 → 1.40 · No row" tabIndex="0" />
          <rect className="hit" x="219.14285714285714" y="22" width="90.57142857142858" height="260" data-wallet-event="Day 5 · Receives 0.50 SOL · +0.50 SOL · Balance 1.40 → 1.90 · Funding row only" aria-label="Day 5 · Receives 0.50 SOL · +0.50 SOL · Balance 1.40 → 1.90 · Funding row only" tabIndex="0" />
          <rect className="hit" x="309.7142857142857" y="22" width="90.57142857142856" height="260" data-wallet-event="Day 7 · Receives 0.05 SOL · +0.05 SOL · Balance 1.90 → 1.95 · No row" aria-label="Day 7 · Receives 0.05 SOL · +0.05 SOL · Balance 1.90 → 1.95 · No row" tabIndex="0" />
          <rect className="hit" x="400.2857142857143" y="22" width="113.21428571428572" height="260" data-wallet-event="Day 9 · Sends everything out · -1.95 SOL · Balance 1.95 → 0.00 · Funding row only" aria-label="Day 9 · Sends everything out · -1.95 SOL · Balance 1.95 → 0.00 · Funding row only" tabIndex="0" />
          <rect className="hit" x="513.5" y="22" width="158.5" height="260" data-wallet-event="Day 12 · Receives 1.00 SOL · +1.00 SOL · Balance 0.00 → 1.00 · Top-up row + funding row" aria-label="Day 12 · Receives 1.00 SOL · +1.00 SOL · Balance 0.00 → 1.00 · Top-up row + funding row" tabIndex="0" />
        </svg>
      </div>
      <div className="oa-chart oa-chart--narrow">
        <svg className="oa-svg" viewBox="0 0 358 270" role="img" aria-label="Step chart of one wallet&#x27;s SOL balance over 14 days. It is topped up from zero to 2.00 SOL on day 1, receives 0.50 SOL on day 5 and 0.05 SOL on day 7, is emptied on day 9 and topped up from zero again on day 12.">
          <g>
            <line className="axis" x1="30" x2="348" y1="242" y2="242" />
            <text x="22" y="246" textAnchor="end" fontSize="11">0.0</text>
          </g>
          <g>
            <line className="grid" x1="30" x2="348" y1="195.91304347826087" y2="195.91304347826087" />
            <text x="22" y="199.91304347826087" textAnchor="end" fontSize="11">0.5</text>
          </g>
          <g>
            <line className="grid" x1="30" x2="348" y1="149.82608695652175" y2="149.82608695652175" />
            <text x="22" y="153.82608695652175" textAnchor="end" fontSize="11">1.0</text>
          </g>
          <g>
            <line className="grid" x1="30" x2="348" y1="103.7391304347826" y2="103.7391304347826" />
            <text x="22" y="107.7391304347826" textAnchor="end" fontSize="11">1.5</text>
          </g>
          <g>
            <line className="grid" x1="30" x2="348" y1="57.65217391304347" y2="57.65217391304347" />
            <text x="22" y="61.65217391304347" textAnchor="end" fontSize="11">2.0</text>
          </g>
          <text x="30" y="264" textAnchor="middle" fontSize="11">Day 0</text>
          <text x="75.42857142857142" y="264" textAnchor="middle" fontSize="11">2</text>
          <text x="120.85714285714285" y="264" textAnchor="middle" fontSize="11">4</text>
          <text x="166.28571428571428" y="264" textAnchor="middle" fontSize="11">6</text>
          <text x="211.7142857142857" y="264" textAnchor="middle" fontSize="11">8</text>
          <text x="257.1428571428571" y="264" textAnchor="middle" fontSize="11">10</text>
          <text x="302.57142857142856" y="264" textAnchor="middle" fontSize="11">12</text>
          <text x="348" y="264" textAnchor="middle" fontSize="11">14</text>
          <path className="area" d="M30,242 H52.71428571428571 V57.65217391304347 H98.14285714285714 V112.95652173913044 H143.57142857142856 V66.86956521739131 H189 V62.26086956521738 H234.42857142857144 V242 H302.57142857142856 V149.82608695652175 H348 V242 H30 Z" />
          <path className="line" d="M30,242 H52.71428571428571 V57.65217391304347 H98.14285714285714 V112.95652173913044 H143.57142857142856 V66.86956521739131 H189 V62.26086956521738 H234.42857142857144 V242 H302.57142857142856 V149.82608695652175 H348" />
          <g className="oa-topup">
            <line className="riser" x1="52.71428571428571" x2="52.71428571428571" y1="242" y2="57.65217391304347" />
            <circle className="dot" cx="52.71428571428571" cy="57.65217391304347" r="5" />
          </g>
          <g className="oa-none">
            <line className="riser" x1="98.14285714285714" x2="98.14285714285714" y1="57.65217391304347" y2="112.95652173913044" />
            <circle className="dot" cx="98.14285714285714" cy="112.95652173913044" r="5" />
          </g>
          <g className="oa-funding">
            <line className="riser" x1="143.57142857142856" x2="143.57142857142856" y1="112.95652173913044" y2="66.86956521739131" />
            <circle className="dot" cx="143.57142857142856" cy="66.86956521739131" r="5" />
          </g>
          <g className="oa-none">
            <line className="riser" x1="189" x2="189" y1="66.86956521739131" y2="62.26086956521738" />
            <circle className="dot" cx="189" cy="62.26086956521738" r="5" />
          </g>
          <g className="oa-funding">
            <line className="riser" x1="234.42857142857144" x2="234.42857142857144" y1="62.26086956521738" y2="242" />
            <circle className="dot" cx="234.42857142857144" cy="242" r="5" />
          </g>
          <g className="oa-topup">
            <line className="riser" x1="302.57142857142856" x2="302.57142857142856" y1="242" y2="149.82608695652175" />
            <circle className="dot" cx="302.57142857142856" cy="149.82608695652175" r="5" />
          </g>
          <text className="t-ink" x="63.71428571428571" y="48.65217391304347" fontSize="11">0 → 2.00</text>
          <text className="t-ink" x="143.57142857142856" y="54.86956521739131" textAnchor="middle" fontSize="11">+0.50</text>
          <text x="211.7142857142857" y="79.26086956521738" textAnchor="middle" fontSize="11">+0.05</text>
          <text className="t-ink" x="244.42857142857144" y="122.17391304347825" fontSize="11">−1.95 to zero</text>
          <text className="t-ink" x="348" y="137.82608695652175" textAnchor="end" fontSize="11">again: 0 → 1.00</text>
          <rect className="hit" x="30" y="22" width="45.428571428571416" height="220" data-wallet-event="Day 1 · Receives 2.00 SOL · +2.00 SOL · Balance 0.00 → 2.00 · Top-up row + funding row" aria-label="Day 1 · Receives 2.00 SOL · +2.00 SOL · Balance 0.00 → 2.00 · Top-up row + funding row" tabIndex="0" />
          <rect className="hit" x="75.42857142857142" y="22" width="45.42857142857143" height="220" data-wallet-event="Day 3 · Buys a token from a pool · -0.60 SOL · Balance 2.00 → 1.40 · No row" aria-label="Day 3 · Buys a token from a pool · -0.60 SOL · Balance 2.00 → 1.40 · No row" tabIndex="0" />
          <rect className="hit" x="120.85714285714285" y="22" width="45.42857142857143" height="220" data-wallet-event="Day 5 · Receives 0.50 SOL · +0.50 SOL · Balance 1.40 → 1.90 · Funding row only" aria-label="Day 5 · Receives 0.50 SOL · +0.50 SOL · Balance 1.40 → 1.90 · Funding row only" tabIndex="0" />
          <rect className="hit" x="166.28571428571428" y="22" width="45.428571428571416" height="220" data-wallet-event="Day 7 · Receives 0.05 SOL · +0.05 SOL · Balance 1.90 → 1.95 · No row" aria-label="Day 7 · Receives 0.05 SOL · +0.05 SOL · Balance 1.90 → 1.95 · No row" tabIndex="0" />
          <rect className="hit" x="211.7142857142857" y="22" width="56.785714285714306" height="220" data-wallet-event="Day 9 · Sends everything out · -1.95 SOL · Balance 1.95 → 0.00 · Funding row only" aria-label="Day 9 · Sends everything out · -1.95 SOL · Balance 1.95 → 0.00 · Funding row only" tabIndex="0" />
          <rect className="hit" x="268.5" y="22" width="79.5" height="220" data-wallet-event="Day 12 · Receives 1.00 SOL · +1.00 SOL · Balance 0.00 → 1.00 · Top-up row + funding row" aria-label="Day 12 · Receives 1.00 SOL · +1.00 SOL · Balance 0.00 → 1.00 · Top-up row + funding row" tabIndex="0" />
        </svg>
      </div>
    </div>
    <figcaption>
      <span className="oa-label">Fig. 2</span>
      <span>The first payment and the payment after the wallet was emptied are top-ups, because the balance started at zero. The 0.50 SOL payment is only a funding. The 0.05 SOL payment and the token purchase are in neither table. Hover or tap for details.</span>
    </figcaption>
  </figure>
</WalletTimeline>

## Two servers, two history depths

The tables live on two servers. Tables without a prefix are on the main server and keep about one month. Tables that start with `indexer3_` are on a second server and keep much more history. This query prints the current first day of each one:

**SQLhistory_depth.sql**

<WalletExample>

```sql
-- How far back each table goes today.
SELECT *
FROM
(
    SELECT 'sol_top_ups' AS table_name, min(block_date_utc) AS first_day,
           toTimeZone(max(block_time), 'UTC') AS last_row_utc
    FROM sol_top_ups
    UNION ALL
    SELECT 'token_transfers', min(block_date_utc), toTimeZone(max(block_time), 'UTC')
    FROM token_transfers
    UNION ALL
    SELECT 'indexer3_sol_top_ups', min(block_date_utc), toTimeZone(max(block_time), 'UTC')
    FROM indexer3_sol_top_ups
    UNION ALL
    SELECT 'indexer3_sol_fundings', min(block_date_utc), toTimeZone(max(block_time), 'UTC')
    FROM indexer3_sol_fundings
    UNION ALL
    SELECT 'indexer3_token_transfers', min(block_date_utc), toTimeZone(max(block_time), 'UTC')
    FROM indexer3_token_transfers
)
ORDER BY first_day DESC, table_name
```

</WalletExample>

**Result** · 5 rows · this code ran on 2026-11-18 01:10 UTC

| `table_name` | `first_day` | `last_row_utc` |
| --- | --- | --- |
| sol_top_ups | 2026-10-18 | 2026-11-18 01:10:02 |
| token_transfers | 2026-10-18 | 2026-11-18 01:10:02 |
| indexer3_sol_top_ups | 2026-08-20 | 2026-11-18 01:10:05 |
| indexer3_sol_fundings | 2026-08-01 | 2026-11-18 01:10:05 |
| indexer3_token_transfers | 2026-08-01 | 2026-11-18 01:10:05 |

You query all of them through the same connection. Two things are different for the `indexer3_` tables:

- **Joins are slower.** The data has to travel between servers. Filter the `indexer3_` table by wallet, slot or date first, then join.
- **Use `GLOBAL IN` for subqueries.** If you filter an `indexer3_` table with a list that comes from a main-server table, write `GLOBAL IN (SELECT ...)`. A plain `IN` is sent to the second server as it is, and that server does not have the main tables. Keep that list simple: build it with a join, not with another subquery inside it. A nested subquery there can silently return nothing.

<Note>

**About times**

`block_time` is shown in the time zone of the main server, which is US Pacific time, not UTC. The examples on this page wrap it in `toTimeZone(block_time, 'UTC')` so every time you see here is UTC.

</Note>

|  | Top-ups | Fundings | Token transfers |
| --- | --- | --- | --- |
| A row means | A SOL balance went from 0 to above 0 | One wallet lost SOL and another gained SOL in the same transaction | A token moved from one owner to another |
| Smallest amount | Any | More than 0.09 SOL, on both sides | Any |
| Sender column | Each signer of the transaction | Each wallet that lost SOL | Owner of the source token account |
| Signature | Yes | No. Use slot and tx_idx | Yes in token_transfers, no in indexer3_token_transfers |
| Kept for | 31 days. 180 days in indexer3_sol_top_ups | No expiry so far | 31 days. No expiry so far in indexer3_token_transfers |
| Program accounts | Included as receivers | Left out | In token_transfers only |

## Top-ups: from zero to above zero

`sol_top_ups` has one simple rule. After every successful transaction we compare each account's SOL balance before and after. If it was exactly zero before and is above zero after, we write a row. Token accounts are skipped.

Here is a good transaction to learn from. One wallet pays five others with five plain transfers: [open it on Solscan](https://solscan.io/tx/KfjE2rhYq66UuMjZhbgwB7rxXkwnbfH8dvPmNY1dxjv3Ngw2bgC4mHrLXdeX6BBoz82mcQtK9NyeXWKLwPRmACb#balance_change) and look at the balance changes.

**SQLtop_ups_one_tx.sql**

<WalletExample>

```sql
-- One transaction that pays five wallets with five System Program transfers.
-- sol_top_ups keeps only the wallets whose balance was zero before.
SELECT
    dst_wallet,
    amount,
    src_wallet,
    JSONLength(top_level_transfers_json) AS transfers_in_tx,
    signature
FROM sol_top_ups
WHERE block_date_utc = '2026-11-17'
  AND signature = 'KfjE2rhYq66UuMjZhbgwB7rxXkwnbfH8dvPmNY1dxjv3Ngw2bgC4mHrLXdeX6BBoz82mcQtK9NyeXWKLwPRmACb'
```

</WalletExample>

**Result** · 3 rows · this code ran on 2026-11-18 01:10 UTC

| `dst_wallet` | `amount` | `src_wallet` | `transfers_in_tx` | `signature` |
| --- | --- | --- | --- | --- |
| [`CfmG…699S`](https://solscan.io/account/CfmGBMdnuTVHNDWSQ8iCRQF4e1wRTT2aeKKyZYB3699S) | 3,500,000 | [`2BJb…mzWj`](https://solscan.io/account/2BJbdM2onBjRFDPQ7gw33K4FTe3actfr4uemi73nmzWj) | 5 | [`KfjE2r…mACb`](https://solscan.io/tx/KfjE2rhYq66UuMjZhbgwB7rxXkwnbfH8dvPmNY1dxjv3Ngw2bgC4mHrLXdeX6BBoz82mcQtK9NyeXWKLwPRmACb#balance_change) |
| [`6oK1…Xs4d`](https://solscan.io/account/6oK1n8sPhqjwtGKhFTVXHW2NHXCJEEgR6zMmjSNLXs4d) | 3,500,000 | [`2BJb…mzWj`](https://solscan.io/account/2BJbdM2onBjRFDPQ7gw33K4FTe3actfr4uemi73nmzWj) | 5 | [`KfjE2r…mACb`](https://solscan.io/tx/KfjE2rhYq66UuMjZhbgwB7rxXkwnbfH8dvPmNY1dxjv3Ngw2bgC4mHrLXdeX6BBoz82mcQtK9NyeXWKLwPRmACb#balance_change) |
| [`GX2L…NUAE`](https://solscan.io/account/GX2LjaPw5co9onSapZxRowh5QRR7PnK5vRLjkdfbNUAE) | 3,500,000 | [`2BJb…mzWj`](https://solscan.io/account/2BJbdM2onBjRFDPQ7gw33K4FTe3actfr4uemi73nmzWj) | 5 | [`KfjE2r…mACb`](https://solscan.io/tx/KfjE2rhYq66UuMjZhbgwB7rxXkwnbfH8dvPmNY1dxjv3Ngw2bgC4mHrLXdeX6BBoz82mcQtK9NyeXWKLwPRmACb#balance_change) |

Five transfers, but only three rows. The three wallets in the result had a zero balance before the transaction. The other two receivers, `Asgard3A…6Bh6` and `71DDZTmG…1vKu`, already held SOL, so for this table nothing happened to them.

Three details matter when you read these rows:

- **`amount` is the balance after the transaction.** Because the balance before was zero, this is also what the wallet received.
- **`src_wallet` is a signer of the transaction.** It is the wallet that signed, which is usually the wallet that paid, but not always. A transaction with two signers gives two rows for the same receiver.
- **`dst_wallet` is any account that came to life.** Most are wallets. Some are accounts created by programs, such as a Pump.fun bonding curve or a stake account. Join with your own list of wallets when you need wallets only.

### A wallet can be topped up many times

The name suggests a top-up happens once. It does not. Every time a wallet is drained to zero and paid again, it gets a new row. The wallet below collects profits for an arbitrage bot. Its owner empties it after each payout, so each payout starts from zero again:

**SQLtop_ups_many_times.sql**

<WalletExample>

```sql
-- A top-up is not a once-in-a-lifetime event. This wallet is emptied and
-- refilled all day, and every refill from zero is a new row.
SELECT
    toTimeZone(block_time, 'UTC') AS block_time_utc,
    amount / 1e9 AS sol,
    src_wallet,
    signature
FROM sol_top_ups
WHERE block_date_utc = '2026-11-17'
  AND dst_wallet = '6gnVbP38GXVgseLGRTN52rhzfHsyfKzzSK1Z5SuykuQZ'
ORDER BY slot, tx_idx
```

</WalletExample>

**Result** · 7 rows · this code ran on 2026-11-18 01:10 UTC

| `block_time_utc` | `sol` | `src_wallet` | `signature` |
| --- | --- | --- | --- |
| 2026-11-17 16:13:25 | 0.5394 | [`3WWd…aTLZ`](https://solscan.io/account/3WWddu8qzSKtLsf8zHZSeRraZUWDGjLxmeYqD67BaTLZ) | [`5wBzYL…G2kY`](https://solscan.io/tx/5wBzYLgeitwPw2vyRZE1vNQFhDqbKb3bYiJ3bvzaHwjEs44DDYJ5NjzPqT5HHHtRs5ZSnUzGMsbQzMw7BGXtG2kY#balance_change) |
| 2026-11-17 16:52:13 | 3.4674 | [`3zMJ…y6vi`](https://solscan.io/account/3zMJccz2CTLewG4iNaCHa1cCrU3rFtdJ9WgNcSK8y6vi) | [`21uCJU…Q9cZ`](https://solscan.io/tx/21uCJU4nE6DDTz3NGNiHjW8y7UgCYMr4VwHUPR4VuzSYZPy8wBp26xnA8izESXfkPfcibq4PDkhhThRdzhDuQ9cZ#balance_change) |
| 2026-11-17 16:52:13 | 3.4674 | [`EbsU…KnE7`](https://solscan.io/account/EbsUZEFAU23Z2SgAymFtU2hADLiyNLzaPLKiJfvpKnE7) | [`21uCJU…Q9cZ`](https://solscan.io/tx/21uCJU4nE6DDTz3NGNiHjW8y7UgCYMr4VwHUPR4VuzSYZPy8wBp26xnA8izESXfkPfcibq4PDkhhThRdzhDuQ9cZ#balance_change) |
| 2026-11-17 23:18:47 | 0.1861 | [`3WWd…aTLZ`](https://solscan.io/account/3WWddu8qzSKtLsf8zHZSeRraZUWDGjLxmeYqD67BaTLZ) | [`2vrtWc…JqJK`](https://solscan.io/tx/2vrtWc7Xt7cqMTspcGSAf74qPmE91PEqWTK3cFS1XRrKRABSg5UqRByHLnV2wEgRvPmpvN7nY38zPxoJCf22JqJK#balance_change) |
| 2026-11-17 23:25:25 | 0.211 | [`3WWd…aTLZ`](https://solscan.io/account/3WWddu8qzSKtLsf8zHZSeRraZUWDGjLxmeYqD67BaTLZ) | [`5drtNH…bhsb`](https://solscan.io/tx/5drtNHjcDZWaBZN2MAp1BxuvgVuobZKMTp2tUhsuee38UvAix7n1zkxmtwNoquAmckmYPC7CyheXVeJDxDmTbhsb#balance_change) |
| 2026-11-17 23:28:58 | 0.1981 | [`3WWd…aTLZ`](https://solscan.io/account/3WWddu8qzSKtLsf8zHZSeRraZUWDGjLxmeYqD67BaTLZ) | [`4GwYi7…vR8G`](https://solscan.io/tx/4GwYi73NL6at95nAuR9oYKQJBdhmu29kmRqaQkS5ZSbqJem7EqbjdQj6B2RkyqqhGqaSZEjQaaLyCtVmkvV9vR8G#balance_change) |
| 2026-11-17 23:34:12 | 0.1983 | [`3WWd…aTLZ`](https://solscan.io/account/3WWddu8qzSKtLsf8zHZSeRraZUWDGjLxmeYqD67BaTLZ) | [`3ovXx2…CAVj`](https://solscan.io/tx/3ovXx2hAwbfRFsSP5NhKvcZ16KUboWEYjXtw4EEVCx5FjmtjKAWXF3T8gRGUbn9HESm825aiqPDrnh8CAjmJCAVj#balance_change) |

Two of the rows share a time and an amount but show different senders. That is one transaction with two signers.

If you want the first top-up of a wallet, take the earliest row. Keep the 31-day window in mind: a wallet that was first paid two months ago has its first top-up in `indexer3_sol_top_ups`, not here.

### What top-ups are good for: fresh wallets

A wallet that was empty a few minutes before it does something important is a fresh wallet. Fresh wallets are how people hide who they are. So "when was this wallet last filled from zero?" is a strong signal, and `sol_top_ups` answers it with one lookup.

The query below takes the last 1,000 Pump.fun launches that trade against SOL. For each launch it finds two numbers: how long before the launch the creator's wallet was topped up, and how many different wallets bought in the first minute. Then it counts launches in each combination.

**SQLcreator_top_up_heatmap.sql**

<WalletExample>

```sql
-- Last 1,000 Pump.fun launches quoted in SOL.
-- x: how long before the launch the creator wallet was last topped up from zero.
-- y: how many different wallets bought in the first minute.
WITH
    launches AS
    (
        SELECT
            trim(BOTH '\0' FROM toString(mint)) AS mint,
            trim(BOTH '\0' FROM toString(creator)) AS creator,
            block_time AS launched_at
        FROM pumpfun_token_creation
        WHERE quote_coin = '11111111111111111111111111111111' -- SOL
          AND block_time < now() - INTERVAL 2 MINUTE
        ORDER BY slot DESC, tx_idx DESC
        LIMIT 1000
    ),
    top_ups AS
    (
        SELECT dst_wallet, block_time
        FROM sol_top_ups
        WHERE dst_wallet IN (SELECT creator FROM launches)
    ),
    buys AS
    (
        SELECT base_coin, signing_wallet, block_time
        FROM pumpfun_v2_swaps
        WHERE block_date_utc >= (SELECT toDate(min(launched_at)) FROM launches)
          AND failed = 0
          AND direction = 'buy'
          AND base_coin IN (SELECT mint FROM launches)
    ),
    per_launch AS
    (
        SELECT
            l.mint AS mint,
            dateDiff(
                'second',
                maxIf(t.block_time, t.block_time <= l.launched_at),
                any(l.launched_at)
            ) AS top_up_age,
            uniqExactIf(
                b.signing_wallet,
                b.block_time < l.launched_at + INTERVAL 1 MINUTE
            ) AS buyers
        FROM launches AS l
        LEFT JOIN top_ups AS t ON t.dst_wallet = l.creator
        LEFT JOIN buys AS b ON b.base_coin = l.mint
        GROUP BY l.mint
    )
SELECT
    -- no top-up found means the last one is older than the table (31 days)
    multiIf(top_up_age < 60, 1, top_up_age < 600, 2, top_up_age < 3600, 3,
            top_up_age < 21600, 4, top_up_age < 86400, 5,
            top_up_age < 31 * 86400, 6, 7) AS age_bucket,
    ['<1 min', '1-10 min', '10-60 min', '1-6 h', '6-24 h', '1-31 d', 'older'][age_bucket]
        AS topped_up_before_launch,
    multiIf(buyers <= 1, 1, buyers <= 3, 2, buyers <= 7, 3,
            buyers <= 15, 4, buyers <= 31, 5, 6) AS buyers_bucket,
    ['0-1', '2-3', '4-7', '8-15', '16-31', '32+'][buyers_bucket]
        AS buyers_in_first_minute,
    count() AS launches
FROM per_launch
GROUP BY age_bucket, buyers_bucket
ORDER BY age_bucket, buyers_bucket
```

</WalletExample>

**Result** · 42 rows · this code ran on 2026-11-18 01:10 UTC

<div className="wallet-walkthrough-figure">
  <div className="oa-heat">
    <div className="oa-heat__ylabel">↑ Wallets buying in the first minute</div>
    <div className="oa-heat__grid">
      <div className="oa-heat__row">
        <div className="oa-heat__ytick">32+</div>
        <div className="oa-heat__cell" data-heat="38%" title="18 launches · Creator wallet topped up before launch: &lt;1 min · Wallets buying in the first minute: 32+">18</div>
        <div className="oa-heat__cell" data-heat="25%" title="8 launches · Creator wallet topped up before launch: 1-10 min · Wallets buying in the first minute: 32+">8</div>
        <div className="oa-heat__cell" data-heat="18%" title="4 launches · Creator wallet topped up before launch: 10-60 min · Wallets buying in the first minute: 32+">4</div>
        <div className="oa-heat__cell" data-heat="20%" title="5 launches · Creator wallet topped up before launch: 1-6 h · Wallets buying in the first minute: 32+">5</div>
        <div className="oa-heat__cell" data-heat="22%" title="6 launches · Creator wallet topped up before launch: 6-24 h · Wallets buying in the first minute: 32+">6</div>
        <div className="oa-heat__cell" data-heat="36%" title="16 launches · Creator wallet topped up before launch: 1-31 d · Wallets buying in the first minute: 32+">16</div>
        <div className="oa-heat__cell" data-heat="48%" title="29 launches · Creator wallet topped up before launch: older · Wallets buying in the first minute: 32+">29</div>
      </div>
      <div className="oa-heat__row">
        <div className="oa-heat__ytick">16-31</div>
        <div className="oa-heat__cell" data-heat="20%" title="5 launches · Creator wallet topped up before launch: &lt;1 min · Wallets buying in the first minute: 16-31">5</div>
        <div className="oa-heat__cell" data-heat="34%" title="14 launches · Creator wallet topped up before launch: 1-10 min · Wallets buying in the first minute: 16-31">14</div>
        <div className="oa-heat__cell" data-heat="24%" title="7 launches · Creator wallet topped up before launch: 10-60 min · Wallets buying in the first minute: 16-31">7</div>
        <div className="oa-heat__cell" data-heat="20%" title="5 launches · Creator wallet topped up before launch: 1-6 h · Wallets buying in the first minute: 16-31">5</div>
        <div className="oa-heat__cell" data-heat="30%" title="11 launches · Creator wallet topped up before launch: 6-24 h · Wallets buying in the first minute: 16-31">11</div>
        <div className="oa-heat__cell is-dark" data-heat="72%" title="65 launches · Creator wallet topped up before launch: 1-31 d · Wallets buying in the first minute: 16-31">65</div>
        <div className="oa-heat__cell" data-heat="55%" title="38 launches · Creator wallet topped up before launch: older · Wallets buying in the first minute: 16-31">38</div>
      </div>
      <div className="oa-heat__row">
        <div className="oa-heat__ytick">8-15</div>
        <div className="oa-heat__cell" data-heat="18%" title="4 launches · Creator wallet topped up before launch: &lt;1 min · Wallets buying in the first minute: 8-15">4</div>
        <div className="oa-heat__cell" data-heat="44%" title="24 launches · Creator wallet topped up before launch: 1-10 min · Wallets buying in the first minute: 8-15">24</div>
        <div className="oa-heat__cell" data-heat="37%" title="17 launches · Creator wallet topped up before launch: 10-60 min · Wallets buying in the first minute: 8-15">17</div>
        <div className="oa-heat__cell" data-heat="20%" title="5 launches · Creator wallet topped up before launch: 1-6 h · Wallets buying in the first minute: 8-15">5</div>
        <div className="oa-heat__cell" data-heat="39%" title="19 launches · Creator wallet topped up before launch: 6-24 h · Wallets buying in the first minute: 8-15">19</div>
        <div className="oa-heat__cell is-dark" data-heat="85%" title="90 launches · Creator wallet topped up before launch: 1-31 d · Wallets buying in the first minute: 8-15">90</div>
        <div className="oa-heat__cell" data-heat="70%" title="61 launches · Creator wallet topped up before launch: older · Wallets buying in the first minute: 8-15">61</div>
      </div>
      <div className="oa-heat__row">
        <div className="oa-heat__ytick">4-7</div>
        <div className="oa-heat__cell" data-heat="13%" title="2 launches · Creator wallet topped up before launch: &lt;1 min · Wallets buying in the first minute: 4-7">2</div>
        <div className="oa-heat__cell" data-heat="35%" title="15 launches · Creator wallet topped up before launch: 1-10 min · Wallets buying in the first minute: 4-7">15</div>
        <div className="oa-heat__cell" data-heat="34%" title="14 launches · Creator wallet topped up before launch: 10-60 min · Wallets buying in the first minute: 4-7">14</div>
        <div className="oa-heat__cell" data-heat="16%" title="3 launches · Creator wallet topped up before launch: 1-6 h · Wallets buying in the first minute: 4-7">3</div>
        <div className="oa-heat__cell" data-heat="40%" title="20 launches · Creator wallet topped up before launch: 6-24 h · Wallets buying in the first minute: 4-7">20</div>
        <div className="oa-heat__cell is-dark" data-heat="100%" title="124 launches · Creator wallet topped up before launch: 1-31 d · Wallets buying in the first minute: 4-7">124</div>
        <div className="oa-heat__cell" data-heat="70%" title="61 launches · Creator wallet topped up before launch: older · Wallets buying in the first minute: 4-7">61</div>
      </div>
      <div className="oa-heat__row">
        <div className="oa-heat__ytick">2-3</div>
        <div className="oa-heat__cell" data-heat="16%" title="3 launches · Creator wallet topped up before launch: &lt;1 min · Wallets buying in the first minute: 2-3">3</div>
        <div className="oa-heat__cell" data-heat="25%" title="8 launches · Creator wallet topped up before launch: 1-10 min · Wallets buying in the first minute: 2-3">8</div>
        <div className="oa-heat__cell" data-heat="28%" title="10 launches · Creator wallet topped up before launch: 10-60 min · Wallets buying in the first minute: 2-3">10</div>
        <div className="oa-heat__cell" data-heat="28%" title="10 launches · Creator wallet topped up before launch: 1-6 h · Wallets buying in the first minute: 2-3">10</div>
        <div className="oa-heat__cell" data-heat="37%" title="17 launches · Creator wallet topped up before launch: 6-24 h · Wallets buying in the first minute: 2-3">17</div>
        <div className="oa-heat__cell is-dark" data-heat="91%" title="103 launches · Creator wallet topped up before launch: 1-31 d · Wallets buying in the first minute: 2-3">103</div>
        <div className="oa-heat__cell" data-heat="67%" title="56 launches · Creator wallet topped up before launch: older · Wallets buying in the first minute: 2-3">56</div>
      </div>
      <div className="oa-heat__row">
        <div className="oa-heat__ytick">0-1</div>
        <div className="oa-heat__cell" data-heat="41%" title="21 launches · Creator wallet topped up before launch: &lt;1 min · Wallets buying in the first minute: 0-1">21</div>
        <div className="oa-heat__cell" data-heat="16%" title="3 launches · Creator wallet topped up before launch: 1-10 min · Wallets buying in the first minute: 0-1">3</div>
        <div className="oa-heat__cell" data-heat="28%" title="10 launches · Creator wallet topped up before launch: 10-60 min · Wallets buying in the first minute: 0-1">10</div>
        <div className="oa-heat__cell" data-heat="24%" title="7 launches · Creator wallet topped up before launch: 1-6 h · Wallets buying in the first minute: 0-1">7</div>
        <div className="oa-heat__cell" data-heat="16%" title="3 launches · Creator wallet topped up before launch: 6-24 h · Wallets buying in the first minute: 0-1">3</div>
        <div className="oa-heat__cell" data-heat="53%" title="35 launches · Creator wallet topped up before launch: 1-31 d · Wallets buying in the first minute: 0-1">35</div>
        <div className="oa-heat__cell" data-heat="44%" title="24 launches · Creator wallet topped up before launch: older · Wallets buying in the first minute: 0-1">24</div>
      </div>
      <div />
      <div className="oa-heat__xtick">&lt;1 min</div>
      <div className="oa-heat__xtick">1-10 min</div>
      <div className="oa-heat__xtick">10-60 min</div>
      <div className="oa-heat__xtick">1-6 h</div>
      <div className="oa-heat__xtick">6-24 h</div>
      <div className="oa-heat__xtick">1-31 d</div>
      <div className="oa-heat__xtick">older</div>
    </div>
    <div className="oa-heat__foot">
      <span className="oa-heat__xlabel">Creator wallet topped up before launch →</span>
      <span className="oa-heat__scale">0 <i /> 124 launches per cell · 1000 in total</span>
    </div>
  </div>
</div>

Read it from left to right. The left columns are creators whose wallet was filled from zero minutes before the launch. The right column, "older", holds creators with no top-up in the table at all: their wallet has not been empty for at least a month. Each column then shows how much attention those launches got in their first minute.

## Fundings: every balance change above the dust line

`indexer3_sol_fundings` looks at the same balances but asks a wider question. It does not care if the receiver was empty. For each successful transaction it collects the wallets that lost SOL and the wallets that gained SOL, and writes a row for each sender and receiver pair. `src_decrease` is what the sender lost, `dst_increase` is what the receiver gained, and `src_pre_balance` and `dst_pre_balance` are the balances before.

Let us look at the slot that holds the five-transfer transaction from above. It was transaction 292 in slot 470716085.

**SQLfundings_one_slot.sql**

<WalletExample>

```sql
-- Every funding row of the slot that holds the transaction above (tx_idx 292).
SELECT
    tx_idx,
    src_wallet,
    dst_wallet,
    src_decrease,
    dst_increase,
    src_pre_balance,
    dst_pre_balance
FROM indexer3_sol_fundings
WHERE slot = 470716085
ORDER BY tx_idx
```

</WalletExample>

**Result** · 1 row · this code ran on 2026-11-18 01:10 UTC

| `tx_idx` | `src_wallet` | `dst_wallet` | `src_decrease` | `dst_increase` | `src_pre_balance` | `dst_pre_balance` |
| --- | --- | --- | --- | --- | --- | --- |
| 0 | [`FEvc…MBfd`](https://solscan.io/account/FEvcczr8AQ28wZ5aY4gE6wTEgqvLd1mtyqXp1GaTMBfd) | [`HWzn…DYmk`](https://solscan.io/account/HWznbZDvQHYJpM2XV8MYwkaKaU5Gc1W9eEosxC8yDYmk) | 817,900,000 | 817,889,961 | 827,900,000 | 23,009,089,925,144 |

Transaction 292 is not there. It paid 0.0035 SOL to each wallet, and that is too small.

<Warning>

**Fundings do not record dust**

**A wallet counts only if its SOL balance changed by more than 0.09 SOL (90,000,000 lamports) inside one transaction.** A change of exactly 0.09 SOL or less is ignored, whether it goes up or down.

The full rule, applied to every successful transaction:

1. Take each account whose SOL balance changed by more than 0.09 SOL.
2. Drop token accounts and addresses that are not ordinary wallets (addresses derived by programs).
3. If at least one wallet is left that lost SOL **and** at least one that gained SOL, write a row for every pair. Otherwise write nothing.

What this means in practice:

- a 0.05 SOL payment never appears;
- a wallet that pays 0.05 SOL to each of ten wallets loses 0.5 SOL, but no receiver passes the line, so there is no row at all;
- transaction fees, tips and rent for new accounts are almost always below the line and leave no rows.

If you need small payments into empty wallets, use `sol_top_ups`. It has no minimum.

</Warning>

You can see the line in the data itself:

**SQLdust_line.sql**

<WalletExample>

```sql
-- The smallest balance changes recorded yesterday.
-- Both sit just above the line of 90,000,000 lamports.
SELECT
    min(src_decrease) AS smallest_loss,
    min(dst_increase) AS smallest_gain,
    count() AS funding_rows
FROM indexer3_sol_fundings
WHERE block_date_utc = today() - 1
```

</WalletExample>

**Result** · 1 row · this code ran on 2026-11-18 01:10 UTC

| `smallest_loss` | `smallest_gain` | `funding_rows` |
| --- | --- | --- |
| 90,002,858 | 90,000,001 | 2,609,250 |

The table also has no `signature` column. A transaction is identified by `slot` and `tx_idx`. When you need the signature, join a table that has it on those two columns. A trading table works well, as the next example shows.

### We record what happened, not how it was done

This is the most important thing to understand about top-ups and fundings. We do not look for "transfer" instructions. We compare balances before and after. If a wallet ends a transaction with more SOL, we see it, no matter which program moved the SOL or how many steps it took.

Here is a transaction where 9.65 SOL goes from one wallet to another and no instruction transfers SOL between them:

**SQLhidden_transfer.sql**

<WalletExample>

```sql
-- 9.65 SOL moves from one wallet to another, yet no instruction says
-- "transfer SOL to that wallet". The only top-level transfer goes elsewhere.
SELECT
    src_wallet,
    dst_wallet,
    src_decrease / 1e9 AS sol_lost,
    dst_increase / 1e9 AS sol_gained,
    JSONExtractString(top_level_transfers_json, 1, 'to') AS only_transfer_goes_to
FROM indexer3_sol_fundings
WHERE slot = 470716000
  AND tx_idx = 241
```

</WalletExample>

**Result** · 1 row · this code ran on 2026-11-18 01:10 UTC

| `src_wallet` | `dst_wallet` | `sol_lost` | `sol_gained` | `only_transfer_goes_to` |
| --- | --- | --- | --- | --- |
| [`BiEH…py1r`](https://solscan.io/account/BiEHvFqAHu1Z7RqE6tXgpLgsZcAEABq7FqKJZuUKpy1r) | [`CV4g…ZPR9`](https://solscan.io/account/CV4gafozgDfZohWLb6b4rZEEVfiRMo4Z3CfzkXngZPR9) | 9.6783 | 9.65 | [`4FpY…Au2Z`](https://solscan.io/account/4FpYTLt6c3vJFzFj7xsa3TX5VfPtQZYLTWcMSAV8Au2Z) |

The only top-level SOL transfer in that transaction goes to a third address. That address is the sender's own wrapped SOL account. So how did the SOL reach the receiver? The PumpSwap table shows it:

**SQLhidden_transfer_swaps.sql**

<WalletExample>

```sql
-- The same transaction in the PumpSwap table. Slot and tx_idx identify it,
-- and this table has the signature. In this pool wSOL is the base token.
SELECT
    signing_wallet,
    if(direction = 'S', 'pays SOL into the pool', 'takes SOL out of the pool') AS what_it_does,
    base_token_amount / 1e9 AS sol,
    signature
FROM pumpswap_all_swaps
WHERE slot = 470716000
  AND tx_idx = 241
  AND base_token = 'So11111111111111111111111111111111111111112'
ORDER BY direction DESC
```

</WalletExample>

**Result** · 2 rows · this code ran on 2026-11-18 01:10 UTC

| `signing_wallet` | `what_it_does` | `sol` | `signature` |
| --- | --- | --- | --- |
| [`BiEH…py1r`](https://solscan.io/account/BiEHvFqAHu1Z7RqE6tXgpLgsZcAEABq7FqKJZuUKpy1r) | pays SOL into the pool | 9.6782 | [`4oGMUQ…c3Ec`](https://solscan.io/tx/4oGMUQJVLr5eEXeeiL5htgerz1W6E2S3GEjLHqonPYdouR1JjpFRn2SM33x9KNYEnjVP35NG7DzAvf4TKMw8c3Ec#balance_change) |
| [`CV4g…ZPR9`](https://solscan.io/account/CV4gafozgDfZohWLb6b4rZEEVfiRMo4Z3CfzkXngZPR9) | takes SOL out of the pool | 9.65 | [`4oGMUQ…c3Ec`](https://solscan.io/tx/4oGMUQJVLr5eEXeeiL5htgerz1W6E2S3GEjLHqonPYdouR1JjpFRn2SM33x9KNYEnjVP35NG7DzAvf4TKMw8c3Ec#balance_change) |

The first wallet buys a token from a PumpSwap pool. In the same transaction the second wallet sells the same token to the same pool. SOL goes in from one side and comes out on the other. Both wallets sign. An explorer shows two swaps. The funding table shows what it really was: about 9.65 SOL moved from wallet A to wallet B, and the pool kept the fees. [See the transaction on Solscan](https://solscan.io/tx/4oGMUQJVLr5eEXeeiL5htgerz1W6E2S3GEjLHqonPYdouR1JjpFRn2SM33x9KNYEnjVP35NG7DzAvf4TKMw8c3Ec#balance_change).

The same idea covers wrapped SOL. Closing a wSOL account pays its SOL to a wallet. That is how the receiver above got paid, and it is recorded like any other payment.

<Note>

**The other side of this**

Because we only see results, we cannot tell you which instruction moved the SOL. When that matters, take the slot and transaction index and open the transaction.

</Note>

### Many senders, many receivers

Balances tell us who lost SOL and who gained SOL. They do not tell us who paid whom. With one sender and one receiver that is not a problem. With several of each, we cannot split the amounts, so we do not try. We write one row for every sender and receiver pair. Each row carries the full loss of its sender and the full gain of its receiver. `n_src` and `n_dst` say how many senders and receivers the transaction had.

**SQLmany_to_many.sql**

<WalletExample>

```sql
-- One transaction where three wallets lost SOL and two gained it.
-- The table pairs every sender with every receiver: 3 x 2 = 6 rows.
SELECT
    src_wallet,
    dst_wallet,
    src_decrease,
    dst_increase,
    n_src,
    n_dst
FROM indexer3_sol_fundings
WHERE slot = 470678384
  AND tx_idx = 709
ORDER BY dst_wallet, src_wallet
```

</WalletExample>

**Result** · 6 rows · this code ran on 2026-11-18 01:10 UTC

<div className="wallet-walkthrough-figure">
  <div className="oa-cross oa-funding">
    <svg className="oa-svg" viewBox="0 0 440 168" role="img" aria-label="3 wallets lost SOL and 2 gained it; every sender is linked to every receiver, 6 rows in total">
      <line className="edge" strokeWidth="1.5" x1="156" y1="32" x2="278" y2="58" />
      <line className="edge" strokeWidth="1.5" x1="156" y1="32" x2="278" y2="110" />
      <line className="edge" strokeWidth="1.5" x1="156" y1="84" x2="278" y2="58" />
      <line className="edge" strokeWidth="1.5" x1="156" y1="84" x2="278" y2="110" />
      <line className="edge" strokeWidth="1.5" x1="156" y1="136" x2="278" y2="58" />
      <line className="edge" strokeWidth="1.5" x1="156" y1="136" x2="278" y2="110" />
      <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(284 58) rotate(0)" />
      <polygon className="head" points="0,0 -9,-4.5 -9,4.5" transform="translate(284 110) rotate(0)" />
      <g>
        <rect className="node" x="2" y="13" width="150" height="38" rx="10" />
        <text className="t-ink" x="14" y="30" fontSize="12.5">3DBD…GAiA</text>
        <text x="14" y="44" fontSize="11.5">−1.1578 SOL</text>
      </g>
      <g>
        <rect className="node" x="2" y="65" width="150" height="38" rx="10" />
        <text className="t-ink" x="14" y="82" fontSize="12.5">6dwo…rmFR</text>
        <text x="14" y="96" fontSize="11.5">−1.0035 SOL</text>
      </g>
      <g>
        <rect className="node" x="2" y="117" width="150" height="38" rx="10" />
        <text className="t-ink" x="14" y="134" fontSize="12.5">Ft8d…mtaa</text>
        <text x="14" y="148" fontSize="11.5">−1.598 SOL</text>
      </g>
      <g>
        <rect className="node" x="288" y="39" width="150" height="38" rx="10" />
        <text className="t-ink" x="300" y="56" fontSize="12.5">9LGq…zaqQ</text>
        <text x="300" y="70" fontSize="11.5">+1.0035 SOL</text>
      </g>
      <g>
        <rect className="node" x="288" y="91" width="150" height="38" rx="10" />
        <text className="t-ink" x="300" y="108" fontSize="12.5">wYKb…sano</text>
        <text x="300" y="122" fontSize="11.5">+1.0269 SOL</text>
      </g>
    </svg>
  </div>
</div>

| `src_wallet` | `dst_wallet` | `src_decrease` | `dst_increase` | `n_src` | `n_dst` |
| --- | --- | --- | --- | --- | --- |
| [`3DBD…GAiA`](https://solscan.io/account/3DBDztY1HGeb26pTNGzc5FLXuMN38GfZP2zrmrBZGAiA) | [`9LGq…zaqQ`](https://solscan.io/account/9LGqbs3kfBapkSLDoRFzYDHRhnnjQT99hTkoqenAzaqQ) | 1,157,831,911 | 1,003,462,243 | 3 | 2 |
| [`6dwo…rmFR`](https://solscan.io/account/6dwoP3UimwZRciJK21VkZfTmFmqCEwXFaYSxE1yRrmFR) | [`9LGq…zaqQ`](https://solscan.io/account/9LGqbs3kfBapkSLDoRFzYDHRhnnjQT99hTkoqenAzaqQ) | 1,003,482,062 | 1,003,462,243 | 3 | 2 |
| [`Ft8d…mtaa`](https://solscan.io/account/Ft8dWUccy6a6iq1cHtVpKegeroZ22yP13MCcBcJemtaa) | [`9LGq…zaqQ`](https://solscan.io/account/9LGqbs3kfBapkSLDoRFzYDHRhnnjQT99hTkoqenAzaqQ) | 1,597,976,808 | 1,003,462,243 | 3 | 2 |
| [`3DBD…GAiA`](https://solscan.io/account/3DBDztY1HGeb26pTNGzc5FLXuMN38GfZP2zrmrBZGAiA) | [`wYKb…sano`](https://solscan.io/account/wYKbspsmuP618JHt2DBgmiVbFEw73fsUDkHKTRRsano) | 1,157,831,911 | 1,026,864,789 | 3 | 2 |
| [`6dwo…rmFR`](https://solscan.io/account/6dwoP3UimwZRciJK21VkZfTmFmqCEwXFaYSxE1yRrmFR) | [`wYKb…sano`](https://solscan.io/account/wYKbspsmuP618JHt2DBgmiVbFEw73fsUDkHKTRRsano) | 1,003,482,062 | 1,026,864,789 | 3 | 2 |
| [`Ft8d…mtaa`](https://solscan.io/account/Ft8dWUccy6a6iq1cHtVpKegeroZ22yP13MCcBcJemtaa) | [`wYKb…sano`](https://solscan.io/account/wYKbspsmuP618JHt2DBgmiVbFEw73fsUDkHKTRRsano) | 1,597,976,808 | 1,026,864,789 | 3 | 2 |

Three senders and two receivers give six rows. Look at the amounts: the first receiver gained about 1.00 SOL, and that same number is repeated on all three of its rows.

This example is on purpose a hard one. The transaction merges eight pairs of stake accounts, and each merge moves SOL only inside its own pair. Five of those sixteen accounts have ordinary wallet-style addresses, so we see them: three that lost SOL and two that gained it. Their real partners are program addresses, which this table leaves out. So in this transaction none of the six rows is a real payment. [Check it on Solscan](https://solscan.io/tx/4Dwo1TCFybHgySYuYxXFn1RyMNNZPR28fcCw8AZABMz1uuKoBPVERfA7dRxGucKcQsfoLvnKKVov69c1oo9wRT4N#balance_change).

Two rules keep you safe:

- **For exact pairs, add `n_src = 1 AND n_dst = 1`.** Then each row is one sender, one receiver, and the amounts are real.
- **Never sum `dst_increase` over rows with `n_src` above 1.** The same gain is repeated once per sender.

## Three things you can do with these tables

### 1. Find wallets filled by the same tool

Someone who launches many tokens often funds each creator wallet from a different source, so the wallets look unrelated. But the funding transactions are usually built by the same script. The script leaves marks: the same compute-unit limit, the same priority fee, the compute-budget instructions at the same positions.

This query takes wallets that created a Pump.fun token in the last 24 hours. It groups their top-ups by those settings, by hour, and by amount (each group holds amounts within 5% of each other). It keeps groups where every wallet was paid by a different sender.

**SQLsame_builder_top_ups.sql**

<WalletExample>

```sql
-- Pump.fun creators of the last 24 hours whose wallets were topped up
-- by different senders, yet with the same transaction settings, amounts
-- within 5% of each other, and inside the same hour.
WITH
    creators AS
    (
        SELECT DISTINCT trim(BOTH '\0' FROM toString(creator)) AS wallet
        FROM pumpfun_token_creation
        WHERE block_time >= now() - INTERVAL 1 DAY
    )
SELECT
    toTimeZone(toStartOfHour(block_time), 'UTC') AS hour_utc,
    provided_gas_limit,
    provided_gas_fee,
    cu_limit_ix_index,
    cu_price_ix_index,
    round(min(amount) / 1e9, 4) AS min_sol,
    round(max(amount) / 1e9, 4) AS max_sol,
    uniqExact(dst_wallet) AS creators,
    uniqExact(src_wallet) AS senders,
    groupUniqArray(3)(dst_wallet) AS sample_creators
FROM sol_top_ups
WHERE block_date_utc >= today() - 1
  AND num_signatures = 1
  AND provided_gas_limit > 0
  AND dst_wallet IN (SELECT wallet FROM creators)
GROUP BY
    hour_utc,
    provided_gas_limit,
    provided_gas_fee,
    cu_limit_ix_index,
    cu_price_ix_index,
    floor(log(amount) / log(1.05)) -- one bucket = amounts within 5%
HAVING creators >= 4 AND senders = creators
ORDER BY creators DESC
LIMIT 10
```

</WalletExample>

**Result** · 10 rows · this code ran on 2026-11-18 01:12 UTC

| `hour_utc` | `provided_gas_limit` | `provided_gas_fee` | `cu_limit_ix_index` | `cu_price_ix_index` | `min_sol` | `max_sol` | `creators` | `senders` | `sample_creators` |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 2026-11-17 11:00:00 | 1,450 | 0 | 0 | -1 | 0.1766 | 0.1776 | 9 | 9 | [`35e3…uzZG`](https://solscan.io/account/35e3Nhr9yTWKPxn7dQ1zhfMDA8i4RtSRkRA77f8LuzZG), [`8scr…zwt5`](https://solscan.io/account/8scrSVk3HUHJMBruP5uxXqrWbszsnxhy4kVP1GfVzwt5), [`EJWt…kz38`](https://solscan.io/account/EJWtRmvk2mvNNHAixg3ucz62Neme84grUgZX2QNpkz38) |
| 2026-11-17 01:00:00 | 50,000 | 200,000 | 0 | 1 | 0.5 | 0.5001 | 9 | 9 | [`5pti…Mokf`](https://solscan.io/account/5ptiFSmcRhrqnrca8Ss8kYKfeSUDWsPotQcD4KJJMokf), [`6qVH…sCTD`](https://solscan.io/account/6qVH1rbYg1WUQVmKEVMQv7rLxEAosKpS3NmPQ1u6sCTD), [`DF1b…BWUj`](https://solscan.io/account/DF1bnzPxokksQ4t6WBEFi4bfwLFEB73nsXvNWEB2BWUj) |
| 2026-11-17 04:00:00 | 1,450 | 20,000 | 0 | 1 | 65.5537 | 66.7569 | 9 | 9 | [`GUqZ…AUyM`](https://solscan.io/account/GUqZGiNiMaCD5edbFG5A9voTdFNYxczwBMdie1CEAUyM), [`Feee…iKrT`](https://solscan.io/account/Feeeww3s6aQC2U96XXUDRxUuMSPbGZBprx8DXWWqiKrT), [`8yXX…QyCU`](https://solscan.io/account/8yXX19yMJfoWJh9u77PdeKnnB1GcAT2z1DGKmPULQyCU) |
| 2026-11-17 08:00:00 | 50,000 | 200,000 | 0 | 1 | 0.5 | 0.5001 | 8 | 8 | [`6swS…GqXu`](https://solscan.io/account/6swS5ZdgeDkpfDsVoVmUszU1G6s9CD4ce9Sib9rGGqXu), [`Aqkr…XchF`](https://solscan.io/account/Aqkrc3omSJX1trCt9Hv36oRKQcsEp6U5wL3YP196XchF), [`2sQh…PLpd`](https://solscan.io/account/2sQhZ3LVLjDVkbNP2jP2WYCJ26z2sDiGgyPiU3XgPLpd) |
| 2026-11-18 00:00:00 | 50,000 | 200,000 | 0 | 1 | 0.5 | 0.5001 | 8 | 8 | [`HJgr…JCKn`](https://solscan.io/account/HJgrLUY53LUf5jkJyiNhdu2oDemRFVUaU7ZFhJL4JCKn), [`7JoD…LvoK`](https://solscan.io/account/7JoDrZucbdozMX5qwsan1ZTauQuipGDYiKZ9ukpLLvoK), [`B4ge…RRKZ`](https://solscan.io/account/B4gem2GVK4TL3jvDG8RhBNso8tqXxr1VTk2cEV76RRKZ) |
| 2026-11-17 02:00:00 | 1,450 | 0 | 0 | -1 | 0.113 | 0.118 | 7 | 7 | [`35e3…uzZG`](https://solscan.io/account/35e3Nhr9yTWKPxn7dQ1zhfMDA8i4RtSRkRA77f8LuzZG), [`ADtJ…ueP1`](https://solscan.io/account/ADtJx5ipjbjdoKc5WbcNwW19MxrNBbFdYay7yhy7ueP1), [`HH2t…qDWZ`](https://solscan.io/account/HH2tUyxqoyW69CR9iiNXFFSrwAEWBmEVsGkCo7jmqDWZ) |
| 2026-11-17 13:00:00 | 1,450 | 20,000 | 0 | 1 | 74.5178 | 75.972 | 6 | 6 | [`Baoa…wsHQ`](https://solscan.io/account/BaoaFgejCBURa3GBRR6cWsDBJ4ovFniafpyunU6iwsHQ), [`4gVW…SpiL`](https://solscan.io/account/4gVWc4fzHAHgT2z2361pKm5xEXqH3JZJAxNcvWaeSpiL), [`4Hrg…ahHq`](https://solscan.io/account/4HrgSH9GaqMGpUxh8nU8PyQM8vxoSQPfwFUNq1BPahHq) |
| 2026-11-17 15:00:00 | 1,450 | 20,000 | 0 | 1 | 79.0057 | 80.0851 | 6 | 6 | [`13dB…QEj2`](https://solscan.io/account/13dBGHByZUQJS5WfMFrtWFrxoaEFBe3pZZzj6MGcQEj2), [`8MPY…Hryc`](https://solscan.io/account/8MPYHNhGjyyEkyjS4oVSdxn1o57RARTyZaZhp3WWHryc), [`FWbn…Q992`](https://solscan.io/account/FWbnLcj2ENqcFD3czghZq6BrLha9tUPNXoK3wiAhQ992) |
| 2026-11-17 19:00:00 | 200,000 | 0 | -1 | -1 | 0.0069 | 0.0069 | 5 | 5 | [`3kHx…45vh`](https://solscan.io/account/3kHxeD5ypNv85Df3Kp8EMBoPzH5ixJymf9oGQh8e45vh), [`6D4b…fBwA`](https://solscan.io/account/6D4b9nxR3qdZXv2DKuypcwzwQfzmrRp2N29mDkb6fBwA), [`95d2…9urn`](https://solscan.io/account/95d2m5K4VwBCwW9roPuTjyoN6PXafeDoJRRyvNtb9urn) |
| 2026-11-17 21:00:00 | 562 | 133,333,334 | 1 | 0 | 2.5594 | 2.6725 | 5 | 5 | [`Hp5f…Zitw`](https://solscan.io/account/Hp5fNhnw8uaecuHWWPkismYPVHpRmCpFEEXPFHKjZitw), [`99DY…Ha1f`](https://solscan.io/account/99DYGJ2DqEyAieaEqoG8y71Kb7HfwiFCBFAzSpS6Ha1f), [`Azhh…XQcH`](https://solscan.io/account/Azhh3KhpasyZnNpyxN5ADwXnNRDEA8u9E9ctGchSXQcH) |

Each row is a cluster: several creator wallets, each paid by a different sender, in the same hour, with nearly the same amount and identical transaction settings. Common settings from popular wallet apps will also show up, so treat a cluster as a lead and check a few of its wallets by hand.

### 2. Follow a pipe of pass-through wallets

To hide where money comes from, people send it through a chain of new wallets. Each wallet receives SOL and passes all of it to the next. In the funding table such a hop has a clear shape:

- `dst_pre_balance = 0`: the receiver was empty;
- the sender kept almost nothing: `src_pre_balance - src_decrease` is close to zero;
- `n_src = 1 AND n_dst = 1`: one sender, one receiver.

This script starts at the creator of a Pump.fun token and walks backwards, one hop at a time, until the shape breaks or it has made 12 hops. The connection code is in a small helper file, so the script shows only the logic.

**Pythonfunding_pipe.py**

<WalletExample>

```python
"""Walk SOL backwards from a Pump.fun creator through pass-through wallets."""
 
from ocd import query, show
 
CREATOR = "2x7XsuzUzWPsTHeoUgEtSbFXNVcKiPTu3mfqX4Kqx3sZ"  # launched a token on 2026-11-18
 
# One hop back: who filled this wallet when it was empty,
# and sent nearly everything they had?
HOP = """
SELECT
    slot,
    toTimeZone(block_time, 'UTC') AS block_time_utc,
    src_wallet,
    dst_wallet,
    dst_increase / 1e9 AS sol
FROM indexer3_sol_fundings
WHERE dst_wallet = %(wallet)s
  AND slot < %(before_slot)s
  AND dst_pre_balance = 0                        -- receiver was empty
  AND src_pre_balance - src_decrease < 3000000   -- sender kept under 0.003 SOL
  AND n_src = 1 AND n_dst = 1                    -- one sender, one receiver
ORDER BY slot DESC
LIMIT 1
"""
 
wallet, before_slot, hops = CREATOR, 470_740_000, []
while len(hops) < 12:
    rows = query(HOP, {"wallet": wallet, "before_slot": before_slot})
    if not rows:
        break
    hops.append({"hop": len(hops) + 1, **rows[0]})
    wallet, before_slot = rows[0]["src_wallet"], rows[0]["slot"]
 
show(hops)
```

</WalletExample>

**Result** · 12 rows · this code ran on 2026-11-18 01:10 UTC

<div className="wallet-walkthrough-figure">
  <ol className="oa-pipe oa-funding">
    <li className="oa-pipe__node">
      <code>5i7v…PtbR</code>
      <span>earliest wallet reached</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.125 SOL</b>
        <span>11-17 23:57 UTC</span>
      </div>
      <code>3aA2…Dm8C</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.125 SOL</b>
        <span>11-17 23:57 UTC</span>
      </div>
      <code>BQYX…L6Yk</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.125 SOL</b>
        <span>11-17 23:59 UTC</span>
      </div>
      <code>CuWu…SvmJ</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.124 SOL</b>
        <span>11-17 23:59 UTC</span>
      </div>
      <code>6Me3…zMvP</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>17.321 SOL</b>
        <span>11-18 00:02 UTC</span>
      </div>
      <code>7RCz…A6AU</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>17.321 SOL</b>
        <span>11-18 00:02 UTC</span>
      </div>
      <code>2qGH…tcYv</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>21.225 SOL</b>
        <span>11-18 00:04 UTC</span>
      </div>
      <code>AYS8…KRYU</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>21.225 SOL</b>
        <span>11-18 00:04 UTC</span>
      </div>
      <code>ChZT…PvfY</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.873 SOL</b>
        <span>11-18 00:26 UTC</span>
      </div>
      <code>H2Du…XEKv</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.873 SOL</b>
        <span>11-18 00:26 UTC</span>
      </div>
      <code>B94a…wVQK</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.873 SOL</b>
        <span>11-18 00:27 UTC</span>
      </div>
      <code>CgWB…6eow</code>
      <span>empty before, passes it all on</span>
    </li>
    <li className="oa-pipe__node">
      <div className="oa-pipe__edge">
        <b>13.873 SOL</b>
        <span>11-18 00:27 UTC</span>
      </div>
      <code>2x7X…x3sZ</code>
      <span>the token creator</span>
    </li>
  </ol>
</div>

| `hop` | `slot` | `block_time_utc` | `src_wallet` | `dst_wallet` | `sol` |
| --- | --- | --- | --- | --- | --- |
| 1 | 470734043 | 2026-11-18 00:27:08 | [`CgWB…6eow`](https://solscan.io/account/CgWBdQCxyVfB7rdtW2ejEzwtvqRoCPUc8qp3T2en6eow) | [`2x7X…x3sZ`](https://solscan.io/account/2x7XsuzUzWPsTHeoUgEtSbFXNVcKiPTu3mfqX4Kqx3sZ) | 13.8733 |
| 2 | 470734037 | 2026-11-18 00:27:06 | [`B94a…wVQK`](https://solscan.io/account/B94aCRTMBMWx7kzn74Vpu9xA8mK7DW1KCYCoLMF4wVQK) | [`CgWB…6eow`](https://solscan.io/account/CgWBdQCxyVfB7rdtW2ejEzwtvqRoCPUc8qp3T2en6eow) | 13.8734 |
| 3 | 470733953 | 2026-11-18 00:26:48 | [`H2Du…XEKv`](https://solscan.io/account/H2DutKg14nTe8T91ZFgkwK8qpYS5e83jauVV3ajVXEKv) | [`B94a…wVQK`](https://solscan.io/account/B94aCRTMBMWx7kzn74Vpu9xA8mK7DW1KCYCoLMF4wVQK) | 13.8734 |
| 4 | 470733946 | 2026-11-18 00:26:46 | [`ChZT…PvfY`](https://solscan.io/account/ChZTedjbJshuHze9Qpap9NQYJEd6f5rX6iCVBjE6PvfY) | [`H2Du…XEKv`](https://solscan.io/account/H2DutKg14nTe8T91ZFgkwK8qpYS5e83jauVV3ajVXEKv) | 13.8734 |
| 5 | 470727696 | 2026-11-18 00:04:20 | [`AYS8…KRYU`](https://solscan.io/account/AYS8AKEYRVwUgNwBmeQT39k5tiuoM9gUhoA7w5AKKRYU) | [`ChZT…PvfY`](https://solscan.io/account/ChZTedjbJshuHze9Qpap9NQYJEd6f5rX6iCVBjE6PvfY) | 21.2254 |
| 6 | 470727687 | 2026-11-18 00:04:18 | [`2qGH…tcYv`](https://solscan.io/account/2qGHoffAzvV2Ju3PPpnaut4AuCdCvoE6WmdZP79xtcYv) | [`AYS8…KRYU`](https://solscan.io/account/AYS8AKEYRVwUgNwBmeQT39k5tiuoM9gUhoA7w5AKKRYU) | 21.2254 |
| 7 | 470727227 | 2026-11-18 00:02:38 | [`7RCz…A6AU`](https://solscan.io/account/7RCzVyCikEAZAHR2nNCPyzipk2fGqntHKcucxk3YA6AU) | [`2qGH…tcYv`](https://solscan.io/account/2qGHoffAzvV2Ju3PPpnaut4AuCdCvoE6WmdZP79xtcYv) | 17.3208 |
| 8 | 470727220 | 2026-11-18 00:02:37 | [`6Me3…zMvP`](https://solscan.io/account/6Me3oEkUtEwZ2qpyXjJFxvcDzkLhiSa3q8YgMNY6zMvP) | [`7RCz…A6AU`](https://solscan.io/account/7RCzVyCikEAZAHR2nNCPyzipk2fGqntHKcucxk3YA6AU) | 17.3208 |
| 9 | 470726298 | 2026-11-17 23:59:20 | [`CuWu…SvmJ`](https://solscan.io/account/CuWuC7gp2yc82Zpyqs7tBDB2JTpFKxWcVukCjsuCSvmJ) | [`6Me3…zMvP`](https://solscan.io/account/6Me3oEkUtEwZ2qpyXjJFxvcDzkLhiSa3q8YgMNY6zMvP) | 13.1245 |
| 10 | 470726290 | 2026-11-17 23:59:18 | [`BQYX…L6Yk`](https://solscan.io/account/BQYXjBPwB85wrpgSPkJnwaTnshngkZcRi54RCzvEL6Yk) | [`CuWu…SvmJ`](https://solscan.io/account/CuWuC7gp2yc82Zpyqs7tBDB2JTpFKxWcVukCjsuCSvmJ) | 13.1245 |
| 11 | 470725760 | 2026-11-17 23:57:24 | [`3aA2…Dm8C`](https://solscan.io/account/3aA2QrgMS3gBc3PLb4r73L9k6teQptT74k1BCBKZDm8C) | [`BQYX…L6Yk`](https://solscan.io/account/BQYXjBPwB85wrpgSPkJnwaTnshngkZcRi54RCzvEL6Yk) | 13.1245 |
| 12 | 470725752 | 2026-11-17 23:57:23 | [`5i7v…PtbR`](https://solscan.io/account/5i7vnRQhu61rbDxXQy9he5i39tQ5yrFsfJSNFi8hPtbR) | [`3aA2…Dm8C`](https://solscan.io/account/3aA2QrgMS3gBc3PLb4r73L9k6teQptT74k1BCBKZDm8C) | 13.1245 |

Each hop loses a few thousand lamports, which is the transaction fee. Where the amount jumps between two hops, that wallet did something else before passing the SOL on. In this chain those wallets launched Pump.fun tokens of their own, so this is one operator moving the same money from launch to launch. If the walk ends before 12 hops, it has reached a wallet that does not fit the shape: one that already held SOL, kept some, or was paid with less than 0.09 SOL. That wallet is where you start looking by hand.

### 3. Find the sink that early buyers pay into

When one person controls the first buyers of a token, the profits have to come together somewhere. This query takes tokens launched in the last day and the wallets behind their first 10 trades. Then it looks for a wallet that receives SOL from early traders of more than one launch.

**SQLcommon_sink.sql**

<WalletExample>

```sql
-- Wallets that collect SOL from the early traders of several launches.
-- "Early" = behind one of the first 10 trades of a token launched in the last day.
WITH
    launches AS
    (
        SELECT trim(BOTH '\0' FROM toString(mint)) AS mint
        FROM pumpfun_token_creation
        WHERE block_time >= now() - INTERVAL 1 DAY
    ),
    early AS
    (
        SELECT s.base_coin AS mint, s.signing_wallet AS wallet, s.block_time AS traded_at
        FROM pumpfun_v2_swaps AS s
        INNER JOIN launches AS l ON l.mint = s.base_coin
        WHERE s.block_date_utc >= today() - 1
          AND s.failed = 0
        ORDER BY s.slot, s.tx_idx, s.ix_idx
        LIMIT 10 BY mint
    ),
    payouts AS
    (
        SELECT src_wallet, dst_wallet, block_time, dst_increase
        FROM indexer3_sol_fundings
        WHERE block_date_utc >= today() - 1
          AND n_src = 1 AND n_dst = 1
          AND src_wallet GLOBAL IN (SELECT wallet FROM early)
    )
SELECT
    p.dst_wallet AS sink,
    uniqExact(e.mint) AS launches,
    uniqExact(e.wallet) AS early_wallets,
    round(sum(p.dst_increase) / 1e9, 1) AS sol_received,
    groupUniqArray(2)(e.mint) AS sample_tokens
FROM early AS e
INNER JOIN payouts AS p ON p.src_wallet = e.wallet
WHERE p.block_time >= e.traded_at
  AND p.dst_wallet NOT IN (SELECT wallet FROM early)
GROUP BY sink
HAVING launches >= 3 AND early_wallets >= 5
ORDER BY early_wallets DESC
LIMIT 10
```

</WalletExample>

**Result** · 10 rows · this code ran on 2026-11-18 01:11 UTC

| `sink` | `launches` | `early_wallets` | `sol_received` | `sample_tokens` |
| --- | --- | --- | --- | --- |
| [`GPcP…ECkm`](https://solscan.io/account/GPcPUvocqUf9yYXdbAdZ8fSryJXGXMUBKQ13gfwvECkm) | 150 | 146 | 667.3 | [`GyLe…pump`](https://solscan.io/account/GyLeMPEPNKBUATzox767R5XKkoLy8iS1zvUpc5dHpump), [`8vhy…pump`](https://solscan.io/account/8vhyjuPNxK2jCiS7Hf9kYUkhbLTBMCLGmsbMUg2kpump) |
| [`2abw…TJVn`](https://solscan.io/account/2abws3DfBmgd7toRJL4cRT7nw3hFrYEjkfRUauZvTJVn) | 49 | 142 | 3,653.8 | [`E9QZ…pump`](https://solscan.io/account/E9QZaPgABjDH3D7dr86cruWF65NxPDYBswmceSmCpump), [`CyZB…pump`](https://solscan.io/account/CyZBPdhzpBr17Fp8GYUvsyvpWc5ytiF2jumtK3nDpump) |
| [`GAiN…LmVZ`](https://solscan.io/account/GAiNS2aR3fCX2eCAUNJkZknnX3MQMEEAhqHe3UtRLmVZ) | 127 | 127 | 383.3 | [`DnCk…pump`](https://solscan.io/account/DnCkopbaViCMHySj2E9iXAsFCN7sAxS3sVRYaeTypump), [`2a3k…pump`](https://solscan.io/account/2a3kB6ztewdJwPiuCxNER9zPv1BBqQjSrq1tA4unpump) |
| [`Fz2U…LWec`](https://solscan.io/account/Fz2Uczbd14mDmyLJfLTihyEeCpwCYKv69GU16yF6LWec) | 15 | 100 | 222.2 | [`AqYq…pump`](https://solscan.io/account/AqYqgocargqHEcedt5ivbmEBMRTEq97wPTQTwYpopump), [`F2Fc…pump`](https://solscan.io/account/F2FcC88dpRe47LYKkd8cne24inyKM6gNJpQE23BZpump) |
| [`HS23…jnWF`](https://solscan.io/account/HS23RyJnR9uop2bYPucyKtrtR3fY2Va7jCLbintAjnWF) | 10 | 89 | 71.1 | [`9YqP…pump`](https://solscan.io/account/9YqPnBehyAs72yqS15gJq4k9aDS89QqYDZhuteQxpump), [`Hz3s…pump`](https://solscan.io/account/Hz3sFt3aSJ64D6b2TTk7EXex96USe9tDWAer5LqHpump) |
| [`Cfh3…9i77`](https://solscan.io/account/Cfh3p3Z3Qr7sTzQkoMebnQ3Y5gwemookkaYdXAem9i77) | 82 | 80 | 67.9 | [`85M6…5qAw`](https://solscan.io/account/85M66j6AyyFe9pyNT94exZL7nV87GTS8B5KxTdj95qAw), [`A7ov…RWz6`](https://solscan.io/account/A7ovo3iiX41txVCbNrec4cNjxRd8ZEK6SgYz1grvRWz6) |
| [`EYXK…1Qcs`](https://solscan.io/account/EYXK1Tg2eNUk4LxzffJ9D37K44J26H9keXdJaYud1Qcs) | 30 | 79 | 1,180.5 | [`8MHD…pump`](https://solscan.io/account/8MHDGjKZGkM7uRKCQEB9Z2qVtsezRYQ3juhTpW5Xpump), [`FfaR…pump`](https://solscan.io/account/FfaRg7QcEMGTTrSh1BsyaMjw2SCiPvF75FbKJZAapump) |
| [`D3Je…Lfaz`](https://solscan.io/account/D3JesPi8AyFRi6fb7VnEtdNUGw9Nyfwh33jAZfm2Lfaz) | 10 | 68 | 515.4 | [`B2La…pump`](https://solscan.io/account/B2Lam7L1Ex5GDnguVrPzSYivCxAUbe9YbyWLYWNzpump), [`4HEc…pump`](https://solscan.io/account/4HEc7VKQF4HZtabhbj3BTstPeUWrdfiqHqE3h72Apump) |
| [`7RVA…co5q`](https://solscan.io/account/7RVAeeLHQkdgfwGCLUaZVyWqPpamWzJ8cuTE1Gz3co5q) | 64 | 64 | 789.6 | [`9kTB…pump`](https://solscan.io/account/9kTBNpTmDMxJoN4CGCKnii4fhp3XADwmQp8c4Pqapump), [`BnpL…pump`](https://solscan.io/account/BnpLuuMYwuSD8JsAWDhh81VkNS9DKeQJXANX8WKppump) |
| [`C2fv…fhjR`](https://solscan.io/account/C2fvoX6srM6gh3GmC4kCbXtxFmbTXLesSRjCNW67fhjR) | 8 | 64 | 102.6 | [`Fbc7…pump`](https://solscan.io/account/Fbc7qyGQxSnuTy1CtTHwASVQrzP913ayBFYGzypWpump), [`HRky…pump`](https://solscan.io/account/HRky5hHownrJRBQht9ka7K4E5LkHQoJhdV38LdrJpump) |

A wallet at the top of this list collects SOL from the first buyers of several launches. Some of them are exchange deposit addresses or trading-bot fee wallets, so open a few before you draw conclusions. Note the `GLOBAL IN`: the list of early wallets comes from the main server, and the funding table lives on the second one.

## Token transfers

Token transfers are the simplest of the three. A row means a token moved from one owner to another. The columns are `mint`, `src_wallet`, `dst_wallet` and `amount`. The wallets are the owners of the token accounts, not the token accounts themselves. `amount` is in the token's smallest unit.

**SQLtoken_transfers_recent.sql**

<WalletExample>

```sql
-- The five largest USDC transfers of the last hour.
SELECT
    toTimeZone(block_time, 'UTC') AS block_time_utc,
    src_wallet,
    dst_wallet,
    amount / 1e6 AS usdc,
    flavour,
    signature
FROM token_transfers
WHERE block_date_utc >= today() - 1
  AND block_time >= now() - INTERVAL 1 HOUR
  AND mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC
  AND src_wallet != dst_wallet
ORDER BY amount DESC
LIMIT 5
```

</WalletExample>

**Result** · 5 rows · this code ran on 2026-11-18 01:11 UTC

| `block_time_utc` | `src_wallet` | `dst_wallet` | `usdc` | `flavour` | `signature` |
| --- | --- | --- | --- | --- | --- |
| 2026-11-18 00:34:52 | [`Bc5b…nXHf`](https://solscan.io/account/Bc5bth4Mn2n8DX1etZwvnq3uDEGg479s2D24TCEsnXHf) | [`81w9…ytUj`](https://solscan.io/account/81w96XvKAZZFmmuzaohSQUyxtGnAPJmkjwoBFBmtytUj) | 31,548,281.3145 | 1 | [`6785SK…K8iz`](https://solscan.io/tx/6785SKQb9HPmhDrHpp493pQHwcdmpiidTHrDq9TxqcVhuz4FXZEuFbcN4ijLtqrwE5im6fUGjepijZYVbKEKK8iz#balance_change) |
| 2026-11-18 00:15:23 | [`5g7y…aBWs`](https://solscan.io/account/5g7yNHyGLJ7fiQ9SN9mf47opDnMjc585kqXWt6d7aBWs) | [`EWWf…39Us`](https://solscan.io/account/EWWfXKBgvnu8cyioXodqht79e9goknYJkkSHU8RE39Us) | 6,666,680.006 | 1 | [`rKFUPh…g2iu`](https://solscan.io/tx/rKFUPhXJ1RzyBFMW1ssbq8gq7eMK3cxvBERHcXjj9wYy9H4gjgqW5J926Ruj6zTNuJu5zzdwP7bthGTmxs6g2iu#balance_change) |
| 2026-11-18 00:15:22 | [`5g7y…aBWs`](https://solscan.io/account/5g7yNHyGLJ7fiQ9SN9mf47opDnMjc585kqXWt6d7aBWs) | [`EWWf…39Us`](https://solscan.io/account/EWWfXKBgvnu8cyioXodqht79e9goknYJkkSHU8RE39Us) | 6,666,660.006 | 1 | [`4BwqLs…9n56`](https://solscan.io/tx/4BwqLsBJV9yP4Wm4FMvRmyUymRnLDrcE22DK5hGXt5qXFkiRHd1SJMQGX4bcebq2tBPgTvNvzm3mAk931fmh9n56#balance_change) |
| 2026-11-18 00:15:22 | [`5g7y…aBWs`](https://solscan.io/account/5g7yNHyGLJ7fiQ9SN9mf47opDnMjc585kqXWt6d7aBWs) | [`3NZu…5hhJ`](https://solscan.io/account/3NZuxdx5si74TdDygNFE3bvrYuYXwsdKYreXAiJc5hhJ) | 6,666,660.006 | 1 | [`3qe6GE…rKgt`](https://solscan.io/tx/3qe6GEzd1bQcNwfm8q9m5EkTVaVRNns6MGbStFM4dYp5j12MWuzuxWVPot6uQCJc3yAnU6afBDULHhLPHLBErKgt#balance_change) |
| 2026-11-18 00:15:23 | [`5g7y…aBWs`](https://solscan.io/account/5g7yNHyGLJ7fiQ9SN9mf47opDnMjc585kqXWt6d7aBWs) | [`EWWf…39Us`](https://solscan.io/account/EWWfXKBgvnu8cyioXodqht79e9goknYJkkSHU8RE39Us) | 6,666,660.006 | 1 | [`uVpwN5…ghfK`](https://solscan.io/tx/uVpwN5rZnFtEYVVYUSKunR3Nixum82Dx8wvXLdNktrSXuizaefxsQVv5uzgnD8dRBbZxNf9KLr8ZiQW9z97ghfK#balance_change) |

There are two tables, and they differ in more than history:

- **`token_transfers`** keeps 31 days and has the signature. It records transfers written directly in the transaction. Transfers that a program makes on your behalf are not in it. A swap, for example, is not a row here.
- **`indexer3_token_transfers`** has the long history and also records transfers made inside programs. It adds `src_pre_amount` and `dst_pre_amount`, the token balances before the transfer. It keeps a transfer only when both owners are ordinary wallets. It has no signature, so use `slot` and `tx_idx`.

Both tables cover the classic Token program and Token-2022, including mints that use extensions such as transfer fees. The `flavour` column tells you how the transfer was made: 0 is a plain transfer, 1 a checked transfer, 2 a transfer with a fee, 3 a change of the token account's owner. Add 16 for Token-2022. We index more of the token programs than most people expect, and we will keep the finer details to ourselves for now.

A few things are not token transfers and are not here: minting, burning, and closing a token account.

### What about wrapped SOL?

wSOL is a token, so moving wSOL between owners is a row in the token tables with the mint `So11111111111111111111111111111111111111112`. Wrapping and unwrapping are different. They are not token transfers. Unwrapping closes the wSOL account and pays plain SOL to a wallet. That shows up on the SOL side: as a top-up if the wallet was empty, and as a funding if more than 0.09 SOL arrived and another wallet lost SOL in the same transaction. The PumpSwap example above is exactly that case.

## What these tables do not see

**Wallets controlled by programs.** A multisig vault, such as a Squads vault, is not an ordinary wallet. Its address is derived by a program and has no private key. `indexer3_sol_fundings` and `indexer3_token_transfers` only keep ordinary wallets, so money that goes into or out of such a vault is not there. `token_transfers` misses them for a different reason: a vault always moves tokens through its program, and that table only records transfers written directly in the transaction. `sol_top_ups` is the one exception. It shows a vault as a receiver the first time it is paid, but the sender is the signer of the transaction, not the vault's owner.

**Small SOL amounts between wallets that already hold SOL.** Too small for fundings, and not a top-up.

**The instruction.** Top-ups and fundings tell you that SOL moved, not which program moved it.

**Summary**

## Key takeaways

- **Top-ups are for fresh wallets.** A row means a balance went from zero to above zero. Any amount counts, and it can happen to the same wallet many times.
- **Fundings are for following money.** They cover every wallet-to-wallet change above 0.09 SOL, with balances before, and go back much further. They have no signature and no dust.
- **Both record results, not instructions.** SOL that moves through a pool or a wSOL account is still seen.
- **Check n_src and n_dst.** With several senders or receivers, every pair gets a row and the amounts repeat.
- **Token transfers follow tokens.** Use token_transfers for recent rows with signatures, and indexer3_token_transfers for history and transfers made inside programs.

**Keep reading**

- [Solana Table Reference](https://supanode.xyz/docs/solana/indexer/tables). Column types, partition keys and retention.
