NOTE<\/strong>: The tool developed in this series is for illustrative purposes only and doesn’t guarantee real-time trading prices. Its primary <\/strong>focus lies in showcasing the potential of AI-driven data analysis techniques, not providing actionable trading advice.<\/p>\n\n\n\n Before you begin, you will need to set up the following:<\/p>\n\n\n\n In this section, we guide you through establishing your data groundwork. You will create a Note<\/strong>: TiDB Serverless does not have a password by default. You must click the Generate Password<\/strong> button to create a new one.<\/em><\/p>\n\n\n\n The above command creates the In this step, we’ll set up a Data App within TiDB Cloud Data Service. A Data App acts as a framework for organizing your backend services, enabling the generation of REST endpoints to interact efficiently with your imported cryptocurrency data. <\/p>\n\n\n\n To create a Data App:<\/p>\n\n\n\n A Getting Started with Data Service tutorial will pop up for first-time users. However, for this tutorial, we\u2019ll ignore it and proceed to detail how to manually create the endpoints for your app. <\/p>\n\n\n\n This section guides you through setting up the required HTTPS GET<\/strong> endpoints. We recommend exploring our previous blog post \u2013 Mastering TiDB Cloud Data Service<\/a> \u2013 for enthusiasts eager to dive deeper into endpoint creation and management. <\/p>\n\n\n\n The The Integrating Endpoints with GPTs requires API documentation in JSON or YAML format and an encoded API key to access the endpoints.<\/p>\n\n\n\n TCDS provides a configuration tile within the Data App home page to access GPT’s integration-related information. To obtain the configuration:<\/p>\n\n\n\n You can integrate your Data App’s endpoints with GPT using the API documentation URL and encoded API key. <\/p>\n\n\n\n Note<\/strong>: This feature is only available for ChatGPT Plus users.<\/p><\/span>Prerequisites for Building a Crypto ETF Insights App<\/span><\/h2>\n\n\n\n
\n
<\/span>Set Up Your Data Environment<\/span><\/h2>\n\n\n\n
crypto_demo<\/code> database and a crypto_trends<\/code> table within the database. Furthermore, you will import the pricing information for the top 5 trending cryptocurrencies <\/em>over the last two years into the crypto_trends<\/code> table.<\/p>\n\n\n\nGet Database Connection Info<\/strong><\/h3>\n\n\n\n
\n
![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/20200125\/image-16-1024x417.png\")
<\/figure><\/li>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/20200657\/image-17-1024x995.png\")
<\/figure><\/li>\n<\/ol>\n\n\n\nConfigure & Load Crypto Currency Data<\/strong><\/h3>\n\n\n\n
\n
git clone https:\/\/github.com\/tidbcloud\/ccxt-web3-bot.git\n<\/code><\/pre><\/li>\n\n\n\ncd ccxt-web3-bot <\/code><\/pre><\/li>\n\n\n\npython3 -m pip install -r requirements.txt<\/code><\/pre><\/li>\n\n\n\n % vi config.json { \"db_host\":\" python3 .\/main.py <\/code><\/pre><\/li>\n<\/ol>\n\n\n\ncrypto_demo<\/code> database and a crypto_trends<\/code> table. It will also import the data for the top 5 cryptocurrency price trends from the last two years into the database. Upon completion, you will see a confirmation message in the terminal indicating the successful data import.<\/p>\n\n\n\n<\/span>Create a Data App<\/strong><\/span><\/h2>\n\n\n\n
\n
\n
<\/span>Create HTTPS GET Endpoints<\/strong><\/span><\/h2>\n\n\n\n
GET \/list_cryptos<\/strong><\/h3>\n\n\n\n
GET \/list_cryptos<\/strong><\/code> <\/strong>endpoint <\/strong>lists all cryptocurrencies. Follow the steps below to create the endpoint:<\/p>\n\n\n\n\n
\n
\/list_cryptos<\/code> to define the endpoint’s access path.<\/li>\n\n\n\nSELECT DISTINCT crypto FROM crypto_demo.crypto_trends;<\/code><\/pre><\/li>\n\n\n\n\n
![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21071309\/image-30-1024x436.png\")
<\/figure><\/li>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21071352\/image-31-1024x542.png\")
<\/figure><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n\nGET \/trading_data_by_crypto<\/strong><\/h3>\n\n\n\n
GET \/trading_data_by_crypto<\/code><\/strong> endpoint retrieves the pricing trend data for a specific cryptocurrency and data range. Follow similar steps as the GET \/list_cryptos<\/strong><\/code> <\/strong>endpoint:<\/p>\n\n\n\n\n
\n
SELECT * FROM crypto_demo.crypto_trends\nWHERE `crypto` = ${crypto} and \n`time` between ${start_datetime} and ${end_datetime};\n<\/code><\/pre><\/li>\n\n\n\nGET \/list_cryptos<\/strong><\/code> <\/strong>endpoint to publish the endpoint.<\/li>\n<\/ol>\n\n\n\n<\/span>Integrate DataApp with GPTs<\/strong><\/span><\/h2>\n\n\n\n
Get Configuration for GPT Integration<\/strong><\/h3>\n\n\n\n
\n
web3-demo<\/code>). Then, click the Get Configuration button<\/strong> in the Integration with GPTs tile on the right. ![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21015707\/image-19-1024x318.png\")
<\/figure><\/li>\n\n\n\n\n
Create & Configure the GPT<\/strong><\/h3>\n\n\n\n
\n
![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21020303\/image-20-1024x457.png\")
<\/figure><\/li>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21020440\/image-21-1024x817.png\")
<\/figure><\/li>\n\n\n\n\n
![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21021115\/image-22-1024x807.png\")
<\/figure><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21072056\/image-33.png\")
<\/figure><\/li>\n<\/ol>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/04\/23192547\/GPTs-in-actions-1024x615.png\")
<\/figure>\n\n\n\n![\"Crypto](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21022527\/GPT-in-actions-Volatility-1024x683.gif\")
<\/figure>\n\n\n\n![\"Crypto](\"https:\/\/static.pingcap.com\/files\/2024\/03\/21022602\/GPTs-in-Action-volatality-prediction-1024x683.gif\")
<\/figure>\n\n\n\n