DAY | UNIQUE_HOLDERS | |
|---|---|---|
1 | 2024-12-27 00:00:00.000 | 7 |
2 | 2024-12-28 00:00:00.000 | 9 |
3 | 2024-12-29 00:00:00.000 | 10 |
4 | 2024-12-30 00:00:00.000 | 12 |
5 | 2024-12-31 00:00:00.000 | 13 |
6 | 2025-01-01 00:00:00.000 | 17 |
7 | 2025-01-02 00:00:00.000 | 18 |
8 | 2025-01-03 00:00:00.000 | 19 |
9 | 2025-01-04 00:00:00.000 | 22 |
10 | 2025-01-05 00:00:00.000 | 23 |
11 | 2025-01-06 00:00:00.000 | 24 |
12 | 2025-01-07 00:00:00.000 | 25 |
13 | 2025-01-08 00:00:00.000 | 26 |
14 | 2025-01-09 00:00:00.000 | 26 |
15 | 2025-01-10 00:00:00.000 | 27 |
16 | 2025-01-11 00:00:00.000 | 29 |
17 | 2025-01-12 00:00:00.000 | 30 |
18 | 2025-01-13 00:00:00.000 | 31 |
19 | 2025-01-14 00:00:00.000 | 31 |
20 | 2025-01-15 00:00:00.000 | 31 |
picasoUnique Holder for veNFT
Updated 2025-04-09
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 raw AS (
SELECT
BLOCK_TIMESTAMP,
EVENT_INDEX,
TOKEN_ID,
TO_ADDRESS AS nft_to_address
FROM swell.nft.ez_nft_transfers
WHERE CONTRACT_ADDRESS = '0xc4e6a85630ca1d9b754518f653cb43c3f768215b'
),
all_token_id AS (
SELECT DISTINCT TOKEN_ID FROM raw
),
all_dates AS (
SELECT DATE_DAY AS day
FROM crosschain.core.dim_dates
WHERE DATE_DAY BETWEEN '2021-07-22' AND CURRENT_DATE()
),
full_list AS (
SELECT
day,
TOKEN_ID
FROM all_dates
CROSS JOIN all_token_id
),
daily_transfers AS ( -- end of day owners
SELECT
BLOCK_TIMESTAMP,
BLOCK_TIMESTAMP::DATE AS day,
EVENT_INDEX,
TOKEN_ID,
nft_to_address AS eod_owner
FROM raw
Last run: 3 months ago
...
104
3KB
2s