Elprognerd12 - Top 10 Whales on Solanart
    Updated 2022-12-08
    WITH price_table AS (SELECT
    date_trunc('day', hour) AS DATE,
    avg(price) AS price
    FROM ethereum.core.fact_hourly_token_prices
    WHERE token_address ilike '0xD31a59c85aE9D8edEFeC411D448f90841571b89c'
    GROUP BY 1)

    SELECT
    PURCHASER,
    sum(SALES_AMOUNT*price) AS tot_volume_usd
    FROM solana.core.fact_nft_sales x JOIN price_table ON date_trunc('day', BLOCK_TIMESTAMP) = price_table.DATE
    JOIN solana.dim_nft_metadata y on x.mint = y.mint
    WHERE (MARKETPLACE = 'solanart' ) AND SUCCEEDED = 'TRUE'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data