BLOCK_NUMBER | BLOCK_TIMESTAMP | TX_HASH | EVENT_INDEX | ADDRESS | DAILY_DELTA | BALANCE | NEXT_DATE | LAG_BAL | CATEGORY | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 24 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 1 | 20971415 | 0 | The originals (hold 1 NFT) |
2 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 24 | 0x0000000000000000000000000000000000000000 | -1 | -1 | 20971415 | 0 | The originals (hold 1 NFT) |
3 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 25 | 0x0000000000000000000000000000000000000000 | -1 | -2 | 20971415 | -1 | The originals (hold 1 NFT) |
4 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 25 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 2 | 20971415 | 1 | The originals (hold 1 NFT) |
5 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 26 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 3 | 20971415 | 2 | The originals (hold 1 NFT) |
6 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 26 | 0x0000000000000000000000000000000000000000 | -1 | -3 | 20971415 | -2 | The originals (hold 1 NFT) |
7 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 27 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 4 | 20971415 | 3 | The originals (hold 1 NFT) |
8 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 27 | 0x0000000000000000000000000000000000000000 | -1 | -4 | 20971415 | -3 | The originals (hold 1 NFT) |
9 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 28 | 0x0000000000000000000000000000000000000000 | -1 | -5 | 20971415 | -4 | The originals (hold 1 NFT) |
10 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 28 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 5 | 20971415 | 4 | The originals (hold 1 NFT) |
11 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 29 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 6 | 20971415 | 5 | Collector (holds 2-5 NFT) |
12 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 29 | 0x0000000000000000000000000000000000000000 | -1 | -6 | 20971415 | -5 | The originals (hold 1 NFT) |
13 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 30 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 7 | 20971415 | 6 | Collector (holds 2-5 NFT) |
14 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 30 | 0x0000000000000000000000000000000000000000 | -1 | -7 | 20971415 | -6 | The originals (hold 1 NFT) |
15 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 31 | 0x0000000000000000000000000000000000000000 | -1 | -8 | 20971415 | -7 | The originals (hold 1 NFT) |
16 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 31 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 8 | 20971415 | 7 | Collector (holds 2-5 NFT) |
17 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 32 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 9 | 20971415 | 8 | Collector (holds 2-5 NFT) |
18 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 32 | 0x0000000000000000000000000000000000000000 | -1 | -9 | 20971415 | -8 | The originals (hold 1 NFT) |
19 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 33 | 0xd5d696842c4279d0e72c5fab791861c6c4cf6555 | 1 | 10 | 20971415 | 9 | Collector (holds 2-5 NFT) |
20 | 20971414 | 2024-10-15 13:58:47.000 | 0x83f40b9ab384b61eda43cb9dc7292fbbc64da175ead9efe9f4e4111bdecc601a | 33 | 0x0000000000000000000000000000000000000000 | -1 | -10 | 20971415 | -9 | The originals (hold 1 NFT) |
Sandeshholders
Updated 2025-03-24
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
›
⌄
-- forked from holders over time @ https://flipsidecrypto.xyz/studio/queries/45b1202f-0737-4ba8-8c73-0bdb306154f0
-- 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 >= '2024-10-01 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
block_number,
BLOCK_TIMESTAMP ,
tx_hash,
event_index,
nft_to_address AS address,
1 AS amount -- Represent each incoming NFT as +1
FROM ethereum.nft.ez_nft_transfers
WHERE block_timestamp>= '2024-10-01 00:00:00.000'
AND nft_address = LOWER('0x3A1561Ef33515BBA77A4df88D80aFA9D363900E1') -- Target NFT contract address
)
UNION ALL
(
-- Extract "sell" transactions where NFTs are sent from an address
SELECT
block_number,
BLOCK_TIMESTAMP ,
tx_hash,
event_index,
Last run: 13 days ago
...
8169
2MB
3s