PREVIEW / stock_daily / 2014-06-13

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-13.parquet
  size:    219 KB
  rows:    6,533
  symbols: 3,534

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-06-13	AAPL	Stock	23.05	23.11	22.72	22.82	218100000.0
2014-06-13	MSFT	Stock	41.1	41.57	40.86	41.23	26310000.0
2014-06-13	NVDA	Stock	0.493	0.4932	0.4838	0.4885	227852000.0
2014-06-13	AMZN	Stock	16.3525	16.465	16.1765	16.3135	55296000.0
2014-06-13	GOOGL	Stock	28.004	28.0325	27.686	28.0175	27066860.0
2014-06-13	META	Stock	64.7	64.97	63.83	64.5	29419000.0
2014-06-13	TSLA	Stock	13.652	13.786	13.4387	13.7613	53164500.0
2014-06-13	TLT	Stock	111.57	112.62	111.53	112.15	5413846.0
2014-06-13	ES	Stock	45.06	45.49	44.8	45.36	1078800.0
2014-06-13	CL	Stock	67.78	67.97	67.72	67.86	1559000.0
2014-06-13	A	Stock	41.867	42.1102	41.6166	41.8455	1474750.0
2014-06-13	AABA-DELISTED	Stock	36.88	37.06	36.64	36.94	12542724.0
2014-06-13	AACG	Stock	4.76	4.76	4.54	4.6	5900.0
2014-06-13	AAIC-DELISTED	Stock	27.74	27.82	27.55	27.66	222506.0
2014-06-13	AAL	Stock	40.25	40.92	39.55	40.38	13586100.0
2014-06-13	AAMC-DELISTED	Stock	317.6735	320.5588	316.3618	320.5588	17728.0
2014-06-13	AAME	Stock	3.9	3.9	3.7	3.84	6900.0
2014-06-13	AAOI	Stock	22.01	22.01	21.27	21.86	113500.0
2014-06-13	AAON	Stock	14.3644	14.3644	14.0533	14.1556	207900.0
2014-06-13	AAP	Stock	124.65	124.84	123.36	124.8	439800.0
2014-06-13	AAT	Stock	34.03	34.03	33.46	33.87	86700.0
2014-06-13	AAU-DELISTED	Stock	1.48	1.48	1.4	1.45	117220.0
2014-06-13	AAUAF-DELISTED	Stock	1.46	1.46	1.399	1.45	120640.0
2014-06-13	AAV-DELISTED	Stock	6.79	6.96	6.7	6.95	336086.0
2014-06-13	AAWW-DELISTED	Stock	37.17	37.68	36.5	37.29	130407.0
2014-06-13	AAXJ	Stock	62.67	62.76	62.47	62.74	329803.0
2014-06-13	AAXN-DELISTED	Stock	14.09	14.09	13.62	13.87	461106.0
2014-06-13	AB	Stock	25.26	25.54	25.04	25.36	433500.0
2014-06-13	ABAC-DELISTED	Stock	2.19	2.19	2.13	2.15	44981.0
2014-06-13	ABAX-DELISTED	Stock	43.31	43.35	43.0	43.19	78000.0
2014-06-13	ABB-DELISTED	Stock	23.24	23.28	23.15	23.27	2297513.0
2014-06-13	ABBNY-DELISTED	Stock	23.24	23.28	23.15	23.27	2489233.0
2014-06-13	ABBV	Stock	53.67	54.31	53.44	54.16	4413000.0
2014-06-13	ABC-DELISTED	Stock	71.45	71.9	71.0	71.79	1136204.0
2014-06-13	ABCB	Stock	21.81	22.03	21.43	21.52	28800.0
2014-06-13	ABCD-DELISTED	Stock	2.04	2.17	1.99	2.09	79503.0
2014-06-13	ABCO-DELISTED	Stock	49.91	50.28	49.14	49.91	148241.0
2014-06-13	ABDC-DELISTED	Stock	14.4345	15.0	14.38	14.6	38184.0
2014-06-13	ABE-DELISTED	Stock	14.64	14.64	14.55	14.55	6300.0
2014-06-13	ABEO	Stock	400.0	412.5	400.0	412.5	5.0
2014-06-13	ABEV	Stock	7.19	7.19	7.05	7.09	6652600.0
2014-06-13	ABG	Stock	62.66	62.84	61.65	62.28	174100.0
2014-06-13	ABGB-DELISTED	Stock	27.57	28.19	27.19	27.82	19942.0
2014-06-13	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	3435.0
2014-06-13	ABM	Stock	26.84	26.84	26.41	26.46	194400.0
2014-06-13	ABMD-DELISTED	Stock	23.16	23.2	22.82	22.95	109062.0
2014-06-13	ABR	Stock	7.08	7.18	7.08	7.15	109500.0
2014-06-13	ABR.A-DELISTED	Stock	24.24	24.2999	24.2101	24.27	6134.0
2014-06-13	ABR.C-DELISTED	Stock	25.05	25.099	24.961	24.961	1000.0
2014-06-13	ABRN-DELISTED	Stock	25.19	25.19	24.98	24.99	5014.0

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

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