amelia-leeUntitled Query
Updated 2022-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
--'Ethereum' AS TYPE,
BLOCK_TIMESTAMP::DATE AS DATE,
T_PRICE AS TOKEN_PRICE,
COUNT (DISTINCT TX_HASH) AS TXN,
SUM (TX_FEE * T_PRICE) as USD_FEE,
AVG (TX_FEE * T_PRICE) as AVG_USD_FEE,
MEDIAN (TX_FEE * T_PRICE) as MEDIAN_USD_FEE,
AVG_USD_FEE / COUNT (DISTINCT BLOCK_NUMBER) AS FEE_PER_BLOCK,
SUM (TXN) OVER (ORDER BY DATE) AS CUM_TXN,
SUM (USD_FEE) OVER (ORDER BY DATE) AS CUM_USD_FEE
FROM ethereum.core.fact_transactions
LEFT JOIN (SELECT HOUR::DATE AS TIME, AVG (PRICE) AS T_PRICE FROM ethereum.core.fact_hourly_token_prices WHERE SYMBOL = 'WETH' AND TIME BETWEEN '2022-10-16' AND '2022-11-15' GROUP BY 1) ON BLOCK_TIMESTAMP::DATE = TIME
WHERE DATE BETWEEN '2022-10-16' AND '2022-11-15' GROUP by 1,2
Run a query to Download Data