msafadoostContracts used by whales
    Updated 2022-07-18
    WITH whales1 AS (
    SELECT SELLER,
    COUNT(SELLER) as counts,
    'Flow' AS label
    FROM flow.core.fact_nft_sales
    WHERE BLOCK_TIMESTAMP >= '2022-04-20'
    AND TX_SUCCEEDED = 'TRUE'
    AND PRICE > 0
    GROUP by 1 HAVING counts >= 500
    ),
    whales2 AS (
    SELECT BUYER,
    COUNT(BUYER) as counts,
    'Flow' AS label
    FROM flow.core.fact_nft_sales
    WHERE BLOCK_TIMESTAMP >= '2022-04-20'
    AND TX_SUCCEEDED = 'TRUE'
    AND PRICE > 0
    GROUP by 1 HAVING counts >= 500
    ),
    whales AS (
    SELECT SELLER
    FROM whales1 JOIN whales2 ON SELLER = BUYER
    GROUP by 1
    )
    SELECT CONTRACT_NAME,
    COUNT(CONTRACT_NAME)
    FROM flow.core.fact_events JOIN flow.core.dim_contract_labels USING(EVENT_CONTRACT)
    WHERE TX_ID IN (
    SELECT TX_ID
    FROM flow.core.fact_transactions
    WHERE PROPOSER IN (
    SELECT SELLER FROM whales
    )
    )
    GROUP by 1
    Run a query to Download Data