noanuman-1x1vZpWhale Activity
Updated 2024-10-19
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
user_address,
current_bal,
usd_value_now
FROM ethereum.core.ez_current_balances
WHERE usd_value_now > 100000
AND LOWER(contract_address) = LOWER('0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a')
),
sells30 AS(
SELECT
ORIGIN_FROM_ADDRESS,
amount_in,
amount_in*p.PRICE AS dollar_in,
block_timestamp
FROM ethereum.defi.ez_dex_swaps s
JOIN ethereum.price.ez_prices_hourly p
ON p.HOUR = DATE_TRUNC('HOUR', s.block_timestamp)
JOIN whales w
ON LOWER(w.user_address) = LOWER(ORIGIN_FROM_ADDRESS)
WHERE LOWER(TOKEN_IN) = LOWER('0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a')
AND block_timestamp::date >= CURRENT_DATE()-30
),
sells7 AS(
SELECT *
FROM sells30
WHERE block_timestamp::date >= CURRENT_DATE()-7
),
buys30 AS(
SELECT
ORIGIN_FROM_ADDRESS,
amount_out,
amount_out*p.PRICE AS dollar_out,
QueryRunArchived: QueryRun has been archived