date_trunc('day', BLOCK_TIMESTAMP_HOUR) as date,

sum(TRANSACTION_COUNT) as tx_count,

sum(UNIQUE_SIGNERS_COUNT) as unique_user_count,

sum(TOTAL_FEES_USD) as total_fees

FROM solana.stats.ez_core_metrics_hourly

WHERE BLOCK_TIMESTAMP_HOUR::date >= current_date - interval '90 day'

group by 1

ORDER by 1