SELECT date_trunc('hour', block_timestamp) as date,
COUNT (DISTINCT from_address) as active_address
FROM avalanche.core.fact_transactions
WHERE block_timestamp::date = CURRENT_DATE-1
AND status = 'SUCCESS'
GROUP by date
ORDER BY active_address DESC
limit 10