SniperTotal whale balance USD by token
Updated 2023-06-01
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
cte as (
SELECT
*
FROM
(
VALUES
('0x013b646fe54562a3ff6e3469fcc8c4efc2337656'),
('0x77134cbc06cb00b66f4c7e623d5fdbf6777635ec'),
('0xd464ecbd0c16169c098abd367124c3e4ee46a9f5'),
('0xa1dd9d42425cb0e096428fe583ed157115d60511'),
('0x3de0de4e7417253c92fcdbb0e72e0230554c9024'),
('0x51af494f1b4d3f77835951fa827d66fc4a18dae8'),
('0xcdc8bbc2c740e44e9231dc3a8842800aa2433d18'),
('0x46f80018211d5cbbc988e853a8683501fca4ee9b'),
('0xd275e5cb559d6dc236a5f8002a5f0b4c8e610701'),
('0x4aefa39caeadd662ae31ab0ce7c8c2c9c0a013e8'),
('0x0e0100ab771e9288e0aa97e11557e6654c3a9665'),
('0x00e39085c877328619fdb2a47d995c516a5fa869'),
('0x1bc2efcc22e22d7d380b58b2736f9b6144c1e34a'),
('0x1c634af3d63e62fd4b1236e891573ffa88bf5f6f'),
('0x3a23f943181408eac424116af7b7790c94cb97a5')
) AS X (address)
),
depoist as (
select
'Ethereum' as Chain,
to_address,
symbol,
sum(amount_usd) as volume_depoist
from
ethereum.core.ez_token_transfers
where
to_address in (select address from cte)
group by 1,2,3
UNION
Run a query to Download Data