DATE | Unique New Users | Unique Reactions | Unique Reactors | Unique Casts | Unique Casters | |
|---|---|---|---|---|---|---|
1 | 2076-05-11 00:00:00.000 | 1 | 0 | 0 | 0 | 0 |
2 | 2076-05-04 00:00:00.000 | 1 | 0 | 0 | 6 | 1 |
3 | 2025-06-01 00:00:00.000 | 2360 | 378414 | 23312 | 284541 | 27316 |
4 | 2025-05-31 00:00:00.000 | 4100 | 504575 | 31095 | 348862 | 34209 |
5 | 2025-05-30 00:00:00.000 | 6808 | 596828 | 37032 | 290895 | 39435 |
6 | 2025-05-29 00:00:00.000 | 10880 | 737916 | 47501 | 430203 | 55810 |
7 | 2025-05-28 00:00:00.000 | 10555 | 683422 | 39032 | 333709 | 40828 |
8 | 2025-05-27 00:00:00.000 | 10845 | 682214 | 38692 | 326610 | 41944 |
9 | 2025-05-26 00:00:00.000 | 4489 | 583526 | 31138 | 329070 | 36598 |
10 | 2025-05-25 00:00:00.000 | 4071 | 546863 | 30433 | 340793 | 34450 |
11 | 2025-05-24 00:00:00.000 | 5579 | 554425 | 31054 | 286211 | 35854 |
12 | 2025-05-23 00:00:00.000 | 2948 | 653544 | 35213 | 319050 | 38957 |
13 | 2025-05-22 00:00:00.000 | 4516 | 681911 | 36317 | 317881 | 41410 |
14 | 2025-05-21 00:00:00.000 | 5023 | 612335 | 31054 | 289192 | 41155 |
15 | 2025-05-20 00:00:00.000 | 6452 | 551071 | 28631 | 263795 | 39810 |
16 | 2025-05-19 00:00:00.000 | 5842 | 519190 | 28946 | 243721 | 37534 |
17 | 2025-05-18 00:00:00.000 | 6187 | 435642 | 29003 | 216183 | 38263 |
18 | 2025-05-17 00:00:00.000 | 6131 | 427512 | 27942 | 175536 | 36104 |
19 | 2025-05-16 00:00:00.000 | 7455 | 457048 | 33060 | 189859 | 37807 |
20 | 2025-05-15 00:00:00.000 | 3170 | 434306 | 32588 | 189884 | 38160 |
shadabFarcaster_data
Updated 2025-06-01
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 new_users AS (
SELECT
date_trunc('day', TIMESTAMP) as Date,
COUNT(DISTINCT ID) AS "Unique New Users"
FROM
external.farcaster.fact_user_data
GROUP BY
1
),
reactions AS (
SELECT
date_trunc('day', TIMESTAMP) as Date,
COUNT(DISTINCT ID) AS "Unique Reactions",
COUNT(DISTINCT FID) AS "Unique Reactors"
FROM
external.farcaster.fact_reactions
GROUP BY
1
),
casts AS (
SELECT
date_trunc('day', TIMESTAMP) as Date,
COUNT(DISTINCT ID) AS "Unique Casts",
COUNT(DISTINCT FID) AS "Unique Casters"
FROM
external.farcaster.fact_casts
GROUP BY
1
)
SELECT
COALESCE(new_users.Date, reactions.Date, casts.Date) AS Date,
COALESCE(new_users."Unique New Users", 0) AS "Unique New Users",
COALESCE(reactions."Unique Reactions", 0) AS "Unique Reactions",
COALESCE(reactions."Unique Reactors", 0) AS "Unique Reactors",
COALESCE(casts."Unique Casts", 0) AS "Unique Casts",
COALESCE(casts."Unique Casters", 0) AS "Unique Casters"
Last run: 13 days ago
...
812
45KB
329s