day | holder | holder's balance category | total holders for each day | |
|---|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | 319 | <100K $Schedule1 | 639 |
2 | 2025-03-28 00:00:00.000 | 199 | 100K - 1M $Schedule1 | 639 |
3 | 2025-03-28 00:00:00.000 | 100 | >1M - 10M $Schedule1 | 639 |
4 | 2025-03-28 00:00:00.000 | 19 | >10M - 100M $Schedule1 | 639 |
5 | 2025-03-28 00:00:00.000 | 2 | >100M $Schedule1 | 639 |
6 | 2025-03-29 00:00:00.000 | 73 | >1M - 10M $Schedule1 | 528 |
7 | 2025-03-29 00:00:00.000 | 23 | >10M - 100M $Schedule1 | 528 |
8 | 2025-03-29 00:00:00.000 | 2 | >100M $Schedule1 | 528 |
9 | 2025-03-29 00:00:00.000 | 278 | <100K $Schedule1 | 528 |
10 | 2025-03-29 00:00:00.000 | 152 | 100K - 1M $Schedule1 | 528 |
11 | 2025-03-30 00:00:00.000 | 25 | >10M - 100M $Schedule1 | 557 |
12 | 2025-03-30 00:00:00.000 | 2 | >100M $Schedule1 | 557 |
13 | 2025-03-30 00:00:00.000 | 269 | <100K $Schedule1 | 557 |
14 | 2025-03-30 00:00:00.000 | 95 | >1M - 10M $Schedule1 | 557 |
15 | 2025-03-30 00:00:00.000 | 166 | 100K - 1M $Schedule1 | 557 |
16 | 2025-03-31 00:00:00.000 | 2 | >100M $Schedule1 | 787 |
17 | 2025-03-31 00:00:00.000 | 370 | <100K $Schedule1 | 787 |
18 | 2025-03-31 00:00:00.000 | 269 | 100K - 1M $Schedule1 | 787 |
19 | 2025-03-31 00:00:00.000 | 28 | >10M - 100M $Schedule1 | 787 |
20 | 2025-03-31 00:00:00.000 | 118 | >1M - 10M $Schedule1 | 787 |
defi__joshBalance Category of Active $Schedule1 Holders in the last few Days since launch
Updated 8 days ago
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,
block_timestamp::date as day,
owner,
balance
from solana.core.fact_token_balances
where block_timestamp::date >= '2025-03-28' -- first mint date
and mint = '8Td15GjwPNtADXrZC3GQqUvarHR9hyNKeVihLi3Spump' -- $Schedule1 CA
qualify row_number() over (partition by day, owner order by block_timestamp desc) = 1 -- Ensuring Only Latest Balance Per Owner Per Day
),
owners as (
select
distinct owner as owner
from raw
),
all_dates as (
select
date_day as day
from crosschain.core.dim_dates
where date_day::date between '2025-03-28' and current_date() :: date -- Getting resuts for the last few days and today
),
all_dates_owners as (
select
day,
owner
from all_dates
cross join owners
),
daily_join as (
select
day,
Last run: 8 days ago
20
1KB
5s