Deebs-DeFi-j9fRbzWhale Activity Transactions 10k and up
Updated 2023-12-06
99
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 purchases AS(
SELECT
--TO_ADDRESS AS whale,
date_trunc('week',BLOCK_TIMESTAMP) AS DATE,
SYMBOL_OUT,
sum(AMOUNT_OUT_USD) AS bought_amount
FROM avalanche.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP>CURRENT_DATE-{{Date_Range}}
AND date_trunc('week',BLOCK_TIMESTAMP)!=date_trunc('week',Current_date)
AND AMOUNT_OUT_USD>10000
AND sender NOT IN(SELECT ADDRESS FROM avalanche.core.dim_labels)
GROUP BY 1,2
HAVING bought_amount>0
ORDER BY 2 DESC
),
Sells AS(
SELECT
--TO_ADDRESS AS whale,
date_trunc('week',BLOCK_TIMESTAMP) AS DATE,
SYMBOL_IN,
sum(-AMOUNT_IN_USD) AS sold_amount
FROM avalanche.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP>CURRENT_DATE-{{Date_Range}}
AND date_trunc('week',BLOCK_TIMESTAMP)!=date_trunc('week',Current_date)
AND AMOUNT_IN_USD>10000
AND sender NOT IN(SELECT ADDRESS FROM avalanche.core.dim_labels)
GROUP BY 1,2
ORDER BY 2 DESC
)
SELECT
date,
symbol_out as symbol,
bought_amount as NET_purchased_USD
Run a query to Download Data