connorhUniswap Volumes
Updated 2021-07-02
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
›
⌄
WITH outflows AS (
SELECT from_address_name AS pool_address, DATE_TRUNC('day',block_timestamp) AS date, symbol, SUM(AMOUNT) AS amount, SUM(AMOUNT_USD) AS amount_usd
FROM gold.ethereum_events
WHERE from_address = '0xbb2b8038a1640196fbe3e38816f3e67cba72d940'
AND block_timestamp >= CURRENT_DATE - INTERVAL '1 week'
AND symbol IN ('WETH','WBTC')
AND to_address <> '0x0000000000000000000000000000000000000000'
GROUP BY 1,2,3
), inflows AS (
SELECT to_address_name AS pool_address, DATE_TRUNC('day',block_timestamp) AS date, symbol, SUM(AMOUNT) AS amount, SUM(AMOUNT_USD) AS amount_usd
FROM gold.ethereum_events
WHERE to_address = '0xbb2b8038a1640196fbe3e38816f3e67cba72d940'
AND block_timestamp >= CURRENT_DATE - INTERVAL '1 week'
AND symbol IN ('WETH','WBTC')
AND from_address <> '0x0000000000000000000000000000000000000000'
GROUP BY 1,2,3
)
SELECT inflows.pool_address,
inflows.date,
SUM(CASE WHEN inflows.symbol = 'WETH' THEN inflows.amount + outflows.amount ELSE NULL END) AS weth_vol24hr,
SUM(CASE WHEN inflows.symbol = 'WBTC' THEN inflows.amount + outflows.amount ELSE NULL END) AS wbtc_vol24hr,
SUM(inflows.amount_usd + outflows.amount_usd) AS usd_vol24hr
FROM inflows FULL OUTER JOIN outflows
ON inflows.symbol = outflows.symbol AND inflows.date = outflows.date
GROUP BY 1,2
ORDER BY 1,2 DESC
Run a query to Download Data