flyingfishWBTC/WETH and USDC/WETH swap volume by day
Updated 2022-05-14
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
›
⌄
-- get details for selected pools
-- WBTC/WETH pool: 0xceff51756c56ceffca006cd410b03ffc46dd3a58
-- USDC/WETH pool: 0x397FF1542f962076d0BFE58eA045FfA2d347ACa0
WITH pools AS (
SELECT
pool_name,
pool_address,
token0,
token1
FROM ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS
WHERE pool_address = LOWER('0xceff51756c56ceffca006cd410b03ffc46dd3a58') OR pool_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')
),
-- get details for tokens in both pools
-- it should have 1 common token
tokens AS (
SELECT DISTINCT token0 FROM pools
UNION
SELECT DISTINCT token1 FROM pools
),
-- get tokens symbols and decimals
decimals AS (
SELECT
address,
symbol,
decimals
FROM ETHEREUM_CORE.DIM_CONTRACTS
WHERE
address IN (SELECT token0 from tokens)
),
-- aggregate pool and token details
pool_token_details AS (
SELECT
pool_name,
pool_address,
token0,
token1,
Run a query to Download Data