dr1888Gas used in the last 90 days
    Updated 2023-03-18
    select
    BLOCK_TIMESTAMP::Date as BTD,
    sum(GAS_USED) as GU,
    sum(GU) over (order by BTD)
    from ethereum.core.fact_transactions
    WHERE
    to_address=lower('0xec568fffba86c094cf06b22134b23074dfe2252c')
    AND
    BTD>= CURRENT_DATE-90
    group by 1
    order by 1 DESC

    Run a query to Download Data