lagandispenserUntitled Query
Updated 2022-07-12
99
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
›
⌄
-- https://coincodex.com/cryptocurrencies/sector/stablecoins/
WITH
STABLECOIN_IN AS (
SELECT
-- POOL_NAME, PLATFORM ,
SYMBOL_IN ,
COUNT (DISTINCT (TX_HASH)) AS SWAP_NUM_IN ,
COUNT (DISTINCT (POOL_NAME)) AS POOL_NUM_IN ,
SUM(AMOUNT_IN_USD) AS VOLUME_IN
FROM flipside_prod_db.ethereum_core.ez_dex_swaps --ethereum.dex_swaps
WHERE PLATFORM = 'sushiswap'
AND AMOUNT_IN_USD IS NOT NULL
AND ( SYMBOL_IN LIKE '%USD%'
OR SYMBOL_IN IN ( 'DAI' , 'FRAX' , 'UST' ,'FEI' , 'VAI', 'EURS' ) )
-- (USDT, USDC, BUSD, DAI, FRAX, TUSD, USDP, UST , USDN , USDK , LUSD , FEI, HUSD, GUSD, sUSD , VAI , EURS )
GROUP BY 1 -- , 2 , 3
HAVING VOLUME_IN >= 3E6
ORDER BY VOLUME_IN DESC
LIMIT 13 )
,
STABLECOIN_OUT AS (
SELECT
SYMBOL_OUT ,
COUNT (DISTINCT (TX_HASH)) AS SWAP_NUM_OUT,
COUNT (DISTINCT (POOL_NAME)) AS POOL_NUM_OUT ,
SUM(AMOUNT_OUT_USD) AS VOLUME_OUT
FROM flipside_prod_db.ethereum_core.ez_dex_swaps
WHERE PLATFORM = 'sushiswap'
AND AMOUNT_OUT_USD IS NOT NULL
AND ( SYMBOL_OUT LIKE '%USD%'
OR SYMBOL_OUT IN ( 'DAI' ,'FRAX' , 'UST' ,'FEI' , 'VAI', 'EURS' ) )
GROUP BY 1
Run a query to Download Data