PREVIEW / stock_daily / 2016-02-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-09.parquet
  size:    216 KB
  rows:    6,556
  symbols: 3,333

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2016-02-09	AAPL	Stock	23.5725	23.985	23.4825	23.7475	177324800.0
2016-02-09	MSFT	Stock	49.02	50.24	48.67	49.28	46740500.0
2016-02-09	NVDA	Stock	0.623	0.6638	0.62	0.6372	425372000.0
2016-02-09	AMZN	Stock	23.9005	24.919	23.7	24.1035	141558000.0
2016-02-09	GOOGL	Stock	34.6475	36.048	34.425	35.051	84299000.0
2016-02-09	META	Stock	97.14	102.4	96.82	99.54	62709000.0
2016-02-09	TSLA	Stock	9.488	10.6527	9.4033	9.8833	129774000.0
2016-02-09	TLT	Stock	132.04	132.06	130.96	131.63	15232056.0
2016-02-09	ES	Stock	54.0	54.9	53.84	54.69	3068300.0
2016-02-09	CL	Stock	65.48	66.31	64.93	65.88	4423900.0
2016-02-09	A	Stock	34.21	35.77	34.15	35.37	3464500.0
2016-02-09	AA.B-DELISTED	Stock	26.53	28.2296	26.53	27.37	17010.0
2016-02-09	AAAP-DELISTED	Stock	24.0	25.23	23.89	24.06	20191.0
2016-02-09	AABA-DELISTED	Stock	26.65	27.69	26.51	26.82	13550664.0
2016-02-09	AAC-DELISTED	Stock	19.15	19.85	18.37	19.45	220433.0
2016-02-09	AACG	Stock	5.21	5.34	5.17	5.2	4900.0
2016-02-09	AAIC-DELISTED	Stock	11.2	11.23	10.78	10.95	352285.0
2016-02-09	AAL	Stock	34.93	36.75	34.91	36.19	11143300.0
2016-02-09	AAMC-DELISTED	Stock	4.4765	4.5059	4.2706	4.3206	103601.0
2016-02-09	AAME	Stock	4.48	4.48	4.28	4.4	2800.0
2016-02-09	AAMI	Stock	10.74	11.13	10.74	10.89	169000.0
2016-02-09	AAOI	Stock	14.44	15.55	14.29	14.53	371200.0
2016-02-09	AAON	Stock	13.4933	13.74	13.3	13.4	186600.0
2016-02-09	AAP	Stock	141.15	143.64	139.13	141.5	1239800.0
2016-02-09	AAT	Stock	35.35	35.97	34.51	34.61	305100.0
2016-02-09	AAU-DELISTED	Stock	0.61	0.6526	0.61	0.614	56080.0
2016-02-09	AAUAF-DELISTED	Stock	0.61	0.6526	0.61	0.614	56410.0
2016-02-09	AAV-DELISTED	Stock	5.69	5.69	5.35	5.37	66975.0
2016-02-09	AAVL-DELISTED	Stock	4.1	4.27	4.0	4.15	382050.0
2016-02-09	AAWW-DELISTED	Stock	34.67	35.7	34.48	35.23	91716.0
2016-02-09	AAXJ	Stock	47.37	48.0	47.09	47.53	1144329.0
2016-02-09	AAXN-DELISTED	Stock	15.1	15.45	14.84	15.36	966245.0
2016-02-09	AB	Stock	16.51	17.39	16.5	17.27	298100.0
2016-02-09	ABAC-DELISTED	Stock	0.7386	0.7386	0.7386	0.7386	400.0
2016-02-09	ABAX-DELISTED	Stock	40.08	40.705	39.475	39.77	319941.0
2016-02-09	ABB-DELISTED	Stock	16.84	17.065	16.79	16.98	3119298.0
2016-02-09	ABBNY-DELISTED	Stock	16.84	17.065	16.79	16.98	6043286.0
2016-02-09	ABBV	Stock	52.31	53.94	52.06	53.48	7655800.0
2016-02-09	ABC-DELISTED	Stock	82.69	85.04	82.62	84.75	2523209.0
2016-02-09	ABCB	Stock	25.52	26.64	25.46	26.26	279100.0
2016-02-09	ABCD-DELISTED	Stock	3.84	4.07	3.7701	3.81	27620.0
2016-02-09	ABCO-DELISTED	Stock	41.3	42.27	39.505	40.37	253577.0
2016-02-09	ABCW-DELISTED	Stock	40.75	41.7	40.75	41.3	60242.0
2016-02-09	ABDC-DELISTED	Stock	9.7	9.89	9.04	9.05	40883.0
2016-02-09	ABE-DELISTED	Stock	9.99	10.2483	9.99	10.24	3396.0
2016-02-09	ABEO	Stock	60.25	63.25	56.75	61.5	1320.0
2016-02-09	ABEV	Stock	4.51	4.57	4.41	4.45	16884100.0
2016-02-09	ABG	Stock	45.45	49.08	45.38	47.02	966200.0
2016-02-09	ABGB-DELISTED	Stock	0.92	0.92	0.86	0.873	8173.0
2016-02-09	ABIL-DELISTED	Stock	7.1	7.1	6.18	6.48	25761.0

> showing 50 of 6,556 rows — these rows as CSV

> unlock the full archive -- $79 one-time