Abbas_ra21Aave Delegates Votes 3
    Updated 2023-03-22
    -- forked from 0cb1ae19-ae95-40df-9f8c-c1dd8d3f7ca3

    with
    tb AS (
    select
    TX_HASH
    from
    ethereum.aave.ez_votes
    )
    select
    GAS_PRICE AS "Gas Price (Gwei)",
    sum(TX_FEE) AS "Generated Fee (ETH)",
    sum(GAS_USED/1e9) AS "Used GAS"
    from
    ethereum.core.fact_transactions
    where
    TX_HASH in (
    Select
    TX_HASH
    from
    tb
    ) and BLOCK_TIMESTAMP >= Dateadd('Day',-180,current_date)
    group by
    1


    Run a query to Download Data