WITH table1 AS ( SELECT TIMESTAMP, TX_HASH, CONTRACT, CASE CONTRACT WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 'ETH' WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 'USDC' WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 'DAI' WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN 'USDT' WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN 'LUSD' WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN 'WBTC' WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN 'wstETH' WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN 'rETH' WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN 'LORDS' ELSE '31' END AS TOKEN_NAME, CASE CONTRACT WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 18 --WETH18DECIMALS WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 6 --USDC6DECIMALS WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 18 --DAI18DECIMALS WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN 6 --USDT6DECIMALS WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN 18 --LUSD18DECIMALS WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN 8 --WBTC8DECIMALS WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN 18 --wstETH31DECIMALS WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN 18 --rETH18DECIMALS WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN 18 --LORDS18DECIMALS ELSE '31' END AS decimals, CASE CONTRACT WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN PARAMETERS[2]:"value" ELSE PARAMETERS[2]:"value"[0]:"value" END AS raw_amount, PARAMETERS[0]:"value" AS swapper, PARAMETERS, CASE CONTRACT WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH18DECIMALS WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' --USDC6DECIMALS WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI18DECIMALS WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN '0xdac17f958d2ee523a2206206994597c13d831ec7' --USDT6DECIMALS WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' --WBTC8DECIMALS WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' --wstETH18DECIMALS WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN '0xae78736cd615f374d3085123a210448e74fc6393' --rETH18DECIMALS WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN '0x686f2404e77ab0d9070a46cdfb0b7fecdd2318b0' --LORDS18DECIMALS WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' --LUSD18DECIMALS ELSE '31' END AS addressonL1, TRACE_ID, EVENT_ORDER, EVENT_ID, ROW_NUMBER() OVER (PARTITION BY TX_HASH ORDER BY EVENT_ORDER) AS numberOfinputtokens FROM external.tokenflow_starknet.decoded_events WHERE CHAIN_ID = 'mainnet' AND NAME = 'Transfer' --AND TX_HASH = '0x033f7f9fbe5b77e3369747b1cfd90ba40db1d6f3f1ebafa58ed1a018f7dafcec' AND PARAMETERS[1]:"value" IN ('0x1b23ed400b210766111ba5b1e63e33922c6ba0c45e6ad56ce112e5f4c578e62' --fibrous router , '0x3201e8057a781dca378564b9d3bbe9b5b7617fac4ad9d9deaa1024cf63f877e' , '0xf6f4cf62e3c010e0ac2451cc7807b5eec19a40b0faacd00cca3914280fdf5a' --v3 router ) AND PARAMETERS[0]:"value" NOT IN ( '0x437bd0dab99c6a011ba3a9b17e103832c18af282a12c251555a1e05b8ea2f5b' --zetsu.stark , '0x7e2a13b40fc1119ec55e0bcf9428eedaa581ab3c924561ad4e955f95da63138' --JediSwap: DAI/ETH Pair , '0x45e7131d776dddc137e30bdd490b431c7144677e97bf9369f629ed8d3fb7dd6' --JediSwap: ETH/USDT Pair , '0x260e98362e0949fefff8b4de85367c035e44f734c9f8069b6ce2075ae86b45c' -- JediSwap: WBTC/ETH Pair , '0x4d0390b777b424e43839cd1e744799f3de6c176c7e32c1812a41dbd9c19db6a' -- JediSwap: ETH/USDC Pair , '0x5801bdad32f343035fb242e98d1e9371ae85bc1543962fedea16c59b35bd19b' -- JediSwap: USDC/USDT Pair , '0xcfd39f5244f7b617418c018204a8a9f9a7f72e71f0ef38f968eeb2a9ca302b' -- JediSwap: DAI/USDC Pair , '0xf0f5b3eed258344152e1f17baf84a2e1b621cd754b625bec169e8595aea767' -- JediSwap: DAI/USDT Pair , '0x5a8054e5ca0b277b295a830e53bd71a6a6943b42d0dbb22329437522bc80c8' -- JediSwap: WBTC/USDC Pair , '0x44d13ad98a46fd2322ef2637e5e4c292ce8822f47b7cb9a1d581176a801c1a0' -- JediSwap: WBTC/USDT Pair , '0x70cda8400d7b1ee9e21f7194d320b9ad9c7a2b27e0d15a5a9967b9fefe10c76' --JediSwap: ETH/wstETH Pair , '0x2b3030c04e9c920bd66c6a8dc209717bbefa1ea5f8bc8ebabd639e5a4766502' --Jediswap eth/lords , '0x39c183c8e5a2df130eefa6fbaa3b8aad89b29891f6272cb0c90deaa93ec6315' --JediSwap: DAI/WBTC , '0x7f409bd2e266e00486566dd3cb72bacc6996f49c0b19f04c0a8b5bd7bf991d1' --JediSwap: LORDS/USDC , '0x54a6698d6ac927713cf66c2f595948991e0a27e1b1ac04956c32026d94a8f99' --JediSwap: LORDS/WBTC , '0x74855288dbb974584593acf7bd738572cce3d8f90a7076722d0a624a97d2620' --JediSwap: USDC/wstETH , '0x56dc2aa83379f195de35ee699a270c76f1c2840b8b97385689d9137b38d9f44' --JediSwap: DAI/LORDS , '0x73ffa5c873e39a2e8ea21494133081f4202b0dd583e50383a231b1f6f136a85' --JediSwap: DAI/wstETH , '0x16220c67cdff746f2afd4178524a2dc9e49ff15567694277fa2302130576678' --JediSwap: wBTC/wstETH , '0x51184e312f09abcbf28132d6ef58259a6ebe9b5e7e32b5200427fdc96973f94' --JediSwap: USDT/LORDS , '0x33863afb8968fc40bc588a7c839faea1d47bb43d034b8ba19f0b8acb7191522' --JediSwap: USDT/wstETH , '0x781694f7f5f4dc9d7273e669ab0f9c8a0bd2d2279cc238e53522cd2e028c69c' --JediSwap: LORDS/wstETH , '0x041a708cf109737a50baa6cbeb9adf0bf8d97112dc6cc80c7a458cbad35328b0' -- 10KSwap: USDC-USDT Pair , '0x23c72abdf49dffc85ae3ede714f2168ad384cc67d08524732acea90df325' -- 10KSwap: ETH-USDC Pair , '0x17e9e62c04b50800d7c59454754fe31a2193c9c3c6c92c093f2ab0faadf8c87' -- 10KSwap: DAI-ETH Pair , '0x50031010bcee2f43575b3afe197878e064e1a03c12f2ff437f29a2710e0b6ef' -- 10KSwap: WBTC-USDT Pair , '0x5900cfa2b50d53b097cb305d54e249e31f24f881885aae5639b0cd6af4ed298' -- 10KSwap: ETH-USDT Pair , '0x2a6e0ecda844736c4803a385fb1372eff458c365d2325c7d4e08032c7a908f3' -- 10KSwap: WBTC-ETH Pair , '0x2e767b996c8d4594c73317bb102c2018b9036aee8eed08ace5f45b3568b94e5' -- 10KSwap: DAI-USDC Pair , '0x41a708cf109737a50baa6cbeb9adf0bf8d97112dc6cc80c7a458cbad35328b0' -- 10KSwap: USDC-USDT Pair , '0xf9d8f827734f5fd54571f0e78398033a3c1f1074a471cd4623f2aa45163718' -- 10KSwap: DAI-WBTC Pair , '0x41d52e15e82b003bf0ad52ca58393c87abef3e00f1bf69682fd4162d5773f8f' -- 10KSwap: DAI-USDT Pair , '0x22e45d94d5c6c477d9efd440aad71b2c02a5cd5bed9a4d6da10bb7c19fd93ba' -- 10KSwap: WBTC-USDC Pair , '0x2aab581754064a87ade1b680fd9756dc3a17440a87aaf496dcfb39fd163d1dd' --SithSwap: DAI/ETH , '0x32ebb8e68553620b97b308684babf606d9556d5c0a652450c32e85f40d000d' --SithSwap: DAI/ETH , '0x30615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' --SithSwap: ETH/USDC , '0x6e1ed57b7e9fed35364ca419340c47479e93206a2dcda5e50530ae198d872ea' --SithSwap: ETH/USDC , '0x691fa7f66d63dc8c89ff4e77732fff5133f282e7dbd41813273692cc595516' --SithSwap: ETH/USDT , '0x4d15040581b20b7682ad69db3c57fd0513fdc55639b8b406da3ddcd5ba39b8a' --SithSwap: DAI/USDT , '0x5e86d570376e8dc917d241288150a3286c8ad7151638c152d787eca2b96aec3' --SithSwap: ETH/USDT , '0x030615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' --SithSWap: ETH/USDC , '0x15e9cd2d4d6b4bb9f1124688b1e6bc19b4ff877a01011d28c25c9ee918e83e5' --SithSwap: DAI/USDC , '0x601f72228f73704e827de5bcd8dadaad52c652bb1e42bf492d90bbe22df2cec' --SithSwap: USDC/USDT , '0x106ff0f48fba1274b1f4f65e6d847fa58ac455e95318754fec20eb221b660ed' --SithSwap: WBTC/ETH , '0x3b65c0d9664f7d186c457f6678044485fa3dc4e9bb921c9491bd229287351c8' --SithSwap: WBTC/ETH , '0xa144ef99419e4dbb3ef99bc2db894fbe7b4532ebed9592a407908727321fcf' --SithSwap: DAI/USDC , '0x7500d8ba71b0a0c587fa431753dbb01a4595a434f27b296358c2c4cb7f83585' --SithSwap: DAI/USDT , '0x34b7f1c71726cd75e3b1664371beec65890e46f110f2c175d465163638c691a' --SithSwap: USDC/USDT , '0x30615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' --SithSWap: ETH/USDC , '0x2718bbc0176cff083b5c95ac22691bd1c16d55d37ae153d3ba347ce2292417e' --SithSwap: ETH/LORDS , '0x24bd1600bbe18593e983f858f2e7a69148e6b973f43b6304b2b8cf110059595' --SithSwap: wBTC/USDC , '0x4244758dc89add83255ee9268e041117dc3249efeb29652ac0916c0e3a55c59' --SithSwap: ETH/rETH , '0xa20410b97dcbfb44f370b67f877c669d859ff85c536d5e8e8336b6d565e1f8' --SithSwap: ETH/wstETH , '0x69b1da498135bb5b06a322627f28945ca13bb759fa92074e8b4e1f06c567600' --SithSwap: wstETH/ETH , '0xc480346ef90a9463ef16b5ed5f9f9de66944f1eef78504d280a03086f46435' -- SithSwap rETH/ETH , '0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b' --EKUBOCORE , '0x10884171baf1914edc28d7afb619b40a4051cfae78a094a55d230f19e944a28' --mySwap , '0x1114c7103e12c2b2ecbd3a2472ba9c48ddcbf702b1c242dd570057e26212111' --mySwapCl ) ) , prices AS ( SELECT DATE_TRUNC('HOUR', HOUR) AS HOUR , TOKEN_ADDRESS , AVG(price) AS price FROM crosschain.price.fact_hourly_token_prices WHERE BLOCKCHAIN = 'ethereum' AND HOUR > '2023-05-07' AND TOKEN_ADDRESS IN ( '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH18DECIMALS , '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' --USDC6DECIMALS , '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI18DECIMALS , '0xdac17f958d2ee523a2206206994597c13d831ec7' --USDT6DECIMALS , '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' --LUSD18DECIMALS , '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' --WBTC8DECIMALS , '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' --wstETH18DECIMALS , '0x686f2404e77ab0d9070a46cdfb0b7fecdd2318b0' --LORDS18DECIMALS , '0xae78736cd615f374d3085123a210448e74fc6393' --rETH18DECIMALS , '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' --LUSD18DECIMALS ) GROUP BY 1,2 ) , fibrous AS ( SELECT CASE WHEN volume >= 0 AND volume <= 10 THEN 'A(0-10]' WHEN volume > 10 AND volume <= 50 THEN 'B(10-50]' WHEN volume > 50 AND volume <= 100 THEN 'C(50-100]' WHEN volume > 100 AND volume <= 250 THEN 'D(100-250]' WHEN volume > 250 AND volume <= 500 THEN 'E(250-500]' WHEN volume > 500 AND volume <= 1000 THEN 'F(500-1K]' WHEN volume > 1000 AND volume <= 2500 THEN 'G(1K-2.5K]' WHEN volume > 2500 AND volume <= 5000 THEN 'H(2.5K-5K]' WHEN volume > 5000 AND volume <= 10000 THEN 'I(5K-10K]' WHEN volume > 10000 AND volume <= 25000 THEN 'J(10K-25K]' WHEN volume > 25000 AND volume <= 50000 THEN 'K(25K-50K]' ELSE 'ERROR' END AS volumeTiers , 'Fibrous' AS platform , COUNT(TX_HASH) AS numberOfSwaps , SUM(volume) AS TotalVolume FROM ( SELECT COALESCE( (RAW_AMOUNT/POW(10,t.decimals)) * p.price, 0) AS volume , * FROM table1 t LEFT JOIN prices p ON t.addressonL1 = p.TOKEN_ADDRESS AND DATE_TRUNC('HOUR', t.TIMESTAMP) = p.HOUR WHERE t.TOKEN_NAME != '31' ) GROUP BY 1, 2 ) ------- , table11 AS ( SELECT TIMESTAMP, TX_HASH, CONTRACT, CASE CONTRACT WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 'ETH' WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 'USDC' WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 'DAI' WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN 'USDT' WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN 'WBTC' WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN 'wstETH' WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN 'LORDS' WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN 'rETH' WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN 'LUSD' ELSE '31' END AS TOKEN_NAME, CASE CONTRACT WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 18 --WETH18DECIMALS WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 6 --USDC6DECIMALS WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 18 --DAI18DECIMALS WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN 6 --USDT6DECIMALS WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN 8 --WBTC8DECIMALS WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN 18 --wstETH31DECIMALS WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN 18 --LORDS18DECIMALS WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN 18 --rETH18DECIMALS WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN 18 --LUSD18DECIMALS ELSE '31' END AS decimals, CASE CONTRACT WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN PARAMETERS[2]:value ELSE PARAMETERS[2]:"value"[0]:"value" END AS raw_amount, PARAMETERS[0]:"value" AS swapper, PARAMETERS, CASE CONTRACT WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH18DECIMALS WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' --USDC6DECIMALS WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI18DECIMALS WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN '0xdac17f958d2ee523a2206206994597c13d831ec7' --USDT6DECIMALS WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' --WBTC8DECIMALS WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' --wstETH18DECIMALS WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN '0x686f2404e77ab0d9070a46cdfb0b7fecdd2318b0' --LORDS18DECIMALS WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN '0xae78736cd615f374d3085123a210448e74fc6393' --rETH18DECIMALS WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' --LUSD18DECIMALS ELSE '31' END AS addressonL1, TRACE_ID, EVENT_ORDER, EVENT_ID, ROW_NUMBER() OVER (PARTITION BY TX_HASH ORDER BY EVENT_ORDER) AS numberOfinputtokens FROM external.tokenflow_starknet.decoded_events WHERE CHAIN_ID = 'mainnet' AND NAME = 'Transfer' AND TIMESTAMP > '2023-05-30' --AND TX_HASH = '0x00c404e56ba22933a060d8e66c2525fca54701694d72bd77138eb49ba908dab2' AND PARAMETERS[1]:"value" = '0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f' --avnu router AND PARAMETERS[0]:"value" NOT IN ( '0x7e2a13b40fc1119ec55e0bcf9428eedaa581ab3c924561ad4e955f95da63138' --JediSwap: DAI/ETH Pair , '0x45e7131d776dddc137e30bdd490b431c7144677e97bf9369f629ed8d3fb7dd6' --JediSwap: ETH/USDT Pair , '0x260e98362e0949fefff8b4de85367c035e44f734c9f8069b6ce2075ae86b45c' -- JediSwap: WBTC/ETH Pair , '0x4d0390b777b424e43839cd1e744799f3de6c176c7e32c1812a41dbd9c19db6a' -- JediSwap: ETH/USDC Pair , '0x5801bdad32f343035fb242e98d1e9371ae85bc1543962fedea16c59b35bd19b' -- JediSwap: USDC/USDT Pair , '0xcfd39f5244f7b617418c018204a8a9f9a7f72e71f0ef38f968eeb2a9ca302b' -- JediSwap: DAI/USDC Pair , '0xf0f5b3eed258344152e1f17baf84a2e1b621cd754b625bec169e8595aea767' -- JediSwap: DAI/USDT Pair , '0x5a8054e5ca0b277b295a830e53bd71a6a6943b42d0dbb22329437522bc80c8' -- JediSwap: WBTC/USDC Pair , '0x44d13ad98a46fd2322ef2637e5e4c292ce8822f47b7cb9a1d581176a801c1a0' -- JediSwap: WBTC/USDT Pair , '0x70cda8400d7b1ee9e21f7194d320b9ad9c7a2b27e0d15a5a9967b9fefe10c76' --JediSwap: ETH/wstETH Pair , '0x2b3030c04e9c920bd66c6a8dc209717bbefa1ea5f8bc8ebabd639e5a4766502' --Jediswap eth/lords , '0x39c183c8e5a2df130eefa6fbaa3b8aad89b29891f6272cb0c90deaa93ec6315' --JediSwap: DAI/WBTC , '0x7f409bd2e266e00486566dd3cb72bacc6996f49c0b19f04c0a8b5bd7bf991d1' --JediSwap: LORDS/USDC , '0x54a6698d6ac927713cf66c2f595948991e0a27e1b1ac04956c32026d94a8f99' --JediSwap: LORDS/WBTC , '0x74855288dbb974584593acf7bd738572cce3d8f90a7076722d0a624a97d2620' --JediSwap: USDC/wstETH , '0x56dc2aa83379f195de35ee699a270c76f1c2840b8b97385689d9137b38d9f44' --JediSwap: DAI/LORDS , '0x73ffa5c873e39a2e8ea21494133081f4202b0dd583e50383a231b1f6f136a85' --JediSwap: DAI/wstETH , '0x16220c67cdff746f2afd4178524a2dc9e49ff15567694277fa2302130576678' --JediSwap: wBTC/wstETH , '0x51184e312f09abcbf28132d6ef58259a6ebe9b5e7e32b5200427fdc96973f94' --JediSwap: USDT/LORDS , '0x33863afb8968fc40bc588a7c839faea1d47bb43d034b8ba19f0b8acb7191522' --JediSwap: USDT/wstETH , '0x781694f7f5f4dc9d7273e669ab0f9c8a0bd2d2279cc238e53522cd2e028c69c' --JediSwap: LORDS/wstETH , '0x041a708cf109737a50baa6cbeb9adf0bf8d97112dc6cc80c7a458cbad35328b0' -- 10KSwap: USDC-USDT Pair , '0x23c72abdf49dffc85ae3ede714f2168ad384cc67d08524732acea90df325' -- 10KSwap: ETH-USDC Pair , '0x17e9e62c04b50800d7c59454754fe31a2193c9c3c6c92c093f2ab0faadf8c87' -- 10KSwap: DAI-ETH Pair , '0x50031010bcee2f43575b3afe197878e064e1a03c12f2ff437f29a2710e0b6ef' -- 10KSwap: WBTC-USDT Pair , '0x5900cfa2b50d53b097cb305d54e249e31f24f881885aae5639b0cd6af4ed298' -- 10KSwap: ETH-USDT Pair , '0x2a6e0ecda844736c4803a385fb1372eff458c365d2325c7d4e08032c7a908f3' -- 10KSwap: WBTC-ETH Pair , '0x2e767b996c8d4594c73317bb102c2018b9036aee8eed08ace5f45b3568b94e5' -- 10KSwap: DAI-USDC Pair , '0x41a708cf109737a50baa6cbeb9adf0bf8d97112dc6cc80c7a458cbad35328b0' -- 10KSwap: USDC-USDT Pair , '0xf9d8f827734f5fd54571f0e78398033a3c1f1074a471cd4623f2aa45163718' -- 10KSwap: DAI-WBTC Pair , '0x41d52e15e82b003bf0ad52ca58393c87abef3e00f1bf69682fd4162d5773f8f' -- 10KSwap: DAI-USDT Pair , '0x22e45d94d5c6c477d9efd440aad71b2c02a5cd5bed9a4d6da10bb7c19fd93ba' -- 10KSwap: WBTC-USDC Pair , '0x2aab581754064a87ade1b680fd9756dc3a17440a87aaf496dcfb39fd163d1dd' --SithSwap: DAI/ETH , '0x32ebb8e68553620b97b308684babf606d9556d5c0a652450c32e85f40d000d' --SithSwap: DAI/ETH , '0x30615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' --SithSwap: ETH/USDC , '0x6e1ed57b7e9fed35364ca419340c47479e93206a2dcda5e50530ae198d872ea' --SithSwap: ETH/USDC , '0x691fa7f66d63dc8c89ff4e77732fff5133f282e7dbd41813273692cc595516' --SithSwap: ETH/USDT , '0x4d15040581b20b7682ad69db3c57fd0513fdc55639b8b406da3ddcd5ba39b8a' --SithSwap: DAI/USDT , '0x5e86d570376e8dc917d241288150a3286c8ad7151638c152d787eca2b96aec3' --SithSwap: ETH/USDT , '0x030615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' --SithSWap: ETH/USDC , '0x15e9cd2d4d6b4bb9f1124688b1e6bc19b4ff877a01011d28c25c9ee918e83e5' --SithSwap: DAI/USDC , '0x601f72228f73704e827de5bcd8dadaad52c652bb1e42bf492d90bbe22df2cec' --SithSwap: USDC/USDT , '0x106ff0f48fba1274b1f4f65e6d847fa58ac455e95318754fec20eb221b660ed' --SithSwap: WBTC/ETH , '0x3b65c0d9664f7d186c457f6678044485fa3dc4e9bb921c9491bd229287351c8' --SithSwap: WBTC/ETH , '0xa144ef99419e4dbb3ef99bc2db894fbe7b4532ebed9592a407908727321fcf' --SithSwap: DAI/USDC , '0x7500d8ba71b0a0c587fa431753dbb01a4595a434f27b296358c2c4cb7f83585' --SithSwap: DAI/USDT , '0x34b7f1c71726cd75e3b1664371beec65890e46f110f2c175d465163638c691a' --SithSwap: USDC/USDT , '0x30615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' --SithSWap: ETH/USDC , '0x2718bbc0176cff083b5c95ac22691bd1c16d55d37ae153d3ba347ce2292417e' --SithSwap: ETH/LORDS , '0x24bd1600bbe18593e983f858f2e7a69148e6b973f43b6304b2b8cf110059595' --SithSwap: wBTC/USDC , '0x4244758dc89add83255ee9268e041117dc3249efeb29652ac0916c0e3a55c59' --SithSwap: ETH/rETH , '0xa20410b97dcbfb44f370b67f877c669d859ff85c536d5e8e8336b6d565e1f8' --SithSwap: ETH/wstETH , '0x69b1da498135bb5b06a322627f28945ca13bb759fa92074e8b4e1f06c567600' --SithSwap: wstETH/ETH , '0xc480346ef90a9463ef16b5ed5f9f9de66944f1eef78504d280a03086f46435' -- SithSwap rETH/ETH , '0x10884171baf1914edc28d7afb619b40a4051cfae78a094a55d230f19e944a28' --MySwap AMM , '0x1114c7103e12c2b2ecbd3a2472ba9c48ddcbf702b1c242dd570057e26212111' --mySwapCL , '0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b' --EkuboCore ) ) , avnu AS ( SELECT CASE WHEN volume >= 0 AND volume <= 10 THEN 'A(0-10]' WHEN volume > 10 AND volume <= 50 THEN 'B(10-50]' WHEN volume > 50 AND volume <= 100 THEN 'C(50-100]' WHEN volume > 100 AND volume <= 250 THEN 'D(100-250]' WHEN volume > 250 AND volume <= 500 THEN 'E(250-500]' WHEN volume > 500 AND volume <= 1000 THEN 'F(500-1K]' WHEN volume > 1000 AND volume <= 2500 THEN 'G(1K-2.5K]' WHEN volume > 2500 AND volume <= 5000 THEN 'H(2.5K-5K]' WHEN volume > 5000 AND volume <= 10000 THEN 'I(5K-10K]' WHEN volume > 10000 AND volume <= 25000 THEN 'J(10K-25K]' WHEN volume > 25000 AND volume <= 50000 THEN 'K(25K-50K]' WHEN volume > 50000 AND volume <= 100000 THEN 'L(50K-100K]' ELSE 'ERROR' END AS volumeTiers , 'AVNU' AS platform , COUNT(TX_HASH) AS numberOfSwaps , SUM(volume) AS TotalVolume FROM ( SELECT * , COALESCE( (RAW_AMOUNT/POW(10,t.decimals)) * p.price, 0) AS volume FROM table11 t LEFT JOIN prices p ON t.addressonL1 = p.TOKEN_ADDRESS AND DATE_TRUNC('HOUR', t.TIMESTAMP) = p.HOUR WHERE t.TOKEN_NAME != '31' ) GROUP BY 1,2 ) SELECT * FROM fibrous UNION SELECT * FROM avnu

Fibrous vs AVNU