cloudr3nJoepegs Top 10 High Rollers
Updated 2023-04-26Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with buyers as (
select origin_from_address as buyer, sum(event_inputs:price*power(10,-18)) as total_spent, count(*) as total_purchases,
row_number() over (order by total_spent desc) as rank
from avalanche.core.fact_event_logs
where origin_to_address='0xae079eda901f7727d0715aff8f82ba8295719977' and event_name in ('TakerBid','TakerAsk')
group by buyer
order by total_spent desc
limit 10
)
select --rank,
case when rank = 1 then '🤑🤑🤑'
when rank = 2 then '🤑🤑'
when rank = 3 then '🤑'
else '💸' end as ranking,
buyer, total_spent, total_purchases
from buyers
order by total_spent desc
Run a query to Download Data