LABEL | USERS | $PRIME Amount | |
|---|---|---|---|
1 | 30 Months | 1130 | 712327 |
2 | 7 Months | 510 | 2379211 |
3 | 23 Months | 227 | 86416 |
4 | 13 Months | 90 | 76519 |
5 | 27 Months | 3511 | 1248332 |
6 | 35 Months | 248 | 720401 |
7 | 31 Months | 164 | 2243597 |
8 | 3 Months | 2568 | 8078434 |
9 | 22 Months | 9 | 4763 |
10 | 9 Months | 284 | 1909197 |
11 | 19 Months | 27 | 5236 |
12 | 18 Months | 222 | 981587 |
13 | 24 Months | 783 | 703862 |
14 | 4 Months | 640 | 3384237 |
15 | 10 Months | 158 | 770117 |
16 | 17 Months | 51 | 35695 |
17 | 33 Months | 137 | 120770 |
18 | Less Than 1 Month | 243 | 470847 |
19 | 6 Months | 2148 | 6164742 |
20 | 1 Months | 2565 | 6597171 |
freemartianWayfinder Deposit & Increase Time
Updated 1 hour 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 prices AS(
SELECT
hour::date AS price_day,
AVG(price) AS price
FROM ethereum.price.ez_prices_hourly
WHERE token_address = '0xb23d80f5fefcddaa212212f028021b41ded428cf'
AND hour::date >= '2024-06-01'
GROUP BY 1
),
deposits AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:user AS user,
decoded_log:amount / pow(10,18) AS amount,
to_timestamp(decoded_log:createdTimestamp) AS createdTimestamp,
to_timestamp(decoded_log:endTimestamp) AS endTimestamp,
DATEDIFF(DAY, createdTimestamp, endTimestamp) AS difference_in_days,
decoded_log:depositIndex AS depositIndex,
decoded_log
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
AND event_name = 'DepositCreated'
AND block_timestamp::date >= '2024-06-01'
),
addtime AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:user AS user,
-- decoded_log:amount / pow(10,18) AS amount,
to_timestamp(decoded_log:createdTimestamp) AS createdTimestamp,
to_timestamp(decoded_log:endTimestamp) AS newTimestamp,
Last run: about 1 hour agoAuto-refreshes every 1 hour
37
919B
355s