freemartianFavorite Chain - ETH Hop Whales
Updated 2022-06-22Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
origin_from_address as user,
count(distinct origin_from_address) as whale_count,
sum(event_inputs:amount)/pow(10,18) * avg(price) as volume,
case
when event_inputs:chainId = '10' then 'Optimism'
when event_inputs:chainId = '100' then 'xDAI'
when event_inputs:chainId = '137' then 'Polygon'
when event_inputs:chainId = '42161' then 'Arbitrum'
end as chain
from ethereum.core.fact_event_logs l
inner join ethereum.core.fact_hourly_token_prices p on to_char(block_timestamp, 'yyyy-mm-dd HH24:00:00.000 ') = hour
where origin_to_address = lower('0xb8901acB165ed027E32754E0FFe830802919727f')
and event_name = 'TransferSentToL2'
and symbol = 'WETH'
group by user, chain
having volume > 1000000
order by volume DESC
Run a query to Download Data