Query editor
/* This query is just a filtered version of "Revenue By Day" */WITHunibotMarketcapByDay AS (SELECTdate_trunc('day', blockTime) AS block_date,APPROX_PERCENTILE(closePriceWETH, 0.5) AS unibotPriceWETH,APPROX_PERCENTILE(mcapETH, 0.5) AS unibotMarketcapETHFROM/* UNIBOT Token */query_2656557GROUP BYdate_trunc('day', blockTime)),revenueByDay AS (SELECTblock_date,/* Combined Revenue */totalCombinedRevenueUSD,totalCombinedRevenueWithoutV1TaxETH,cumulative_totalCombinedRevenueETH,/* Bot Revenue */totalBotFeeRevenueETH,cumulative_totalBotFeeRevenueETH,totalBotFeeRevenueSOL,/* Tax Revenue */totalTaxRevenueETH,totalTaxRevenueETHInUSD,cumulative_totalTaxV1AndV2RevenueETH,totalCombinedRevenueWithoutV1TaxETH7dSMA,/* Holder Revenue */totalHolderRevenueETH,holderBotFeeRevenueETH,holderBotFeeRevenueETHInUSD,holderTaxRevenueETH,holderTaxRevenueETHInUSD,cumulative_totalHolderRevenueETH,totalHolderRevenueETH7dSMA,totalHolderRevenueETH7dSMA * ethPriceUSD AS totalHolderRevenueETHInUSD7dSMA,totalHolderRevenueSOL7dSMA,totalHolderRevenueSOL7dSMA * solPriceUSD AS totalHolderRevenueSOLInUSD7dSMA,holderAndReferralBotFeeRevenueSOL,holderAndReferralBotFeeRevenueSOLInUSD,/* Team Revenue */teamAndReferralBotFeeRevenueETH,teamAndReferralBotFeeRevenueETHInUSD,ecoFundRevenueETH,ecoFundRevenueETHInUSD,teamTaxRevenueETH,teamTaxRevenueETHInUSD,teamBotFeeRevenueSOL,teamBotFeeRevenueSOLInUSD,/* LP Adds */addedLiquidityFromTaxRevenueETH,addedLiquidityFromTaxRevenueETHInUSD,/* Median Token Prices */ethPriceUSD,solPriceUSDFROM/* Revenue By Day */query_2651138