shreexMints VS Sales 2
Updated 2022-10-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
(select
date_trunc('day',block_timestamp) as date,
'Mint Sales' as event,
count(distinct tx_id) as sales
from flow.core.fact_events
where event_contract = 'A.329feb3ab062d289.RaceDay_NFT' and event_type = 'Minted'
GROUP BY date
ORDER BY date )
UNION
(select
date_trunc('day',block_timestamp) as date,
'Secondary Sales' as event,
count(distinct tx_id) as sales
from flow.core.ez_nft_sales where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT' and tx_succeeded='TRUE'
GROUP BY date
ORDER BY date)
Run a query to Download Data