KaskoazulMonke DAO - sales after voting - sale price
    Updated 2022-04-06
    WITH PURCHASERS AS (
    select block_timestamp as fecha,
    purchaser,
    sales_amount,
    concat_ws('#', 'SMB', token_id),
    marketplace,
    tx_id
    from solana.dim_nft_metadata md
    left join solana.fact_nft_sales sale
    on md.mint = sale.mint
    where contract_address = ('9uBX3ASjxWvNBAD1xjbVaKA74mWGZys3RGSF7DdeDD3F') --contract_name = ('Solana Monkey Business')
    --and program_id in ('J7RagMKwSD5zJSbRQZU56ypHUtux8LRDkUpAPSKH4WPp', 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K', 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')
    and succeeded = 'TRUE'
    and fecha >= '2022-02-15'
    and sales_amount < 1000
    )

    select *
    from PURCHASERS


    Run a query to Download Data