Query editor
WITH base AS (SELECTcall_block_date AS d,"from" AS payer,"to" AS recipient,value / 1e6 AS usdcFROM base_usdc_base.fiattokenv2_1_call_transferwithauthorizationWHERE call_block_date >= DATE '2025-05-01'AND call_success = trueAND call_tx_from <> "from" -- facilitator relayed the payer's signed authorization (x402 shape))SELECTdate_trunc('week', d) AS wk,count(*) AS payments,count(distinct payer) AS payers,count(distinct recipient) AS recipients,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,count(*) FILTER (WHERE usdc >= 1) AS payments_1usd_plus,sum(usdc) FILTER (WHERE usdc >= 1) AS total_usd_1usd_plusFROM baseGROUP BY 1ORDER BY 1