freemartianUntitled Query
    Updated 2021-12-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