Query editor
1SELECT2 date_trunc('month', evt_block_time) AS month,3 COUNT(*) AS fee_events,4 COUNT(DISTINCT affiliatorAddress) AS unique_affiliates5FROM rango_exchange_multichain.rangodiamond_evt_feeinfo6GROUP BY 17ORDER BY 1
SELECT
date_trunc('month', evt_block_time) AS month,
COUNT(*) AS fee_events,
COUNT(DISTINCT affiliatorAddress) AS unique_affiliates
FROM rango_exchange_multichain.rangodiamond_evt_feeinfo
GROUP BY 1
ORDER BY 1