PREVIEW / stock_daily / 2014-09-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-10.parquet
  size:    222 KB
  rows:    6,620
  symbols: 3,570

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
2014-09-10	AAPL	Stock	24.5025	25.2775	24.44	25.25	403478400.0
2014-09-10	MSFT	Stock	46.82	46.94	46.28	46.84	27302400.0
2014-09-10	NVDA	Stock	0.4912	0.492	0.4858	0.4902	172376000.0
2014-09-10	AMZN	Stock	16.715	16.749	16.441	16.5665	75948000.0
2014-09-10	GOOGL	Stock	29.587	29.686	29.357	29.671	23205820.0
2014-09-10	META	Stock	76.52	77.95	76.51	77.43	29909000.0
2014-09-10	TSLA	Stock	18.6333	18.7607	18.244	18.74	56719500.0
2014-09-10	TLT	Stock	114.97	115.12	114.79	114.96	8729422.0
2014-09-10	ES	Stock	45.79	45.9	45.35	45.47	1907000.0
2014-09-10	CL	Stock	63.5	64.08	63.36	64.0	2769700.0
2014-09-10	A	Stock	41.2017	41.3662	40.9013	41.2661	2066104.0
2014-09-10	AABA-DELISTED	Stock	41.06	41.23	40.33	41.14	28399654.0
2014-09-10	AACG	Stock	4.53	4.64	4.52	4.63	6500.0
2014-09-10	AAIC-DELISTED	Stock	27.62	27.75	27.52	27.61	234785.0
2014-09-10	AAL	Stock	37.93	38.87	37.91	38.58	8107500.0
2014-09-10	AAMC-DELISTED	Stock	206.1765	206.7647	205.8824	206.2088	82623.0
2014-09-10	AAME	Stock	4.07	4.07	3.94	4.07	3400.0
2014-09-10	AAOI	Stock	19.12	19.55	18.75	19.21	101100.0
2014-09-10	AAON	Stock	12.3933	12.4733	12.2867	12.4467	132150.0
2014-09-10	AAP	Stock	136.07	136.3	134.56	135.9	402600.0
2014-09-10	AAT	Stock	34.95	34.97	34.49	34.63	122800.0
2014-09-10	AAU-DELISTED	Stock	1.46	1.52	1.46	1.49	105147.0
2014-09-10	AAUAF-DELISTED	Stock	1.46	1.52	1.46	1.49	113235.0
2014-09-10	AAV-DELISTED	Stock	5.72	5.78	5.61	5.76	241245.0
2014-09-10	AAVL-DELISTED	Stock	29.69	31.49	29.61	30.74	45859.0
2014-09-10	AAWW-DELISTED	Stock	34.04	34.08	33.295	33.99	109721.0
2014-09-10	AAXJ	Stock	64.95	65.35	64.68	65.28	460130.0
2014-09-10	AAXN-DELISTED	Stock	17.2	17.83	17.05	17.73	2223304.0
2014-09-10	AB	Stock	26.79	27.11	26.63	27.03	125000.0
2014-09-10	ABAC-DELISTED	Stock	1.251	1.37	1.23	1.37	55373.0
2014-09-10	ABAX-DELISTED	Stock	48.97	49.06	48.335	48.97	76890.0
2014-09-10	ABB-DELISTED	Stock	22.89	23.02	22.8499	23.0	1174790.0
2014-09-10	ABBNY-DELISTED	Stock	22.89	23.02	22.8499	23.0	1782046.0
2014-09-10	ABBV	Stock	56.9	57.32	56.51	57.19	8740300.0
2014-09-10	ABC-DELISTED	Stock	78.15	78.34	77.82	77.96	823749.0
2014-09-10	ABCB	Stock	22.79	23.13	22.78	23.08	46100.0
2014-09-10	ABCD-DELISTED	Stock	1.53	1.57	1.52	1.52	11149.0
2014-09-10	ABCO-DELISTED	Stock	47.32	48.6713	47.28	48.42	304866.0
2014-09-10	ABDC-DELISTED	Stock	13.75	13.93	13.7	13.84	36671.0
2014-09-10	ABE-DELISTED	Stock	14.6	14.66	14.56	14.62	43384.0
2014-09-10	ABEO	Stock	375.0	400.0	375.0	400.0	2.0
2014-09-10	ABEV	Stock	6.82	6.91	6.76	6.9	13968200.0
2014-09-10	ABG	Stock	69.44	69.66	68.34	69.0	322300.0
2014-09-10	ABGB-DELISTED	Stock	28.03	28.3	28.0	28.3	13162.0
2014-09-10	ABM	Stock	27.88	28.01	27.64	27.8	228300.0
2014-09-10	ABMD-DELISTED	Stock	25.01	25.11	24.69	24.83	224350.0
2014-09-10	ABR	Stock	6.86	6.86	6.76	6.77	122600.0
2014-09-10	ABR.A-DELISTED	Stock	24.87	24.87	24.8462	24.8462	500.0
2014-09-10	ABR.B-DELISTED	Stock	24.18	24.18	23.81	24.09	13033.0
2014-09-10	ABR.C-DELISTED	Stock	25.15	25.25	25.15	25.25	3348.0

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

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