jackguyBinance Stablecoin Saga 4
Updated 2023-02-15
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
›
⌄
--SELECT
-- *,
--CASE WHEN net_buy_volume > 0 THEN
-- sum(net_buy_volume) over (ORDER BY week) as cume_buy_volume
--FROM (
SELECT
-- *
-- date_trunc('week', block_timestamp) as week,
-- sum(CASE WHEN symbol_out LIKE 'BUSD' THEN amount_out END) - sum(CASE WHEN symbol_in LIKE 'BUSD' THEN amount_in END) as net_buy_volume,
-- sum(CASE WHEN symbol_out LIKE 'BUSD' THEN amount_out END) as buy_volume,
-- sum(CASE WHEN symbol_in LIKE 'BUSD' THEN amount_in END) as sell_volume
date_trunc('day', block_timestamp) as day,
avg((AMOUNT_IN_USD - AMOUNT_OUT_USD) / AMOUNT_IN_USD) * 100 as avg_slip,
median((AMOUNT_IN_USD - AMOUNT_OUT_USD) / AMOUNT_IN_USD) * 100 as median_slip
FROM ethereum.core.ez_dex_swaps
WHERE (symbol_out LIKE 'BUSD' OR symbol_in LIKE 'BUSD')
AND not AMOUNT_IN_USD is NULL
AND not AMOUNT_OUT_USD is NULL
AND AMOUNT_IN_USD > AMOUNT_OUT_USD
--LIMIT 100
GROUP BY 1
Run a query to Download Data