Query editor
-- Burner de los 10 legs reales del 2026-07-22. Los ERC20 entrantes son los payouts de XO.WITH t AS (SELECT 'ethereum' AS chain, evt_block_time AS ts, contract_address AS token, "from" AS pagador, value, evt_tx_hash AS txFROM erc20_ethereum.evt_TransferWHERE evt_block_time >= TIMESTAMP '2026-07-22 00:00' AND evt_block_time < TIMESTAMP '2026-07-23 00:00'AND "to" = 0x44b28631260ffae6220951f6f6b418a512bce388UNION ALLSELECT 'arbitrum', evt_block_time, contract_address, "from", value, evt_tx_hashFROM erc20_arbitrum.evt_TransferWHERE evt_block_time >= TIMESTAMP '2026-07-22 00:00' AND evt_block_time < TIMESTAMP '2026-07-23 00:00'AND "to" = 0x44b28631260ffae6220951f6f6b418a512bce388UNION ALLSELECT 'polygon', evt_block_time, contract_address, "from", value, evt_tx_hashFROM erc20_polygon.evt_TransferWHERE evt_block_time >= TIMESTAMP '2026-07-22 00:00' AND evt_block_time < TIMESTAMP '2026-07-23 00:00'AND "to" = 0x44b28631260ffae6220951f6f6b418a512bce388)SELECT t.chain, t.ts, coalesce(e.symbol, 'n/d') AS token,t.value / power(10, coalesce(e.decimals, 18)) AS recibido,t.pagador, t.txFROM tLEFT JOIN tokens.erc20 e ON e.contract_address = t.token AND e.blockchain = t.chainORDER BY t.chain, t.ts