StangFAST012 - buy volume
Updated 2023-11-03
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
final AS
(
SELECT
a.value:"DT"::date AS dt
, a.value:"TX"::string AS tx
, a.value:"CL"::string AS cl
, a.value:"AC"::string AS ac
, a.value:"MK"::string AS mk
, a.value:"BU"::string AS bu
, a.value:"SE"::string AS se
, a.value:"AM"::string AS am
, a.value:"FE"::string AS fe
, a.value:"PR"::string AS pr
FROM
(
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/fe783fc3-e585-48fa-ac27-588929a9e6ec/data/latest' ):"data" AS data
) live
JOIN
lateral flatten ( input => live.data ) a
)
,
conclus AS
(
SELECT
a.bu AS "buyer"
, sum( ( a.am / power( 10 , 6 ) ) * a.pr ) AS "buy volume"
FROM
final a
GROUP BY 1
Run a query to Download Data