maybeyonassol_me_port_taiyo_daily
    Updated 2022-04-04
    with
    taiyo as (
    select
    distinct contract_address as mint
    from solana.dim_nft_metadata
    where project_name = 'Taiyo Robotics'
    )

    select
    marketplace,
    date(block_timestamp) as date,
    count(distinct tx_id) as txs,
    count(distinct purchaser) as users
    from solana.fact_nft_sales
    where program_id in (
    'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K', -- eden
    'SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj' -- solport
    )
    and block_timestamp >= '2022-01-12'
    and mint in (select mint from taiyo)
    group by 1,2

    Run a query to Download Data