SELECT date_trunc('day', block_timestamp) as timestamp,
sum(event_amount) as volume,
count(distinct tx_id) as tx_count,
count(distinct event_from) as address_count
FROM gold.kava_events
WHERE
block_timestamp >= getdate() - interval '90 days'
AND event_currency = 'KAVA'
GROUP BY 1
ORDER BY 1 DESC