ErsvanSmart Money NFT Traders - General
    Updated 2022-06-08
    WITH
    min (ad,min,minP) AS (
    SELECT PURCHASER, MINT, MINT_PRICE FROM solana.fact_nft_mints WHERE SUCCEEDED = TRUE AND BLOCK_TIMESTAMP > '2022-01-01'
    ),
    tra (ad,min,id) AS (
    SELECT TX_FROM, MINT, TX_ID FROM solana.fact_transfers WHERE BLOCK_TIMESTAMP > '2022-01-01'
    ),
    topMin (ad,num) AS (
    SELECT AD, COUNT(*) AS NUM
    FROM min
    GROUP BY ad
    ORDER BY NUM DESC
    LIMIT 10
    ),
    topNFT(ad,min,minP) AS (
    SELECT
    min.ad,
    min.min,
    min.minP
    FROM
    min
    JOIN topMin ON topMin.ad = min.ad
    ),
    topTra (ad,num) AS (
    SELECT tra.ad, COUNT(*) AS NUM
    FROM
    tra
    JOIN min ON min.min = tra.min
    WHERE tra.ad = min.ad
    GROUP BY tra.ad
    ORDER BY NUM DESC
    LIMIT 10
    ),
    topAd (ad,min,numMin,numTra,avg) AS(
    SELECT
    topTra.ad AS address,
    Run a query to Download Data