KuramaStargate - STG Holders over time
Updated 2023-01-10
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
›
⌄
-- from dune adaptation
SELECT date, sum(users) OVER (
ORDER BY date ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) AS total_users
FROM
(SELECT date, count(USER) AS users
FROM
(SELECT min(date) AS date,
account AS USER
FROM
(SELECT date_trunc('day', min(t.block_timestamp)) AS date,
t.from_address AS account
FROM ethereum.core.fact_token_transfers t
WHERE t.contract_address = lower('0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6')
GROUP BY 2
UNION SELECT date_trunc('day', min(t.block_timestamp)) AS date,
t.to_address AS account
FROM ethereum.core.fact_token_transfers t
WHERE t.contract_address = lower('0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6')
GROUP BY 2) AS a
GROUP BY 2) AS b
GROUP BY 1
ORDER BY 1) AS c
Run a query to Download Data