Delamir-6014Untitled Query
    Updated 2022-11-18
    with ethpricet as (
    select hour::date as day,
    avg (price) as ETHPrice
    from ethereum.core.fact_hourly_token_prices
    where symbol = 'WETH'
    group by 1)

    select
    count (distinct tx_hash) as TX_Count,
    count (distinct from_address) as Users_Count,
    sum (tx_fee) as Total_ETH_Fee,
    avg (tx_fee) as Average_ETH_Fee,

    sum (tx_fee*ethprice) as Total_USD_Fee,
    avg (tx_fee*ethprice) as Average_USD_Fee,

    from ethereum.core.fact_transactions t1 join ethpricet t2 on t1.block_timestamp::date = t2.day
    where status = 'SUCCESS'
    Run a query to Download Data