[Dagora marketplace] - Total

saeedmzn[Dagora marketplace] - Total

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

	NUM_TRADES	NUM_SELLERS	NUM_PURCHASERS	VOLUME	VOLUME_USD	NUM_NFTS	AVG_VOLUME	MED_VOLUME	MIN_VOLUME	MAX_VOLUME
1	31347	9937	6470	2586306.134573	1525572.63029977	193	48.667260991	7.741866646	0.00003226899064	2503.235603109

112B

188s