MoeAVAX whale copy
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 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 whales 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',
'0xd9fa522f5bc6cfa40211944f2c8da785773ad99d',
'0x625e7708f30ca75bfd92586e17077590c60eb4cd',
'0x4224f6f4c9280509724db2dbac314621e4465c29',
Run a query to Download Data