Query editor
-- API3 OEV & Other Income (Monthly)SELECTDATE_TRUNC('month', evt_block_time) AS month,SUM(value / 1e6) AS oev_other_usdcFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48AND "to" IN (0x8e03609ed680B237C7b6f8020472CA0687308b24,0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA)AND "from" NOT IN (0x8e03609ed680B237C7b6f8020472CA0687308b24,0xBBE0dE9757F93e3306aDBfeBE906AB285EDD13DA,0xe2221Aa07ec3266DA87763E2b1e28d07A8a4e53b,0xB3f4D94A209045Ef35661e657Db9ADAc584141f1,0x54210d3f1A066413891AF9E17210E787d5C6e3f4,0x62067831C193810F3b044Cc42249632b5d08Bc6b,0x68Aea7b82Df6CcdF76235D46445Ed83f85F845A3,0xBBBBBbbBBb9cC5e90e3b3Af64bdAF62C37EEFFCb,0x3Ef3D8bA38EBe18DB133cEc108f4D14CE00Dd9Ae,0x330eefa8a787552DC5cAd3C3cA644844B1E61Ddb,0x556ecbb0311d350491ba0ec7e019c354d7723ce0,0x9008d19f58aabd9ed0d60971565aa8510560ab41,0x4a6c312ec70e8747a587ee860a0353cd42be0ae0,0x36cfe1568461E499391ef0A555300F1ae2da2439, -- Api3 dCOMP USDC VaultV20xc92A37Fd0250F4eecF092960a2F70A1334217528 -- Purinta USDC VaultV2)AND evt_block_time >= TIMESTAMP '2025-12-01'GROUP BY 1ORDER BY 1 DESC