day | holder | holder's balance category | total holders for each day | |
|---|---|---|---|---|
1 | 2025-05-24 00:00:00.000 | 575 | >1K - 10K FARTCOIN | 4887 |
2 | 2025-05-24 00:00:00.000 | 272 | >10K - 100K FARTCOIN | 4887 |
3 | 2025-05-24 00:00:00.000 | 778 | 100 - 1K FARTCOIN | 4887 |
4 | 2025-05-24 00:00:00.000 | 123 | >100K FARTCOIN | 4887 |
5 | 2025-05-24 00:00:00.000 | 3139 | <100 FARTCOIN | 4887 |
6 | 2025-05-25 00:00:00.000 | 1247 | 100 - 1K FARTCOIN | 7006 |
7 | 2025-05-25 00:00:00.000 | 4236 | <100 FARTCOIN | 7006 |
8 | 2025-05-25 00:00:00.000 | 917 | >1K - 10K FARTCOIN | 7006 |
9 | 2025-05-25 00:00:00.000 | 437 | >10K - 100K FARTCOIN | 7006 |
10 | 2025-05-25 00:00:00.000 | 169 | >100K FARTCOIN | 7006 |
11 | 2025-05-26 00:00:00.000 | 546 | >10K - 100K FARTCOIN | 8943 |
12 | 2025-05-26 00:00:00.000 | 5457 | <100 FARTCOIN | 8943 |
13 | 2025-05-26 00:00:00.000 | 1596 | 100 - 1K FARTCOIN | 8943 |
14 | 2025-05-26 00:00:00.000 | 196 | >100K FARTCOIN | 8943 |
15 | 2025-05-26 00:00:00.000 | 1148 | >1K - 10K FARTCOIN | 8943 |
16 | 2025-05-27 00:00:00.000 | 653 | >10K - 100K FARTCOIN | 11000 |
17 | 2025-05-27 00:00:00.000 | 232 | >100K FARTCOIN | 11000 |
18 | 2025-05-27 00:00:00.000 | 1902 | 100 - 1K FARTCOIN | 11000 |
19 | 2025-05-27 00:00:00.000 | 1373 | >1K - 10K FARTCOIN | 11000 |
20 | 2025-05-27 00:00:00.000 | 6840 | <100 FARTCOIN | 11000 |
defi__joshBalance Category of Active $FARTCOIN Holders in the Last 14 Days
Updated 10 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
›
⌄
-- forked from $FARTCOIN launch info @ https://flipsidecrypto.xyz/studio/queries/fe4a884c-7f8a-468e-a609-f54525c454d5
with raw as (
select
block_timestamp,
block_timestamp::date as day,
owner,
balance
from solana.core.fact_token_balances
where block_timestamp::date >= '2024-10-18' -- first mint date
and mint = '9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump' -- $FARTCOIN 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 current_date - 14 and current_date :: date -- Getting resuts for the last 14 days
),
all_dates_owners as (
select
day,
owner
from all_dates
cross join owners
),
daily_join as (
Last run: 10 days ago
75
4KB
490s