theericstonerealT tokens
    Updated 2021-04-12
    select
    date_trunc('month',block_timestamp) as month,
    count(distinct(contract_address)) as active_tokens,
    count(distinct(to_address)) as n_tokenholders
    from
    gold.ethereum_events
    where
    contract_address in ('0x2830209f6573f10c481d946ba18b446429f30360',
    '0x4475ad655d6fa73db81cc52a5cf4585faa34a1dd',
    '0x033b186321fa88603e3ecc98821fb0932b2c0760',
    '0xbecaea7aa3629d4b7ddccf3a973bef09ff34d4b6',
    '0x83c0865364fccaca2aa3459964f7a4ce3befbc75',
    '0x53993d04758ee89bbe190e15a81c411688543aba',
    '0xec2d495f20adf65cd26e9e250c8cd5d863609afd',
    '0xfc89f1b932079b462ef9c8757de5a28e387b847b',
    '0xd4203d4f0f2c3ae21ce93f04ab00517262f65aa9',
    '0x87645f94f6ea37f9f2f56d4521315e9c1ed89aa4',
    '0x67f2014293d641468161bbb0e6bd088fc0b8c381',
    '0xb0eb2ceb5583ca909faa9c76891026148c2be8a9',
    '0x273a160eb5df613c8c99869f5ae4941f65bf94cb',
    '0xbff3a3d79d0f9165cfcc1b369ee41f3c5c9ae398'
    )
    and block_timestamp > '2020-01-01'
    and block_timestamp < '2020-11-01'
    and from_address <> '0x0000000000000000000000000000000000000000'
    group by 1
    order by 1;

    Run a query to Download Data