Query editor
with vote_data as (selectblock_date, signer as validator_address, COUNT(*) as vote_tx_count, SUM(fee) / 1000000000.0 as total_fees_sol, AVG(compute_units_consumed) as avg_compute_units, COUNT(casewhen success = falsethen 1end) as failed_votesfrom solana.vote_transactionsgroup byblock_date, signer), daily_validator_metrics as (selectblock_date, COUNT(distinct validator_address) as active_validators, AVG(vote_tx_count) as avg_votes_per_validator, MAX(vote_tx_count) as max_votes_by_validator, MIN(vote_tx_count) as min_votes_by_validator, APPROX_PERCENTILE(vote_tx_count, 0.5) as median_votes_per_validator, SUM(vote_tx_count) as total_votes, SUM(failed_votes) as total_failed_votes, SUM(total_fees_sol) as total_vote_fees_solfrom vote_datagroup byblock_date)selectv.block_date, v.active_validators, v.avg_votes_per_validator, v.median_votes_per_validator, v.total_votes, v.total_failed_votes, v.total_vote_fees_sol, t.total_transactions as total_non_vote_transactions, ROUND((TRY_CAST(v.total_votes as DECIMAL) / (v.total_votes + t.total_transactions)) * 100, 2) as vote_percentage, ROUND((v.total_vote_fees_sol / (v.total_vote_fees_sol + t.total_fees)) * 100, 2) as vote_fee_percentagefrom daily_validator_metrics as vleft join (selectblock_date, COUNT(*) as total_transactions, SUM(fee) / 1000000000.0 as total_feesfrom solana.transactionsgroup byblock_date) as t on v.block_date = t.block_dateorder byv.block_date desc