Query editor
-- Nado Revenue By User Per Month Query-- Shows revenue breakdown per wallet address per month-- Time period: November 2025 through April 2026WITH recent_fills AS (SELECT*,CAST(BYTEARRAY_SUBSTRING(subaccount, 1, 20) AS VARBINARY) AS wallet,DATE_TRUNC('month', evt_block_time) AS monthFROM nado_ink.offchainexchange_evt_fillorderWHERE evt_block_time >= TIMESTAMP '2025-11-01'AND evt_block_time < TIMESTAMP '2026-05-01')SELECTmonth,wallet,SUM(CASE WHEN isTaker THEN feeAmount / 1e18 ELSE 0 END) AS taker_fees,SUM(CASE WHEN NOT isTaker AND feeAmount > 0 THEN feeAmount / 1e18 ELSE 0 END) AS maker_fees,SUM(CASE WHEN NOT isTaker AND feeAmount < 0 THEN feeAmount / 1e18 ELSE 0 END) AS maker_rebates,SUM(feeAmount / 1e18) AS revenue,COUNT(*) AS total_trades,SUM(CASE WHEN isTaker THEN 1 ELSE 0 END) AS taker_fills,SUM(CASE WHEN NOT isTaker THEN 1 ELSE 0 END) AS maker_fillsFROM recent_fillsGROUP BYmonth,walletORDER BY month, revenue DESC