PREVIEW / stock_daily / 2014-07-01

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-01.parquet
  size:    221 KB
  rows:    6,597
  symbols: 3,579

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-07-01	AAPL	Stock	23.38	23.5175	23.2825	23.38	152892000.0
2014-07-01	MSFT	Stock	41.86	42.15	41.69	41.87	26917000.0
2014-07-01	NVDA	Stock	0.463	0.4715	0.4615	0.4688	321180000.0
2014-07-01	AMZN	Stock	16.293	16.66	16.255	16.6195	63472000.0
2014-07-01	GOOGL	Stock	29.3825	29.683	29.3145	29.5745	32892560.0
2014-07-01	META	Stock	67.58	68.44	67.39	68.06	33243000.0
2014-07-01	TSLA	Stock	16.164	16.2293	15.9133	15.9813	65041500.0
2014-07-01	TLT	Stock	112.5	112.74	112.2	112.28	8019205.0
2014-07-01	ES	Stock	47.33	47.37	46.66	46.68	1275600.0
2014-07-01	CL	Stock	68.5	68.6	67.95	68.48	2150000.0
2014-07-01	A	Stock	41.3019	41.8026	41.0443	41.6667	2811098.0
2014-07-01	AABA-DELISTED	Stock	35.5	35.7	35.21	35.35	17284401.0
2014-07-01	AACG	Stock	4.64	4.64	4.49	4.49	1700.0
2014-07-01	AAIC-DELISTED	Stock	27.25	27.54	27.25	27.26	256762.0
2014-07-01	AAL	Stock	43.44	43.9	43.05	43.86	9162600.0
2014-07-01	AAMC-DELISTED	Stock	216.1765	216.1765	188.0897	191.0676	246354.0
2014-07-01	AAME	Stock	3.97	3.97	3.97	3.97	3800.0
2014-07-01	AAOI	Stock	23.23	23.69	22.67	23.34	188100.0
2014-07-01	AAON	Stock	14.9956	15.3956	14.8044	15.1911	329625.0
2014-07-01	AAP	Stock	135.86	135.95	134.35	134.53	1085900.0
2014-07-01	AAT	Stock	34.67	35.03	34.25	34.92	164500.0
2014-07-01	AAU-DELISTED	Stock	1.4	1.45	1.4	1.43	63187.0
2014-07-01	AAUAF-DELISTED	Stock	1.4	1.45	1.4	1.43	63726.0
2014-07-01	AAV-DELISTED	Stock	6.7	6.72	6.6	6.615	178667.0
2014-07-01	AAWW-DELISTED	Stock	36.87	37.25	36.57	37.14	141896.0
2014-07-01	AAXJ	Stock	63.0	63.24	62.97	63.22	704071.0
2014-07-01	AAXN-DELISTED	Stock	13.35	13.7399	13.2	13.51	1066804.0
2014-07-01	AB	Stock	25.99	26.25	25.81	26.05	230800.0
2014-07-01	ABAC-DELISTED	Stock	2.03	2.07	2.03	2.07	16413.0
2014-07-01	ABAX-DELISTED	Stock	44.6	46.07	44.32	46.045	145872.0
2014-07-01	ABB-DELISTED	Stock	22.97	23.11	22.95	23.02	981048.0
2014-07-01	ABBNY-DELISTED	Stock	22.97	23.11	22.95	23.01	1070154.0
2014-07-01	ABBV	Stock	56.42	57.2	56.17	56.89	6869800.0
2014-07-01	ABC-DELISTED	Stock	72.67	73.26	72.59	72.99	937034.0
2014-07-01	ABCB	Stock	21.6	22.39	21.6	22.09	70800.0
2014-07-01	ABCD-DELISTED	Stock	2.13	2.22	2.06	2.07	6016.0
2014-07-01	ABCO-DELISTED	Stock	52.0	52.73	51.79	51.85	158283.0
2014-07-01	ABDC-DELISTED	Stock	14.9	15.04	14.3106	15.0	51513.0
2014-07-01	ABE-DELISTED	Stock	14.39	14.4799	14.3742	14.46	11108.0
2014-07-01	ABEO	Stock	387.5	387.5	375.0	375.0	6.0
2014-07-01	ABEV	Stock	7.09	7.19	7.08	7.18	6953600.0
2014-07-01	ABG	Stock	68.72	70.42	68.51	69.38	444900.0
2014-07-01	ABGB-DELISTED	Stock	26.73	26.89	26.45	26.8004	4865.0
2014-07-01	ABM	Stock	26.82	27.45	26.71	27.2	280800.0
2014-07-01	ABMD-DELISTED	Stock	25.24	25.92	25.24	25.42	300034.0
2014-07-01	ABR	Stock	7.0	7.04	6.95	7.0	77600.0
2014-07-01	ABR.A-DELISTED	Stock	24.6	24.67	24.5	24.58	14890.0
2014-07-01	ABR.B-DELISTED	Stock	24.639	24.639	24.501	24.6	2200.0
2014-07-01	ABR.C-DELISTED	Stock	25.11	25.11	25.08	25.1	2600.0
2014-07-01	ABRN-DELISTED	Stock	25.05	25.05	24.8601	24.93	14836.0

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

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