CONTRACT_ADDRESS | CONTRACT_NAME | SYMBOL_1 | SYMBOL_2 | DEX | SYMBOL_1_DECIMALS | SYMBOL_2_DECIMALS | |
|---|---|---|---|---|---|---|---|
1 | 0x247442181b8baa03b3c7dc0d8e971bd4686db27c | BOBA/WETH | BOBA | WETH | Sushiswap | 18 | 18 |
2 | 0x4f059f8d45230cd5b37544e87eebba033a5f1b17 | USDC/WETH | USDC | WETH | Sushiswap | 6 | 18 |
3 | 0x2e014fe08247a080f2ed6d230b2594911f9f9a69 | USDT/USDC | USDT | USDC | Uniswap | 6 | 6 |
4 | 0x78c6db2b6073e762f89a23eb3da71d2feeb18315 | SUSHI/WETH | SUSHI | WETH | Sushiswap | 18 | 18 |
5 | 0x0ec9d6d21358221cccfc933530a8026038cedc12 | USDC/WETH | USDC | WETH | Uniswap | 6 | 18 |
6 | 0x48643395833882729032170078bf7791a0999f8c | USDC/BOBA | USDC | BOBA | Sushiswap | 6 | 18 |
7 | 0xce4956c398ba118f4eacabca1b32ae97bd31df2a | SUSHI/BOBA | SUSHI | BOBA | Sushiswap | 18 | 18 |
8 | 0x6398a59ca706c11d02de1ea3d921742771bcd06f | WBTC/WETH | WBTC | WETH | Sushiswap | 8 | 18 |
9 | 0x3b444d1dbf68d1cfc64a8158affb6a24a6bdf038 | BOBA/WETH | BOBA | WETH | Uniswap | 18 | 18 |
10 | 0xaf3da220bc03bdbf9b0280d6e2813ea0ffe03f69 | USDC/BOBA | USDC | BOBA | Sushiswap | 6 | 18 |
datavortexpools, dex and decimals
Updated 2025-04-01
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT DISTINCT
contract_address,
CASE
WHEN contract_address = '0x0ec9d6d21358221cccfc933530a8026038cedc12' THEN 'USDC/WETH'
WHEN contract_address = '0x2e014fe08247a080f2ed6d230b2594911f9f9a69' THEN 'USDT/USDC'
WHEN contract_address = '0x3b444d1dbf68d1cfc64a8158affb6a24a6bdf038' THEN 'BOBA/WETH'
WHEN contract_address = '0x48643395833882729032170078bf7791a0999f8c' THEN 'USDC/BOBA'
WHEN contract_address = '0x247442181b8baa03b3c7dc0d8e971bd4686db27c' THEN 'BOBA/WETH'
WHEN contract_address = '0xce4956c398ba118f4eacabca1b32ae97bd31df2a' THEN 'SUSHI/BOBA'
WHEN contract_address = '0x6398a59ca706c11d02de1ea3d921742771bcd06f' THEN 'WBTC/WETH'
WHEN contract_address = '0x4f059f8d45230cd5b37544e87eebba033a5f1b17' THEN 'USDC/WETH'
WHEN contract_address = '0x78c6db2b6073e762f89a23eb3da71d2feeb18315' THEN 'SUSHI/WETH'
WHEN contract_address = '0xaf3da220bc03bdbf9b0280d6e2813ea0ffe03f69' THEN 'USDC/BOBA'
END AS contract_name,
SPLIT_PART(
CASE
WHEN contract_address = '0x0ec9d6d21358221cccfc933530a8026038cedc12' THEN 'USDC/WETH'
WHEN contract_address = '0x2e014fe08247a080f2ed6d230b2594911f9f9a69' THEN 'USDT/USDC'
WHEN contract_address = '0x3b444d1dbf68d1cfc64a8158affb6a24a6bdf038' THEN 'BOBA/WETH'
WHEN contract_address = '0x48643395833882729032170078bf7791a0999f8c' THEN 'USDC/BOBA'
WHEN contract_address = '0x247442181b8baa03b3c7dc0d8e971bd4686db27c' THEN 'BOBA/WETH'
WHEN contract_address = '0xce4956c398ba118f4eacabca1b32ae97bd31df2a' THEN 'SUSHI/BOBA'
WHEN contract_address = '0x6398a59ca706c11d02de1ea3d921742771bcd06f' THEN 'WBTC/WETH'
WHEN contract_address = '0x4f059f8d45230cd5b37544e87eebba033a5f1b17' THEN 'USDC/WETH'
WHEN contract_address = '0x78c6db2b6073e762f89a23eb3da71d2feeb18315' THEN 'SUSHI/WETH'
WHEN contract_address = '0xaf3da220bc03bdbf9b0280d6e2813ea0ffe03f69' THEN 'USDC/BOBA'
END, '/', 1
) AS symbol_1,
SPLIT_PART(
CASE
WHEN contract_address = '0x0ec9d6d21358221cccfc933530a8026038cedc12' THEN 'USDC/WETH'
WHEN contract_address = '0x2e014fe08247a080f2ed6d230b2594911f9f9a69' THEN 'USDT/USDC'
WHEN contract_address = '0x3b444d1dbf68d1cfc64a8158affb6a24a6bdf038' THEN 'BOBA/WETH'
Last run: about 1 month ago
10
902B
2s