PREVIEW / stock_daily / 2015-02-12

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-12.parquet
  size:    222 KB
  rows:    6,642
  symbols: 3,526

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
2015-02-12	AAPL	Stock	31.515	31.87	31.3925	31.615	297898000.0
2015-02-12	MSFT	Stock	42.66	43.09	42.51	43.09	33268800.0
2015-02-12	NVDA	Stock	0.55	0.5625	0.5468	0.5575	676904000.0
2015-02-12	AMZN	Stock	18.755	18.9255	18.6575	18.8585	55822000.0
2015-02-12	GOOGL	Stock	26.983	27.417	26.85	27.3005	48590400.0
2015-02-12	META	Stock	76.86	76.87	75.89	76.23	17235000.0
2015-02-12	TSLA	Stock	12.9047	13.5393	12.8853	13.5253	234744000.0
2015-02-12	TLT	Stock	129.66	130.541	129.45	129.52	12548329.0
2015-02-12	ES	Stock	53.4	53.97	52.15	52.3	3488000.0
2015-02-12	CL	Stock	69.32	69.86	69.32	69.85	2829900.0
2015-02-12	A	Stock	39.58	40.06	39.53	40.02	1317700.0
2015-02-12	AA.B-DELISTED	Stock	50.1	50.5	49.81	50.18	250372.0
2015-02-12	AABA-DELISTED	Stock	42.96	44.16	42.86	43.93	17291678.0
2015-02-12	AAC-DELISTED	Stock	27.9631	29.76	27.71	28.12	47536.0
2015-02-12	AACG	Stock	4.22	4.44	4.22	4.35	12500.0
2015-02-12	AAIC-DELISTED	Stock	24.82	25.107	24.72	25.06	361782.0
2015-02-12	AAL	Stock	46.75	48.5	46.4	47.88	9542800.0
2015-02-12	AAMC-DELISTED	Stock	52.9118	53.4559	51.7647	53.4559	9394.0
2015-02-12	AAME	Stock	3.98	3.98	3.97	3.97	1100.0
2015-02-12	AAMI	Stock	16.18	16.47	15.6	16.23	257400.0
2015-02-12	AAOI	Stock	10.27	10.775	10.105	10.2	310500.0
2015-02-12	AAON	Stock	15.4	15.66	15.3867	15.6	131100.0
2015-02-12	AAP	Stock	155.0	157.07	150.95	151.42	4046100.0
2015-02-12	AAT	Stock	42.59	43.0	42.27	42.96	112700.0
2015-02-12	AAU-DELISTED	Stock	1.1	1.1	1.0695	1.071	211206.0
2015-02-12	AAUAF-DELISTED	Stock	1.1	1.1	1.07	1.071	217335.0
2015-02-12	AAV-DELISTED	Stock	4.76	4.97	4.67	4.94	153803.0
2015-02-12	AAVL-DELISTED	Stock	36.23	36.78	35.31	36.28	227237.0
2015-02-12	AAWW-DELISTED	Stock	47.47	51.0	43.75	47.565	907668.0
2015-02-12	AAXJ	Stock	62.88	63.22	62.8	63.17	1033607.0
2015-02-12	AAXN-DELISTED	Stock	26.36	27.39	26.36	27.39	1217924.0
2015-02-12	AB	Stock	25.41	26.87	25.1	26.7	582900.0
2015-02-12	ABAC-DELISTED	Stock	1.59	1.5901	1.59	1.5901	800.0
2015-02-12	ABAX-DELISTED	Stock	58.85	60.51	58.502	60.25	106625.0
2015-02-12	ABB-DELISTED	Stock	20.91	21.12	20.9	21.065	1352113.0
2015-02-12	ABBNY-DELISTED	Stock	20.91	21.12	20.9	21.07	1415683.0
2015-02-12	ABBV	Stock	57.4	57.58	56.16	57.05	11940900.0
2015-02-12	ABC-DELISTED	Stock	98.83	99.85	98.23	99.8	2034622.0
2015-02-12	ABCB	Stock	24.94	25.57	24.84	25.51	73700.0
2015-02-12	ABCD-DELISTED	Stock	2.5899	2.59	2.51	2.5768	12691.0
2015-02-12	ABCO-DELISTED	Stock	54.8	56.49	52.06	53.36	775754.0
2015-02-12	ABCW-DELISTED	Stock	32.57	33.48	32.57	33.48	5348.0
2015-02-12	ABDC-DELISTED	Stock	13.54	13.66	13.25	13.4	33921.0
2015-02-12	ABE-DELISTED	Stock	12.94	13.1228	12.94	13.1162	3522.0
2015-02-12	ABEO	Stock	77.75	77.75	72.0	77.5	112.0
2015-02-12	ABEOW-DELISTED	Stock	0.95	0.95	0.93	0.93	7500.0
2015-02-12	ABEV	Stock	6.38	6.45	6.34	6.44	11027900.0
2015-02-12	ABG	Stock	79.12	80.81	78.18	80.36	404600.0
2015-02-12	ABGB-DELISTED	Stock	15.07	15.28	15.07	15.17	62978.0
2015-02-12	ABM	Stock	29.61	29.78	29.41	29.74	144100.0

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

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