PREVIEW / stock_daily / 2014-03-27

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-27.parquet
  size:    217 KB
  rows:    6,472
  symbols: 3,530

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-27	AAPL	Stock	19.2864	19.3393	19.1114	19.195	222031600.0
2014-03-27	MSFT	Stock	39.74	39.97	39.34	39.36	35369200.0
2014-03-27	NVDA	Stock	0.4498	0.4535	0.4398	0.4448	540728000.0
2014-03-27	AMZN	Stock	17.1575	17.2	16.544	16.9235	115328000.0
2014-03-27	META	Stock	60.51	61.9	57.98	60.97	112650000.0
2014-03-27	TSLA	Stock	14.158	14.24	13.5333	13.8213	142435500.0
2014-03-27	TLT	Stock	109.64	110.39	109.42	109.99	9773185.0
2014-03-27	ES	Stock	44.63	44.98	44.46	44.95	1712700.0
2014-03-27	CL	Stock	64.25	65.92	63.99	64.06	8116000.0
2014-03-27	A	Stock	39.7711	39.7711	38.784	39.1202	4151780.0
2014-03-27	AABA-DELISTED	Stock	35.5	36.15	35.05	35.58	21070903.0
2014-03-27	AACG	Stock	4.01	4.12	4.01	4.05	11300.0
2014-03-27	AAIC-DELISTED	Stock	25.9	26.19	25.58	25.75	708067.0
2014-03-27	AAL	Stock	36.62	36.77	35.02	35.77	9542200.0
2014-03-27	AAMC-DELISTED	Stock	318.2382	323.5294	307.3529	314.9647	80199.0
2014-03-27	AAME	Stock	3.74	3.75	3.7	3.7	9700.0
2014-03-27	AAOI	Stock	24.29	25.23	23.61	24.95	367500.0
2014-03-27	AAON	Stock	12.4133	12.6311	12.2578	12.3378	164700.0
2014-03-27	AAP	Stock	122.31	125.3	122.07	123.89	732400.0
2014-03-27	AAT	Stock	32.97	33.2	32.67	33.15	70600.0
2014-03-27	AAU-DELISTED	Stock	1.33	1.36	1.31	1.31	146103.0
2014-03-27	AAUAF-DELISTED	Stock	1.33	1.36	1.31	1.31	146707.0
2014-03-27	AAV-DELISTED	Stock	4.52	4.67	4.49	4.67	1099147.0
2014-03-27	AAWW-DELISTED	Stock	34.16	34.39	33.795	34.3	287486.0
2014-03-27	AAXJ	Stock	57.87	58.39	57.87	58.32	551433.0
2014-03-27	AAXN-DELISTED	Stock	18.76	18.8999	18.13	18.27	838662.0
2014-03-27	AB	Stock	25.5	25.5	24.9	25.14	510200.0
2014-03-27	ABAC-DELISTED	Stock	1.85	2.099	1.8	1.85	113774.0
2014-03-27	ABAX-DELISTED	Stock	37.67	38.668	37.07	37.94	151419.0
2014-03-27	ABB-DELISTED	Stock	25.09	25.325	25.05	25.21	2385386.0
2014-03-27	ABBNY-DELISTED	Stock	25.09	25.325	25.05	25.2	2545472.0
2014-03-27	ABBV	Stock	51.53	51.84	51.43	51.66	4778000.0
2014-03-27	ABC-DELISTED	Stock	64.81	64.82	63.72	64.2	1964826.0
2014-03-27	ABCB	Stock	23.46	23.75	23.25	23.4	66900.0
2014-03-27	ABCD-DELISTED	Stock	2.079	2.11	2.072	2.0801	22945.0
2014-03-27	ABCO-DELISTED	Stock	63.44	63.63	62.18	62.83	175585.0
2014-03-27	ABE-DELISTED	Stock	12.83	13.37	12.79	12.97	31628.0
2014-03-27	ABEO	Stock	662.5	712.5	625.0	650.0	35.0
2014-03-27	ABEV	Stock	7.28	7.49	7.24	7.45	9668500.0
2014-03-27	ABFS-DELISTED	Stock	35.56	36.11	34.81	34.96	265610.0
2014-03-27	ABG	Stock	54.7	55.37	53.85	54.23	484100.0
2014-03-27	ABGB-DELISTED	Stock	22.13	22.2	22.0	22.09	8463.0
2014-03-27	ABIL-DELISTED	Stock	9.64	9.64	9.6	9.63	2704.0
2014-03-27	ABM	Stock	28.18	28.29	28.06	28.21	314300.0
2014-03-27	ABMD-DELISTED	Stock	26.43	26.58	25.4	25.77	370513.0
2014-03-27	ABR	Stock	6.71	6.79	6.66	6.79	95400.0
2014-03-27	ABR.A-DELISTED	Stock	24.62	24.62	24.6	24.62	900.0
2014-03-27	ABR.B-DELISTED	Stock	22.89	22.89	22.59	22.78	21170.0
2014-03-27	ABR.C-DELISTED	Stock	24.7	24.75	24.45	24.46	9050.0
2014-03-27	ABT	Stock	38.55	38.69	38.13	38.45	7404100.0

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

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