DigitalDanOwnership Distribution copy
Updated 2023-04-25
999
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
›
⌄
-- forked from Ownership Distribution @ https://flipsidecrypto.xyz/edit/queries/ca5a59a6-f008-4e33-94a9-3a3f61762f5d
WITH date_range AS (
SELECT
DATEADD('day', -1 * days, CURRENT_DATE()) AS balance_date
FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY seq4()) - 1 AS days
FROM
TABLE(GENERATOR(ROWCOUNT => 30))
)
),
daily_total_balance AS (
SELECT
date_range.balance_date,
SUM(CURRENT_BAL) AS total_balance
FROM
date_range
CROSS JOIN ethereum.core.ez_current_balances
WHERE
CONTRACT_ADDRESS = lower('0x9f8F72aA9304c8B593d555F12eF6589cC3A579A2')
AND DATE(LAST_ACTIVITY_BLOCK_TIMESTAMP) <= date_range.balance_date
GROUP BY
date_range.balance_date
),
wallet_activity AS (
SELECT
USER_ADDRESS,
MAX(DATE(LAST_ACTIVITY_BLOCK_TIMESTAMP)) AS last_activity_date
FROM
ethereum.core.ez_current_balances
WHERE
CONTRACT_ADDRESS = lower('0x9f8F72aA9304c8B593d555F12eF6589cC3A579A2')
GROUP BY
Run a query to Download Data