Query editor
WITH payer AS (SELECT * FROM (VALUES(0x51dbd97fa14f4d78f8afc2e92a692a9e087efb5c, 'P-A'),(0xfb19ffd1ff9316b7f5bba076ef4b78e4bbedf4e1, 'sin-atribuir'),(0x016606acc6b0cfe537acc221e3bf1bb44b4049ee, 'P-B'),(0xdd3d72c53ff982ff59853da71158bf1538b3ceee, 'P-hex14')) AS t(addr, prov)),tk AS (SELECT * FROM (VALUES(0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 'USDC', 6),(0xdac17f958d2ee523a2206206994597c13d831ec7, 'USDT', 6),(0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2, 'WETH', 18),(0x6b175474e89094c44da98b954eedeac495271d0f, 'DAI', 18),(0x6c3ea9036406852006290770bedfcaba0e23a0e8, 'PYUSD', 6),(0x45804880de22913dafe09f4980848ece6ecbaf78, 'PAXG', 18)) AS t(addr, sym, dec)),px AS (SELECT contract_address, timestamp AS d, price FROM prices.dayWHERE blockchain = 'ethereum' AND timestamp >= TIMESTAMP '2026-01-01' AND timestamp < TIMESTAMP '2026-07-30'AND contract_address IN (SELECT addr FROM tk)),-- 1) payouts: scan filtrado por los 4 pagadorespo AS (SELECT p.prov, t."to" AS usuario, t.evt_block_time AS ts, tk.sym AS out_sym,t.value / power(10, tk.dec) * px.price AS out_usdFROM erc20_ethereum.evt_Transfer tJOIN payer p ON p.addr = t."from"JOIN tk ON tk.addr = t.contract_addressJOIN px ON px.contract_address = t.contract_address AND px.d = date_trunc('day', t.evt_block_time)WHERE t.evt_block_time >= TIMESTAMP '2026-01-01' AND t.evt_block_time < TIMESTAMP '2026-07-30'UNION ALLSELECT p.prov, x."to", x.block_time, 'ETH',CAST(x.value AS double) / 1e18 * px.priceFROM ethereum.transactions xJOIN payer p ON p.addr = x."from"JOIN px ON px.contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND px.d = date_trunc('day', x.block_time)WHERE x.block_time >= TIMESTAMP '2026-01-01' AND x.block_time < TIMESTAMP '2026-07-30'AND x.value > CAST(0 AS uint256)),pou AS (SELECT * FROM po WHERE out_usd BETWEEN 10 AND 50000),usr AS (SELECT DISTINCT usuario FROM pou),-- 2) depósitos: scan filtrado por esos usuariosdep AS (SELECT t."from" AS usuario, t.evt_block_time AS ts, tk.sym AS in_sym,t.value / power(10, tk.dec) * px.price AS in_usdFROM erc20_ethereum.evt_Transfer tJOIN usr u ON u.usuario = t."from"JOIN tk ON tk.addr = t.contract_addressJOIN px ON px.contract_address = t.contract_address AND px.d = date_trunc('day', t.evt_block_time)WHERE t.evt_block_time >= TIMESTAMP '2026-01-01' AND t.evt_block_time < TIMESTAMP '2026-07-30'UNION ALLSELECT x."from", x.block_time, 'ETH',CAST(x.value AS double) / 1e18 * px.priceFROM ethereum.transactions xJOIN usr u ON u.usuario = x."from"JOIN px ON px.contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND px.d = date_trunc('day', x.block_time)