mehrancrypto-dxoepqQ70-9
Updated 2022-10-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 as
(
SELECT block_timestamp::date as daily , count( DISTINCT tx_id) as mint
from flow.core.fact_events
where event_contract ilike '%raceday%'
and EVENT_TYPE = 'Minted'
GROUP by 1
)
, tab2 as (
SELECT block_timestamp::date as daily, COUNT(DISTINCT tx_id) as sale
from flow.core.ez_nft_sales
where NFT_COLLECTION ilike '%raceday%'
and TX_SUCCEEDED ilike '%TRUE%'
GROUP by 1
)
SELECT A.daily , sale , mint
from tab1 A
join tab2 B on A.daily = B.daily
Run a query to Download Data