NuveveCryptoArchivedwhales selling volume
Updated 2023-05-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with whales as (
select
user_address,
current_bal as balance
from ethereum.core.ez_current_balances
where contract_address = '0x6982508145454ce325ddbe47a25d4ec3d2311933'
and current_bal >= 0.001 * 424180277408960
order by balance desc
)
select
transfers.block_timestamp::date as date,
substring(whales.user_address, 1, 14) as whale,
sum(amount_in_usd) as volume_usd
from ethereum.core.ez_dex_swaps as transfers
inner join whales on transfers.origin_from_address = whales.user_address
where transfers.token_in = '0x6982508145454ce325ddbe47a25d4ec3d2311933'
and transfers.amount_in_usd is not null
group by date, whale
Run a query to Download Data