JimMyersTechKava - Daily Benchmark Metrics
    Updated 2020-11-12
    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
    Run a query to Download Data