Query editor
WITH base AS (SELECT "to" AS recipient, value / 1e6 AS usdcFROM base_usdc_base.fiattokenv2_1_call_transferwithauthorizationWHERE call_block_date >= DATE '2026-01-01'AND call_success = trueAND call_tx_from <> "from"),tot AS (SELECT count(*) AS all_payments FROM base)SELECT'0x' || to_hex(recipient) AS recipient,count(*) AS payments,cast(count(*) AS double) / (SELECT all_payments FROM tot) AS share_of_payments,approx_percentile(usdc, 0.5) AS median_usd,sum(usdc) AS total_usd_receivedFROM baseGROUP BY 1ORDER BY payments DESCLIMIT 15