imjosh-KH0MAeOverview of Top 1000 Hoders
    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
    USERS
    HOLD_SOLMAPS
    Buy Count
    Mint Count
    Sell Count
    ||
    Total Spent Sol
    Buy Amount
    Mint Amount
    Sell Amount
    |||
    Avg Buy Amount
    Avg Mint Amount (including Fees)
    Avg Sell Amount
    1
    6hJmrYLAFDhYnUavUfBvK9Jeu4n666h9yhL6NLkQCnXn1782816996353026987467.4889602497237.448292229230.040668021358.1178697850.42583244840.065167328050.5033794921
    2
    FaTo9y3XS2aoF3CabEVvvNRyv85UFpESUyJcDftvGeWq1282512855291829485608.0046172215417.848775993190.1558412281070.312592540.42145848120.065166498020.363063973
    3
    BTj94TTK2vJYMqY6BKC4PGDKtgNayyPd6EJCzYfiNoCE11301102731118904253.7985810464199.57028144654.228299648.3456114240.40879687350.048504740250.5371734603
    4
    GmShKpyTNPZmchKAFyweBEbMuSE62vewMzbFbvb2bQL594959712124514624164.0061623794103.55165139560.454510984687.9639098070.42252385210.048557840150.4705635498
    5
    BTMFkhjUzCGzMSX9dApB61oLM8Gx1uGXeY9jraH2eCZp91769119177417173838.3541322553752.05619554586.29793671481.1197400990.41145478620.048645962070.2802095167
    6
    GeZRE9KeVLyibNQsHzaGqNmMwEpi64NQ1EsMQXb29nCn76617631161015803208.1806658923103.257918432104.92274746468.3423036970.40666464660.065169408360.2964191796
    7
    DJSJzn3MsgYmtm7Wb94jTeDBnAKVgTcEtswynshpxAKW6363566312615612835.9316856612753.75310503582.178580626334.2965781580.48627107630.065169374010.5958940787
    8
    81dtoYmzsqFaCavu7KZwojMCERce18xPCQJXs71fMVu58415891131313632434.7003375692349.12978255185.570555018294.2514025010.39876587720.0651717860.2158851082
    9
    B6oKsU4awj3QGT7mmQHoAiJtY3f7oA2XjGQSxGuVxrSh5601499310684602071.8982853762002.29616816869.602117208153.7493065420.40102066260.065170521730.3342376229
    10
    E31DYaPx7uo1MVuYvJZTmXbywK9X2pLYbkxtcXXCzPMs56005538113210702351.1939861512296.28619031154.90779584353.4074910.41464178230.048505120.3302873748
    11
    map5xuS91f5Jwkm5rGzGT7mb1DC1QWzr1A8C2uWEfhd519913664152319989.546457012718.9600293270.586427712230.8759066990.52632505810.065170141550.7237489238
    12
    5nDpPTHSgwuBMrzRr56x11D2MwirbVQXJFw4yvBo22fi477840738991941963.8062760221905.22319488858.583081134146.242523560.46776901420.065164717610.753827441
    13
    599f4ud8uKy8y64FAy5bw1xbMqxCppzpwYws2UZMo8XN477748017778012069.2946721962018.65729415450.637378042279.3693122610.42046600590.065170370710.3487756707
    14
    AtQGAZJuHLsXqV6j6F8ERXBVCPykcnB5BMk875GJxU19459145949929952102.7022846692054.58520562948.11707904480.3138483020.44723230420.048505120.4827274857
    15
    DjfCwA7e8ytdnuRAqbEuoRcmp65NjjXzRShGpRypmQcK409342003935001721.5287976431695.91892358525.60987405867.4319007630.40379021990.065165073940.1348638015
    16
    Gh9eD8chfPp63Tgcwe3g6A91WDHbU2afH66hVD1T8jA9395939694874971629.6282698991597.89299963731.73527026263.23073870.40259334840.0651648260.1272248264
    17
    HYrRDYMSUCdcQ9z4i37wdiGcZg2iybYtSebaxzndqaRP3895491070717222208.2872193852162.21192204346.075297342294.1346410130.44036902690.065170151830.1708098961
    18
    3r63NNWqDmZ8S9tC1cAptbMPNVbV5zwvKLUhZCfU75i9380038268889141680.1689524751622.30228074757.866671728563.5866784330.42402046020.065165170860.6166156219
    19
    13ZHdc3p9T59awb6knegwjzaPp7n4QzJW4oP5sykPMD1371537203223271559.9225190921544.30513717215.61738192168.6297281840.41513578960.048501186090.5156872422
    20
    7FgUZLW16k7HNnLatbKpAvuyqXdgt8rz2Xrh64yvMiWc34142967477301343.6353212071320.49837896723.136942247.993050.44506180620.048505120.266435
    ...
    1000
    156KB
    381s