DATE | HOLDERS | |
|---|---|---|
1 | 2025-01-13 00:00:00.000 | 313 |
2 | 2025-01-12 00:00:00.000 | 313 |
3 | 2025-01-11 00:00:00.000 | 313 |
4 | 2025-01-10 00:00:00.000 | 313 |
5 | 2025-01-09 00:00:00.000 | 313 |
6 | 2025-01-08 00:00:00.000 | 312 |
7 | 2025-01-07 00:00:00.000 | 311 |
8 | 2025-01-06 00:00:00.000 | 311 |
9 | 2025-01-05 00:00:00.000 | 311 |
10 | 2025-01-04 00:00:00.000 | 311 |
11 | 2025-01-03 00:00:00.000 | 310 |
12 | 2025-01-02 00:00:00.000 | 310 |
13 | 2025-01-01 00:00:00.000 | 309 |
14 | 2024-12-31 00:00:00.000 | 309 |
15 | 2024-12-30 00:00:00.000 | 309 |
16 | 2024-12-29 00:00:00.000 | 309 |
17 | 2024-12-28 00:00:00.000 | 309 |
18 | 2024-12-27 00:00:00.000 | 309 |
19 | 2024-12-26 00:00:00.000 | 309 |
20 | 2024-12-25 00:00:00.000 | 309 |
Sandeshg3 nft holders
Updated 2025-01-13
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
›
⌄
-- CTE to generate a list of distinct dates from transaction data starting from March 26, 2023
WITH dates AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date
FROM ethereum.core.fact_transactions
WHERE date >= '2023-03-26 00:00:00.000'
AND date <= CURRENT_DATE -- Include up to the current date
GROUP BY 1
),
-- CTE to identify NFT buy and sell transactions
buy_sell_table AS (
(
-- Extract "buy" transactions where NFTs are sent to an address
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
nft_to_address AS address,
1 AS amount -- Represent each incoming NFT as +1
FROM ethereum.nft.ez_nft_transfers
WHERE block_number >= '19524812' -- From a specific block onwards
AND nft_address = LOWER('0xDE76aD8998310dd4C6cA9fdb03a5F20bbf01Ce96') -- Target NFT contract address
)
UNION ALL
(
-- Extract "sell" transactions where NFTs are sent from an address
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
nft_from_address AS address,
-1 AS amount -- Represent each outgoing NFT as -1
FROM ethereum.nft.ez_nft_transfers
WHERE block_number >= '19524812' -- From a specific block onwards
AND nft_address = LOWER('0xDE76aD8998310dd4C6cA9fdb03a5F20bbf01Ce96') -- Target NFT contract address
)
),
Last run: 3 months ago
92
3KB
3s