Send feedback
Stock Price Table as JSON
Stay organized with collections
Save and categorize content based on your preferences.
Generate key information from a stock data table and return as JSON
You can query a model directly and test the results returned when using
different parameter values with the Cloud console, or by calling the
Vertex AI API directly.
Context:
| Date | Open price | Close price |
|------------|------------|-------------|
| 2024-01-04 | 19.97 | 19.05 |
| 2024-01-05 | 19.08 | 19.54 |
| 2024-01-06 | 19.60 | 20.51 |
| 2024-01-07 | 20.69 | 20.56 |
| 2024-01-08 | 20.61 | 20.05 |
Query:
Extract the date, open price, and close price into a JSON array, with one entry for each day.
Also print the "highest_close_price_date" and "lowest_close_price_date" in the last part of the JSON array.
Response
[
{
"da te ": "2024-01-04 ",
"ope n _price ": 19.97 ,
"close_price ": 19.05
},
{
"da te ": "2024-01-05 ",
"ope n _price ": 19.08 ,
"close_price ": 19.54
},
{
"da te ": "2024-01-06 ",
"ope n _price ": 19.60 ,
"close_price ": 20.51
},
{
"da te ": "2024-01-07 ",
"ope n _price ": 20.69 ,
"close_price ": 20.56
},
{
"da te ": "2024-01-08 ",
"ope n _price ": 20.61 ,
"close_price ": 20.05
},
{
"highes t _close_price_da te ": "2024-01-07 ",
"lowes t _close_price_da te ": "2024-01-04 "
}
]
Model:
gemini-1.5-flash-001
Temperature:
1
Max output tokens:
8192
TopK:
40
TopP:
0.95
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-10-03 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-10-03 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-10-03 UTC."]]