day | daily profit (USD) | no. of active holders | average profit / loss per holder (USD) | |
|---|---|---|---|---|
1 | 2025-03-14 00:00:00.000 | 200237.136785128 | 483 | 414.569641377 |
2 | 2025-03-15 00:00:00.000 | 213154.898982894 | 856 | 249.012732457 |
3 | 2025-03-16 00:00:00.000 | 297307.546089732 | 1272 | 233.732347555 |
4 | 2025-03-17 00:00:00.000 | 245455.869125095 | 1460 | 168.120458305 |
5 | 2025-03-18 00:00:00.000 | -71876.235816011 | 1391 | -51.672347819 |
6 | 2025-03-19 00:00:00.000 | 222296.934981607 | 1773 | 125.378981941 |
7 | 2025-03-20 00:00:00.000 | 1061882.63948805 | 3962 | 268.016819659 |
8 | 2025-03-21 00:00:00.000 | 2119382.94955707 | 5513 | 384.433693009 |
9 | 2025-03-22 00:00:00.000 | 2057108.45311752 | 7902 | 260.327569364 |
10 | 2025-03-23 00:00:00.000 | 82337.336018619 | 7249 | 11.358440615 |
11 | 2025-03-24 00:00:00.000 | 75390.542135869 | 7773 | 9.699027677 |
12 | 2025-03-25 00:00:00.000 | -87885.999613677 | 7651 | -11.486864412 |
13 | 2025-03-26 00:00:00.000 | -411887.209267191 | 7237 | -56.914081701 |
14 | 2025-03-27 00:00:00.000 | 406370.741908589 | 7271 | 55.889250709 |
15 | 2025-03-28 00:00:00.000 | 1340798.49685011 | 8877 | 151.041849369 |
16 | 2025-03-29 00:00:00.000 | 4963075.0147509 | 11171 | 444.282070965 |
17 | 2025-03-30 00:00:00.000 | 1159516.80325196 | 10962 | 105.776026569 |
18 | 2025-03-31 00:00:00.000 | 3142973.96236689 | 11869 | 264.805287924 |
19 | 2025-04-01 00:00:00.000 | 6795651.51199725 | 15397 | 441.362051828 |
20 | 2025-04-02 00:00:00.000 | 10628197.9394335 | 17248 | 616.198860125 |
defi__joshDaily Profit Analysis for $TITCOIN Holders (March 14 - April 2, 2025)
Updated 6 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-06' -- first mint date
and mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump' -- $TITCOIN CA
qualify row_number() over (partition by day, owner order by block_timestamp desc) = 1
),
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-14' and '2025-04-02'
),
all_dates_owners as (
select
day,
owner
from all_dates
cross join owners
),
daily_join as (
select
day,
Last run: 6 days ago
20
1KB
31s