amelia-leeUntitled Query
    Updated 2022-11-16
    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