ArioOrdinal sales by marketplace in USD
Updated 2024-10-08
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 okx_hist as (
select
f.value:DATE::timestamp as DATE,
f.value:MARKETPLACE::string as MARKETPLACE,
f.value:N_SALES::int as N_SALES,
f.value:N_SELLERS::int as N_SELLERS,
f.value:SALES_VOLUME::float as SALES_VOLUME,
f.value:SALES_VOLUME_USD::float as SALES_VOLUME_USD
from (
select
livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/8b053f8c-bed9-48fb-bb57-1576b7f83276/data/latest'
):data as resp
) resp,
lateral flatten (input => resp) f
),
ordinalmarket_hist as (
select
f.value:DATE::timestamp as DATE,
f.value:MARKETPLACE::string as MARKETPLACE,
f.value:N_SALES::int as N_SALES,
f.value:N_SELLERS::int as N_SELLERS,
f.value:SALES_VOLUME::float as SALES_VOLUME,
f.value:SALES_VOLUME_USD::float as SALES_VOLUME_USD
from (
select
livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/71af15c4-ebed-487f-ab28-e5cc583c6f7b/data/latest'
):data as resp
) resp,
lateral flatten (input => resp) f
),
unisat_hist as (
select
f.value:DATE::timestamp as DATE,
f.value:MARKETPLACE::string as MARKETPLACE,
QueryRunArchived: QueryRun has been archived