mar1na-catscatscodenyan cats trait body
    Updated 2023-04-13
    with base as (
    select
    metadata.mint as mint,
    metadata.contract_name,
    metadata.contract_address,
    metadata.token_id,
    sales.tx_id as sale_tx_id,
    sales.marketplace,
    sales.block_timestamp::date as sale_date,
    sales.purchaser,
    sales.seller,
    sales.sales_amount,
    metadata.token_metadata['Background'] as background,
    metadata.token_metadata['Body'] as body,
    metadata.token_metadata['Border'] as border,
    metadata.token_metadata['Equipment'] as equipment,
    metadata.token_metadata['Eyes'] as eyes,
    metadata.token_metadata['Eyewear'] as eyewear,
    metadata.token_metadata['Headwear'] as headwear,
    metadata.token_metadata['Mech'] as mech,
    metadata.token_metadata['Mouth'] as mouth,
    metadata.token_metadata['Rarity'] as rarity,
    metadata.token_metadata['Special'] as special
    from solana.core.dim_nft_metadata metadata
    left join solana.core.fact_nft_sales sales on sales.mint = metadata.mint
    where metadata.contract_name = 'Nyan Heroes'
    and sales.succeeded = 'TRUE'
    )

    select
    -- background,
    body,
    -- border, equipment, eyes, eyewear, headwear, mech, mouth, rarity, special,
    sales_amount
    from base
    Run a query to Download Data