SandeshTotal Numbers copy
    Updated 2024-01-24
    -- forked from hess / Total Numbers @ https://flipsidecrypto.xyz/hess/q/6RN29tKpbh7o/total-numbers

    with dim_collection as ( select * from
    ( values ( 'RoverSeals', 'sei1rhx6r2q63t37yfsymzq9esx784lm2esskm7ny6j7j208xvpghzesp20vz2'),
    ( 'Sei Shiba', 'sei1aj6t3eyus0vc5w7f4dnr84tk7g5xwrxfughvl0rfjljjs90rtklqlmz966'),
    ('WeBump','sei1v90ly54qeu7497lzk2mnmp2h29sgtep8hs5ryvfqf8dwq5gc0t9srp6aey'),
    ('SEIYANS','sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc'),
    ( 'Seimyname', 'sei13wx26urrrh0pp0fjues2gawxzq2hdmgqt8cmqvr3f4d058f4jd8sfwrtlh'),
    ( 'Amphora: Sei', 'sei1zn8vezzrzr59lt9zsfe9hup4z4f67ke0w3fwc4vtf5rjd794z2wsmcv836'),
    ( 'Yolee Universe', 'sei1kk00dtyzgqc8t2slcu9sra2gxqlruvk8nc8x96xzrnuvd4ne2mjqskj3nw'),
    ( 'Duck Club', 'sei1cc0qgdxgstsjfnsz0u2at4flr93f0ux43u8lj770ft4dxfqvc6yqkvv289'),
    ( 'Akira', 'sei18ddlx5jsqhugd8g3qd5h5l5xdzc00rhvk8khvrvlyrm4x4r2g4vsfs3ckf'),
    ( 'ShipMunk', 'sei155kpekevm59yg8kaj0wufzpma6s78q6l0y9nnlnqu6lxmglskw7ss0zh9x'),
    ( 'Mint By Users', 'sei12ne7qtmdwd0j03t9t5es8md66wq4e5xg9neladrsag8fx3y89rcs5m2xaj'),
    ( 'Discordels', 'sei1tepe8yu2jsgy5rttrs6zd7m37whes8ch8d3cz2k2mj55ula29ktqm0dery'),
    ( 'Sei Seals', 'sei1laa7n0hrkmjlq0famtthzhghcp637jp0qk0793c007wehp7vxw3syupjzw'),
    ( 'Path to Sei Mainnet: Fin Wallet', 'sei14wu660wh5dnmw8j0d5v0qqmfw4hu7u95ewpm6ydy7ffpm7am66lqr8k0fr'),
    ( 'ObtgonSei', 'sei1xpxtdzcqh5dug3xdncmrw8lf8k7q37qly8s68g9prt5k2tsz8xwq5x67fm'),
    ( 'Sei Mainnet Commemorative NFT', 'sei1y7dzt3uf4fk7vc54kt6ntjyggefsk45pnfj09rdyyrar28yh5axq5leavl'),
    ( 'Path to Sei Mainnet: SeaSwap', 'sei1auh2wqt263lqmj2ex362cmkyg8d3yg64jw5yv85h5c9vmn68w2tq29zk6k'),
    ( 'Unknown', 'sei1alp24grk7e5f3msv0apk68hehspglpr7y7upfrvkpdfu7c84sqtqghqne9'),
    ( 'Yugo Sei', 'sei172eu5n5fhnpxysj8y23gkarkvwt4s8luxun35pmz6j7cn46ck75qepe70y'),
    ( 'Sailors', 'sei19lsam8qjj3jacfhsuqnn7zsc9326uje8qp96neukhaxyjtk3pkhs366058'),
    ( 'The Colony', 'sei1pkteljh83a83gmazcvam474f7dwt9wzcyqcf5puxvqqs6jcx8nnq2y74lu')
    ) as a (collection_name, collect))
    ,
    pallet as ( select DISTINCT tx_id,
    msg_type
    from sei.core.fact_msg_attributes
    where ATTRIBUTE_VALUE in ('sei152u2u0lqc27428cuf8dx48k8saua74m6nql5kgvsu4rfeqm547rsnhy4y9')
    and ATTRIBUTE_KEY = '_contract_address'
    and msg_type in ('wasm-buy_now','wasm-accept_bid')
    and TX_SUCCEEDED = 'true'
    and block_timestamp::date >= current_date - 30)
    ,
    seller as ( select date(block_timestamp) as date, tx_id, msg_index, ATTRIBUTE_VALUE as seller
    Last run: over 1 year ago
    TX
    Sales
    Buyers
    Sellers
    Volume (SEI)
    Volume (USD)
    Avg Price (SEI)
    Avg Price (USD)
    Max Price (SEI)
    Max Price (USD)
    1
    126764157675220194151616712115.33291511248912.308111298.58456862865.51441576100006990
    1
    98B
    234s