PREVIEW / stock_daily / 2014-03-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-19.parquet
  size:    218 KB
  rows:    6,490
  symbols: 3,544

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-03-19	AAPL	Stock	19.0093	19.1514	18.8929	18.9736	224756000.0
2014-03-19	MSFT	Stock	39.47	39.55	38.91	39.27	35597200.0
2014-03-19	NVDA	Stock	0.4595	0.4728	0.4582	0.464	366168000.0
2014-03-19	AMZN	Stock	18.9385	18.95	18.471	18.6615	52934000.0
2014-03-19	META	Stock	69.17	69.29	67.47	68.24	43981000.0
2014-03-19	TSLA	Stock	16.0927	16.1033	15.5673	15.7227	76069500.0
2014-03-19	TLT	Stock	107.92	107.98	106.81	107.26	11557635.0
2014-03-19	ES	Stock	45.23	45.34	44.22	44.41	1517500.0
2014-03-19	CL	Stock	64.27	64.32	63.14	63.39	2285500.0
2014-03-19	A	Stock	40.5722	40.8798	40.186	40.5079	2522551.0
2014-03-19	AABA-DELISTED	Stock	39.7	39.94	38.51	38.62	18429303.0
2014-03-19	AACG	Stock	4.32	4.32	4.25	4.25	6800.0
2014-03-19	AAIC-DELISTED	Stock	27.84	28.0	27.56	27.77	171726.0
2014-03-19	AAL	Stock	37.27	37.63	36.68	37.08	3863100.0
2014-03-19	AAMC-DELISTED	Stock	291.2382	314.9353	290.0	311.7647	212765.0
2014-03-19	AAME	Stock	3.6	3.63	3.51	3.51	12600.0
2014-03-19	AAOI	Stock	25.48	26.45	24.62	26.34	160800.0
2014-03-19	AAON	Stock	12.6622	12.9111	12.6089	12.8844	358425.0
2014-03-19	AAP	Stock	125.84	126.5	123.48	124.52	575500.0
2014-03-19	AAT	Stock	33.71	34.04	33.08	33.38	146500.0
2014-03-19	AAU-DELISTED	Stock	1.49	1.5	1.45	1.47	225828.0
2014-03-19	AAUAF-DELISTED	Stock	1.49	1.5	1.45	1.47	229849.0
2014-03-19	AAV-DELISTED	Stock	4.19	4.27	4.19	4.22	139917.0
2014-03-19	AAWW-DELISTED	Stock	32.17	32.89	32.15	32.57	153674.0
2014-03-19	AAXJ	Stock	57.45	57.48	56.44	56.72	387458.0
2014-03-19	AAXN-DELISTED	Stock	18.55	18.79	18.06	18.23	913302.0
2014-03-19	AB	Stock	25.62	25.94	24.97	25.29	425000.0
2014-03-19	ABAC-DELISTED	Stock	1.86	1.86	1.732	1.78	30096.0
2014-03-19	ABAX-DELISTED	Stock	39.57	39.9699	39.13	39.66	97797.0
2014-03-19	ABB-DELISTED	Stock	25.37	25.38	24.76	24.96	1414659.0
2014-03-19	ABBNY-DELISTED	Stock	25.38	25.38	24.76	24.97	1504240.0
2014-03-19	ABBV	Stock	53.09	53.53	52.44	53.11	6408600.0
2014-03-19	ABC-DELISTED	Stock	68.05	68.1	66.59	66.87	1229354.0
2014-03-19	ABCB	Stock	23.9	24.01	23.56	23.88	69700.0
2014-03-19	ABCD-DELISTED	Stock	2.11	2.13	2.0201	2.05	27748.0
2014-03-19	ABCO-DELISTED	Stock	68.62	68.64	67.73	68.32	102124.0
2014-03-19	ABE-DELISTED	Stock	12.66	12.7	12.51	12.51	22160.0
2014-03-19	ABEO	Stock	612.5	612.5	562.5	600.0	28.0
2014-03-19	ABEV	Stock	7.03	7.2	7.02	7.11	10022900.0
2014-03-19	ABFS-DELISTED	Stock	36.51	36.7	35.95	36.4	273163.0
2014-03-19	ABG	Stock	53.98	53.99	53.47	53.75	169600.0
2014-03-19	ABGB-DELISTED	Stock	23.29	23.409	22.67	22.85	10964.0
2014-03-19	ABIL-DELISTED	Stock	9.63	9.71	9.62	9.64	892.0
2014-03-19	ABM	Stock	28.79	29.0	28.58	28.73	169800.0
2014-03-19	ABMD-DELISTED	Stock	25.63	27.1	25.57	26.77	1060080.0
2014-03-19	ABR	Stock	6.76	6.83	6.7	6.71	147000.0
2014-03-19	ABR.A-DELISTED	Stock	24.45	24.45	24.45	24.45	100.0
2014-03-19	ABR.B-DELISTED	Stock	23.0	23.0	22.82	22.82	4950.0
2014-03-19	ABR.C-DELISTED	Stock	24.75	24.8	24.73	24.7799	14434.0
2014-03-19	ABT	Stock	39.73	40.22	39.32	39.45	8679100.0

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

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