Sean/marketdata
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
marketdata/Database/portfolio_data.dat.bak
Sean Kessler f62b648f97 init
2024-02-22 14:48:01 -05:00

172 lines
34 KiB
Plaintext
Raw Permalink Blame History

-- MySQL dump 10.13 Distrib 5.6.23, for Win64 (x86_64)
--
-- Host: localhost Database: portfolio_data
-- ------------------------------------------------------
-- Server version 5.6.23-log
/*!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 */;
/*!40101 SET NAMES utf8 */;
/*!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 `accounts`
--
DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` (
`account` varchar(25) NOT NULL,
PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts`
--
LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` VALUES ('401K-20963'),('BRK-1576'),('BRK-4852'),('BRK-54X61101'),('BRK-59326578'),('BRK-5QX13608'),('BRK-8502'),('BRK6107-4777');
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cash`
--
DROP TABLE IF EXISTS `cash`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cash` (
`account` varchar(25) NOT NULL,
`date` datetime NOT NULL,
`description` varchar(255) DEFAULT NULL,
`credit` decimal(19,2) DEFAULT NULL,
`debit` decimal(19,2) DEFAULT NULL,
`balance` decimal(19,2) DEFAULT NULL,
`transaction_id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`account`,`date`,`transaction_id`),
UNIQUE KEY `transaction_id` (`transaction_id`),
KEY `account` (`account`),
KEY `IDX_DATE` (`date`),
CONSTRAINT `FK_Cash_Accounts` FOREIGN KEY (`account`) REFERENCES `accounts` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cash`
--
LOCK TABLES `cash` WRITE;
/*!40000 ALTER TABLE `cash` DISABLE KEYS */;
INSERT INTO `cash` VALUES ('401K-20963','2014-04-03 00:00:00','Initial Record',3462.18,0.00,3462.18,10),('401K-20963','2014-04-03 00:00:00','Buy 75.298 of JFNIX @$45.98',0.00,3462.18,-3462.18,48),('401K-20963','2014-04-10 00:00:00','Buy 75 of JFNIX @45.98',0.00,3462.18,0.00,11),('401K-20963','2014-04-16 00:00:00','Buy 7 of JFNIX @$45.30',0.00,317.10,-317.10,14),('401K-20963','2014-04-16 00:00:00','Buy 7.874 of JFNIX @$43.50',0.00,342.48,-3804.66,49),('401K-20963','2014-05-01 00:00:00','Buy 7 of JFNIX @$43.49',0.00,304.43,-621.53,15),('401K-20963','2014-05-01 00:00:00','Buy 7.56 of JFNIX @$45.30',0.00,342.47,-4147.13,50),('401K-20963','2014-05-08 00:00:00','Adjustment',621.53,0.00,0.00,16),('401K-20963','2014-05-16 00:00:00','Buy 7 of JFNIX @$45.02',0.00,315.14,-315.14,22),('401K-20963','2014-05-16 00:00:00','Adjustment',315.14,0.00,0.00,23),('401K-20963','2014-05-16 00:00:00','Buy 7.608 of JFNIX @$45.02',0.00,342.51,-4489.64,51),('401K-20963','2014-06-02 00:00:00','Buy 7 of JFNIX @$46.57',0.00,325.99,-325.99,26),('401K-20963','2014-06-02 00:00:00','Adjustment',325.99,0.00,0.00,27),('401K-20963','2014-06-02 00:00:00','Buy 7.354 of JFNIX @$46.57',0.00,342.48,-4832.12,52),('401K-20963','2014-06-16 00:00:00','Buy 7 of JFNIX @$47.43',0.00,332.01,-670.60,31),('401K-20963','2014-06-16 00:00:00','Buy 7.22 of JFNIX @$47.43',0.00,342.44,-5174.56,53),('401K-20963','2014-06-25 00:00:00','Buy 7 of JFNIX @$48.37',0.00,338.59,-338.59,30),('401K-20963','2014-07-01 00:00:00','Buy 7 of JFNIX @$49.63',0.00,347.41,-1018.01,33),('401K-20963','2014-07-01 00:00:00','Buy 6.9 of JFNIX @$49.63',0.00,342.45,-5517.01,54),('401K-20963','2014-07-14 00:00:00','Adjustment',1018.01,0.00,0.00,34),('401K-20963','2014-07-16 00:00:00','Buy 7 of JFNIX @$48.01',0.00,336.07,-336.07,39),('401K-20963','2014-07-16 00:00:00','Buy 7.134 of JFNIX @$48.01',0.00,342.50,-5859.51,55),('401K-20963','2014-08-01 00:00:00','Buy 7 of JFNIX @$49.19',0.00,344.33,-680.40,40),('401K-20963','2014-08-01 00:00:00','Buy 6.962 of JFNIX @$49.19',0.00,342.46,-6201.97,56),('401K-20963','2014-08-05 00:00:00','Adjustment',336.07,0.00,-344.33,41),('401K-20963','2014-08-05 00:00:00','Adjustment',344.33,0.00,0.00,42),('401K-20963','2014-08-18 00:00:00','Buy 6 of JFNIX @$51.33',0.00,307.98,-615.96,46),('401K-20963','2014-08-18 00:00:00','Buy 6.672 of JFNIX @$51.33',0.00,342.47,-6544.44,57),('401K-20963','2014-08-19 00:00:00','Buy 6 of JFNIX @$51.33',0.00,307.98,-307.98,45),('401K-20963','2014-08-19 00:00:00','Adjustment',307.98,0.00,0.00,47),('401K-20963','2014-09-02 00:00:00','Buy 6.44 of JFNIX @$53.18',0.00,342.48,-6886.92,58),('401K-20963','2014-09-03 00:00:00','Adjustment',6886.92,0.00,0.00,59),('401K-20963','2014-09-16 00:00:00','Buy 6.44 of JFNIX @$53.05',0.00,341.64,-341.64,60),('401K-20963','2014-09-16 00:00:00','Buy 6.44 of JFNIX @$53.18',0.00,342.48,-684.12,61),('401K-20963','2014-09-26 00:00:00','Adjustment',684.12,0.00,0.00,62),('401K-20963','2014-10-01 00:00:00','Buy 6.574 of JFNIX @$52.09',0.00,342.44,-684.92,70),('401K-20963','2014-10-03 00:00:00','Buy 6.574 of JFNIX @$52.10',0.00,342.48,-342.48,69),('401K-20963','2014-10-16 00:00:00','Buy 6.892 of JFNIX @$49.69',0.00,342.46,-1027.38,71),('401K-20963','2014-11-03 00:00:00','Buy 6.242 of JFNIX @$54.86',0.00,342.44,-1369.82,72),('401K-20963','2014-11-17 00:00:00','Buy 8.308 of JFNIX @$54.97',0.00,456.65,-1826.47,73),('401K-20963','2014-12-01 00:00:00','Buy 8.076 of JFNIX @$56.54',0.00,456.62,-2283.09,74),('401K-20963','2014-12-16 00:00:00','Buy 8.164 of JFNIX @$55.93',0.00,456.61,-2739.70,75),('401K-20963','2014-12-17 00:00:00','Buy 20.51 of JFNIX @$52.05',0.00,1067.55,-3807.25,76),('401K-20963','2014-12-31 00:00:00','Buy 8.664 of JFNIX @$52.70',0.00,456.59,-4263.84,77),('401K-20963','2015-01-06 00:00:00','Update',4263.84,0.00,0.00,79),('401K-20963','2015-01-16 00:00:00','Buy 8.352 of JFNIX @$54.68',0.00,456.69,-456.69,83),('401K-20963','2015-02-02 00:00:00','Buy 40.932 of JFNIX @$54.97',0.00,2250.03,-2706.72,84),('401K-20963','2015-02-17 00:00:00','Buy 8.386 of JFNIX @$56.45',0.00,473.39,-4126.89,88),('401K-20963','2015-02-19 00:00:00','Buy 8.386 of JFNIX @$56.45',0.00,473.39,-3180.11,86),('401K-20963','2015-02-19 00:00:00','Buy 8.386 of JFNIX @$56.45',0.00,473.39,-3653.50,87),('401K-20963','2015-03-02 00:00:00','Buy 8.07 of JFNIX @$58.66',0.00,473.39,-5073.63,94),('401K-20963','2015-03-06 00:00:00','Buy 8.07 of JFNIX @$58.66',0.00,473.35,-4600.24,93),('401K-20963','2015-03-16 00:00:00','Buy 7.864 of JFNIX @$60.19',0.00,473.33,-5546.96,97),('401K-20963','2015-04-01 00:00:00','Buy 7.944 of JFNIX @$59.58',0.00,473.30,-6020.26,98),('401K-20963','2015-04-16 00:00:00','Buy 7.536 of JFNIX @$62.81',0.00,473.34,-6493.60,99),('401K-20963','2015-04-21 00:00:00','Adjustment',6493.60,0.00,0.00,101),('401K-20963','2015-05-01 00:00:00','Buy 7.914 of JFNIX @$59.81',0.00,473.34,-473.34,102),('401K-20963','2015-05-18 00:00:00','Buy 7.626 of JFNIX @$62.07',0.00,473.35,-946.69,105),('401K-20963','2015-06-01 00:00:00','Buy 7.578 of JFNIX @$62.46',0.00,473.32,-1420.01,107),('401K-20963','2015-06-16 00:00:00','Buy 7.578 of JFNIX @$62.46',0.00,473.32,-1893.33,108),('401K-20963','2015-07-01 00:00:00','Buy 7.548 of JFNIX @$62.72',0.00,473.41,-2366.74,109),('401K-20963','2015-07-16 00:00:00','Buy 7.154 of JFNIX @$66.16',0.00,473.31,-2840.05,110),('401K-20963','2015-08-03 00:00:00','Buy 7.204 of JFNIX @$65.71',0.00,473.37,-3313.42,111),('401K-20963','2015-08-17 00:00:00','Buy 7.35 of JFNIX @$64.41',0.00,473.41,-3786.83,114),('401K-20963','2015-09-01 00:00:00','Buy 8.066 of JFNIX @$58.68',0.00,473.31,-4260.14,115),('401K-20963','2015-09-16 00:00:00','Buy 7.712 of JFNIX @$61.38',0.00,473.36,-4733.50,116),('401K-20963','2015-10-01 00:00:00','Buy 8.622 of JFNIX @$54.90',0.00,473.35,-5206.85,117),('401K-20963','2015-10-16 00:00:00','Buy 8.44 of JFNIX @$56.08',0.00,473.32,-5680.17,118),('401K-20963','2015-11-02 00:00:00','Buy 8.17 of JFNIX @$57.94',0.00,473.37,-6153.54,119),('401K-20963','2015-11-16 00:00:00','Buy 8.558 of JFNIX @$55.31',0.00,473.34,-6626.88,121),('401K-20963','2015-11-16 00:00:00','Buy 8.558 of JFNIX @$55.31',0.00,473.34,-7573.53,123),('401K-20963','2015-12-01 00:00:00','Buy 8.186 of JFNIX @$57.82',0.00,473.31,-7100.19,122),('401K-20963','2015-12-01 00:00:00','Buy 8.186 of JFNIX @$57.82',0.00,473.31,-8046.84,124),('401K-20963','2015-12-16 00:00:00','Buy 8.254 of JFNIX @$57.35',0.00,473.37,-8520.21,125),('401K-20963','2015-12-17 00:00:00','Buy 40.892 of JFNIX @$52.05',0.00,2128.39,-10648.60,126),('401K-20963','2015-12-31 00:00:00','Buy 9.05 of JFNIX @$52.31',0.00,473.36,-11121.96,127),('401K-20963','2016-01-19 00:00:00','Buy 9.05 of JFNIX @$52.30',0.00,473.35,-11595.31,132),('401K-20963','2016-02-01 00:00:00','Buy 46.186 of JFNIX @$45.54',0.00,2103.31,-13698.62,133),('401K-20963','2016-02-16 00:00:00','Buy 11.088 of JFNIX @$44.04',0.00,488.32,-14186.94,134),('401K-20963','2016-03-01 00:00:00','Buy 10.928 of JFNIX @$44.69',0.00,488.37,-14675.31,135),('401K-20963','2016-03-16 00:00:00','Buy 11.128 of JFNIX @$43.88',0.00,488.30,-15163.61,136),('401K-20963','2016-03-23 00:00:00','Adjustment',15163.61,0.00,0.00,137),('401K-20963','2016-04-01 00:00:00','Buy 10.64 of JFNIX @$45.90',0.00,488.38,-488.38,141),('401K-20963','2016-04-18 00:00:00','Buy 10.272 of JFNIX @$47.54',0.00,488.33,-976.71,142),('401K-20963','2016-05-02 00:00:00','Buy 10.296 of JFNIX @$47.43',0.00,488.34,-1465.05,143),('401K-20963','2016-05-16 00:00:00','Buy 10.296 of JFNIX @$47.43',0.00,488.34,-1953.39,145),('401K-20963','2016-06-01 00:00:00','Buy 10.04 of JFNIX @$48.64',0.00,488.35,-2441.74,147),('401K-20963','2016-06-16 00:00:00','Buy 10.3 of JFNIX @$47.42',0.00,488.43,-2930.17,148),('401K-20963','2016-07-01 00:00:00','Buy 10.11 of JFNIX @$48.30',0.00,488.31,-3418.48,149),('401K-20963','2016-07-18 00:00:00','Buy 9.85 of JFNIX @$49.57',0.00,488.26,-3906.74,150),('401K-20963','2016-08-01 00:00:00','Buy 9.47 of JFNIX @$51.57',0.00,488.37,-4395.11,151),('401K-20963','2016-08-16 00:00:00','Buy 9.628 of JFNIX @$50.72',0.00,488.33,-4883.44,152),('401K-20963','2016-09-01 00:00:00','Buy 9.852 of JFNIX @$49.57',0.00,488.36,-5371.80,153),('401K-20963','2016-09-16 00:00:00','Buy 9.672 of JFNIX @$50.49',0.00,488.34,-5860.14,154),('401K-20963','2016-10-03 00:00:00','Buy 9.806 of JFNIX @$49.80',0.00,488.34,-6348.48,155),('401K-20963','2016-10-17 00:00:00','Buy 10.324 of JFNIX @$47.30',0.00,488.33,-6836.81,156),('401K-20963','2016-11-01 00:00:00','Buy 10.84 of JFNIX @$45.05',0.00,488.34,-7325.15,157),('401K-20963','2016-11-16 00:00:00','Buy 10.222 of JFNIX @$47.77',0.00,488.30,-7813.45,162),('401K-20963','2016-12-01 00:00:00','Buy 10.67 of JFNIX @$45.77',0.00,488.37,-8301.82,163),('401K-20963','2016-12-16 00:00:00','Buy 10.514 of JFNIX @$46.45',0.00,488.38,-8790.20,164),('401K-20963','2016-12-19 00:00:00','Buy 10.024 of JFNIX @$45.54',0.00,456.49,-9246.69,165),('401K-20963','2016-12-30 00:00:00','Buy 10.782 of JFNIX @$45.29',0.00,488.32,-9735.01,166),('401K-20963','2017-01-17 00:00:00','Buy 10.39 of JFNIX @$47.00',0.00,488.33,-10223.34,167),('401K-20963','2017-02-01 00:00:00','Buy 57.372 of JFNIX @$47.58',0.00,2729.76,-12953.10,168),('401K-20963','2017-02-16 00:00:00','Buy 10.256 of JFNIX @$49.64',0.00,509.11,-13462.21,169),('401K-20963','2017-03-01 00:00:00','Buy 10.022 of JFNIX @$50.79',0.00,509.02,-13971.23,170),('401K-20963','2017-03-16 00:00:00','Buy 9.998 of JFNIX @$50.92',0.00,509.05,-14480.28,171),('401K-20963','2017-04-03 00:00:00','Buy 10.074 of JFNIX @$50.53',0.00,509.04,-14989.32,172),('401K-20963','2017-04-13 00:00:00','Adjustment',14989.32,0.00,0.00,173),('401K-20963','2017-04-18 00:00:00','Buy 10.208 of JFNIX @$49.87',0.00,509.07,-509.07,175),('401K-20963','2017-05-01 00:00:00','Buy 9.802 of JFNIX @$51.93',0.00,509.02,-1018.09,176),('401K-20963','2017-05-16 00:00:00','Buy 9.786 of JFNIX @$52.02',0.00,509.07,-1527.16,177),('401K-20963','2017-06-01 00:00:00','Buy 9.66 of JFNIX @$52.70',0.00,509.08,-2036.24,178),('401K-20963','2017-06-05 00:00:00','Buy 29 of JHG @$34.48',0.00,999.92,-3036.16,179),('401K-20963','2017-06-05 00:00:00','Buy 29 of JHG @$34.48',0.00,999.92,-4036.08,180),('401K-20963','2017-06-16 00:00:00','Buy 9.58 of JFNIX @$53.14',0.00,509.08,-4545.16,185),('401K-20963','2017-06-16 00:00:00','Buy 9.58 of JFNIX @$53.14',0.00,509.08,-5054.24,186),('401K-20963','2017-07-03 00:00:00','Buy 9.364 of JFNIX @$54.36',0.00,509.03,-5563.27,187),('401K-20963','2017-07-17 00:00:00','Buy 9.236 of JFNIX @$55.12',0.00,509.09,-6072.36,188),('401K-20963','2017-08-01 00:00:00','Buy 9.322 of JFNIX @$54.61',0.00,509.07,-6581.43,189),('401K-20963','2017-08-16 00:00:00','Buy 9.414 of JFNIX @$54.08',0.00,509.11,-7090.54,190),('401K-20963','2017-09-01 00:00:00','Buy 9.122 of JFNIX @$55.81',0.00,509.10,-7599.64,191),('401K-20963','2017-09-18 00:00:00','Buy 9.062 of JFNIX @$56.17',0.00,509.01,-8108.65,193),('401K-20963','2017-09-18 00:00:00','Buy 9.062 of JFNIX @$56.17',0.00,509.01,-8617.66,194),('401K-20963','2017-10-02 00:00:00','Buy 8.896 of JFNIX @$57.22',0.00,509.03,-9126.69,195),('401K-20963','2017-10-16 00:00:00','Buy 9.05 of JFNIX @$56.25',0.00,509.06,-9635.75,196),('401K-20963','2017-11-01 00:00:00','Buy 9.376 of JFNIX @$54.29',0.00,509.02,-10144.77,197),('BRK-1576','2013-04-06 00:00:00','Initial Record',25822.67,0.00,25822.67,1),('BRK-1576','2014-05-28 00:00:00','Adjustment',0.00,9999.66,15823.01,24),('BRK-1576','2016-03-23 00:00:00','Adjustment',0.00,9998.57,5824.44,138),('BRK-4852','2013-04-06 00:00:00','Initial Record',152467.73,0.00,152467.73,2),('BRK-4852','2014-05-08 00:00:00','Adjustment',0.00,152467.73,0.00,18),('BRK-54X61101','2017-06-27 00:00:00','Transfer from BRK-8502',135116.49,0.00,135116.49,183),('BRK-59326578','2015-01-06 00:00:00','Update',21614.41,0.00,21614.41,80),('BRK-59326578','2016-03-23 00:00:00','Adjustment',23.30,0.00,21637.71,139),('BRK-5QX13608','2017-11-09 00:00:00','PROCEEDS FROM SALE DLTR',5889.71,0.00,5889.71,192),('BRK-5QX13608','2017-12-01 00:00:00','Buy 71 of WDC @$78.76',0.00,5591.96,297.75,198),('BRK-8502','2013-04-06 00:00:00','Initial Record',48628.35,0.00,48628.35,3),('BRK-8502','2014-04-07 00:00:00','Buy 20 of MIDD @$254.00',0.00,5080.00,43548.35,8),('BRK-8502','2014-04-07 00:00:00','Commission: MIDD $6.95',0.00,6.95,43541.40,9),('BRK-8502','2014-05-07 00:00:00','Sell 145 of UNH @$77.61',11253.45,0.00,54794.85,12),('BRK-8502','2014-05-07 00:00:00','Commission: UNH $6.95',0.00,6.95,54787.90,13),('BRK-8502','2014-05-08 00:00:00','Adjustment',152468.99,0.00,207256.89,19),('BRK-8502','2014-05-08 00:00:00','Adjustment',0.85,0.00,207257.74,20),('BRK-8502','2014-05-14 00:00:00','Buy 23 of MIDD @$221.10',0.00,5085.30,202172.44,21),('BRK-8502','2014-05-28 00:00:00','Adjustment',0.00,76442.96,125729.48,25),('BRK-8502','2014-06-23 00:00:00','Buy 113 of KORS @$88.52',0.00,10002.76,115726.72,28),('BRK-8502','2014-06-23 00:00:00','Buy 113 of KORS @$88.20',0.00,9966.60,105760.12,29),('BRK-8502','2014-06-25 00:00:00','Adjustment',86509.78,0.00,192269.90,32),('BRK-8502','2014-07-16 00:00:00','Buy 93 of KORS @$81.25',0.00,7556.25,184713.65,35),('BRK-8502','2014-07-16 00:00:00','Commission: KORS $5.95',0.00,5.95,184707.70,36),('BRK-8502','2014-07-22 00:00:00','Buy 100 of MIDD @$75.30',0.00,7530.00,177177.70,37),('BRK-8502','2014-07-22 00:00:00','Commission: MIDD $5.95',0.00,5.95,177171.75,38),('BRK-8502','2014-08-14 00:00:00','Buy 60 of CPA @$125.34',0.00,7520.10,169651.65,43),('BRK-8502','2014-08-14 00:00:00','Commission: CPA $6.95',0.00,6.95,169644.70,44),('BRK-8502','2014-09-30 00:00:00','Buy 75 of CPA @$107.42',0.00,8056.50,161588.20,63),('BRK-8502','2014-09-30 00:00:00','Commission: CPA $8.95',0.00,8.95,161579.25,64),('BRK-8502','2014-09-30 00:00:00','Buy 75 of CPA @$107.42',0.00,8056.50,153522.75,65),('BRK-8502','2014-09-30 00:00:00','Commission: CPA $6.95',0.00,6.95,153515.80,66),('BRK-8502','2014-10-03 00:00:00','Buy 170 of THRM @$43.68',0.00,7425.60,146090.20,67),('BRK-8502','2014-10-03 00:00:00','Commission: THRM $6.95',0.00,6.95,146083.25,68),('BRK-8502','2014-10-15 00:00:00','Buy 55 of SPY @$184.13',0.00,10127.15,124004.23,85),('BRK-8502','2015-01-06 00:00:00','Update',0.00,1712.47,144370.78,78),('BRK-8502','2015-01-07 00:00:00','Buy 95 of VDE @$107.71',0.00,10232.45,134138.33,81),('BRK-8502','2015-01-07 00:00:00','Commission: VDE $6.95',0.00,6.95,134131.38,82),('BRK-8502','2015-02-20 00:00:00','Sell 434 of CHEF @$23.29',10107.86,0.00,134112.09,89),('BRK-8502','2015-02-20 00:00:00','Commission: CHEF $6.95',0.00,6.95,134105.14,90),('BRK-8502','2015-02-24 00:00:00','Buy 155 of BLV @$96.16',0.00,14904.03,119201.12,91),('BRK-8502','2015-02-26 00:00:00','Buy 147 of KORS @$68.05',0.00,10003.35,109197.77,92),('BRK-8502','2015-03-30 00:00:00','Sell 155 of BLV @$96.19',14909.45,0.00,124107.22,95),('BRK-8502','2015-03-30 00:00:00','Commission: BLV $6.95',0.00,6.95,124100.27,96),('BRK-8502','2015-04-21 00:00:00','Adjustment',10402.72,0.00,134502.99,100),('BRK-8502','2015-05-19 00:00:00','Buy 82 of CPA @$90.94',0.00,7457.08,127045.91,103),('BRK-8502','2015-05-19 00:00:00','Commission: CPA $6.95',0.00,6.95,127038.96,104),('BRK-8502','2015-05-29 00:00:00','Buy 130 of KORS @$46.68',0.00,6068.40,120970.56,106),('BRK-8502','2015-08-21 00:00:00','Buy 55 of SPY @$198.93',0.00,10941.15,110029.41,112),('BRK-8502','2015-08-21 00:00:00','Commission: SPY $6.95',0.00,6.95,110022.46,113),('BRK-8502','2015-12-08 00:00:00','Buy 100 of CPA @$49.18',0.00,4918.00,105104.46,120),('BRK-8502','2016-01-14 00:00:00','Buy 120 of VDE @$76.99',0.00,9238.80,95865.66,128),('BRK-8502','2016-01-14 00:00:00','Commission: VDE $6.95',0.00,6.95,95858.71,129),('BRK-8502','2016-01-26 00:00:00','Buy 133 of MIDD @$85.10',0.00,11318.30,84540.41,130),('BRK-8502','2016-01-26 00:00:00','Commission: MIDD $6.95',0.00,6.95,84533.46,131),('BRK-8502','2016-03-23 00:00:00','Adjustment',7212.78,0.00,91746.24,140),('BRK-8502','2016-05-18 00:00:00','Buy 213 of THRM @$35.11',0.00,7478.43,84267.81,144),('BRK-8502','2016-06-27 00:00:00','Buy 60 of FXB @$130.00',0.00,7800.00,76467.81,146),('BRK-8502','2016-12-07 00:00:00','Sell 55 of SPY @$123.00',6765.00,0.00,83232.81,158),('BRK-8502','2016-12-07 00:00:00','Sell 51 of SPY @$123.00',6273.00,0.00,89505.81,159),('BRK-8502','2016-12-07 00:00:00','Sell 55 of SPY @$223.00',12265.00,0.00,101770.81,160),('BRK-8502','2016-12-07 00:00:00','Sell 51 of SPY @$223.00',11373.00,0.00,113143.81,161),('BRK-8502','2017-04-13 00:00:00','Adjustment',21972.68,0.00,135116.49,174),('BRK-8502','2017-06-27 00:00:00','Transfer to BRK-54X61101',0.00,135116.49,0.00,181),('BRK-8502','2017-07-27 00:00:00','Buy 520 of JETS @$29.00',0.00,15080.00,-15080.00,184);
/*!40000 ALTER TABLE `cash` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `trades`
--
DROP TABLE IF EXISTS `trades`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trades` (
`trade_id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(15) NOT NULL,
`trade_date` datetime NOT NULL,
`shares` decimal(19,2) DEFAULT NULL,
`price` decimal(19,2) DEFAULT NULL,
`buysell` char(1) DEFAULT NULL,
`status` varchar(10) NOT NULL,
`account` varchar(25) NOT NULL,
`commission` decimal(19,2) NOT NULL DEFAULT '0.00',
`date_sold` datetime DEFAULT NULL,
`sell_price` decimal(19,2) DEFAULT NULL,
PRIMARY KEY (`trade_id`),
KEY `IX_Trades` (`symbol`,`trade_date`),
KEY `FK_Trades_Accounts` (`account`),
CONSTRAINT `FK_Trades_Accounts` FOREIGN KEY (`account`) REFERENCES `accounts` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `trades`
--
LOCK TABLES `trades` WRITE;
/*!40000 ALTER TABLE `trades` DISABLE KEYS */;
INSERT INTO `trades` VALUES (3,'SPY','2013-10-09 00:00:00',30.00,165.94,'B','CLOSED','BRK-1576',6.95,'2013-10-18 00:00:00',174.00),(4,'MIDD','2013-10-09 00:00:00',120.00,68.04,'B','OPEN','BRK-8502',6.95,NULL,NULL),(5,'UNH','2013-10-22 00:00:00',145.00,68.75,'S','CLOSED','BRK-8502',6.95,'2014-05-07 00:00:00',77.61),(6,'MIDD','2013-11-08 00:00:00',69.00,72.05,'B','OPEN','BRK-8502',6.95,NULL,0.00),(9,'SPY','2014-01-31 00:00:00',50.00,177.95,'B','CLOSED','BRK-8502',6.95,'2014-03-12 00:00:00',186.23),(10,'CHEF','2014-03-07 00:00:00',434.00,23.25,'S','CLOSED','BRK-8502',6.95,'2015-02-20 00:00:00',23.29),(11,'CPA','2014-03-11 00:00:00',80.00,126.55,'S','CLOSED','BRK-8502',6.95,'2017-04-03 00:00:00',112.50),(12,'MIDD','2014-03-27 00:00:00',60.00,86.00,'B','OPEN','BRK-8502',6.95,NULL,0.00),(13,'SPY','2014-04-01 00:00:00',55.00,188.01,'B','CLOSED','BRK-4852',6.95,'2014-04-01 00:00:00',188.26),(16,'MIDD','2014-04-07 00:00:00',60.00,84.67,'B','OPEN','BRK-8502',6.95,NULL,NULL),(17,'JFNIX','2014-04-03 00:00:00',75.30,45.98,'B','OPEN','401K-20963',0.00,NULL,NULL),(18,'JFNIX','2014-04-16 00:00:00',7.87,43.50,'B','OPEN','401K-20963',0.00,NULL,NULL),(19,'JFNIX','2014-05-01 00:00:00',7.56,45.30,'B','OPEN','401K-20963',0.00,NULL,NULL),(20,'MIDD','2014-05-14 00:00:00',69.00,73.70,'B','OPEN','BRK-8502',0.00,NULL,NULL),(21,'JFNIX','2014-05-16 00:00:00',7.61,45.02,'B','OPEN','401K-20963',0.00,NULL,NULL),(22,'JFNIX','2014-06-02 00:00:00',7.35,46.57,'B','OPEN','401K-20963',0.00,NULL,NULL),(23,'KORS','2014-06-23 00:00:00',113.00,88.20,'B','OPEN','BRK-8502',0.00,NULL,NULL),(24,'JFNIX','2014-06-16 00:00:00',7.22,47.43,'B','OPEN','401K-20963',0.00,NULL,NULL),(25,'JFNIX','2014-07-01 00:00:00',6.90,49.63,'B','OPEN','401K-20963',0.00,NULL,NULL),(26,'KORS','2014-07-16 00:00:00',93.00,81.25,'B','OPEN','BRK-8502',5.95,NULL,NULL),(27,'MIDD','2014-07-22 00:00:00',100.00,75.30,'B','OPEN','BRK-8502',5.95,NULL,NULL),(28,'JFNIX','2014-07-16 00:00:00',7.13,48.01,'B','OPEN','401K-20963',0.00,NULL,NULL),(29,'JFNIX','2014-08-01 00:00:00',6.96,49.19,'B','OPEN','401K-20963',0.00,NULL,NULL),(30,'CPA','2014-08-14 00:00:00',60.00,125.33,'S','CLOSED','BRK-8502',6.95,'2017-04-03 00:00:00',112.50),(31,'JFNIX','2014-08-18 00:00:00',6.67,51.33,'B','OPEN','401K-20963',0.00,NULL,NULL),(32,'JFNIX','2014-09-02 00:00:00',6.44,53.18,'B','OPEN','401K-20963',0.00,NULL,NULL),(33,'JFNIX','2014-09-16 00:00:00',6.44,53.18,'B','OPEN','401K-20963',0.00,NULL,NULL),(34,'CPA','2014-09-30 00:00:00',75.00,107.42,'S','CLOSED','BRK-8502',6.95,'2017-04-03 00:00:00',112.50),(35,'THRM','2014-10-03 00:00:00',170.00,43.68,'B','CLOSED','BRK-8502',6.95,'2017-07-11 00:00:00',39.25),(36,'JFNIX','2014-10-01 00:00:00',6.57,52.09,'B','OPEN','401K-20963',0.00,NULL,NULL),(37,'SPY','2014-10-14 00:00:00',55.00,187.80,'S','CLOSED','BRK-59326578',7.00,'2014-11-12 00:00:00',203.83),(38,'JFNIX','2014-10-16 00:00:00',6.89,49.69,'B','OPEN','401K-20963',0.00,NULL,NULL),(39,'JFNIX','2014-11-03 00:00:00',6.24,54.86,'B','OPEN','401K-20963',0.00,NULL,NULL),(40,'JFNIX','2014-11-17 00:00:00',8.31,54.97,'B','OPEN','401K-20963',0.00,NULL,NULL),(41,'JFNIX','2014-12-01 00:00:00',8.08,56.54,'B','OPEN','401K-20963',0.00,NULL,NULL),(42,'JFNIX','2014-12-16 00:00:00',8.16,55.93,'B','OPEN','401K-20963',0.00,NULL,NULL),(43,'JFNIX','2014-12-17 00:00:00',20.51,52.05,'B','OPEN','401K-20963',0.00,NULL,NULL),(44,'JFNIX','2014-12-31 00:00:00',8.66,52.70,'B','OPEN','401K-20963',0.00,NULL,NULL),(45,'VDE','2015-01-07 00:00:00',95.00,107.71,'B','OPEN','BRK-8502',6.95,NULL,NULL),(46,'JFNIX','2015-01-16 00:00:00',8.35,54.68,'B','OPEN','401K-20963',0.00,NULL,NULL),(47,'JFNIX','2015-02-02 00:00:00',40.93,54.97,'B','OPEN','401K-20963',0.00,NULL,NULL),(48,'SPY','2014-10-15 00:00:00',55.00,184.13,'S','CLOSED','BRK-8502',0.00,'2016-12-07 00:00:00',223.00),(49,'JFNIX','2015-02-17 00:00:00',8.39,56.45,'B','OPEN','401K-20963',0.00,NULL,NULL),(50,'BLV','2015-02-24 00:00:00',155.00,96.16,'S','CLOSED','BRK-8502',6.95,'2015-03-30 00:00:00',96.19),(51,'KORS','2015-02-26 00:00:00',147.00,68.05,'B','OPEN','BRK-8502',0.00,NULL,NULL),(52,'JFNIX','2015-03-02 00:00:00',8.07,58.66,'B','OPEN','401K-20963',0.00,NULL,NULL),(53,'JFNIX','2015-03-16 00:00:00',7.86,60.19,'B','OPEN','401K-20963',0.00,NULL,NULL),(54,'JFNIX','2015-04-01 00:00:00',7.94,59.58,'B','OPEN','401K-20963',0.00,NULL,NULL),(55,'JFNIX','2015-04-16 00:00:00',7.54,62.81,'B','OPEN','401K-20963',0.00,NULL,NULL),(56,'JFNIX','2015-05-01 00:00:00',7.91,59.81,'B','OPEN','401K-20963',0.00,NULL,NULL),(57,'CPA','2015-05-19 00:00:00',82.00,90.94,'S','CLOSED','BRK-8502',6.95,'2017-04-03 00:00:00',112.50),(58,'JFNIX','2015-05-18 00:00:00',7.63,62.07,'B','OPEN','401K-20963',0.00,NULL,NULL),(59,'KORS','2015-05-29 00:00:00',130.00,46.68,'B','OPEN','BRK-8502',0.00,NULL,NULL),(60,'JFNIX','2015-06-01 00:00:00',7.58,62.46,'B','OPEN','401K-20963',0.00,NULL,NULL),(61,'JFNIX','2015-06-16 00:00:00',7.58,62.46,'B','OPEN','401K-20963',0.00,NULL,NULL),(62,'JFNIX','2015-07-01 00:00:00',7.55,62.72,'B','OPEN','401K-20963',0.00,NULL,NULL),(63,'JFNIX','2015-07-16 00:00:00',7.15,66.16,'B','OPEN','401K-20963',0.00,NULL,NULL),(64,'JFNIX','2015-08-03 00:00:00',7.20,65.71,'B','OPEN','401K-20963',0.00,NULL,NULL),(65,'SPY','2015-08-21 00:00:00',51.00,198.93,'S','CLOSED','BRK-8502',0.00,'2016-12-07 00:00:00',223.00),(66,'JFNIX','2015-08-17 00:00:00',7.35,64.41,'B','OPEN','401K-20963',0.00,NULL,NULL),(67,'JFNIX','2015-09-01 00:00:00',8.07,58.68,'B','OPEN','401K-20963',0.00,NULL,NULL),(68,'JFNIX','2015-09-16 00:00:00',7.71,61.38,'B','OPEN','401K-20963',0.00,NULL,NULL),(69,'JFNIX','2015-10-01 00:00:00',8.62,54.90,'B','OPEN','401K-20963',0.00,NULL,NULL),(70,'JFNIX','2015-10-16 00:00:00',8.44,56.08,'B','OPEN','401K-20963',0.00,NULL,NULL),(71,'JFNIX','2015-11-02 00:00:00',8.17,57.94,'B','OPEN','401K-20963',0.00,NULL,NULL),(72,'JFNIX','2015-11-16 00:00:00',8.56,55.31,'B','OPEN','401K-20963',0.00,NULL,NULL),(73,'JFNIX','2015-12-01 00:00:00',8.19,57.82,'B','OPEN','401K-20963',0.00,NULL,NULL),(74,'JFNIX','2015-12-16 00:00:00',8.25,57.35,'B','OPEN','401K-20963',0.00,NULL,NULL),(75,'JFNIX','2015-12-17 00:00:00',40.89,52.05,'B','OPEN','401K-20963',0.00,NULL,NULL),(76,'JFNIX','2015-12-31 00:00:00',9.05,52.31,'B','OPEN','401K-20963',0.00,NULL,NULL),(77,'VDE','2016-01-14 00:00:00',120.00,76.99,'B','OPEN','BRK-8502',6.95,NULL,NULL),(78,'MIDD','2016-01-26 00:00:00',133.00,85.10,'B','OPEN','BRK-8502',6.95,NULL,NULL),(79,'JFNIX','2016-01-19 00:00:00',10.28,46.04,'B','OPEN','401K-20963',0.00,NULL,NULL),(80,'JFNIX','2016-02-01 00:00:00',46.19,45.54,'B','OPEN','401K-20963',0.00,NULL,NULL),(81,'JFNIX','2016-02-16 00:00:00',11.09,44.04,'B','OPEN','401K-20963',0.00,NULL,NULL),(82,'JFNIX','2016-03-01 00:00:00',10.93,44.69,'B','OPEN','401K-20963',0.00,NULL,NULL),(83,'JFNIX','2016-03-16 00:00:00',11.13,43.88,'B','OPEN','401K-20963',0.00,NULL,NULL),(84,'JFNIX','2016-04-01 00:00:00',10.64,45.90,'B','OPEN','401K-20963',0.00,NULL,NULL),(85,'JFNIX','2016-04-18 00:00:00',10.27,47.54,'B','OPEN','401K-20963',0.00,NULL,NULL),(86,'JFNIX','2016-05-02 00:00:00',10.30,47.43,'B','OPEN','401K-20963',0.00,NULL,NULL),(87,'THRM','2016-05-18 00:00:00',213.00,35.11,'B','CLOSED','BRK-8502',0.00,'2017-07-11 00:00:00',39.25),(88,'JFNIX','2016-05-16 00:00:00',10.30,47.43,'B','OPEN','401K-20963',0.00,NULL,NULL),(89,'FXB','2016-06-27 00:00:00',60.00,130.00,'B','OPEN','BRK-8502',0.00,NULL,NULL),(90,'JFNIX','2016-06-01 00:00:00',10.04,48.64,'B','OPEN','401K-20963',0.00,NULL,NULL),(91,'JFNIX','2016-06-16 00:00:00',10.30,47.42,'B','OPEN','401K-20963',0.00,NULL,NULL),(92,'JFNIX','2016-07-01 00:00:00',10.11,48.30,'B','OPEN','401K-20963',0.00,NULL,NULL),(93,'JFNIX','2016-07-18 00:00:00',9.85,49.57,'B','OPEN','401K-20963',0.00,NULL,NULL),(94,'JFNIX','2016-08-01 00:00:00',9.47,51.57,'B','OPEN','401K-20963',0.00,NULL,NULL),(95,'JFNIX','2016-08-16 00:00:00',9.63,50.72,'B','OPEN','401K-20963',0.00,NULL,NULL),(96,'JFNIX','2016-09-01 00:00:00',9.85,49.57,'B','OPEN','401K-20963',0.00,NULL,NULL),(97,'JFNIX','2016-09-16 00:00:00',9.67,50.49,'B','OPEN','401K-20963',0.00,NULL,NULL),(98,'JFNIX','2016-10-03 00:00:00',9.81,49.80,'B','OPEN','401K-20963',0.00,NULL,NULL),(99,'JFNIX','2016-10-17 00:00:00',10.32,47.30,'B','OPEN','401K-20963',0.00,NULL,NULL),(100,'JFNIX','2016-11-01 00:00:00',10.84,45.05,'B','OPEN','401K-20963',0.00,NULL,NULL),(121,'JFNIX','2016-11-16 00:00:00',10.22,47.77,'B','OPEN','401K-20963',0.00,NULL,NULL),(122,'JFNIX','2016-12-01 00:00:00',10.67,45.77,'B','OPEN','401K-20963',0.00,NULL,NULL),(123,'DLTR','2017-01-04 00:00:00',59.00,79.60,'S','CLOSED','BRK-5QX13608',0.00,'2017-11-09 00:00:00',94.68),(124,'JFNIX','2016-12-16 00:00:00',10.51,46.45,'B','OPEN','401K-20963',0.00,NULL,NULL),(125,'JFNIX','2016-12-19 00:00:00',10.02,45.54,'B','OPEN','401K-20963',0.00,NULL,NULL),(126,'JFNIX','2016-12-30 00:00:00',10.78,45.29,'B','OPEN','401K-20963',0.00,NULL,NULL),(127,'JFNIX','2017-01-17 00:00:00',10.39,47.00,'B','OPEN','401K-20963',0.00,NULL,NULL),(128,'JFNIX','2017-02-01 00:00:00',57.37,47.58,'B','OPEN','401K-20963',0.00,NULL,NULL),(129,'JFNIX','2017-02-16 00:00:00',10.26,49.64,'B','OPEN','401K-20963',0.00,NULL,NULL),(130,'JFNIX','2017-03-01 00:00:00',10.02,50.79,'B','OPEN','401K-20963',0.00,NULL,NULL),(131,'JFNIX','2017-03-16 00:00:00',10.00,50.92,'B','OPEN','401K-20963',0.00,NULL,NULL),(132,'JFNIX','2017-04-03 00:00:00',10.07,50.53,'B','OPEN','401K-20963',0.00,NULL,NULL),(133,'JFNIX','2017-04-18 00:00:00',10.21,49.87,'B','OPEN','401K-20963',0.00,NULL,NULL),(134,'JFNIX','2017-05-01 00:00:00',9.80,51.93,'B','OPEN','401K-20963',0.00,NULL,NULL),(135,'JFNIX','2017-05-16 00:00:00',9.79,52.02,'B','OPEN','401K-20963',0.00,NULL,NULL),(136,'JFNIX','2017-06-01 00:00:00',9.66,52.70,'B','OPEN','401K-20963',0.00,NULL,NULL),(137,'JHG','2017-06-05 00:00:00',29.00,34.48,'B','OPEN','401K-20963',0.00,NULL,NULL),(138,'JFNIX','2017-06-16 00:00:00',9.58,53.14,'B','OPEN','401K-20963',0.00,NULL,NULL),(139,'JFNIX','2017-07-03 00:00:00',9.36,54.36,'B','OPEN','401K-20963',0.00,NULL,NULL),(140,'JFNIX','2017-07-17 00:00:00',9.24,55.12,'B','OPEN','401K-20963',0.00,NULL,NULL),(141,'JFNIX','2017-08-01 00:00:00',9.32,54.61,'B','OPEN','401K-20963',0.00,NULL,NULL),(142,'JFNIX','2017-08-16 00:00:00',9.41,54.08,'B','OPEN','401K-20963',0.00,NULL,NULL),(143,'JFNIX','2017-09-01 00:00:00',9.12,55.81,'B','OPEN','401K-20963',0.00,NULL,NULL),(144,'JFNIX','2017-09-18 00:00:00',9.06,56.17,'B','OPEN','401K-20963',0.00,NULL,NULL),(145,'JFNIX','2017-10-02 00:00:00',8.90,57.22,'B','OPEN','401K-20963',0.00,NULL,NULL),(146,'JFNIX','2017-10-16 00:00:00',9.05,56.25,'B','OPEN','401K-20963',0.00,NULL,NULL),(147,'JFNIX','2017-11-01 00:00:00',9.38,54.29,'B','OPEN','401K-20963',0.00,NULL,NULL),(148,'WDC','2017-12-01 00:00:00',71.00,78.76,'B','OPEN','BRK-5QX13608',0.00,NULL,NULL);
/*!40000 ALTER TABLE `trades` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `watchlist`
--
DROP TABLE IF EXISTS `watchlist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `watchlist` (
`watch_list_id` int(11) NOT NULL,
`symbol` varchar(15) NOT NULL,
PRIMARY KEY (`watch_list_id`,`symbol`),
KEY `watch_list_id` (`watch_list_id`),
CONSTRAINT `FK_WatchList_WatchLists` FOREIGN KEY (`watch_list_id`) REFERENCES `watchlists` (`watch_list_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `watchlist`
--
LOCK TABLES `watchlist` WRITE;
/*!40000 ALTER TABLE `watchlist` DISABLE KEYS */;
INSERT INTO `watchlist` VALUES (1,'AAPL'),(1,'AER'),(1,'AGI'),(1,'AKS'),(1,'AMZN'),(1,'ANSS'),(1,'APAM'),(1,'APEI'),(1,'APH'),(1,'ATHM'),(1,'AVG'),(1,'BGSF'),(1,'BIICX'),(1,'BLV'),(1,'BOND'),(1,'BSV'),(1,'BUFF'),(1,'BWLD'),(1,'CBPO'),(1,'CE'),(1,'CELG'),(1,'CF'),(1,'CHEF'),(1,'CHK'),(1,'CLR'),(1,'CMI'),(1,'CPA'),(1,'CSRSX'),(1,'CTSH'),(1,'DGAGX'),(1,'DIA'),(1,'DLPH'),(1,'DLTR'),(1,'EWS'),(1,'EZPW'),(1,'FOSL'),(1,'FSDAX'),(1,'FTSE'),(1,'FXB'),(1,'FXE'),(1,'FXN'),(1,'GACIX'),(1,'GBTC'),(1,'GILD'),(1,'GLD'),(1,'GLP'),(1,'GMCR'),(1,'GOLD'),(1,'GOVT'),(1,'GURE'),(1,'GYLD'),(1,'HA'),(1,'HFC'),(1,'HGG'),(1,'HMCJX'),(1,'IAU'),(1,'IBB'),(1,'IJH'),(1,'IJR'),(1,'IPGP'),(1,'IXJ'),(1,'IYF'),(1,'JETS'),(1,'JFNIX'),(1,'JHG'),(1,'KBWD'),(1,'KORS'),(1,'LLTC'),(1,'LMT'),(1,'LOPE'),(1,'LULU'),(1,'MBUU'),(1,'MDY'),(1,'MELI'),(1,'MIDD'),(1,'MRFIX'),(1,'MSTR'),(1,'NFLX'),(1,'NOV'),(1,'NTRI'),(1,'NVDA'),(1,'OCINY'),(1,'OIGYX'),(1,'OIH'),(1,'PAYC'),(1,'PCLN'),(1,'PDLI'),(1,'PFF'),(1,'QIWI'),(1,'RCL'),(1,'RYT'),(1,'SAVE'),(1,'SEDG'),(1,'SH'),(1,'SPY'),(1,'SQ'),(1,'SWI'),(1,'TARO'),(1,'THRM'),(1,'TOLIX'),(1,'UDN'),(1,'UNG'),(1,'UNH'),(1,'USNA'),(1,'UUP'),(1,'UVXY'),(1,'VDE'),(1,'VGLT'),(1,'VIXM'),(1,'VMW'),(1,'VNQ'),(1,'VXUS'),(1,'VXX'),(1,'VYM'),(1,'WDC'),(1,'WDDYF'),(1,'WFC'),(1,'WMFFX'),(1,'XBI'),(1,'XLP'),(1,'XLY'),(1,'^VIX'),(3,'BSV'),(3,'CHEF'),(3,'MIDD'),(3,'SPY'),(3,'UNH'),(3,'VXUS'),(3,'VYM'),(4,'AOK'),(4,'CNPF'),(4,'DES'),(4,'DGRS'),(4,'DGRW'),(4,'DHS'),(4,'DIV'),(4,'DON'),(4,'DTD'),(4,'DTN'),(4,'EPU'),(4,'FPE'),(4,'GYLD'),(4,'HFIN'),(4,'HSPX'),(4,'IPFF'),(4,'IYLD'),(4,'KBWD'),(4,'KBWY'),(4,'PEY'),(4,'PFF'),(4,'PGF'),(4,'RDIV'),(4,'SDIV'),(4,'SPHD'),(4,'TGR'),(4,'TZD'),(4,'YDIV'),(4,'YYY');
/*!40000 ALTER TABLE `watchlist` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `watchlists`
--
DROP TABLE IF EXISTS `watchlists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `watchlists` (
`watch_list_id` int(11) NOT NULL AUTO_INCREMENT,
`watch_list_name` varchar(255) NOT NULL,
PRIMARY KEY (`watch_list_id`),
UNIQUE KEY `watch_list_id` (`watch_list_id`),
KEY `watch_list_id_2` (`watch_list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `watchlists`
--
LOCK TABLES `watchlists` WRITE;
/*!40000 ALTER TABLE `watchlists` DISABLE KEYS */;
INSERT INTO `watchlists` VALUES (1,'Valuations'),(3,'Portfolio'),(4,'Dividend');
/*!40000 ALTER TABLE `watchlists` 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 2017-12-04 9:59:38
Reference in New Issue View Git Blame Copy Permalink