EARLIEST_DATE | NEW_USERS | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-12-09 00:00:00.000 | 2754074 | 85 | 83 | 77 | 62 | 66 | 74 | 65 | 66 | 66 | 63 | 63 | 61 |
2 | 2024-12-16 00:00:00.000 | 257946 | 42 | 34 | 24 | 25 | 32 | 30 | 29 | 30 | 26 | 26 | 26 | |
3 | 2024-12-23 00:00:00.000 | 237047 | 40 | 27 | 26 | 31 | 28 | 26 | 38 | 28 | 25 | 27 | ||
4 | 2024-12-30 00:00:00.000 | 158105 | 27 | 22 | 27 | 23 | 22 | 25 | 22 | 23 | 23 | |||
5 | 2025-01-06 00:00:00.000 | 87814 | 40 | 36 | 26 | 37 | 35 | 35 | 23 | 21 | ||||
6 | 2025-01-13 00:00:00.000 | 94592 | 34 | 31 | 39 | 37 | 31 | 19 | 19 | |||||
7 | 2025-01-20 00:00:00.000 | 102577 | 43 | 40 | 31 | 30 | 29 | 28 | ||||||
8 | 2025-01-27 00:00:00.000 | 94213 | 53 | 43 | 33 | 19 | 18 | |||||||
9 | 2025-02-03 00:00:00.000 | 121927 | 61 | 44 | 14 | 12 | ||||||||
10 | 2025-02-10 00:00:00.000 | 191027 | 27 | 19 | 17 | |||||||||
11 | 2025-02-17 00:00:00.000 | 178871 | 31 | 29 | ||||||||||
12 | 2025-02-24 00:00:00.000 | 79535 | 45 | |||||||||||
13 | 2025-03-03 00:00:00.000 | 67823 |
0xHaM-dHeatmap || Here Wallet Time based Cohort Wide
Updated 4 days ago
999
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 Heatmap || Near Time based Cohort Wide @ https://flipsidecrypto.xyz/edit/queries/1d884fd6-cde2-4e28-b7c9-4eb04d173146
-- forked from TFM Swapper Time based Cohort Wide @ https://flipsidecrypto.xyz/edit/queries/98de3481-59c3-469a-9c05-1d99ee0a8d78
with hereW as (
select
BLOCK_TIMESTAMP,
case
when ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER) ilike 'tg'
or ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER) ilike '%.hot.tg'
or ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER) ilike '%.herewallet.near'
then 'Here Wallet' else 'Other' end as type,
TX_HASH,
ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER) as user,
TRANSACTION_FEE/1e24 as fee
from near.core.fact_transactions
where TX_SUCCEEDED=true
and BLOCK_TIMESTAMP::date>='2023-10-01'
)
,
qmain as (
SELECT DISTINCT
block_timestamp,
tx_hash,
user as FROM_ADDRESS
FROM hereW
WHERE type = 'Here Wallet'
)
, base_table as ( -- this is data prep
select
FROM_ADDRESS as address
, date_trunc('week', block_timestamp) as date
, min(date_trunc('week', block_timestamp)) over(partition by address) as earliest_date
, datediff(
'week'
, min(date_trunc('week', block_timestamp)) over(partition by address) -- earliest_date
Last run: 4 days ago
13
1KB
158s