Updated 2023-12-30
    with tb1 as ( select DISTINCT tx_id
    from solana.core.fact_events
    where program_id = 'SoLMAPutKhdpSSGpCCWioKfqqNQhsdaM8EEi41ummJM'
    and block_timestamp::date >= '2023-12-20'
    and succeeded = 'true')
    ,
    tb2 as ( select block_timestamp,
    purchaser as buyer,
    tx_id,
    mint_price,
    MINT
    from solana.nft.fact_nft_mints
    where tx_id in (select tx_id from tb1)
    and program_id = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'
    and succeeded = 'true' )
    ,
    tb3 as (select a.value as ti,
    tx_id,
    REPLACE(value, 'Program log: Minting Solmap #')::string as solmap
    from solana.core.fact_transactions , lateral flatten(input => LOG_MESSAGES) a
    where tx_id in (select tx_id from tb1)
    and block_timestamp::date >= '2023-12-20'
    and a.value ilike '%Program log: Minting Solmap #%')
    ,
    tb4 as ( select block_timestamp,
    buyer,
    mint_price,
    a.MINT,
    a.tx_id,
    solmap
    from tb2 a join tb3 b on a.tx_id = b.tx_id)
    ,
    tb5 as ( select a.block_timestamp,
    buyer,
    b.MINT,
    mint_price,
    Last run: about 1 year ago
    SALES
    NFTS
    BUYERS
    SELLERS
    SALES_AMOUNTS
    AVG_PRICE
    MIN_PRICE
    MAX_PRICE
    MEDIAN_PRICE
    1
    9036691717263426030672400270.8371995480.44293965730.00203928216.37750.44751428
    1
    90B
    263s