LABEL | USERS | $PRIME Amount | |
|---|---|---|---|
1 | 25 Months | 58 | 5596 |
2 | 16 Months | 13 | 365 |
3 | 19 Months | 22 | 670 |
4 | 18 Months | 77 | 3939 |
5 | 13 Months | 77 | 1698 |
6 | 14 Months | 25 | 683 |
7 | 8 Months | 228 | 5760 |
8 | 12 Months | 3639 | 33340 |
9 | 32 Months | 83 | 3630 |
10 | 5 Months | 169 | 9266 |
11 | 3 Months | 2996 | 166389 |
12 | 22 Months | 5 | 132 |
13 | Less Than 1 Month | 580 | 14477 |
14 | 27 Months | 5361 | 57164 |
15 | 31 Months | 75 | 9481 |
16 | 35 Months | 48 | 2651 |
17 | 26 Months | 5730 | 52798 |
18 | 2 Months | 671 | 39438 |
19 | 36 Months | 278 | 18223 |
20 | 34 Months | 27 | 308 |
freemartianLock Time
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
›
⌄
with
prices AS(
SELECT
hour,
price,
symbol,
ROW_NUMBER() OVER (ORDER BY hour DESC) AS row_num
FROM base.price.ez_prices_hourly
WHERE symbol ilike 'PRIME'
AND hour::date = current_date
qualify row_num = 1
),
base_deposit_temp AS (
SELECT
block_timestamp,
tx_hash,
origin_from_address as user,
regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS temp_data,
ethereum.public.udf_hex_to_int(temp_data[0] :: STRING) AS depositIndex,
ethereum.public.udf_hex_to_int(temp_data[1] :: STRING)/pow(10,18) AS amount,
to_timestamp(ethereum.public.udf_hex_to_int(temp_data[3] :: STRING)) AS createdTimestamp,
to_timestamp(ethereum.public.udf_hex_to_int(temp_data[2] :: STRING)) AS endTimestamp,
DATEDIFF(DAY, createdTimestamp, endTimestamp) AS difference_in_days,
from base.core.fact_event_logs
-- where tx_hash in ('0xf7977ba798badd22d56d0f5576124e5f4f911bb66168ea8f0b8f3770850d7b3d')
WHERE origin_function_signature = '0xf104489f'
AND block_timestamp::date >= '2024-06-01'
AND origin_to_address = '0xfa980ced6895ac314e7de34ef1bfae90a5add21b'
AND contract_address IN ('0x75a44a70ccb0e886e25084be14bd45af57915451','0xfa980ced6895ac314e7de34ef1bfae90a5add21b')
AND ARRAY_SIZE(temp_data) = 4
),
base_deposits AS(
SELECT
Last run: 4 days agoAuto-refreshes every 1 hour
37
850B
330s