strawbettyETH NFT
    Updated 2022-05-19
    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