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