Query editor
WITH params AS (SELECTFROM_HEX('2791bca1f2de4661ed88a30c99a7a9449aa84174') AS usdc,TIMESTAMP '2025-01-01' AS since,FROM_HEX('cbc57e7899126f3ad47268a6505231d82b8733c8') AS polycule_fee,FROM_HEX('af1797e6e7b38da5f03743a6d92af9fd2bd8d849') AS flipr_vault,FROM_HEX('2f1339db75e1dc0cf133d61538ede7964647ccf0') AS polymtrade_fee,FROM_HEX('3db33dfce16259ea149186631a6a42a11cf68bb9') AS okbet_fee,FROM_HEX('32acf34e8091b057ca0dd3facbb50b07f0a25b87') AS predictify_fee),eoa AS (SELECT DISTINCT "from" AS addr FROM polygon.transactions),polycule_users AS (SELECT DISTINCT e."from" AS addr, 'polycule' AS botFROM erc20_polygon.evt_transfer eCROSS JOIN params pWHERE e.contract_address = p.usdc AND e."to" = p.polycule_fee AND e.evt_block_time >= p.since),polymtrade_users AS (SELECT DISTINCT e."from" AS addr, 'polymtrade' AS botFROM erc20_polygon.evt_transfer eCROSS JOIN params pWHERE e.contract_address = p.usdc AND e."to" = p.polymtrade_fee AND e.evt_block_time >= p.since),okbet_users AS (SELECT DISTINCT e."from" AS addr, 'okbet' AS botFROM erc20_polygon.evt_transfer eCROSS JOIN params pWHERE e.contract_address = p.usdc AND e."to" = p.okbet_fee AND e.evt_block_time >= p.since),predictify_users AS (SELECT DISTINCT e."from" AS addr, 'predictify' AS botFROM erc20_polygon.evt_transfer eCROSS JOIN params pWHERE e.contract_address = p.usdc AND e."to" = p.predictify_fee AND e.evt_block_time >= p.since),flipr_users AS (SELECT DISTINCT e."from" AS addr, 'flipr_users' AS botFROM erc20_polygon.evt_transfer eCROSS JOIN params pJOIN eoa ON e."from" = eoa.addrWHERE e.contract_address = p.usdcAND e."to" = p.flipr_vaultAND e."from" <> p.flipr_vaultAND e.evt_block_time >= p.since),all_users AS (SELECT * FROM polycule_usersUNION ALL SELECT * FROM polymtrade_usersUNION ALL SELECT * FROM okbet_usersUNION ALL SELECT * FROM predictify_usersUNION ALL SELECT * FROM flipr_users),fills AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,makerAssetId AS maker_asset_id,takerAmountFilled AS taker_amt,makerAmountFilled AS maker_amt,