strawbettyETH NFT
Updated 2022-05-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with solana_sales
as( select
trunc(block_timestamp,'day') as Date, tx_id, PURCHASER
from flipside_prod_db.solana.fact_nft_sales
where date >= '2022-01-01'),
solana as(
select Date, count(distinct tx_id) as solana_nft_sales
from solana_sales
group by 1
), ethereum_sales as(
select
trunc(block_timestamp,'day') as Date, TX_HASH, BUYER_ADDRESS
from flipside_prod_db.ethereum_core.ez_nft_sales
where Date >= '2022-01-01'
), ethereum as(
select Date, count(distinct TX_HASH) as ethereum_nft_sales
from ethereum_sales
group by 1
)
select solana.date, solana_nft_sales, ethereum_nft_sales
from solana left join ethereum on ethereum.date = solana.date
order by 1
Run a query to Download Data