Hadisehflow 5
    Updated 2022-07-19
    with tb_flow_whale as ( select buyer , count(DISTINCT(tx_id)) as total_sales , sum(price) as volume
    from flow.core.fact_nft_sales
    group by 1
    order by 3 desc
    limit 100),
    tb_flow_nft as ( select min(block_timestamp::date) as day, NFT_COLLECTION as nft
    from flow.core.fact_nft_sales
    group by 2),
    tb_flow as ( select day , buyer , nft_collection
    from flow.core.fact_nft_sales x join tb_flow_nft y on x.nft_collection = y.nft
    where buyer in ( select buyer from tb_flow_whale)),

    tb_solana_whale as ( select purchaser , count(DISTINCT(tx_id)) as total_sales, sum(sales_amount) as volume
    from solana.core.fact_nft_sales
    where sales_amount is not null and block_timestamp::date >= '2022-01-01'
    group by 1
    order by 3 desc
    limit 100),
    tb_solana_nft as ( select min(block_timestamp::date) as day , mint as nft
    from solana.core.fact_nft_sales
    group by 2),
    tb_solana as ( select day , purchaser , mint
    from solana.core.fact_nft_sales x join tb_solana_nft y on x.mint = y.nft
    where purchaser in ( select purchaser from tb_solana_whale)
    ),
    tb_ethereum_whale as ( select buyer_address ,
    count(DISTINCT(tx_hash)) as total_sales,
    sum(price_usd) as volume
    from ethereum.core.ez_nft_sales
    where price_usd is not null and block_timestamp::date >= '2022-01-01'
    group by 1
    Run a query to Download Data