Abbas_ra21Whales Purchase
Updated 2023-09-17Copy Reference Fork
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
›
⌄
with
balance AS (
select
user_address AS user,
max(BLOCK_TIMESTAMP) AS Time
from
ethereum.core.fact_eth_balances
group by
1
),
balance2 AS (
select
user_address,
Balance
from
ethereum.core.fact_eth_balances
inner join balance on time = BLOCK_TIMESTAMP
and user = user_address
)
select
BLOCK_TIMESTAMP AS Time,
ORIGIN_FROM_ADDRESS AS Address,
AMOUNT_OUT_USD AS "Buy size (USD)",
BALANCE / 1e18 AS "ETH BALANCE"
from
ethereum.core.ez_dex_swaps
inner join balance2 on user_address = ORIGIN_FROM_ADDRESS
where
TOKEN_IN = lower('0x48c87cDacb6Bb6BF6E5Cd85D8ee5C847084c7410')
and AMOUNT_OUT_USD >= 10000
order by
1 desc
Run a query to Download Data