StangFAST012 - buy volume
    Updated 2023-11-03

    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