barbodnet 1
Updated 2022-07-12
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
›
⌄
with tb1 as (select
block_timestamp::date as day,
count(distinct PURCHASER) as user_SOL,
count(distinct TX_ID) as sale_sol
from flipside_prod_db.solana.fact_nft_mints
where block_timestamp>=CURRENT_DATE-60
and SUCCEEDED = 'TRUE' group by 1),
tb2 as (select
block_timestamp::date as day,
count(distinct NFT_TO_ADDRESS) as user_ETH,
count(distinct TX_HASH) as sale_ETH
from flipside_prod_db.ethereum_core.ez_nft_mints
where block_timestamp>=CURRENT_DATE-60
group by 1 )
select tb1.day as day,
user_SOL,
user_ETH,
sale_sol,
sale_ETH
from tb1 join tb2 on tb1.day=tb2.day
Run a query to Download Data