Select Git revision
-
James D'Alton authoredJames D'Alton authored
sqldump.sql 10.02 KiB
-- MySQL dump 10.13 Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost Database: crypto_tracker
-- ------------------------------------------------------
-- Server version 8.0.40-0ubuntu0.24.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `bnb_prices`
--
DROP TABLE IF EXISTS `bnb_prices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bnb_prices` (
`id` int NOT NULL AUTO_INCREMENT,
`timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
`price` decimal(10,2) DEFAULT NULL,
`high` decimal(10,2) DEFAULT NULL,
`low` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bnb_prices`
--
LOCK TABLES `bnb_prices` WRITE;
/*!40000 ALTER TABLE `bnb_prices` DISABLE KEYS */;
INSERT INTO `bnb_prices` VALUES (4,'2024-12-16 22:03:32',711.04,724.47,704.00),(5,'2024-12-17 02:24:10',725.55,726.08,704.00),(6,'2024-12-17 04:48:10',727.72,730.17,704.00),(7,'2024-12-17 07:12:08',725.57,730.17,704.00),(8,'2024-12-17 09:36:10',717.78,730.17,704.00),(9,'2024-12-17 12:00:08',718.13,730.17,704.00),(10,'2024-12-17 14:24:09',717.07,730.17,704.00),(11,'2024-12-17 16:48:09',716.27,730.17,704.00),(12,'2024-12-17 19:12:09',721.09,730.17,704.00),(13,'2024-12-17 21:36:14',721.86,730.17,704.38),(14,'2024-12-18 00:00:10',726.07,736.71,712.57),(15,'2024-12-19 00:00:11',716.54,736.28,703.37),(16,'2024-12-19 02:24:10',709.75,736.28,703.37),(17,'2024-12-19 04:48:09',693.73,736.28,685.06),(18,'2024-12-19 07:12:09',709.75,736.28,703.37),(19,'2024-12-19 09:36:10',689.64,721.98,685.06),(20,'2024-12-19 12:00:09',677.66,720.24,676.55),(21,'2024-12-19 14:24:09',699.95,720.24,669.84),(22,'2024-12-19 15:20:35',702.35,720.24,669.84);
/*!40000 ALTER TABLE `bnb_prices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `btc_prices`
--
DROP TABLE IF EXISTS `btc_prices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `btc_prices` (
`id` int NOT NULL AUTO_INCREMENT,
`timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
`price` decimal(10,2) DEFAULT NULL,
`high` decimal(10,2) DEFAULT NULL,
`low` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `btc_prices`
--
LOCK TABLES `btc_prices` WRITE;
/*!40000 ALTER TABLE `btc_prices` DISABLE KEYS */;
INSERT INTO `btc_prices` VALUES (24,'2024-12-16 22:03:32',103890.27,106495.73,102559.85),(25,'2024-12-17 02:24:10',107391.93,107461.42,102623.83),(26,'2024-12-17 04:48:10',106227.50,107778.43,102623.83),(27,'2024-12-17 07:12:08',105780.49,107778.43,103349.10),(28,'2024-12-17 09:36:10',106207.81,107778.43,103349.10),(29,'2024-12-17 12:00:08',106819.52,107778.43,103349.10),(30,'2024-12-17 14:24:09',106705.02,107778.43,103349.10),(31,'2024-12-17 16:48:09',107365.28,107778.43,103349.10),(32,'2024-12-17 19:12:09',107207.79,107778.43,103349.10),(33,'2024-12-17 21:36:14',107519.39,107778.43,103857.58),(34,'2024-12-18 00:00:10',106319.74,108266.71,105511.33),(35,'2024-12-19 00:00:11',104457.02,107652.45,103269.67),(36,'2024-12-19 02:24:10',104824.75,106983.81,103269.67),(37,'2024-12-19 04:48:09',100735.80,106800.16,100439.03),(38,'2024-12-19 07:12:09',100894.77,106498.31,100439.03),(39,'2024-12-19 09:36:10',100400.84,105661.59,100052.35),(40,'2024-12-19 12:00:09',101241.37,105353.05,98868.19),(41,'2024-12-19 14:24:09',101043.24,105353.05,98868.19),(42,'2024-12-19 15:20:35',101303.92,105353.05,98868.19),(43,'2024-12-19 16:48:40',101759.95,105353.05,98868.19);
/*!40000 ALTER TABLE `btc_prices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doge_prices`
--
DROP TABLE IF EXISTS `doge_prices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `doge_prices` (
`id` int NOT NULL AUTO_INCREMENT,
`timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
`price` decimal(10,4) DEFAULT NULL,
`high` decimal(10,4) DEFAULT NULL,
`low` decimal(10,4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doge_prices`
--
LOCK TABLES `doge_prices` WRITE;
/*!40000 ALTER TABLE `doge_prices` DISABLE KEYS */;
INSERT INTO `doge_prices` VALUES (2,'2024-12-16 22:03:32',0.3970,0.4144,0.3927),(3,'2024-12-17 02:24:10',0.4108,0.4144,0.3927),(4,'2024-12-17 04:48:10',0.4055,0.4144,0.3927),(5,'2024-12-17 07:12:08',0.4036,0.4144,0.3927),(6,'2024-12-17 09:36:10',0.3997,0.4135,0.3927),(7,'2024-12-17 12:00:08',0.4035,0.4135,0.3927),(8,'2024-12-17 14:24:09',0.3998,0.4135,0.3927),(9,'2024-12-17 16:48:09',0.4005,0.4135,0.3927),(10,'2024-12-17 19:12:09',0.4050,0.4135,0.3931),(11,'2024-12-17 21:36:14',0.4066,0.4135,0.3961),(12,'2024-12-18 00:00:10',0.3988,0.4135,0.3961),(13,'2024-12-19 00:00:11',0.3855,0.4040,0.3795),(14,'2024-12-19 02:24:10',0.3866,0.4022,0.3795),(15,'2024-12-19 04:48:09',0.3604,0.4013,0.3561),(16,'2024-12-19 07:12:09',0.3585,0.3971,0.3561),(17,'2024-12-19 09:36:10',0.3576,0.3940,0.3561),(18,'2024-12-19 12:00:09',0.3649,0.3909,0.3418),(19,'2024-12-19 14:24:09',0.3623,0.3909,0.3418),(20,'2024-12-19 15:20:35',0.3630,0.3909,0.3418);
/*!40000 ALTER TABLE `doge_prices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `eth_prices`
--
DROP TABLE IF EXISTS `eth_prices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `eth_prices` (
`id` int NOT NULL AUTO_INCREMENT,
`timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
`price` decimal(10,2) DEFAULT NULL,
`high` decimal(10,2) DEFAULT NULL,
`low` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `eth_prices`
--
LOCK TABLES `eth_prices` WRITE;
/*!40000 ALTER TABLE `eth_prices` DISABLE KEYS */;
INSERT INTO `eth_prices` VALUES (4,'2024-12-16 22:03:32',3901.56,4021.19,3846.70),(5,'2024-12-17 02:24:10',4045.98,4049.18,3846.70),(6,'2024-12-17 04:48:10',4052.21,4106.39,3846.70),(7,'2024-12-17 07:12:08',4019.71,4106.39,3884.82),(8,'2024-12-17 09:36:10',3981.74,4106.39,3884.82),(9,'2024-12-17 12:00:08',4033.30,4106.39,3884.82),(10,'2024-12-17 14:24:09',4012.41,4106.39,3884.82),(11,'2024-12-17 16:48:09',4011.46,4106.39,3884.82),(12,'2024-12-17 19:12:09',4015.87,4106.39,3884.82),(13,'2024-12-17 21:36:14',4013.91,4106.39,3897.83),(14,'2024-12-18 00:00:10',3937.71,4106.39,3920.68),(15,'2024-12-19 00:00:11',3870.96,3984.60,3806.96),(16,'2024-12-19 02:24:10',3878.43,3954.26,3806.96),(17,'2024-12-19 04:48:09',3692.47,3950.81,3673.89),(18,'2024-12-19 07:12:09',3655.42,3904.19,3647.32),(19,'2024-12-19 09:36:10',3629.08,3901.77,3618.85),(20,'2024-12-19 12:00:09',3670.54,3901.77,3551.13),(21,'2024-12-19 14:24:09',3667.75,3901.77,3551.13),(22,'2024-12-19 15:20:35',3683.06,3901.77,3551.13),(23,'2024-12-19 16:48:40',3675.49,3901.77,3551.13);
/*!40000 ALTER TABLE `eth_prices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sol_prices`
--
DROP TABLE IF EXISTS `sol_prices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sol_prices` (
`id` int NOT NULL AUTO_INCREMENT,
`timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
`price` decimal(10,2) DEFAULT NULL,
`high` decimal(10,2) DEFAULT NULL,
`low` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sol_prices`
--
LOCK TABLES `sol_prices` WRITE;
/*!40000 ALTER TABLE `sol_prices` DISABLE KEYS */;
INSERT INTO `sol_prices` VALUES (4,'2024-12-16 22:03:32',216.13,227.24,213.38),(5,'2024-12-17 02:24:10',219.23,227.24,213.38),(6,'2024-12-17 04:48:10',217.20,227.24,213.38),(7,'2024-12-17 07:12:08',217.94,227.24,213.38),(8,'2024-12-17 09:36:10',214.47,225.59,211.68),(9,'2024-12-17 12:00:08',215.48,223.80,211.68),(10,'2024-12-17 14:24:09',214.74,223.80,211.68),(11,'2024-12-17 16:48:09',217.26,221.70,211.68),(12,'2024-12-17 19:12:09',222.61,223.70,211.68),(13,'2024-12-17 21:36:14',224.87,227.47,211.68),(14,'2024-12-18 00:00:10',219.99,227.47,211.68),(15,'2024-12-19 00:00:11',217.24,228.93,213.82),(16,'2024-12-19 02:24:10',216.42,228.93,213.82),(17,'2024-12-19 04:48:09',208.95,226.73,207.75),(18,'2024-12-19 07:12:09',207.87,226.11,206.11),(19,'2024-12-19 09:36:10',205.47,220.36,204.98),(20,'2024-12-19 12:00:09',208.33,218.98,199.84),(21,'2024-12-19 14:24:09',209.45,218.98,199.84),(22,'2024-12-19 15:20:35',210.77,218.98,199.84),(23,'2024-12-19 16:48:41',209.25,218.98,199.84);
/*!40000 ALTER TABLE `sol_prices` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2024-12-19 18:24:51