LABEL | USERS | $PRIME Amount | |
|---|---|---|---|
1 | 3 Months | 3013 | 167947 |
2 | 22 Months | 5 | 132 |
3 | 25 Months | 86 | 6565 |
4 | 16 Months | 13 | 365 |
5 | 18 Months | 77 | 3939 |
6 | 19 Months | 22 | 670 |
7 | 13 Months | 77 | 1698 |
8 | Less Than 1 Month | 580 | 14477 |
9 | 8 Months | 229 | 5782 |
10 | 14 Months | 25 | 683 |
11 | 12 Months | 3642 | 33374 |
12 | 32 Months | 83 | 3630 |
13 | 5 Months | 170 | 9296 |
14 | 11 Months | 98 | 5241 |
15 | 4 Months | 416 | 12985 |
16 | 24 Months | 722 | 18613 |
17 | 10 Months | 70 | 4418 |
18 | 17 Months | 21 | 1347 |
19 | 33 Months | 55 | 1029 |
20 | 27 Months | 5361 | 57164 |
freemartianLock Time
Updated 1 hour 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: about 1 hour agoAuto-refreshes every 1 hour
37
850B
399s