defi__joshBalance Category of Active $TITCOIN Holders in the Last 5 days
Updated 2025-04-02
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-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 '2025-03-28' and '2025-04-02' :: date -- Getting resuts for the last 5 days
),
all_dates_owners as (
select
day,
owner
from all_dates
cross join owners
),
daily_join as (
select
day,