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
),
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived