Query editor
-- Active User Wallets in a Time Window (with activity breakdown)---- Definition: per wallet, counts of trades (FillOrder), liquidations-- (Liquidation), and collateral changes (ModifyCollateral) within a provided-- epoch (Unix seconds) time window.---- The wallet is the first 20 bytes of the bytes32 subaccount.---- Contract addresses (prod):-- OffchainExchange: 0x8373C3Aa04153aBc0cfD28901c3c971a946994ab-- Clearinghouse: 0xD218103918C19D0A10cf35300E4CfAfbD444c5fE---- Parameters:-- {{start_epoch}} = window start, Unix epoch seconds (inclusive)-- {{end_epoch}} = window end, Unix epoch seconds (exclusive)WITH raw_events AS (SELECTtopic0,CASE topic0WHEN 0xb563bd3722620e7af6c3dae109897ca2f45fbbc5975fb6553bb2d53b77e54bf3THEN topic3WHEN 0xfe53084a731040f869d38b1dcd00fbbdbc14e10d7d739160559d77f5bc80cf05THEN topic1WHEN 0x494f937f5cc892f798248aa831acfb4ad7c4bf35edd8498c5fb431ce1e38b035THEN topic2END AS subaccountFROM ink.logsWHERE contract_address IN (0x8373C3Aa04153aBc0cfD28901c3c971a946994ab,0xD218103918C19D0A10cf35300E4CfAfbD444c5fE)AND topic0 IN (0xb563bd3722620e7af6c3dae109897ca2f45fbbc5975fb6553bb2d53b77e54bf3,0xfe53084a731040f869d38b1dcd00fbbdbc14e10d7d739160559d77f5bc80cf05,0x494f937f5cc892f798248aa831acfb4ad7c4bf35edd8498c5fb431ce1e38b035)AND block_time >= FROM_UNIXTIME({{start_epoch}})AND block_time < FROM_UNIXTIME({{end_epoch}})),wallet_events AS (SELECTSUBSTR(subaccount, 1, 20) AS wallet,topic0FROM raw_eventsWHERE subaccount IS NOT NULLAND SUBSTR(subaccount, 1, 20) != 0x0000000000000000000000000000000000000000)SELECTwallet,COUNT_IF(topic0 = 0xb563bd3722620e7af6c3dae109897ca2f45fbbc5975fb6553bb2d53b77e54bf3) AS total_trades,COUNT_IF(topic0 = 0x494f937f5cc892f798248aa831acfb4ad7c4bf35edd8498c5fb431ce1e38b035) AS total_liquidations,COUNT_IF(topic0 = 0xfe53084a731040f869d38b1dcd00fbbdbc14e10d7d739160559d77f5bc80cf05) AS total_modify_collateralFROM wallet_eventsGROUP BY walletORDER BY total_trades DESC, total_liquidations DESC, total_modify_collateral DESC