freemartianWayfinder Withdraw
Updated 2025-01-10
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
›
⌄
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
)
SELECT
block_timestamp,
tx_hash,
decoded_log:user AS user,
decoded_log:totalAmount / pow(10,18) AS amount,
to_timestamp(decoded_log:updatedTimestamp) AS updatedTimestamp,
decoded_log
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
-- AND tx_hash = '0xa153cc7a83d8cf449e825323bb6e90e0a7a82745f1f126769405dd2be7afa20a'
AND event_name = 'DepositsWithdrawn'
AND block_timestamp::date >= '2024-06-01'
-- AND user = '0x0c335fdaa592aa261e4c345754fc498b28274a0d'
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived