NUM_SALES | NUM_PURCHASERS | NUM_SELLERS | TRADED_NFTS | VOLUME | VOLUME_USD | |
|---|---|---|---|---|---|---|
1 | 7573 | 2182 | 3733 | 4245 | 5130320.042472 | 2766204.28444316 |
saeedmzn[Colony NFT collection] Total transactions
Updated 2024-02-21
99
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
›
⌄
WITH
raw_prices AS (
SELECT
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/2c2ebd8f-fa1d-4328-bf69-cf0f793dcf03/data/latest'
) AS response
),
pallet_colony_raw_sales AS (
SELECT
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/82e6f61a-f5d7-4d84-a33e-6356641375a3/data/latest'
) AS response
)
,
pallet_colony_sales as (
select t.value:"DATE"::date date ,
t.value:"TX_ID"::string TX_ID,
t.value :"SALE_PRICE"::float SALE_PRICE ,
t.value:"NFT_ID"::string NFT_ID,
t.value:"BUYER"::string BUYER,
t.value:"SELLER"::string SELLER
from
pallet_colony_raw_sales ,
table(FLATTEN(parse_json(response:data))) t
),
raw_dagora_NFT_sales as (
SELECT
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/8edd7210-5075-4b9a-9baf-5e736a8dfa92/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,
Last run: about 1 year ago
1
55B
4s