KaskoazulTCR Addresses
Updated 2022-03-02
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
29
30
31
32
33
34
35
36
›
⌄
WITH TCR_address AS (
SELECT
distinct user_address as TCRholders,
balance_date,
balance
FROM ethereum.erc20_balances
WHERE contract_address = '0x9c4a4204b79dd291d6b6571c5be8bbcd0622f050' --TCR DAO Token
and balance > 0
and balance_date >= '2021-09-08'
),
Tokemak_users AS (
SELECT
block_timestamp::date as fecha,
tx_id,
tx_from_address,
tx_to_address
FROM ethereum.events_emitted
WHERE contract_address = '0x15a629f0665a3eb97d7ae9a7ce7abf73aeb79415' --Tokemak tTracer Token Reactor
and tx_from_address in (select TCRholders from TCR_address)
and fecha >= '2021-09-08'
)
SELECT
balance_date as fecha,
count(TCRholders) as Number_of_users,
'TCR Holders' as Label
FROM TCR_address
GROUP BY 1,3
UNION SELECT
fecha,
count(tx_id) as Number_of_users,
'TOKEMAK TCR users' as Label
FROM Tokemak_users
GROUP BY 1,3
Run a query to Download Data