USER | TOTAL_CLAIM_AMOUNT | DEPOSIT_PRIME_AMOUNTS | WITHDRAW_PRIME_AMOUNTS | PRIME_NET_AMOUNT | |
|---|---|---|---|---|---|
1 | 0xfe2dfea76b6e6abcbc44f80fd82d5335f515ab99 | 4555698.09058724 | 600000 | 0 | 600000 |
2 | 0xbddb6861b4efc68653bbc4faa4d5df6e411f82ee | 2414542.41527319 | 747847 | 0 | 747847 |
3 | 0x08997eda8ccf295aca5db81071478f735e52e3e3 | 2381749.14600873 | 500000 | 0 | 500000 |
4 | 0x50664ede715e131f584d3e7eaabd7818bb20a068 | 1770063.66974115 | 187356 | 0 | 187356 |
5 | 0xe864ece0dafd82d84150d97e48e3de68f9edb148 | 1635602.77236546 | 784291 | 116253 | 668038 |
6 | 0xfdc5e65eab4ec043cc71fd10fecc3a098b1ea01d | 1352045.60327222 | 439400 | 0 | 439400 |
7 | 0x931e74b6f4e12cfd3fd9b804e5a0bd7b4c3f9633 | 1150914.35212847 | 28935 | 14468 | 14467 |
8 | 0xe0e6a57fcef14eac98ff2518d2e104339ec7578f | 1107544.31409052 | 313909 | 0 | 313909 |
9 | 0x54be3a794282c030b15e43ae2bb182e14c409c5e | 953605.664021346 | 100000 | 0 | 100000 |
10 | 0x532eedeabc0cc70f8d371ac76020e1ad9b02ceab | 923901.171239165 | 100000 | 0 | 100000 |
11 | 0x41797b5e0398af475422f6f33f2dc81d9a24ae33 | 916844.760603315 | 176873 | 0 | 176873 |
12 | 0xa7fc795882c8a5feae70c270abf5e9a05afb963a | 915034.477170874 | 100000 | 0 | 100000 |
13 | 0xe3879b7359695f802d6fd56bb76fd82c362dafd6 | 910308.356732218 | 1092117 | 691492 | 400625 |
14 | 0x46665b2cb0b7859ae4bbffd19583677b9588574f | 728566.28675312 | 80000 | 0 | 80000 |
15 | 0x630d2d3999f532663ca984f49916506eafe03fc0 | 632419.35416084 | 180436 | 0 | 180436 |
16 | 0x3b7bff633d838379b01d940b6eb74d1643542a1c | 613705.863724696 | 92 | 0 | 92 |
17 | 0x857ab110153ad57240ab920e93bfb549c045af55 | 574950.972321738 | 126979 | 4654 | 122325 |
18 | 0xd87de2b6de1c6936751606646769a482510f5ea8 | 571991.17436971 | 58923 | 0 | 58923 |
19 | 0x742c43952a9f5822446f9280f8f942765beab888 | 570376.695969569 | 60537 | 0 | 60537 |
20 | 0x70ca4d3d611a360615d1c09752b846da899d263c | 486395.352483496 | 135745 | 0 | 135745 |
freemartianCachers Claims
Updated 2025-04-16
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
eth_deposits AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:user :: string AS user,
decoded_log:amount / pow(10,18) AS amount,
'Ethereum Deposit' AS label
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
AND event_name = 'DepositCreated'
AND block_timestamp::date >= '2024-06-01'
),
eth_withdraws AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:user :: string AS user,
decoded_log:totalAmount / pow(10,18) AS amount,
'Ethereum Withdraw' AS label
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
AND event_name = 'DepositsWithdrawn'
AND block_timestamp::date >= '2024-06-01'
),
base_deposits AS(
SELECT
block_timestamp,
tx_hash,
from_address :: string AS user,
amount,
'Base Deposit' AS label
Last run: 11 days ago
...
13268
878KB
37s