freemartianTotal Holders list
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
api_call as (
SELECT
value:pairAddress AS pairAddress,
value:liquidity:usd AS liquidity_usd,
value:marketCap AS marketCap,
value:priceUsd AS priceUsd,
value:priceChange:h1 AS priceChange_h1,
value:priceChange:h6 AS priceChange_h6,
value:priceChange:h24 AS priceChange_h24,
value:txns:h1:buys AS h1_buys,
value:txns:h6:buys AS h6_buys,
value:txns:h24:buys AS h24_buys,
value:volume:h1 AS volume_h1,
value:volume:h6 AS volume_h6,
value:volume:h24 AS volume_h24
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')
-- where pairAddress in ('0xe6EC4C661F0B822BA2851b4A1de9Ad64132fbFe3','0x1445fA540021e67d2a0291BAc79036c45AF991d3')
),
token_in_out AS(
SELECT
to_address AS user,
SUM(amount) AS amount,
FROM base.core.ez_token_transfers
WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
GROUP BY 1
UNION ALL
SELECT
from_address AS user,
SUM(-amount) AS amount,
FROM base.core.ez_token_transfers
WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'