DiamondDaily Moment Tiers And Sales (Draft)
Updated 2023-11-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from Daily Moment Tiers And Sales copy @ https://flipsidecrypto.xyz/edit/queries/54dddfc1-90a9-4ff9-99ab-4e1498c49391
select
date_trunc('day', block_timestamp) as date,
moment_tier,
sum(price) as volume,
count(*) as sales
from
flow.nft.ez_nft_sales sales
left join flow.nft.dim_allday_metadata meta on meta.nft_id = sales.nft_id
where
sales.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
and meta.nft_id = sales.nft_id
and block_timestamp between '2023-04-24' and '2023-05-02'
GROUP BY
moment_tier,
date
ORDER BY
date DESC
Run a query to Download Data