USER | WHITELIST_AMOUNT | CURRENT_BALANCE | STAKE_AMOUNT | SELL_AMOUNT | BUY_AMOUN | INFLOW_AMOUNT | OUTFLOW_AMOUNT | |
|---|---|---|---|---|---|---|---|---|
1 | 0xe3e0f2146da732ce6f92c025c961cecdf78e38eb | 1000000 | 0 | 0 | 18135443.2825687 | 0 | 20135443.2825687 | 20135443.2825687 |
2 | 0xc7dc4e39ab2d930552f5fd90a9b07dbb2366df16 | 2449275.36231884 | 0 | 0 | 11192125.2831223 | 5228274.56894315 | 13768764.4091816 | 13768764.4091816 |
3 | 0x4bc3cd268d97d77702e14d2dbcd0b3c93a57d66d | 1000000 | 0.3019097997 | 0 | 6609768.596881 | 5943101.8987908 | 6943101.8987908 | 6943101.596881 |
4 | 0x17c360cbfa39e218fb49ca754ec53af31684dd05 | 2449275.36231884 | 0.3823140413 | 0 | 5284951.925982 | 0 | 23286635.7124318 | 23286635.3301177 |
5 | 0xa2b2f10a3c542fed3a53654cca97d34f628f55e3 | 1000000 | 1.862645149e-9 | 0 | 4129955 | 5156254.47739457 | 16235152.4321837 | 16235152.4321837 |
6 | 0xae0ad2947c529560763db15cfc26e02d21cd3353 | 1000000 | 0 | 0 | 4000000 | 0 | 10000000 | 10000000 |
7 | 0xffa45616a7be43417414ba1d2104530efec0b644 | 1000000 | 0 | 0 | 3196240.74143015 | 196240.741430149 | 5392481.4828603 | 5392481.4828603 |
8 | 0x3884639422ea0493fabf64d1808db50c7c18d3bf | 2449275.36231884 | 0 | 0 | 3122870.80434052 | 673595.442021672 | 3122870.80434051 | 3122870.80434051 |
9 | 0x9bbcdcb4bf4665ac620fde7d23ad697fa12e3cd6 | 2449275.36231884 | 0.08050378971 | 0 | 3039384.167642 | 196830.716069531 | 7258959.10892594 | 7258959.02842215 |
10 | 0x2da76b248e174bcd13a53414b84632317aad4439 | 1000000 | 0.3850757382 | 0 | 3035708 | 2035708.38507574 | 3035708.38507574 | 3035708 |
11 | 0xfdd0c59a748f010431b65faffc2e48b1dbcc008e | 2449275.36231884 | 9.313225746e-10 | 0 | 2765375.51055294 | 316100.148234099 | 7980026.38342472 | 7980026.38342472 |
12 | 0x141d93a0a4720c766700f8b0a86ecaf09b746190 | 1000000 | 999.999999999 | 1.746229827e-10 | 2600219.45124211 | 1201590.2784418 | 5801658.35372632 | 5800658.35372632 |
13 | 0x4cd5dc9a87aceb8fc1cdf0b72c27dc00cbe8e422 | 1000000 | 0.1870406969 | 0 | 2595488 | 296039.42774923 | 5190976.37408139 | 5190976.1870407 |
14 | 0xf93aaaec5e4ced8605a57b3dff011ec408a8ebdb | 2449275.36231884 | 0 | 0 | 2449275.36231884 | 0 | 3573913.04347826 | 3573913.04347826 |
15 | 0x84b8da634d034ff8067503cea37828c77a9cbeab | 2449275.36231884 | 0 | 0 | 2449275.36231884 | 0 | 2449275.36231884 | 2449275.36231884 |
16 | 0xfeee150299115127b64d48ad06cfd77201cfbaae | 2449275.36231884 | 0 | 0 | 2449275.36231884 | 0 | 7347826.08695652 | 7347826.08695652 |
17 | 0x60ff557b93add579a41fbdb18fdc20c064ac3d76 | 2449275.36231884 | 0 | 0 | 2449275.36231884 | 0 | 7347826.08695652 | 7347826.08695652 |
18 | 0xa5875b5f234e84f3ce959e82cb6881efad3cc59c | 2449275.36231884 | 0.3623188408 | 0 | 2449275 | 0 | 2449275.36231884 | 2449275 |
19 | 0x56133d0d3e0dae627ea03165adce111239218fc5 | 2449275.36231884 | 0.3623188408 | 0 | 2449275 | 0 | 4898550.72463768 | 4898550.36231884 |
20 | 0xbe503cbc548cb9fe2ac12c5c7b29f764976d492c | 2449275.36231884 | 0.3623188408 | 0 | 2449275 | 0 | 2449275.36231884 | 2449275 |
freemartianTotal whitelisted activities
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 current_price as (
SELECT
value:pairAddress as pairAddress,
value:priceUsd AS priceUsd,
from (SELECT livequery.live.udf_api(
'https://api.dexscreener.com/latest/dex/tokens/0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
) AS response), lateral FLATTEN (input => response:data:pairs)
where pairAddress in ('0xe6EC4C661F0B822BA2851b4A1de9Ad64132fbFe3')
),
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'
),
token_in AS(
SELECT
to_address AS user,
SUM(amount) AS inflow_amount,
FROM base.core.ez_token_transfers
WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
AND user in (SELECT user FROM whitelisted)
GROUP BY 1
),
Last run: 21 days agoAuto-refreshes every 1 hour
...
852
77KB
1261s