Query editor
WITHallFeePayments AS (SELECTfeePayments.tx_idFROMsolana.account_activity feePaymentsWHEREblock_time >= TIMESTAMP '2024-05-14'AND tx_successAND address = 'F4hJ3Ee3c5UuaorKAMfELBjYCjiiLH75haZTKqTywRP3'AND balance_change > 0),botTrades AS (SELECTtrades.block_time,trades.tx_id,trades.trader_idFROMdex_solana.trades tradesJOIN allFeePayments feePayments ON trades.tx_id = feePayments.tx_idWHEREtrades.trader_id != 'F4hJ3Ee3c5UuaorKAMfELBjYCjiiLH75haZTKqTywRP3'),daily_trades AS (SELECTDATE_TRUNC('day', botTrades.block_time) AS day,COUNT(DISTINCT botTrades.tx_id) AS daily_trades,COUNT(DISTINCT botTrades.trader_id) AS daily_usersFROMbotTradesGROUP BYDATE_TRUNC('day', botTrades.block_time)),lifetime_trades AS (SELECTCOUNT(DISTINCT botTrades.tx_id) AS lifetime_trades,COUNT(DISTINCT botTrades.trader_id) AS lifetime_usersFROMbotTrades),seven_day_trades AS (SELECTCOUNT(DISTINCT botTrades.tx_id) AS seven_day_trades,COUNT(DISTINCT botTrades.trader_id) AS seven_day_usersFROMbotTradesWHEREbotTrades.block_time >= NOW() - INTERVAL '7' DAY)SELECTday,daily_trades,daily_users,(SELECT lifetime_trades FROM lifetime_trades) AS lifetime_trades,(SELECT lifetime_users FROM lifetime_trades) AS lifetime_users,(SELECT seven_day_trades FROM seven_day_trades) AS seven_day_trades,(SELECT seven_day_users FROM seven_day_trades) AS seven_day_usersFROMdaily_tradesORDER BY