Query editor
SELECTblock_date,AVG(fee) AS avg_fee_btc,AVG(fee * 1e8) AS avg_fee_sats,AVG(fee * 1e8 / NULLIF(CAST(virtual_size AS double), 0)) AS avg_sats_per_vbyte,approx_percentile(fee * 1e8 / NULLIF(CAST(virtual_size AS double), 0), 0.5) AS median_sats_per_vbyteFROM bitcoin.transactionsWHERE block_date >= CURRENT_DATE - INTERVAL '365' DAYAND NOT is_coinbaseAND virtual_size > 0GROUP BY 1ORDER BY 1 ASC