barbodnet 1
    Updated 2022-07-12
    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