PREVIEW / stock_daily / 2014-03-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-12.parquet
  size:    218 KB
  rows:    6,478
  symbols: 3,535

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-12	AAPL	Stock	19.0896	19.1911	19.0	19.1646	199326400.0
2014-03-12	MSFT	Stock	37.8	38.43	37.79	38.27	30494100.0
2014-03-12	NVDA	Stock	0.4545	0.4608	0.4528	0.458	239428000.0
2014-03-12	AMZN	Stock	18.32	18.558	18.1805	18.532	44332000.0
2014-03-12	META	Stock	69.86	71.35	69.0	70.88	46340500.0
2014-03-12	TSLA	Stock	15.4333	16.5	15.4073	16.0993	146316000.0
2014-03-12	TLT	Stock	106.92	107.26	106.78	107.06	6430504.0
2014-03-12	ES	Stock	43.28	43.97	43.2	43.94	1376600.0
2014-03-12	CL	Stock	62.91	63.4	62.87	63.22	2368700.0
2014-03-12	A	Stock	40.4292	40.8298	40.0644	40.8155	2309915.0
2014-03-12	AABA-DELISTED	Stock	37.21	37.61	36.48	37.51	13904154.0
2014-03-12	AACG	Stock	4.5	4.6	4.31	4.47	22400.0
2014-03-12	AAIC-DELISTED	Stock	26.69	27.1	26.61	27.09	65537.0
2014-03-12	AAL	Stock	37.97	38.08	37.23	37.56	9412700.0
2014-03-12	AAMC-DELISTED	Stock	234.7059	257.4118	230.6829	252.2176	148427.0
2014-03-12	AAME	Stock	3.87	3.92	3.78	3.82	9400.0
2014-03-12	AAOI	Stock	26.26	26.96	26.15	26.46	124900.0
2014-03-12	AAON	Stock	12.8756	13.1022	12.6667	13.0089	196200.0
2014-03-12	AAP	Stock	125.86	127.01	125.26	126.49	986000.0
2014-03-12	AAT	Stock	32.44	32.91	32.44	32.74	87800.0
2014-03-12	AAU-DELISTED	Stock	1.54	1.58	1.52	1.58	440889.0
2014-03-12	AAUAF-DELISTED	Stock	1.54	1.58	1.52	1.58	444677.0
2014-03-12	AAV-DELISTED	Stock	3.94	3.96	3.85	3.9	163617.0
2014-03-12	AAWW-DELISTED	Stock	31.93	32.39	31.76	32.26	133820.0
2014-03-12	AAXJ	Stock	57.12	57.56	56.99	57.48	1280282.0
2014-03-12	AAXN-DELISTED	Stock	18.95	19.189	18.58	18.65	798581.0
2014-03-12	AB	Stock	23.46	24.25	23.39	24.16	354700.0
2014-03-12	ABAC-DELISTED	Stock	1.89	1.93	1.82	1.84	54300.0
2014-03-12	ABAX-DELISTED	Stock	38.9	39.736	38.65	38.9	68391.0
2014-03-12	ABB-DELISTED	Stock	25.15	25.47	25.09	25.46	2087315.0
2014-03-12	ABBNY-DELISTED	Stock	25.15	25.47	25.09	25.45	2692685.0
2014-03-12	ABBV	Stock	51.46	51.74	51.07	51.64	3924800.0
2014-03-12	ABC-DELISTED	Stock	67.76	67.85	66.97	67.67	1808434.0
2014-03-12	ABCB	Stock	22.9	23.8	22.89	23.47	116600.0
2014-03-12	ABCD-DELISTED	Stock	2.0799	2.16	2.0699	2.15	46513.0
2014-03-12	ABCO-DELISTED	Stock	66.37	66.38	65.43	65.89	322668.0
2014-03-12	ABE-DELISTED	Stock	12.48	12.57	12.48	12.54	4310.0
2014-03-12	ABEO	Stock	550.0	562.5	512.5	550.0	64.0
2014-03-12	ABEV	Stock	7.01	7.07	6.96	7.07	7221500.0
2014-03-12	ABFS-DELISTED	Stock	36.46	37.034	36.288	36.7	202030.0
2014-03-12	ABG	Stock	53.14	53.22	52.74	53.0	150500.0
2014-03-12	ABGB-DELISTED	Stock	24.75	24.75	22.4537	23.56	19585.0
2014-03-12	ABIL-DELISTED	Stock	9.63	9.7	9.62	9.65	20570.0
2014-03-12	ABM	Stock	28.08	28.36	27.98	28.27	184200.0
2014-03-12	ABMD-DELISTED	Stock	29.76	29.9899	29.6499	29.84	128782.0
2014-03-12	ABR	Stock	6.74	6.74	6.67	6.73	86300.0
2014-03-12	ABR.A-DELISTED	Stock	24.4407	24.4407	24.3201	24.4099	3047.0
2014-03-12	ABR.B-DELISTED	Stock	22.9	22.98	22.88	22.89	2700.0
2014-03-12	ABR.C-DELISTED	Stock	24.48	24.55	24.464	24.5	27149.0
2014-03-12	ABT	Stock	39.44	39.89	39.44	39.66	6933000.0

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

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