TX | Sales | Buyers | Sellers | Volume (SEI) | Volume (USD) | Avg Price (SEI) | Avg Price (USD) | Max Price (SEI) | Max Price (USD) | |
---|---|---|---|---|---|---|---|---|---|---|
1 | 126764 | 157675 | 22019 | 41516 | 16712115.332915 | 11248912.3081112 | 98.584568628 | 65.51441576 | 10000 | 6990 |
SandeshTotal Numbers copy
Updated 2024-01-24Copy Reference Fork
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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
1
98B
234s