day | no. of active holders | |
|---|---|---|
1 | 2025-05-13 00:00:00.000 | 10120 |
2 | 2025-05-07 00:00:00.000 | 2843 |
3 | 2025-05-17 00:00:00.000 | 11191 |
4 | 2025-05-12 00:00:00.000 | 9933 |
5 | 2025-05-20 00:00:00.000 | 11466 |
6 | 2025-05-14 00:00:00.000 | 11018 |
7 | 2025-05-06 00:00:00.000 | 1430 |
8 | 2025-05-15 00:00:00.000 | 11423 |
9 | 2025-05-10 00:00:00.000 | 7677 |
10 | 2025-05-19 00:00:00.000 | 11491 |
11 | 2025-05-18 00:00:00.000 | 11418 |
12 | 2025-05-08 00:00:00.000 | 5905 |
13 | 2025-05-16 00:00:00.000 | 11566 |
14 | 2025-05-09 00:00:00.000 | 7114 |
15 | 2025-05-11 00:00:00.000 | 8603 |
defi__joshDaily Active Holders of $TITCOIN Over the Last 14 Days
Updated 8 hours 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 $TITCOIN launch info @ https://flipsidecrypto.xyz/studio/queries/14cf54cf-e523-40a5-a8ba-94976dfe5b51
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-06' -- first mint date
and mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump' -- $TITCOIN 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: about 8 hours ago
15
504B
82s