-- 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