USER_ADDRESS | TOTAL_DEPOSIT | DEPOSIT_TX_COUNT | TOTAL_WITHDRAWAL | WITHDRAWAL_TX_COUNT | CURRENT_BALANCE | |
|---|---|---|---|---|---|---|
1 | 0x9f295b27824c09148ef9956cd76cbf08c9e46926 | 240962730346832 | 34 | 220962730346832 | 7 | 20000000000000 |
2 | 0xd0d396ab9b565282abe670be4263ad362258f9cc | 12691208353.3202 | 10 | 0 | 0 | 12691208353.3202 |
3 | 0xb003289abe0e815479705c1f6d131bd5dc67c10b | 606246279.268014 | 13 | 202082139.636257 | 2 | 404164139.631757 |
4 | 0x3ef346fd7a99773fe76a439c74adaa2616439e68 | 87773497.3739314 | 1 | 46451.1 | 48 | 87727046.2739314 |
5 | 0x25c118e4818bed82d24601e34c71d8675c5061bf | 92925397.6164066 | 5 | 46462686.4366347 | 1 | 46462711.179772 |
6 | 0x8a1c55d7b0424475f2c3086804532fcb7072be78 | 86476690.3298941 | 4 | 61769070.3298941 | 3 | 24707620 |
7 | 0xbe50563747e922f3693fbdc2cf5fd67160c553b0 | 3191729.0050928 | 3 | 0 | 0 | 3191729.0050928 |
8 | 0xfb55f5134eb5f80f8da6117514512ef186448df6 | 512761.678781239 | 1 | 0 | 0 | 512761.678781239 |
9 | 0x02368fc51d9b7a5a15b7f4477a65f0f707c049e0 | 453601.296775378 | 3 | 0 | 0 | 453601.296775378 |
10 | 0x0f4d5495512f1881c62f05d145f21ab67d42f1ac | 447553.991729716 | 1 | 0 | 0 | 447553.991729716 |
11 | 0x8c5c4294e15aa6499d0454c5274432f559964899 | 422413.810140847 | 1 | 0 | 0 | 422413.810140847 |
12 | 0x5cd70c2638f5dbc8f90cf3e85c5f57d3cbecb454 | 420621.932467914 | 2 | 0 | 0 | 420621.932467914 |
13 | 0x119bcfd59401b038245069d61d24d0096b83db42 | 310436.152738668 | 1 | 0 | 0 | 310436.152738668 |
14 | 0xd82b3f5adbb589eda48276554b61b6f05cd5a550 | 301786.138632094 | 8 | 0.007876108302 | 3 | 301786.130755985 |
15 | 0x5ec789dd3d81341397b81f9b8848436ae108e6b3 | 180087.471226169 | 1 | 0 | 0 | 180087.471226169 |
16 | 0xd8a1f9d79a6d822434e23a5f332b9322015f5903 | 178449.275338458 | 2 | 0 | 0 | 178449.275338458 |
17 | 0x9f53b1809e1bb7775074f5f539d2b513e73860c7 | 158375.004904357 | 1 | 0 | 0 | 158375.004904357 |
18 | 0x32384e77e393b02d7096360e78459fbb13ad7a93 | 63345.547071348 | 2 | 0 | 0 | 63345.547071348 |
19 | 0xd5ca60394fa87a1b268463b402579dbfa36ad279 | 54837.018840788 | 1 | 0 | 0 | 54837.018840788 |
20 | 0xf9d4c2a6c327a5f0437d0fb45c41a436f45687c6 | 45558.508999366 | 1 | 0 | 0 | 45558.508999366 |
MrftiTop users (HONEY-WBTC-LP vault) copy
Updated 2025-04-04
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
31
32
33
34
35
36
›
⌄
-- forked from Top users (HONEY-WBTC-LP vault) @ https://flipsidecrypto.xyz/studio/queries/a1067114-245b-42ab-bf8f-0392e702ec2b
WITH Deposits AS (
SELECT
'0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_address,
SUM(utils.udf_hex_to_int(DATA)/pow (10,18)) AS total_deposit,
COUNT(*) AS deposit_tx_count
FROM berachain.testnet.fact_event_logs
WHERE contract_address = lower ('0x42faa63ab12825ec2efb6ff01d7c1cf1327c3bab') -- HONEY-WBTC-LP
AND ORIGIN_FUNCTION_SIGNATURE = '0xa694fc3a' -- deposit
GROUP BY user_address
),
Withdrawals AS (
SELECT
'0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_address,
SUM(utils.udf_hex_to_int(DATA)/pow (10,18)) AS total_withdrawal,
COUNT(*) AS withdrawal_tx_count
FROM berachain.testnet.fact_event_logs
WHERE contract_address = lower ('0x42faa63ab12825ec2efb6ff01d7c1cf1327c3bab') -- HONEY-WBTC-LP
AND ORIGIN_FUNCTION_SIGNATURE = '0x2e1a7d4d' -- withdrawal
GROUP BY user_address
),
CurrentBalances AS (
SELECT
d.user_address,
COALESCE(d.total_deposit, 0) AS total_deposit,
COALESCE(d.deposit_tx_count, 0) AS deposit_tx_count,
COALESCE(w.total_withdrawal, 0) AS total_withdrawal,
COALESCE(w.withdrawal_tx_count, 0) AS withdrawal_tx_count,
COALESCE(d.total_deposit, 0) - COALESCE(w.total_withdrawal, 0) AS current_balance
FROM Deposits d
LEFT JOIN Withdrawals w ON d.user_address = w.user_address
UNION
SELECT
w.user_address,
Last run: 24 days agoAuto-refreshes every 12 hours
100
8KB
87s