Deebs-DeFi-j9fRbzOP token Whales Accumulating
Updated 2023-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from OP token Whale Purchasing @ https://flipsidecrypto.xyz/edit/queries/8540ece5-0032-4579-ade3-653d33352fa5
SELECT
TO_ADDRESS AS whale,
sum(RAW_AMOUNT/POW(10,18)) AS OP_Volume
FROM optimism.core.fact_token_transfers
WHERE BLOCK_TIMESTAMP>CURRENT_DATE-7
AND CONTRACT_ADDRESS='0x4200000000000000000000000000000000000042'
AND whale NOT IN('0x47029bc8f5cbe3b464004e87ef9c9419a48018cd',
'0x19793c7824be70ec58bb673ca42d2779d12581be',
'0x0296b27c2041d55c7220b05aa2079ef1e8e3b60a',
'0x68f5c0a2de713a54991e01858fd27a3832401849',
'0x540243fb1aadc71ee6d713409f35e3ea7865718d'
)
GROUP BY 1
ORDER BY 2 DESC
LIMIT 50
Run a query to Download Data