ArioNFT Wallet Behavior Comparison - Whales Activity
    Updated 2022-07-19
    with flow_whales as (
    select top 50
    buyer,
    count(tx_id) as number_of_sales
    from flow.core.fact_nft_sales
    group by 1
    order by 2 desc
    ),
    flow as (
    select
    block_timestamp::date as date,
    count(tx_id) as number_of_sales,
    sum(number_of_sales) over (order by date asc) as cumulative_N_sales
    from flow.core.fact_nft_sales
    where block_timestamp::date >= '2022-04-20'
    and buyer in (select buyer from flow_whales)
    group by 1
    ),
    ethereum_whales as (
    select top 50
    buyer_address,
    count(DISTINCT tx_hash) as number_of_sales
    from ethereum.core.ez_nft_sales
    where price_usd is not null
    group by 1
    order by 2 desc
    ),
    ETH as (
    select
    block_timestamp::date as date,
    count(tx_hash) as number_of_sales,
    sum(number_of_sales) over (order by date asc) as cumulative_N_sales
    from ethereum.core.ez_nft_sales
    where
    block_timestamp >= '2022-04-20'
    and buyer_address in (select buyer_address from ethereum_whales)
    Run a query to Download Data