Query editor
-- this query gives the single value stats for use as the headerwithstats AS (SELECTcount(*) AS total_txs,date_diff('day', min(evt_block_time), max(evt_block_time)) as days_live,count(distinct caller) as unique_callers,sum(tx_protocolAmount_usd) as total_bnt_earned_usd,sum(tx_rewardAmount_usd) as total_rewards_paid_usd,sum(tx_protocolAmount_usd+tx_rewardAmount_usd) as total_arb_value_usd,sum(tx_sourceAmount_usd) as total_flashloaned_usd,sum(tx_fee_eth) as total_gas_spent_eth,sum(tx_fee_usd) as total_gas_spent_usdfrom query_3421183)select *,(select reward_usd from query_3422217 limit 1) as single_big_reward_usd,total_bnt_earned_usd / days_live as avg_day_bnt_earned_usd,total_bnt_earned_usd / total_txs as avg_tx_bnt_earned_usd,total_rewards_paid_usd/days_live as avg_day_rewards_usd,total_rewards_paid_usd/total_txs as avg_tx_rewards_usd,total_gas_spent_eth/days_live as avg_day_eth_spent_eth,total_gas_spent_usd/days_live as avg_day_eth_spent_usd,total_gas_spent_eth/total_txs as avg_tx_eth_spent_eth,total_gas_spent_usd/total_txs as avg_tx_eth_spent_usdfrom stats