Query editor
1SELECT2 block_date AS date,3 'solana' AS chain,4 COUNT(DISTINCT signer) AS active_addresses5FROM gas_solana.fees6WHERE block_date >= DATE '2021-01-01'7 AND LOWER(tx_type) != 'vote'8GROUP BY 19ORDER BY 1
SELECT
block_date AS date,
'solana' AS chain,
COUNT(DISTINCT signer) AS active_addresses
FROM gas_solana.fees
WHERE block_date >= DATE '2021-01-01'
AND LOWER(tx_type) != 'vote'
GROUP BY 1
ORDER BY 1