Query editor
/* WETHAddress: 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 *//* BotDeployerAddress: 0xf414d478934c29d9a80244a3626c681a71e53bb2 *//* BotDeployerFirstTransactionBlockNumber: 17345515 *//* BotDeployerFirstTransactionTimestamp: '2023-05-26 00:00:00.000 UTC' *//* BANANAV1Address: 0xCcF5CF1D039F1a7B66Be855B79B14A01D0a4dbd5 *//* BANANAV1DeploymentBlockNumber: 18114730 *//* BANANAV1UniswapV2PairAddress: 0x5ad6c0d8d57c0050fa954e227c45339ab8cb953b *//* BANANAV2Address: 0x38E68A37E401F7271568CecaAc63c6B1e19130B4 *//* BANANAV2ADeploymentBlockNumber: 18135851 *//* UniswapV2PairAddress: 0x43de4318b6eb91a7cf37975dbb574396a7b5b5c6 *//* TeamWallet: 0x37aAb97476bA8dC785476611006fD5dDA4eed66B *//* TreasuryWallet: 0xDa74C6B4E6813bdb83cb4cff6ad4eB8D43F34B0D *//* RevshareWallet: 0x90c858023Efd445fF8b8F11911Cff5f59863d61a */WITHtaxDistributions AS (SELECT*FROM/* Tax Fees By Distribution */query_3026941),lifetimeTaxRevenue AS (SELECTSUM(totalTaxRevenueETH) AS lifetimeTotalTaxRevenueETH,SUM(teamTaxRevenueETH) AS lifetimeTeamTaxRevenueETH,SUM(revshareTaxRevenueETH) AS lifetimeRevshareTaxRevenueETH,SUM(treasuryTaxRevenueETH) AS lifetimeTreasuryTaxRevenueETHFROMtaxDistributions),botTradesWithFees AS (SELECTtx_hash,user,amount_usd,fee_usd,fee_token_amount,fee_token_symbol,block_time,block_number,date_trunc('day', block_time) AS block_dateFROM/* Banana Gun Bot Trades */query_2683548WHEREisLastTradeInTransaction = true -- This prevents over counting for multi-hop trades and excludes tax distributions),/*bribes AS (SELECTSUM(bribeETH) AS totalBribesETH,AVG(bribeETH) AS averageBribeETH,APPROX_PERCENTILE(bribeETH, 0.5) AS medianBribeETH,MAX(bribeETH) AS highestBribeETH,COUNT(DISTINCT (user)) AS numberOfBribers,COUNT(DISTINCT (tx_hash)) AS numberOfBribes,COUNT(DISTINCT (miner_address)) AS numberOfMinersBribedFROMquery_3015915 -- Miner Bribes),*/