cloudr3nJoepegs Top 10 High Rollers
    Updated 2023-04-26
    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