jackguyLaLiga Golazos 5
Updated 2022-12-06
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
›
⌄
with tab1 as (
SELECT
NFT_COLLECTION,
min(block_timestamp) as min_day
FROM flow.core.ez_nft_sales
GROUP BY 1
)
SELECT --DISTINCT mp
-- date_diff,
-- SPLIT(mp, '.')[2] as mp1,
count(DISTINCT tx_id) as sales,
count(DISTINCT BUYER) as buyers,
sum(price) as volume,
avg(price) as avg_price
from (
SELECT
tx_id,
tab1.NFT_COLLECTION as mp,
price,
buyer,
datediff('hour', min_day, block_timestamp) as date_diff
FROM flow.core.ez_nft_sales as a
LEFT outer JOIN tab1
on a.NFT_COLLECTION = tab1.NFT_COLLECTION
WHERE date_diff < 168
)
--GROUP BY 1,2
WHERE SPLIT(mp, '.')[2] LIKE '{{collection}}'
Run a query to Download Data