zpencerNFT Volume
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
›
⌄
with historic_nft AS (
select
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/5f592665-9640-409e-9aee-bf83bc4a27c1/data/latest'
):data as json_data
),
-- is there a way to not have to know the columns?
nft_data AS (
SELECT
d.value:"CHAIN"::VARCHAR AS chain,
d.value:"DAY_"::date AS day_,
TO_NUMBER(d.value:"N_NFT_SALES_TX") AS N_NFT_SALES_TX,
TO_NUMBER(d.value:"NFT Sales Volume (USD)") AS "NFT Sales Volume (USD)",
TO_NUMBER(d.value:"USD_PLATFORM_PLUS_CREATOR_FEES") AS USD_PLATFORM_PLUS_CREATOR_FEES,
TO_NUMBER(d.value:"USD_PLATFORM_FEES") AS USD_PLATFORM_FEES,
TO_NUMBER(d.value:"USD_CREATOR_FEES") AS USD_CREATOR_FEES,
TO_NUMBER(d.value:"N_UNIQUE_SELLERS") AS N_UNIQUE_SELLERS,
TO_NUMBER(d.value:"N_UNIQUE_BUYERS") AS N_UNIQUE_BUYERS,
TO_NUMBER(d.value:"N_PROJECTS_WITH_SALES") AS N_PROJECTS_WITH_SALES
FROM
historic_nft,
LATERAL FLATTEN(input => historic_nft.json_data::VARIANT) d
)
select * from nft_data
where day_ >= '{{min_date_daily}}'
and day_ <= '{{max_date_daily}}'
Run a query to Download Data