zackmendelActivity of Whales & Non-Whales
Updated 2024-10-24
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 users AS (
SELECT
DISTINCT sender AS user
FROM ethereum.defi.ez_dex_swaps
WHERE platform LIKE 'uniswap%'
),
balances AS (
SELECT
DISTINCT user_address AS user,
usd_value_now AS balance
FROM ethereum.core.ez_current_balances
WHERE user_address IN (SELECT user FROM users)
),
bal_fix AS (
SELECT
DISTINCT user,
CASE
WHEN balance > 10000 THEN 'Whale'
ELSE 'Not_Whale'
END AS distribution
FROM balances
),
base_stat AS (
SELECT
distribution,
CASE
WHEN block_timestamp::date < '2023-10-17' THEN 'Before_hike'
WHEN block_timestamp::date BETWEEN '2023-10-17' AND '2024-04-10' THEN 'First_hike'
WHEN block_timestamp::date >= '2024-04-10' THEN 'Second_hike'
END AS time_range,
amount_in_usd AS volume,
QueryRunArchived: QueryRun has been archived