EVENT_DATE | TOTAL_INVITATIONS | INVITED_10_FRIENDS | INVITED_5_FRIENDS | UNIQUE_SENDERS | |
---|---|---|---|---|---|
1 | 2025-01-19 00:00:00.000 | 2 | 1 | 1 | 1 |
2 | 2025-01-20 00:00:00.000 | 2 | 1 | 1 | 1 |
3 | 2025-01-21 00:00:00.000 | 4 | 1 | 1 | 1 |
4 | 2025-01-22 00:00:00.000 | 143 | 25 | 100 | 101 |
5 | 2025-01-23 00:00:00.000 | 247 | 28 | 168 | 177 |
6 | 2025-01-24 00:00:00.000 | 659 | 32 | 627 | 637 |
7 | 2025-01-25 00:00:00.000 | 700 | 25 | 628 | 633 |
8 | 2025-01-26 00:00:00.000 | 3206 | 78 | 2829 | 2841 |
9 | 2025-01-27 00:00:00.000 | 5287 | 152 | 4796 | 4812 |
10 | 2025-01-28 00:00:00.000 | 6071 | 158 | 5913 | 5930 |
11 | 2025-01-29 00:00:00.000 | 3470 | 116 | 3354 | 3398 |
12 | 2025-01-30 00:00:00.000 | 4765 | 106 | 4659 | 4683 |
13 | 2025-01-31 00:00:00.000 | 5919 | 161 | 5758 | 5777 |
14 | 2025-02-01 00:00:00.000 | 10184 | 188 | 9996 | 10029 |
15 | 2025-02-02 00:00:00.000 | 4942 | 134 | 4808 | 4859 |
16 | 2025-02-03 00:00:00.000 | 8135 | 141 | 7992 | 8017 |
17 | 2025-02-04 00:00:00.000 | 10591 | 204 | 10387 | 10449 |
18 | 2025-02-05 00:00:00.000 | 91 | 91 | 0 | 91 |
19 | 2025-02-06 00:00:00.000 | 117 | 117 | 0 | 117 |
20 | 2025-02-07 00:00:00.000 | 59 | 59 | 0 | 59 |
datavortexDaily invitations
Updated 2025-02-27
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
›
⌄
WITH event_data AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS event_date,
origin_from_address,
tx_hash,
CASE
WHEN contract_address = '0xd37f28c6c51420054b1fb1362288d07ba40440e8' THEN 'invited 10 friends'
WHEN contract_address = '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2' THEN 'invited 5 friends'
END AS invitation_status
FROM kaia.core.fact_event_logs
WHERE
contract_address IN ('0xd37f28c6c51420054b1fb1362288d07ba40440e8', '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2')
AND tx_succeeded = TRUE
)
SELECT
event_date,
COUNT(DISTINCT tx_hash) AS total_invitations,
COUNT(DISTINCT CASE WHEN invitation_status = 'invited 10 friends' THEN origin_from_address END) AS invited_10_friends,
COUNT(DISTINCT CASE WHEN invitation_status = 'invited 5 friends' THEN origin_from_address END) AS invited_5_friends,
COUNT(DISTINCT origin_from_address) AS unique_senders
FROM event_data
GROUP BY event_date
ORDER BY event_date;
Last run: 2 months ago
40
2KB
1s