Delamir-6014 USDC Volume in Sushi WBTC-WETH compared with WETH-USDC
Updated 2022-09-22
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
›
⌄
WITH
pools_WETH AS (
SELECT
pool_name as pool_name_WETH,
pool_address as pool_address_WETH ,
token0 as token0_WETH,
token1 as token1_WETH
FROM
ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS
WHERE
pool_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')
),
pools_WBTC AS (
SELECT
pool_name as pool_name_WBTC,
pool_address as pool_address_WBTC ,
token0 as token0_WBTC,
token1 as token1_WBTC
FROM
ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS
WHERE
pool_address = LOWER('0xceff51756c56ceffca006cd410b03ffc46dd3a58')
),
-- dddd
decimals_WETH AS (
SELECT
address as address_WETH,
symbol as symbol_WETH,
decimals as decimals_WETH
FROM
ETHEREUM_CORE.DIM_CONTRACTS
WHERE
address = (
SELECT
LOWER(token1_WETH)
FROM
Run a query to Download Data