theericstonerealT tokens
Updated 2021-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
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