Abbas_ra21Aave Delegates Votes 3.5
    Updated 2023-03-22
    -- forked from 8b8ce009-f711-4e93-be3a-09ad98c1c23c

    -- 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',-90,current_date)
    group by
    1



    Run a query to Download Data