[Dagora marketplace] Top 10 collections by number of trades

saeedmzn[Dagora marketplace] Top 10 collections by number of trades

Updated 2024-02-10

WITH

raw_prices AS (

SELECT

livequery.live.udf_api (

'https://flipsidecrypto.xyz/api/v1/queries/2c2ebd8f-fa1d-4328-bf69-cf0f793dcf03/data/latest'

) AS response

raw_NFT_sales as (

SELECT

livequery.live.udf_api (

'https://flipsidecrypto.xyz/api/v1/queries/95a6cfb2-e8b4-4681-b105-8a59ae47c8df/data/latest'

) AS response

sei_price as (

select

date_trunc(day,t.value:"DATE"::date)::date date ,

t.value :"PRICE"::float price ,

t.value:"VOLUME"::number trading_volume,

t.value:"MCAP"::number mcap

from

raw_prices ,

table(FLATTEN(parse_json(response:data))) t

-- NFT_sales as (

-- select date_trunc(day,t.value:"DATE"::date)::date date ,

-- t.value:"TX_ID"::string TX_ID,

-- t.value :"SALE_PRICE"::float SALE_PRICE ,

-- t.value:"NFT_COLLECTION"::string NFT_collection,

-- t.value:"BUYER"::string BUYER,

-- t.value:"SELLER"::string SELLER

-- from

-- raw_NFT_sales ,

-- table(FLATTEN(parse_json(response:data))) t

-- )

-- ,

Last run: about 1 year ago

	COLLECTION_NAME	NUM_TRADES
1	Seiyans	2613
2	Duck Club	1698
3	SeiPunks	1544
4	Seimyname	1534
5	Sei Bears Club	1120
6	Seiguls	964
7	SeiChimps	961
8	SEI DUCKS	930
9	RoverSeals	781
10	Sei Shiba	769
11	Kweck	730
12	Akira	591
13	sei1za9z9l8pwueataj5gx7mwt8g5zrndhjls7yr6tnhan0zlgw2r8fszn5089	580
14	Pussei	567
15	sei1s99j23ctng8jwm7uhrdtyr8vhn9mglcm0mgnxf84hxt32mkzwmgsdctsc8	539
16	sei1np5ls7wmptvy2dd5tjldywlt0wwtfhptw76xlyjhqwsv7sj6rq0s90jhqf	518
17	sei1ttn65xfdugh92pewhfwvkn45fy8c7c3358gaf7a2gqkkm4yx6zjqe4n49q	461
18	sei1gn3lg0wfaxvwg2tmktkurs2h2uw6f5z06spwtdeg0eh0qde5uksslhfgcp	443
19	sei1yxhhuwslqa29rxfhznnlqp9ghcgh2m9m7jj3arfa9vnkn7vnef6syvpa95	414
20	sei1xtacm5jrw3kg49x4mq5g0netlparkyqjwp28dzng3whhjqjnd3gqht8zn0	412

...

193

12KB

146s