with 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 - 31 and block_timestamp::Date <= current_date - 1) , seller as ( select date(block_timestamp) as date, tx_id, msg_index, ATTRIBUTE_VALUE as seller from sei.core.fact_msg_attributes where tx_id in (select tx_id from pallet) and ATTRIBUTE_KEY = 'nft_seller' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1) , nft_id as ( select date, a.tx_id, a.msg_index,seller, ATTRIBUTE_VALUE as token_id from sei.core.fact_msg_attributes a join seller b on a.tx_id = b.tx_id and a.msg_index = b.msg_index where ATTRIBUTE_KEY = 'nft_token_id' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1) , collection as ( select date, a.tx_id, a.msg_index,seller, token_id, ATTRIBUTE_VALUE as collection_address from sei.core.fact_msg_attributes a join nft_id b on a.tx_id = b.tx_id and a.msg_index = b.msg_index where ATTRIBUTE_KEY = 'nft_address' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1) , price as ( select date, a.tx_id, a.msg_index,seller, token_id, collection_address, case when attribute_value ilike 'native:%' then substr(attribute_value, 13,24) else split(attribute_value, 'usei')[0] end as prices, prices/pow(10,6) as price from sei.core.fact_msg_attributes a join collection b on a.tx_id = b.tx_id and a.msg_index = b.msg_index where ATTRIBUTE_KEY = 'sale_price' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1) , buyer as ( select date, 'Pallet' as platform, a.tx_id, a.msg_index,seller, token_id, collection_address, price , ATTRIBUTE_VALUE as buyer from sei.core.fact_msg_attributes a join price b on a.tx_id = b.tx_id where ATTRIBUTE_KEY in ('fee_payer','sold_to') and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1 ) , pallet_bid as ( select date(block_timestamp) as date, tx_id, ATTRIBUTE_VALUE as buyer from sei.core.fact_msg_attributes where ATTRIBUTE_KEY = 'sold_to' and msg_type = 'wasm-accept_bid' and block_timestamp::Date >= current_date - 31 and block_timestamp::Date <= current_date - 1 and tx_id in (select tx_id from pallet) ) , pallet_bid_seller as ( select date, a.tx_id, buyer,ATTRIBUTE_VALUE as seller from sei.core.fact_msg_attributes a join pallet_bid b on a.tx_id = b.tx_id where ATTRIBUTE_KEY = 'fee_payer' and msg_type = 'tx' and block_timestamp::Date >= current_date - 31 and block_timestamp::Date <= current_date - 1 ) , pallet_bid_collection as ( select date, a.tx_id, buyer, seller, ATTRIBUTE_VALUE as collection_address from sei.core.fact_msg_attributes a join pallet_bid_seller b on a.tx_id = b.tx_id where ATTRIBUTE_KEY = 'nft_address' and msg_type = 'wasm-accept_bid' and block_timestamp::Date >= current_date - 31 and block_timestamp::Date <= current_date - 1) , pallet_bid_price as ( select date, a.tx_id, buyer, seller, collection_address, case when attribute_value ilike 'native:%' then substr(attribute_value, 13,24) else split(attribute_value, 'usei')[0] end as prices, prices/pow(10,6) as price from sei.core.fact_msg_attributes a join pallet_bid_collection b on a.tx_id = b.tx_id where ATTRIBUTE_KEY = 'sale_price' and msg_type = 'wasm-accept_bid' and block_timestamp::Date >= current_date - 31 and block_timestamp::Date <= current_date - 1 ) , pallet_bid_nft as ( select date, a.tx_id, buyer, seller, collection_address,price, ATTRIBUTE_VALUE as token_id from sei.core.fact_msg_attributes a join pallet_bid_price b on a.tx_id = b.tx_id where ATTRIBUTE_KEY = 'nft_token_id' and msg_type = 'wasm-accept_bid' and block_timestamp::Date >= current_date - 31 and block_timestamp::Date <= current_date - 1) , dagora as ( select DISTINCT tx_id from sei.core.fact_msg_attributes where attribute_value = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz' and tx_succeeded = 'true' and attribute_key = '_contract_address' and msg_type = 'wasm-execute-exchange' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1) , dagora_collection as ( select date(block_timestamp) as date, tx_id, MSG_GROUP, split(attribute_value,',')[0] as token_id , split(attribute_value,',')[1]::string as collection_address from sei.core.fact_msg_attributes where ATTRIBUTE_KEY = 'nft' and msg_type = 'wasm' and block_timestamp::Date >= current_date - 31 and block_timestamp::Date <= current_date - 1 and tx_id in (select tx_id from dagora)) , dagora_seller as ( select date,a.tx_id, a.msg_group , token_id, collection_address,ATTRIBUTE_VALUE as seller from sei.core.fact_msg_attributes a join dagora_collection b on a.tx_id = b.tx_id and a.msg_group = b.msg_group where attribute_key = 'seller' and msg_type = 'wasm-execute-exchange' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1 ) , dagora_buyer as ( select date,a.tx_id, b.msg_group , token_id, collection_address,seller , ATTRIBUTE_VALUE as buyer from sei.core.fact_msg_attributes a join dagora_seller b on a.tx_id = b.tx_id where attribute_key = 'fee_payer' and msg_type = 'tx' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1 ) , price_usd as (Select TO_TIMESTAMP(value[0]::string) as date, 'SEI' as token, value[1] as avg_price from ( SELECT livequery.live.udf_api( 'https://api.coingecko.com/api/v3/coins/sei-network/market_chart?vs_currency=usd&days=90&interval=daily&precision=3') as resp ) ,LATERAL FLATTEN (input => resp:data:prices) ) , fnl_dagora as ( select b.date,collection_address, 'Dagora' as platform, a.tx_id , seller, buyer,ATTRIBUTE_VALUE/pow(10,6) as price from sei.core.fact_msg_attributes a join dagora_buyer b on a.tx_id = b.tx_id and a.msg_group = b.msg_group where ATTRIBUTE_KEY = 'amount' and msg_type = 'wasm-execute-exchange' and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1 ) , fnl_pallet as (select date,collection_address, platform, tx_id, seller, buyer, price from buyer UNION select date,collection_address, 'Pallet' as platform, tx_id, seller , buyer, price from pallet_bid_price ) , volume_usd_pallet as ( select a.date,collection_address, platform, tx_id, seller, buyer, price, price*avg_price as price_usd from fnl_pallet a join price_USD b on a.date = b.date ) , volume_usd_dagora as ( select a.date,collection_address, platform, tx_id, seller, buyer, price, price*avg_price as price_usd from fnl_dagora a join price_USD b on a.date = b.date ) , fnial_1 as (select collection_address as collection, platform, date, count(DISTINCT(tx_id)) as transactions, count(*) as sales, count(DISTINCT(buyer)) as buyers, count(DISTINCT(seller)) as sellers, sum(price) as Volume_sei, sum(price_usd) as Volume_usd, avg(price) as Avg_Price_sei, max(price) as max_price_sei, avg(price_usd) as Avg_Price_usd, max(price_usd) as max_price_usd from volume_usd_dagora group by 1,2,3 UNION select collection_address as collection, platform, date, count(DISTINCT(tx_id)) as transactions, count(*) as sales, count(DISTINCT(buyer)) as buyers, count(DISTINCT(seller)) as sellers, sum(price) as Volume_sei, sum(price_usd) as Volume_usd, avg(price) as Avg_Price_sei, max(price) as max_price_sei, avg(price_usd) as Avg_Price_usd, max(price_usd) as max_price_usd from volume_usd_pallet group by 1,2,3) select case when collection ilike '%sei1rhx6r2q63t37yfsymzq9esx784lm2esskm7ny6j7j208xvpghzesp20vz2%' then 'RoverSeals' when collection ilike '%sei13zrt6ts27fd7rl3hfha7t63udghm0d904ds68h5wsvkkx5md9jqqkd7z5j%' then 'Dob' when collection ilike '%sei1za9z9l8pwueataj5gx7mwt8g5zrndhjls7yr6tnhan0zlgw2r8fszn5089%' then 'Seiyan by Cult' when collection ilike '%sei1aj6t3eyus0vc5w7f4dnr84tk7g5xwrxfughvl0rfjljjs90rtklqlmz966%' then 'Sei Shiba' when collection ilike '%sei172r2cah7m898qj86epfe2wtvvkkgq5h408jz08h0ny26rj5zjs5qkch29k%' then 'Sei Rocks' when collection ilike '%sei1msmdzdn92aele5878x905h780l2ura0scppt74mkupmeyxk2zdds7e6swx%' then 'Sei Spritis' when collection ilike '%sei1pe3x3dpvq7gl9xl332t0pws0yej9xvp5f280r3sg0mlfqcrhrkfsavf072%' then 'Sei Ducks' when collection ilike '%sei1za9z9l8pwueataj5gx7mwt8g5zrndhjls7yr6tnhan0zlgw2r8fszn5089%' then 'Seiyan by Cult' when collection ilike '%sei1va06zjmjyjrhmqnepznt6z94hnd2dssj489rh4pggv5uaxphzc0qyhec5c%' then 'Sei Punks' when collection ilike '%sei1d8hvqelcqf5qec3p5tqckagduqdgel6krfl50mdp33wl452tfjwsqnj2dj%' then 'Rug Duck Association' when collection ilike '%sei1dk4tyuffcgsscuwtg6hna97rhlngwe2gwl92mhfjgtseymnqjm6qr5jqlf%' then 'Kweck' when collection ilike '%sei18jvwmxdrymavyftqhexzypr7gv5vruf44mj9r06094nzc7x96l2skfkpww%' then 'Seinsei' when collection ilike '%sei1np5ls7wmptvy2dd5tjldywlt0wwtfhptw76xlyjhqwsv7sj6rq0s90jhqf%' then 'Sei Portals' when collection ilike '%sei1skh49xnyqc3gz2gq8jq2ycqjg9dc4klvzq9sxs4dkgdynndfsc4q46pavk%' then 'Cool Cows' when collection ilike '%sei1pxldvejk2q57yhxh2hck450gvddwhv5fcdchu7ys8xv33ywkcvpsftur73%' then 'Seiguins' when collection ilike '%sei1swh8dxdpntgdj3z0mv6z030fjy80t484pkf9ce8veascfljynkjs3na2xs%' then 'SuperTusks' when collection ilike '%sei1jrkssr4pyc0tsqt0y7340lwv0awnnus9rhjgnaj2vcd8a4rt2m3q3txd3x%' then 'Sei Stoics' when collection ilike '%sei1p5l7yc3ur779uqagp9wnfqpp0wpz3d4ju94hqx63sngqk3xfsstsr7scyr%' then 'SeiDoges' when collection ilike '%sei1pcwel0zepeervrhtgecs3kln2me2k3qd64spm2vy5wg8z865e4uq6v5x75%' then 'Seipal' when collection ilike '%sei1t37a3zz329n58mw58jjh4qm3n8w38cu2s2wcre9dshy0h39hh3ysrv39ys%' then 'Seiguls' when collection ilike '%sei1gccj8zy7xxntk9qgmw6wtsfv03dc0q6xz3ls4rncsysl3evtr8xs3ayzag%' then 'Sei Dragons' when collection ilike '%sei188meek4al2mnk3y0jf07p9pwnrfcq4q4cnpz24wl8wcg7lhrtnrq6grecc%' then 'XPX' when collection ilike '%sei1l4jgfuzxa6yu4sj6yxkc4fkt4a944t35zse8szw9394p44njdzlqvde5g5%' then 'Seinosaurz' when collection ilike '%sei1s99j23ctng8jwm7uhrdtyr8vhn9mglcm0mgnxf84hxt32mkzwmgsdctsc8%' then 'NodeSpei' when collection ilike '%sei1gukfj2re9fsuhh3may8hl5sjjr7mk36edjkprqty6l35f2f07d7qgfk5dt%' then 'Seingus' when collection ilike '%sei1ahxexdnrlxhjt53vcav7ktq6ygmwm8aqf5mskjdzdcauqtnn0jsqhtu95a%' then 'Daring Dragonz' when collection ilike '%sei1a9xzhtynlcu84jcwm0qdl82aqteqplpvuyme9vssawptk33rvzrqrvwcll%' then 'SEI MFers' when collection ilike '%sei1jrx0x4vac9s055l8ngzuu7lfpenyua590r7n4ckhxvfzq2n5d2hse7lxvv%' then 'Sei Stoics' when collection ilike '%sei1mfjy3lzavtpq040fspacanyh56skju09xg8k0fa5vjnz3pac6wfsh7nala%' then 'SeiPirates' when collection ilike '%sei1lar5nkq0yektynmnx3x32yeqnqav0ms2rlv3v0xlypac9ntr78wq5drd5j%' then 'SEI9:Terradragons (テラドラゴンズ)' when collection ilike '%sei1nqux82dgsyx0uv6qfhgmxvrfv2rrg3c34c3t3n4w5zqttfq7j6fq2a7zhc%' then 'Nuit' when collection ilike '%sei16zt75829qyqx26smgcp4qktsqdkhhfqd6v0mwd43xl7ytyw5fsnqycf70u%' then 'Sei Marines Club' when collection ilike '%sei127gddn5l4ytmx9kj9sm5h7nuedqpnkxsstc0zjc2cp3jf9we69ssh7rpgu%' then 'SEI9' when collection ilike '%sei1vjgrptlrm0alx330lv6260kzewv7p8elpputvedd45sxrtel2v5qzkrcd7%' then 'Seiber Punks' when collection ilike '%sei1guxe769z6jyrcegempsfsz0m0y7hytf8jhpju7platkvrjzj98qshpfp2a%' then 'Elon' when collection ilike '%sei1lkg8hvz90ems00mv9k08nqg62nmwey00zcvl7trz40mklqr906zsftkx0x%' then 'Pussei' when collection ilike '%sei1yxhhuwslqa29rxfhznnlqp9ghcgh2m9m7jj3arfa9vnkn7vnef6syvpa95%' then 'SeiHorses' when collection ilike '%sei1sr6u2403g2vw5c8442wzhz00td80q5peedghay7nxcgcccckempq80pxz7%' then 'Sei Bears Club' when collection ilike '%sei1r7ewelcex725l6s95c2t69l537q28rrdrp0je4vscu6v4vuf6tzqa4e5k5%' then 'GHOST Sei' when collection ilike '%sei1dpzeuax45trx65wzpe3f3crzllkcqgg7egm44v2j9u03x8uceuts74my9k%' then 'SEI DOOBLES' when collection ilike '%sei10yavj7nwgw6s0526kh7frdgn3zxzpqhxd6jaxl4vw82m2t2r5tqsrp226h%' then 'Sei Ape Society' when collection ilike '%sei1xt4lzvat0327uzrmunue3wsgzhy55dxply48065t5sm0w7r9v0vqdsuftl%' then 'SeiChimps' when collection ilike '%sei1608l2r87r3ygcankltapxyrs8d56s5nwg53k85h03fw33m7jvrrs8c4ude%' then 'Sei Boyz' when collection ilike '%sei1uxgha254cxjhax3gsuswgmtupsj35k9yxcqspkayfcvc4s6jxh0qjukyn2%' then 'Gods on SEI' when collection ilike '%sei1lnpr4t8f87z0vjl5whx0nz9lv6qfctamunuh2x2vet4tsmcmsqvs6jumh2%' then 'Chromatic Nautiluses' when collection ilike '%sei1c9lg7md543g7w9hms4kpa7a0ddhm3g0zz3jr5gejcw3sql5f6jjsxuqwux%' then 'Sei Pepes' when collection ilike '%sei1ju908r9qmndk2jffep5tfsf0khjxgejc6qmnpuw8mh3q7d38c6ss57xdwh%' then '8-Bit' when collection ilike '%sei1xtacm5jrw3kg49x4mq5g0netlparkyqjwp28dzng3whhjqjnd3gqht8zn0%' then 'Sei Chicks' when collection ilike '%sei1jewcn3thnuseywl8p5apegsux8xm6xz74wudlnkn7tdt0x5gle0qf2q65p%' then 'Sei Puppets' when collection ilike '%sei1h2du4zvs7y53r0wv80fg7rxnvxz2y7ek20ecq8degfwl8zp0a48qyld5r7%' then 'Path to Sei Mainnet: Eclipse Fi' when collection ilike '%sei1x78waragdjepmfmz7s3ppqzn0lrves4g2qa0h2ualyl2krcrhqfqfhpnt2%' then 'SEI DOOBLES' when collection ilike '%sei1ddzwh4u8aqcrvs9tt95ecrzpdmpypjpmxzmw0fxjp864wj6vy65q6654tj%' then 'Seᶦ Gnᵒmₑs' when collection ilike '%sei1832l37vacma0nd3a88qummzmyq59w9a43ytsptyn40drjp05ts6qyraj97%' then 'Wen Pallet?' when collection ilike '%sei19lsam8qjj3jacfhsuqnn7zsc9326uje8qp96neukhaxyjtk3pkhs366058%' then 'Sailors' when collection ilike '%sei13wx26urrrh0pp0fjues2gawxzq2hdmgqt8cmqvr3f4d058f4jd8sfwrtlh%' then 'Seimyname' when collection ilike '%sei1zn8vezzrzr59lt9zsfe9hup4z4f67ke0w3fwc4vtf5rjd794z2wsmcv836%' then 'Amphora: Sei' when collection ilike '%sei1pkteljh83a83gmazcvam474f7dwt9wzcyqcf5puxvqqs6jcx8nnq2y74lu%' then 'The Colony' when collection ilike '%sei1kk00dtyzgqc8t2slcu9sra2gxqlruvk8nc8x96xzrnuvd4ne2mjqskj3nw%' then 'Yolee Universe' when collection ilike '%sei1v90ly54qeu7497lzk2mnmp2h29sgtep8hs5ryvfqf8dwq5gc0t9srp6aey%' then 'WeBump' when collection ilike '%sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc%' then 'Seiyans' when collection ilike '%sei1cc0qgdxgstsjfnsz0u2at4flr93f0ux43u8lj770ft4dxfqvc6yqkvv289%' then 'Duck Club' when collection ilike '%sei18ddlx5jsqhugd8g3qd5h5l5xdzc00rhvk8khvrvlyrm4x4r2g4vsfs3ckf%' then 'Akira' when collection ilike '%sei155kpekevm59yg8kaj0wufzpma6s78q6l0y9nnlnqu6lxmglskw7ss0zh9x%' then 'ShipMunk' when collection ilike '%sei12ne7qtmdwd0j03t9t5es8md66wq4e5xg9neladrsag8fx3y89rcs5m2xaj%' then 'Mint By Users' when collection ilike '%sei1tepe8yu2jsgy5rttrs6zd7m37whes8ch8d3cz2k2mj55ula29ktqm0dery%' then 'Discordels' when collection ilike '%sei1laa7n0hrkmjlq0famtthzhghcp637jp0qk0793c007wehp7vxw3syupjzw%' then 'Sei Seals' when collection ilike '%sei14wu660wh5dnmw8j0d5v0qqmfw4hu7u95ewpm6ydy7ffpm7am66lqr8k0fr%' then 'Path to Sei Mainnet: Fin Wallet' when collection ilike '%sei1xpxtdzcqh5dug3xdncmrw8lf8k7q37qly8s68g9prt5k2tsz8xwq5x67fm%' then 'ObtgonSei' when collection ilike '%sei1y7dzt3uf4fk7vc54kt6ntjyggefsk45pnfj09rdyyrar28yh5axq5leavl%' then 'Sei Mainnet Commemorative NFT' when collection ilike '%sei1c56q465aeenfxykhaj8vt7vhhqtmhyn0ntvercdsge288xsdcjlq9xh8wx%' then 'Space id Names' when collection ilike '%sei1wfl480fuwa68yhdzapunsvqmmyuz8ckzz06jgy7h6t7las742qjstw7gs6%' then 'Seitopia' when collection ilike '%sei1atcfjjz779ynmlek4tqh47ssrwge0mhlauyr637wdjkrhtfqdjqqtlcwhl%' then 'Seimurai' when collection ilike '%sei19kfsr9zft0k9awelwwv9k87mrgwf358tfqw9tv30rlvwn8rn5kzq00hnup%' then 'The Seinos' when collection ilike '%sei10pptpnk2eunulssekauc4yfxt6z4kj4xr0smytz8hh93cr8xxp4q56895h%' then 'SeiQuest' when collection ilike '%sei15w6sty6cjjraxanrxxx0y09adwjtywhkcmydh7np25zezg9m5mwsfduktd%' then 'SEI Subjects' when collection ilike '%sei1x50tc96nhw24aytsa4rlrf4un36j9ug5ualz3n320u5g5jd23gpqc4arta%' then 'Outlines' when collection ilike '%sei1ehtglm3vfz45jhycfl9jmvv5qa0pxlj6wfr0msye3y582fxt47ss4rdfw5%' then 'Sei Bots' when collection ilike '%sei1tce33460pf433yhn6k97hn554w09ulr37dfc0qrt5j6mzgdvuygs4s4uux%' then 'Seitizens' when collection ilike '%sei1shx8fp0w3v4z3jk2lxpkrmrzuydkz70dv0ru4wl53y857h8xc4cscsrdhx%' then 'Sei Monke' when collection ilike '%sei10d2s36g80sx2qg75p8c8ue2wpmlphy5tk0stfmc9u4tlv728s2ds6wphcj%' then 'Seimese Cats' when collection ilike '%sei1hgdx0728wscc6xwzle4lcl4cj2ktp2adjaxrchsal29w4pa055tqkzfa3s%' then 'Sei Chicks' when collection ilike '%sei16j8lfq4jz5njgqjzuqfgv8qay8y2qp7aj255np4m8t0u52vjz7tqzczl90%' then 'Goons On Sei' when collection ilike '%sei17kfxfdt8y3s0fup0aqscadwfjrwsky75nn4wyvzupqsgmuuv23hsah5c30%' then 'SEI Gods' when collection ilike '%sei1ma2r3lpv5x86d586vwcdwk0v8pp4r8rd6jafd55h5yl4g4mp42zq09skkd%' then 'KONGS' when collection ilike '%sei1u64thag5ltz7sjte7ggdd0k8wzr59p32vlswh89wswmz46relcqq6my5h6%' then 'Bulls on SEI' when collection ilike '%sei1807fz8fk6f6ucupkn4we6jpu6hwj3r6w97ua2de0zg9sszt26txs7savcq%' then 'Sei Ducks' when collection ilike '%sei1gn3lg0wfaxvwg2tmktkurs2h2uw6f5z06spwtdeg0eh0qde5uksslhfgcp%' then 'Sei Zero Gear' when collection ilike '%sei17axtvzlhk0d2cl8c5g4mqg6mz8nhlll84vz4zy96s4qt0stw9fqqm9zfhh%' then 'Froogz' when collection ilike '%sei1uv4s3r7akmtgemt3306kuu440l7a008xdvenu8n4my4ywckt2mrsvtqan8%' then 'Sei Ape Society' when collection ilike '%sei1zqfsuldyqyuezhdk9yuh2dnn84hykfv0amyezfy4ze50fxpswzas0zy9tm%' then 'Snazzy Society' when collection ilike '%sei1wzhrqprfpxagkrxz9fspmnrtc0fqusk5g6ynpezcl705sfqs55nqscej0k%' then 'Yaka Voyager' when collection ilike '%sei14mer99s65q95hams86z6rc4yjlsdgl2axul8k9g72qs0jfxf58hq0s7u4y%' then 'Seipes' when collection ilike '%sei1s45l507j760qj34w60rvgrtpcg2mln99tyw7ta9pw9azkt0eavdskszx2e%' then 'Seitoshis' when collection ilike '%sei15znfetuc2ghxjjjsetlh220wcj9v8tanlxy4my2ckkad3gpv25yqpxvhdj%' then 'Sei Avatars' when collection ilike '%sei1xe3yrsleumwks3sdqs7hqcnfn7usj0stqnnychhykl69r7290g4q92fyyt%' then 'SoulBot' when collection ilike '%sei1xh4ehttfsnjwt4dcx2kq3z0hdp5aky4pe0k0k975l3n740lala3szrqecv%' then 'MINTRS' when collection ilike '%sei1ezqkre4j3gkxlfhc23zv7w4nz8guwyczu70w650008dv3yscj2pqky7x7g%' then 'Astro Guys' when collection ilike '%sei1cnktx4rr8mlyr09hw3u4l8vrrpv6qtght3zcdpzhlf29fq2enluqlpndct%' then 'SeiMan' when collection ilike '%sei1dr8skknjpn58lnneqw6ahmnddzgl0veyteld0p73f6zzm52r38gs3e3mrd%' then 'REMOs WORLD' when collection ilike '%sei1swyv5jnxjgqrd2yckkan2lmzmklgm736tf6wfx7w7lv8msq90zuqgpr76m%' then 'WeBums' when collection ilike '%sei1xvqzftpyk8nyrhkkq2x70w59x2ml25c37tg668wphgp8upqya2tqdahh4a%' then 'Pandasticals' when collection ilike '%sei1dsvj7tsm9m9rkj7zdg5lle7clmkvwejpmuu7zqu0sut82kpf8axse286ps%' then 'seipenguins' when collection ilike '%sei130chx0wxkzela4s8urydadjkwrlwms22ad8jq7rcmsv2pme4mljq0sw998%' then 'Unfrgtn' when collection ilike '%sei1pkeufl65a66smy6gq09h4f9frz8f7pang8wyex43epaxr8sfp9jq4ccf44%' then 'Sei Cubz' when collection ilike '%sei1vpad5n0m6a0he83mcgp33uem43vst2nykp2nrzkmv57mkgm64a5qlf9ac3%' then 'Rabbit Project' when collection ilike '%sei1cujl8ujhc36lp7sr98x30u0aeqtjlj68kll5rqqr9dke5xvn2ltquzhysl%' then 'Cappys' when collection ilike '%sei1zjqml63xh7cfjxfe229v9c7krx05ytlz22y3cpf09wz83xck5q9qu73y03%' then 'ALIVE1111' when collection ilike '%sei13q4su7r3u9nm0e87ayf4a62qngtlxpn0umaskrrd5q3uxk4tkyls9rlsdx%' then 'The Burrow"' when collection ilike '%sei1qutwpsek4yj24mugfsyr6ypklkavsqx02agefsd8402pckdy4gaqwmhcqd%' then 'e/acc' when collection ilike '%sei1nue0u4rdgmnav9rd87qaxtnhszq4yv7ecxg0wen5e365fjtnp6rqf5dg2u%' then 'Daydreams' when collection ilike '%sei1kstxm0mrswqw69qv2kzhascmjvqg5g3jdrtu4xrvq2qq5n0vrfesjhf2gr%' then 'PlayerX' when collection ilike '%sei1u2nd0rrqhmfpj64rqle8cnlh63nccym5tq4auqvn6ujhyh5ztunsdv8kxl%' then 'CryptoMonos' when collection ilike '%sei10u0d4x9vmy44gtrp434l2l6uqjjuhj27mcu7rsc8x27x3v8c3g3se7mg6d%' then 'Degen Pilots' when collection ilike '%sei1hyy3yc6mhv8l3smekcseswjv8urn9fpuwy9vgqkrs6hh8yr5e36sh2tmh2%' then 'SEI NOBODIES' when collection ilike '%sei1ttn65xfdugh92pewhfwvkn45fy8c7c3358gaf7a2gqkkm4yx6zjqe4n49q%' then 'PokemSeiNFT' when collection ilike '%sei1vtdhz5vqqa4v83e6n4g2w3228jptpf00md5a8zy8kev9uhmcdp6q723gwm%' then 'Seipphire' when collection ilike '%sei1auh2wqt263lqmj2ex362cmkyg8d3yg64jw5yv85h5c9vmn68w2tq29zk6k%' then 'Path to Sei Mainnet: SeaSwap' else collection end as collection_name, count(DISTINCT platform) as "Available Platforms", sum(transactions) as "Transactions", sum(sales) as "Sales", sum(buyers) as "Buyers", sum(sellers) as "Sellers", sum(volume_sei) as "Volume (SEI)", sum(volume_usd) as "Volume (USD)", avg(Avg_Price_sei) as "Avg Price (SEI)", avg(avg_price_usd) as "Avg Price (USD)", max(max_price_sei) as "Max Price (SEI)", max(max_price_usd) as "Max Price (USD)" from fnial_1 group by 1 order by 4 desc limit 8

Sei: NFTs (30D)