oooooblahcheck nft sale is whale
    Updated 2022-07-31
    with buy_whales as (
    select buyer_address, count(*)
    from ethereum_core.ez_nft_sales
    where nft_address = lower('0x34d85c9CDeB23FA97cb08333b511ac86E1C4E258')
    and platform_name = 'opensea'
    group by buyer_address
    order by count(*) desc
    limit 50
    ),
    sell_whales as (
    select seller_address, count(*)
    from ethereum_core.ez_nft_sales
    where nft_address = lower('0x34d85c9CDeB23FA97cb08333b511ac86E1C4E258')
    and platform_name = 'opensea'
    group by seller_address
    order by count(*) desc
    limit 50
    ),
    sales as (
    select *
    from ethereum_core.ez_nft_sales
    where nft_address = lower('0x34d85c9CDeB23FA97cb08333b511ac86E1C4E258')
    and platform_name = 'opensea'
    order by block_timestamp desc
    limit 1000
    ),
    whale_buy_count as (
    select buyer_address, count(*) from sales
    where exists (select 1 from buy_whales where buy_whales.buyer_address = sales.buyer_address)
    group by buyer_address
    )

    select * from whale_buy_count

    Run a query to Download Data