MLDZMNeth1
Updated 2023-05-31
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
›
⌄
-- forked from pol1 @ https://flipsidecrypto.xyz/edit/queries/f31c4620-f75b-4592-b843-e67d404b9463
with Deposits AS(
SELECT
TO_ADDRESS AS whale,
SYMBOL,
sum(AMOUNT_USD) AS bought_amount
FROM ethereum.core.ez_token_transfers
WHERE BLOCK_TIMESTAMP>CURRENT_DATE-30
AND whale IN (
'0x4a4e859565d9b563afc8e63641542455cff0dfd2',
'0xcca0cffbf97fb10b08c1703f1dddcf7b48c69d69',
'0x46f80018211d5cbbc988e853a8683501fca4ee9b',
'0xeb825b8c57b3169c35acf5721d89aa6946da4e9c',
'0xb624219480543c54603fb6b07d5eb347e51bffe0',
'0xe195b82df6a797551eb1acd506e892531824af27',
'0x2297aebd383787a160dd0d9f71508148769342e3',
'0xf62f75dcf3c73cafbcadda2236c3ce61a2b7c64a',
'0x989536719a72cfd50348ccd5521256c7eb41a999',
'0xeb97dee699b7a7237a30c52c5e2afa34cec7147d',
'0xda14473cb67529c8a780c4d0c5c6eb2cf1a9fde7',
'0xd275e5cb559d6dc236a5f8002a5f0b4c8e610701',
'0xdbd08d75a614567ff03f50e75b2a72ff9af35700',
'0xcc9b1f919282c255eb9ad2c0757e8036165e0cad',
'0xe195b82df6a797551eb1acd506e892531824af27',
'0x838d26b7324aefc725098111116d9732057aca26',
'0x5e12fc70b97902ac19b9cb87f2ac5a8593769779',
'0xe0028eb5ae51384418e07cad373dae8f396ad707',
'0x42a178633240601d3485e1f51d8b62ea58c9b5ae',
'0xc279fe84665582169a96cf5621361af086377a79'
)
GROUP BY 1,2
HAVING bought_amount>0
union all
SELECT
eth_TO_ADDRESS AS whale,
Run a query to Download Data