Query editor
WITH base AS (SELECT "from" AS payer, "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")SELECTcount(*) AS payments_2026,count(distinct payer) AS payers_2026,count(distinct recipient) AS recipients_2026,approx_percentile(usdc, 0.5) AS median_usd,sum(usdc) AS total_usd,cast(count(*) FILTER (WHERE usdc < 1) AS double) / count(*) AS share_under_1usd,cast(count(*) FILTER (WHERE usdc >= 1) AS double) / count(*) AS share_1usd_plusFROM base