Drsimonwhale watching...(AVAX)
Updated 2023-08-04
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 whales AS (
SELECT
DATE_TRUNC('{{Time_frame}}', BLOCK_TIMESTAMP) AS DATE,
SYMBOL,
FROM_ADDRESS AS "Sender whale Address",
TO_ADDRESS AS "Receiver whale Address",
AMOUNT_USD ,
SUM(AMOUNT_USD) AS total_volume_USD,
CASE
WHEN AMOUNT_USD BETWEEN 1000 AND 9999 THEN 'Sender whales between 1000 - 9999 USD 🐟'
WHEN AMOUNT_USD BETWEEN 10000 AND 99999 THEN 'Sender whales between 10000 - 99999 USD 🐡'
WHEN AMOUNT_USD BETWEEN 100000 AND 999999 THEN 'Sender whales between 100000 - 999999 USD 🐬'
WHEN AMOUNT_USD BETWEEN 1000000 AND 9999999 THEN 'Sender whales between 1000000 - 9999999 USD 🦈'
WHEN AMOUNT_USD >= 10000000 THEN 'Sender whales more than 10000000 USD 🐋'
ELSE '0'
END AS "Sender whales",
CASE
WHEN AMOUNT_USD BETWEEN 1000 AND 9999 THEN 'Receiver whales between 1000 - 9999 USD 🐟'
WHEN AMOUNT_USD BETWEEN 10000 AND 99999 THEN 'Receiver whales between 10000 - 99999 USD 🐡'
WHEN AMOUNT_USD BETWEEN 100000 AND 999999 THEN 'Receiver whales between 100000 - 999999 USD 🐬'
WHEN AMOUNT_USD BETWEEN 1000000 AND 9999999 THEN 'Receiver whales between 1000000 - 9999999 USD 🦈'
WHEN AMOUNT_USD >= 10000000 THEN 'Receiver whales more than 10000000 USD 🐋'
ELSE '0'
END AS "Receiver whales",AMOUNT
FROM
avalanche.core.ez_token_transfers
WHERE
SYMBOL IN ('WAVAX', 'AVAX')
and (FROM_ADDRESS = ('{{Whale_Address}}') OR TO_ADDRESS = ('{{Whale_Address}}'))
AND AMOUNT >= {{Amount_AVAX}}
Run a query to Download Data