pandaAvalanche Fee | dApps - Total Values
    Updated 2023-03-29
    WITH AVAX_Tx_Tab AS
    (
    SELECT
    a.BLOCK_TIMESTAMP,
    a.GAS_PRICE,
    a.GAS_USED,
    a.TX_FEE,
    a.FROM_ADDRESS,
    a.TX_HASH,
    b.CONTRACT_NAME,
    b.CONTRACT_ADDRESS,
    b.EVENT_NAME,
    c.PROJECT_NAME
    FROM
    avalanche.core.fact_transactions a JOIN avalanche.core.fact_event_logs b ON a.TX_HASH = b.TX_HASH
    JOIN avalanche.core.dim_labels c ON b.contract_address = c.address
    WHERE
    c.LABEL_TYPE = 'dapp'
    ),

    avax_Price AS
    (
    SELECT
    HOUR,
    PRICE
    FROM
    ethereum.core.fact_hourly_token_prices
    WHERE
    TOKEN_ADDRESS = lower('0x85f138bfEE4ef8e540890CFb48F620571d67Eda3')
    )

    SELECT
    AVG(TX_FEE) * AVG(PRICE) as avg_fee,
    AVG(GAS_USED) as avg_gas,
    AVG(GAS_PRICE) as avg_gas_gwei
    FROM
    Run a query to Download Data