dr1888Daily and total gas used in the last 180 days
    Updated 2023-03-17
    -- forked from 6b67032a-8094-4523-b190-2a32e7e34a47

    select
    BLOCK_TIMESTAMP::Date as BTD,
    sum(GAS_USED) as SGU,
    sum(SGU) over (order by BTD)
    from ethereum.core.fact_transactions where
    TO_ADDRESS=lower('0xec568fffba86c094cf06b22134b23074dfe2252c')
    and BTD >= CURRENT_DATE-180
    group by BTD
    order by BTD DESC