Query editor
SELECTCASE WHEN Market = 'ID105' THEN '[105] weETH-ETH' WHEN Market = 'ID144' THEN '[144] sUSDf-USDC' WHEN Market = 'ID145' THEN '[145] PT-sUSDf(25 Sep)-USDC'WHEN Market = 'ID118' THEN '[118] LP-eUSDe(14 Aug 25)-USDC' WHEN Market = 'ID123' THEN '[123] PT-eUSDE(14 Aug)-USDC' WHEN Market = 'ID117' THEN '[117] LP-sUSDe(31 Jul 25)-USDC'WHEN Market = 'ID124' THEN '[124] PT-sUSDE(25 Sep)-USDC' WHEN Market = 'ID127' THEN '[127] RLP-USDC' WHEN Market = 'ID135' THEN '[135] PT-USR(4 Sep)-USDC'WHEN Market = 'ID138' THEN '[138] PT-wstUSR(25 Sep)-USDC' WHEN Market = 'ID104' THEN '[104] ezETH-ETH' WHEN Market = 'ID113' THEN '[113] LP-sUSDe(25 Sep 25)-USDC'WHEN Market = 'ID150' THEN '[150] wsrUSD-USDC' WHEN Market = 'ID140' THEN '[140] PT-RLP(4 Sep)-USDC'WHEN Market = 'ID146' THEN '[146] PT-cUSDO(20 Nov)-USDC' WHEN Market = 'ID149' THEN '[149] PT-USDS(14 Aug)-USDC' WHEN Market = 'ID137' THEN '[137] PT-USDe(25 Sep)-USDC'WHEN Market = 'ID142' THEN '[142] mMEV-USDC' WHEN Market = 'ID131' THEN '[131] WBTC-USDC' WHEN Market = 'ID125' THEN '[125] PT-eUSDE(14 Aug)-USDf'WHEN Market = 'ID148' THEN '[148] USR-USDC' WHEN Market = 'ID147' THEN '[147] wstUSR-USDC' WHEN Market = 'ID151' THEN '[151] USDf-USDC' WHEN Market = 'ID152' THEN '[152] tETH-ETH'WHEN Market = 'ID153' THEN '[153] PT-tETH-8JAN2026/ETH' WHEN Market = 'ID154' THEN '[154] RLP-USDC' WHEN Market = 'ID155' THEN '[155] xUSD-USDC' WHEN Market = 'ID158' THEN '[158] slvlUSD-USDC'WHEN Market = 'ID159' THEN '[159] PT-slvlUSD-25SEP2025/USDC' WHEN Market = 'ID162' THEN '[162] wstETH-ETH' WHEN Market = 'ID163' THEN '[163] weETH-ETH'WHEN Market = 'ID164' THEN '[164] ARM-WETH-stETH/ETH' WHEN Market = 'ID165' THEN '[165] PT-tUSDe-25SEP2025/USDC' WHEN Market = 'ID166' THEN '[166] ETH+/ETH'WHEN Market = 'ID168' THEN '[168] siUSD-USDC' WHEN Market = 'ID169' THEN '[169] PT-siUSD(9 Oct)/USDC'WHEN Market = 'ID170' THEN '[170] PT-sUSDf(29 Jan)/USDC' WHEN Market = 'ID171' THEN '[171] PT-USDf(29 Jan)/USDC' WHEN Market = 'ID172' THEN '[172] savETH-ETH'WHEN Market = 'ID173' THEN '[173] PT-iUSD(4 Dec)/USDC' WHEN Market = 'ID175' THEN '[175] PT-wstUSR(29 Jan)/USDC' WHEN Market = 'ID178' THEN '[178] PT-iUSD(19 Feb)/USDC'WHEN Market = 'ID181' THEN '[181] siUSD-USDC' WHEN Market = 'ID182' THEN '[182] PT-reUSD(25 Jun)/USDC'ELSE Market END AS Market, COUNT(DISTINCT Owner) AS Users, COUNT(Hash) AS TxnsFROM query_5494012GROUP BY 1ORDER BY 2 DESC