Query editor
1SELECT2 block_date AS date,3 'ethereum' AS chain,4 COUNT(DISTINCT tx_from) AS active_addresses5FROM gas.fees6WHERE blockchain = 'ethereum'7 AND block_date >= DATE '2016-01-01'8GROUP BY 19ORDER BY 1
SELECT
block_date AS date,
'ethereum' AS chain,
COUNT(DISTINCT tx_from) AS active_addresses
FROM gas.fees
WHERE blockchain = 'ethereum'
AND block_date >= DATE '2016-01-01'
GROUP BY 1
ORDER BY 1