Moeall in one
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 Avalanche whales full info @ https://flipsidecrypto.xyz/edit/queries/02026a4a-1836-49c8-9849-ff038189e505
-- forked from Deebs-DeFi-I-Orbital-Command-j9fRbz / AVAX Weekly Whale (ALL WHALES BY TOKEN) @ https://flipsidecrypto.xyz/Deebs-DeFi-I-Orbital-Command-j9fRbz/q/avax-weekly-whale-all-whales-a3KhqG
(with fin as (WITH Deposits AS(
SELECT
TO_ADDRESS AS whale,
SYMBOL,
sum(AMOUNT_USD) AS bought_amount
FROM avalanche.core.ez_token_transfers
WHERE BLOCK_TIMESTAMP>CURRENT_DATE-30
AND whale NOT IN('0x0000000000000000000000000000000000000000',
'0x5440235fb0689b1ad755bc1bc5cb1bb07a2538de',
'0x9f8c163cba728e99993abe7495f06c0a3c8ac8b9',
'0xf01ef4051130cc8871fa0c17024a6d62e379e856',
'0x7e4aa755550152a522d9578621ea22edab204308',
'0x1205f31718499dbf1fca446663b532ef87481fe1',
'0xbf14db80d9275fb721383a77c00ae180fc40ae98',
'0x9ab2de34a33fb459b538c43f251eb825645e8595',
'0xd446eb1660f766d533beceef890df7a69d26f7d1',
'0x13fef0c15b7756457f6fe95b49b918b0e6b3bf2a',
'0xb5352a39c11a81fe6748993d586ec448a01f08b5',
'0x3b3e4b4741e91af52d0e9ad8660573e951c88524',
'0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30',
'0xef3c714c9425a8f3697a9c969dc1af30ba82e5d4',
'0x2d722c96f79d149dd21e9ef36f93fc12906ce9f8',
'0x1d7a1a79e2b4ef88d2323f3845246d24a3c20f1d',
'0xa523d2d2e9a2ee4089e57f77bedebec9b36bf318',
'0xdef171fe48cf0115b1d80b88dc8eab59176fee57',
'0x1111111254eeb25477b68fb85ed929f73a960582',
'0x29e38769f23701a2e4a8ef0492e19da4604be62c',
'0x9f8973fb86b35c307324ec31fd81cf565e2f4a63',
'0x87eb2f90d7d0034571f343fb7429ae22c1bd9f72',
'0x42be75636374dfa0e57eb96fa7f68fe7fcdad8a3',
'0xfff6d276bc37c61a23f06410dce4a400f66420f8',
Run a query to Download Data