Updated 2023-06-07
    with
    top10 as (
    select
    BUYER,
    count(DISTINCT TX_ID) as TXN,
    count(distinct NFT_ID) as NFT_IDs,
    SUM(
    CASE
    WHEN CURRENCY = 'A.e3ad6030cbaff1c2.DimensionX' THEN PRICE * FLOW_USD
    ELSE PRICE
    END
    ) AS USD,
    rank() over (
    order by
    TXN desc
    ) rank
    from
    flow.core.ez_nft_sales
    LEFT JOIN (
    SELECT
    DATE_TRUNC('day', RECORDED_HOUR) AS TIMEF,
    AVG(CLOSE) AS FLOW_USD
    FROM
    flow.core.fact_hourly_prices
    WHERE
    TOKEN = 'Flow'
    GROUP BY
    1
    ) FLOW ON TIMEF = DATE_TRUNC('day', BLOCK_TIMESTAMP)
    WHERE
    NFT_COLLECTION = 'A.e3ad6030cbaff1c2.DimensionX'
    AND TX_SUCCEEDED = 'TRUE'
    group by
    1
    qualify
    rank <= 5
    Run a query to Download Data