zakkisyedTotal Encashed Amount by Party
    Updated 2024-04-03
    WITH res1 AS (
    SELECT
    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    {'Content-Type': 'application/json'},
    {
    'sheets_id': '1YfgsP2UGAkeq3GOFVNvjOkI0o3sSog37LpXlX7hZWa0',
    'tab_name': 'Sheet4'
    }
    ) AS result
    FROM DUAL
    ),

    res2 AS (
    SELECT
    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    {'Content-Type': 'application/json'},
    {
    'sheets_id': '1YfgsP2UGAkeq3GOFVNvjOkI0o3sSog37LpXlX7hZWa0',
    'tab_name': 'Sheet5'
    }
    ) AS result
    FROM DUAL
    ),
    data AS (
    SELECT result:data AS json_result_must_pivot FROM res1
    UNION ALL
    SELECT result:data AS json_result_must_pivot FROM res2
    )
    ,
    final_eci_data AS (
    SELECT
    -- TO_DATE(d.value:"date_of_purchase"::VARCHAR, 'DD-MM-YYYY') AS "Date of Purchase",
    QueryRunArchived: QueryRun has been archived