nilofv
Updated 2023-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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