Query editor
SELECTDATE_TRUNC('hour', block_time) AS timestamp,COUNT(DISTINCT id) AS total_tx_count,SUM(output_value) AS daily_onchain_volume_btc,COUNT(DISTINCT CASE WHEN output_value >= 100 THEN id END) AS whale_tx_count,SUM(CASE WHEN output_value >= 100 THEN output_value ELSE 0 END) AS whale_volume_btcFROM bitcoin.transactionsWHERE block_time >= NOW() - INTERVAL '5' YEARGROUP BY 1ORDER BY 1