CryptoCatalyst[WeBump collection] Total
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
›
⌄
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_seiyans_raw_sales AS (
SELECT
livequery.live.udf_api (
-- 'https://api.dune.com/api/v1/query/3369695/results?api_key={mzn1}',
-- 'DUNE'
'https://flipsidecrypto.xyz/api/v1/queries/35b62be9-e632-42eb-a7c6-57efe4997c32/data/latest'
) AS response
)
,
raw_dagora_NFT_sales as (
SELECT
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/e42a9a8c-e7d3-475c-94ac-f658ba4b9ed3/data/latest'
) AS response
)
,
pallet_seiyans_sales as (
select
t.value:"DATE"::date date,
t.value:"SELLER"::string seller,
t.value:"BUYER"::string buyer ,
t.value:"TX_ID"::string tx_id,
t.value:"NFT_ID"::string NFT_ID,
t.value:"SALE_PRICE"::float SALE_PRICE
from
pallet_seiyans_raw_sales ,
-- table(FLATTEN(parse_json(response:data:"result":"rows"))) t
table(FLATTEN(parse_json(response:data))) t
)
Run a query to Download Data