freemartianUntitled Query
Updated 2021-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date,
COUNT(DISTINCT tx_from_address) AS n_active_addresses
FROM (
SELECT
block_timestamp::date AS date,
tx_from_address,
COUNT(DISTINCT tx_id) AS n_transaction
FROM ethereum.events_emitted
WHERE block_timestamp > getdate() - interval '60 days' and contract_address='0xcafe001067cdef266afb7eb5a286dcfd277f3de5'
GROUP BY 1,2
)
WHERE n_transaction <> 0
GROUP BY 1
ORDER BY 1
Run a query to Download Data