BLOCK_TIMESTAMP | TX_HASH | USER | AMOUNT | FUNCTION | LABEL | |
|---|---|---|---|---|---|---|
1 | 2025-01-09 23:12:15.000 | 0x23ecc75647d0449037ee4de263863372c1a083a7bd31e31371bf6b7c6e8a62b5 | 0x83681c14770b44361e21faf91d8325423365ea5c | 29.136533972 | Add 🟢 | None-Whitelisted User ☹️ |
2 | 2025-01-09 05:49:53.000 | 0x55eac81f965f07dfd52c4a2ccb936efad685181187c0bb974acec25a511ddcb7 | 0x654f26dd1c9ee282c037e2ef9b902aff6684d5ae | 1500000 | Add 🟢 | Whitelisted User 🙂 |
3 | 2025-01-09 09:50:47.000 | 0x877dd3b5bb7a656627d841f9a3d2b9f536b912e50345f41f15f2fc22aa16248e | 0x8b274d81e620fd54b6a1670fab253599c803ebd8 | 200280.928714869 | Add 🟢 | None-Whitelisted User ☹️ |
4 | 2025-01-09 13:19:33.000 | 0xdfe66b3cdebf5b7286e17c7f633b4c19e12e1ddbbd88f5da0c28a90d91b8d04c | 0x1c37159f7a4adf25c4821a852a6ec67186b189ef | 2449275.36231884 | Add 🟢 | Whitelisted User 🙂 |
5 | 2025-01-10 00:12:35.000 | 0xaeb97250d4712241939e34257ce01cf810a25c3db4cb32be3faf3c9066c6c78f | 0x83681c14770b44361e21faf91d8325423365ea5c | 3.323674137 | Add 🟢 | None-Whitelisted User ☹️ |
6 | 2025-01-25 05:32:29.000 | 0x7eeab80e9deff2cfea8e6d66121b3e21cadf15fec8b5c0e9c1e99ecedb2bd6e2 | 0x9bbcdcb4bf4665ac620fde7d23ad697fa12e3cd6 | -291164.473754575 | Remove 🔴 | Whitelisted User 🙂 |
7 | 2025-01-09 11:35:21.000 | 0x61cb089c0025ba5f835bbc796fcdfdaf32b1a7d83f857d4061c825ad87571b42 | 0x475f13499de22c9adab0fc9c9d09fb2a5dadf7a9 | 11167.637173048 | Add 🟢 | None-Whitelisted User ☹️ |
8 | 2025-01-10 05:26:25.000 | 0xf0ae836143820f78d0fed6700b7cb3b1081a0776d9e44a3851e9e5235cde22af | 0x47f08ef60bf641e1c4d6e7a1ef8ea6ac80a1006b | -752306.294449151 | Remove 🔴 | Whitelisted User 🙂 |
9 | 2025-01-20 10:15:41.000 | 0xed5c1dd6d5a1dff607e5de9046ee64e6cc6894f3c0c63a8380dcb9e699edc427 | 0x781f63ec713f45d26848e80c403a1c940cd32aa9 | -20559.221790707 | Remove 🔴 | None-Whitelisted User ☹️ |
10 | 2025-01-09 20:12:43.000 | 0xf88969b379181331651b67313f35c38eab9877f91e8097ce453bb1da9bce77e9 | 0x83681c14770b44361e21faf91d8325423365ea5c | 44.930241129 | Add 🟢 | None-Whitelisted User ☹️ |
11 | 2025-01-09 20:39:31.000 | 0xd84b47ad1eec053f8cf97799795353a2ae530bb84e21977e4478f27eef126941 | 0x83681c14770b44361e21faf91d8325423365ea5c | 89.476771025 | Add 🟢 | None-Whitelisted User ☹️ |
12 | 2025-01-10 01:10:53.000 | 0xf05648188e2a2c090369273bc9cd49b80d93802bb3a63342f6b3905ce386a105 | 0x83681c14770b44361e21faf91d8325423365ea5c | 0.4129684845 | Add 🟢 | None-Whitelisted User ☹️ |
13 | 2025-01-09 10:04:19.000 | 0x5213f0530f2f28ca3ead021d2e61b9883fae2784deb55d51a8409a610b926cae | 0x8bc41b02c9f74a7e1242faca987051aa98ceb010 | 730.134677833 | Add 🟢 | None-Whitelisted User ☹️ |
14 | 2025-01-10 16:16:13.000 | 0x8434e3d4b2b3a814b9f0c811811c5e6be29d3f17fdb30213e99ebed007208dc9 | 0x09e90c5786ad5855e8918cbd35a99bf2a65f36d6 | 2822.626759618 | Add 🟢 | None-Whitelisted User ☹️ |
15 | 2025-01-09 23:24:09.000 | 0xcab36d839159a41bc593f0888209efed1ffc2d5977b49a07381f6d0b0794ba74 | 0x1d303f28299c936d88fec35f3c0c4428e8c115ed | 3720.61713609 | Add 🟢 | None-Whitelisted User ☹️ |
16 | 2025-01-11 18:35:49.000 | 0x294b939d8d441aef43ee8e3ba006943154728f87e87236561571a93073882df8 | 0x5d5800de7693dd254bafc09f9c346043dc6a1203 | -187100.509884737 | Remove 🔴 | None-Whitelisted User ☹️ |
17 | 2025-01-09 11:46:41.000 | 0xef87e04755d48deab7a85953754998f43a5f652f91b689b3de129f5561508643 | 0x605e39d307bad8c70f0124da9f604434d8067488 | 6186.891800061 | Add 🟢 | None-Whitelisted User ☹️ |
18 | 2025-01-09 23:46:07.000 | 0x03eacc770567a23f6751c57466d214f1dc54feee15b7b21ad083610ffaf48574 | 0x83681c14770b44361e21faf91d8325423365ea5c | 2.794377451 | Add 🟢 | None-Whitelisted User ☹️ |
19 | 2025-01-11 03:19:21.000 | 0xd7b50345fd22c5b3349c3c995c3aae69fea550494872caf9cf1bed4a34ea5972 | 0x83681c14770b44361e21faf91d8325423365ea5c | 57.18142247 | Add 🟢 | None-Whitelisted User ☹️ |
20 | 2025-01-09 06:19:07.000 | 0x3567f8cff51e8931d362176b03922e501c7ef042494fa2c564372e6d299a80ed | 0x83681c14770b44361e21faf91d8325423365ea5c | 87.827787902 | Add 🟢 | None-Whitelisted User ☹️ |
freemartianTotal Uniswap LP
Updated 2025-03-05
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
whitelisted AS(
select
block_timestamp,
tx_hash,
to_address AS user,
amount AS whitelist_amount,
amount_usd,
symbol,
token_price
FROM base.core.ez_token_transfers
WHERE block_timestamp::date >= '2025-01-09'
AND contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
AND to_address not in ('0xe6ec4c661f0b822ba2851b4a1de9ad64132fbfe3','0xdda04ab22bd06ef490621eace04219798dd71bfd')
AND tx_hash = '0x96f04e65252e38752d13071255b946c982ed1fd8b6569e3903cca00e290d477b'
),
uniswap_datas as (
SELECT * FROM base.core.ez_decoded_event_logs
WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
AND block_timestamp::date >= '2025-01-09'
),
uniswap_lp AS(
SELECT
block_timestamp, tx_hash,event_name,
(CASE WHEN event_name = 'DecreaseLiquidity' THEN -(decoded_log:amount0/pow(10,18)) ELSE (decoded_log:amount0/pow(10,18)) END) AS amount,
origin_from_address AS user
FROM base.core.ez_decoded_event_logs
WHERE tx_hash in (SELECT tx_hash FROM uniswap_datas)
AND event_name IN ('DecreaseLiquidity','IncreaseLiquidity','SwapAndIncreaseLiquidity')
AND block_timestamp::date >= '2025-01-09'
)
Last run: 21 days agoAuto-refreshes every 1 hour
...
2504
483KB
880s