BLOCK_TIMESTAMP | TX_HASH | AMOUNT | USER | CREATEDTIMESTAMP | ENDTIMESTAMP | DIFFERENCE_IN_DAYS | DEPOSITINDEX | EVENT_NAME | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2024-10-02 13:58:45.000 | 0xf7977ba798badd22d56d0f5576124e5f4f911bb66168ea8f0b8f3770850d7b3d | 49 | 0x39fe1beef05ded01d35c2b97e3fb6939d4f0aee3 | 2024-10-02 13:58:45.000 | 2024-12-31 13:58:45.000 | 90 | 0 | Deposit |
2 | 2024-12-03 08:25:19.000 | 0xb6cd16dfc228f044cd9e79553e6ad90b56f79a037b6149d619fde79749661c5c | 2 | 0x39fe1beef05ded01d35c2b97e3fb6939d4f0aee3 | 2024-12-03 08:25:19.000 | 2027-06-19 16:00:00.000 | 928 | 1 | Deposit |
3 | 2024-12-28 11:56:09.000 | 0x389a5c41925da42951d902338d4a110bec3ddf7aed58ba5792326a284ed5a7a1 | 0x39fe1beef05ded01d35c2b97e3fb6939d4f0aee3 | 2024-10-02 13:58:45.000 | 2025-03-31 13:58:45.000 | 180 | 0 | Extend | |
4 | 2025-03-31 20:11:55.000 | 0xd0d2af23f0d0b0f1756e0e4438e91453e0be2eae9832b7d2a08094d9360c071b | 49 | 0x39fe1beef05ded01d35c2b97e3fb6939d4f0aee3 | 2025-03-31 20:11:55.000 | 2025-03-31 20:11:55.000 | 0 | [0] | Withdraw |
5 | 2025-04-04 14:09:07.000 | 0xbd38c2a3a40b9a1488247d16249a4695772c2414016965234b4575f351c19e8d | 12 | 0x39fe1beef05ded01d35c2b97e3fb6939d4f0aee3 | 2025-04-04 14:09:07.000 | 2027-06-19 16:00:00.000 | 806 | 2 | Deposit |
freemartianUser Activity on Base
Updated 25 minutes 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::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
),
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 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
and origin_from_address = LOWER('{{wallet_address}}')
),
base_deposits AS(
SELECT
block_timestamp,
tx_hash,
amount,
user,
Last run: 25 minutes agoAuto-refreshes every 1 hour
5
1KB
704s