pandaSEI: DEX Swap Explorer
Updated 2023-09-26
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
›
⌄
⌄
/*This query has been crafted based on hours of research and effort.
If you plan to use it in your own dashboard or research,
please provide proper reference. */
WITH decimals AS
(
SELECT --WETH, WBTC, DOT, SEI, ATOM, OIN, OSMO
symbol,
CASE WHEN symbol = 'WETH' then '8'
WHEN symbol = 'WBTC' then '8'
WHEN symbol = 'DOT' then '10'
WHEN symbol = 'SEI' then '6'
WHEN symbol = 'ATOM' then '6'
WHEN symbol = 'OIN' then '6'
WHEN symbol = 'OSMO' then '6' END AS decimals
FROM
osmosis.price.dim_prices
WHERE
SYMBOL IN ('WETH', 'WBTC', 'DOT', 'SEI', 'ATOM', 'OIN', 'OSMO')
GROUP BY 1,2
UNION ALL
SELECT --WETH, WBTC, DOT, SEI, ATOM, OIN, OSMO
symbol,
CASE WHEN symbol = 'USDC' then '6'
WHEN symbol = 'USDT' then '8'
WHEN symbol = 'SEA' then '6'
WHEN symbol = 'ASTRO' then '6'
WHEN symbol = 'SEILOR' then '6'
WHEN symbol = 'CRX' then '8'
ELSE decimals END AS decimals
FROM
bsc.price.ez_hourly_token_prices
WHERE
symbol IN ('USDC', 'USDT', 'CRX', 'SEA', 'ASTRO', 'SEILOR')
GROUP BY 1,2
),
Run a query to Download Data