LABEL | USERS | $PRIME Amount | |
|---|---|---|---|
1 | 3 Months | 1673 | 144966 |
2 | 14 Months | 18 | 667 |
3 | 8 Months | 136 | 4973 |
4 | 13 Months | 47 | 1437 |
5 | 29 Months | 3207 | 55140 |
6 | 16 Months | 6 | 272 |
7 | 28 Months | 897 | 43695 |
8 | 1 Months | 2269 | 229823.25 |
9 | 18 Months | 66 | 3614 |
10 | 25 Months | 18 | 259 |
11 | Less Than 1 Month | 229 | 13145 |
12 | 19 Months | 16 | 637 |
13 | 32 Months | 83 | 3630 |
14 | 22 Months | 3 | 128 |
15 | 5 Months | 107 | 6473 |
16 | 12 Months | 448 | 25978 |
17 | 36 Months | 278 | 18223 |
18 | 26 Months | 65 | 13748 |
19 | 33 Months | 55 | 1029 |
20 | 7 Months | 155 | 8681 |
freemartianLock Time
Updated 3 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: 3 days agoAuto-refreshes every 1 hour
37
839B
85s