WITH raw as (
SELECT block_timestamp, TX_RECEIVER, GAS_USED / POW(10,12) as gas
FROM near.core.fact_transactions
)
-- date_trunc('week', block_timestamp) as week,
SELECT TX_RECEIVER, SUM(gas) as total_gas
FROM raw
WHERE block_timestamp > CURRENT_DATE - 7
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10