PREVIEW / stock_daily / 2014-06-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-05.parquet
  size:    218 KB
  rows:    6,531
  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-06-05	AAPL	Stock	23.0786	23.1918	22.9504	23.1196	303805600.0
2014-06-05	MSFT	Stock	40.59	41.25	40.4	41.21	31865200.0
2014-06-05	NVDA	Stock	0.4728	0.4755	0.47	0.474	188696000.0
2014-06-05	AMZN	Stock	15.405	16.397	15.345	16.1785	155934000.0
2014-06-05	GOOGL	Stock	27.8555	28.25	27.7525	28.2465	35927400.0
2014-06-05	META	Stock	63.66	64.36	62.82	63.19	47352000.0
2014-06-05	TSLA	Stock	13.6313	13.9467	13.6033	13.7933	60819000.0
2014-06-05	TLT	Stock	111.13	111.97	111.015	111.59	6915766.0
2014-06-05	ES	Stock	45.14	45.7	45.14	45.6	787600.0
2014-06-05	CL	Stock	67.84	68.2	67.71	67.96	2872700.0
2014-06-05	A	Stock	41.0944	42.0243	41.0658	41.917	2562674.0
2014-06-05	AABA-DELISTED	Stock	34.79	34.99	34.36	34.93	10832264.0
2014-06-05	AACG	Stock	5.4	5.4	4.74	4.79	11800.0
2014-06-05	AAIC-DELISTED	Stock	27.71	27.94	27.53	27.9	142628.0
2014-06-05	AAL	Stock	43.0	43.49	42.27	42.41	8539600.0
2014-06-05	AAMC-DELISTED	Stock	311.7647	318.5118	311.1147	314.7059	44397.0
2014-06-05	AAME	Stock	3.63	3.63	3.55	3.63	25400.0
2014-06-05	AAOI	Stock	20.42	20.97	20.31	20.9	152000.0
2014-06-05	AAON	Stock	13.8578	14.4178	13.5244	14.3067	477900.0
2014-06-05	AAP	Stock	126.53	127.77	126.16	127.43	605600.0
2014-06-05	AAT	Stock	34.44	35.19	34.3	35.0	255000.0
2014-06-05	AAU-DELISTED	Stock	1.29	1.33	1.29	1.33	51297.0
2014-06-05	AAUAF-DELISTED	Stock	1.29	1.35	1.29	1.35	52303.0
2014-06-05	AAV-DELISTED	Stock	6.45	6.87	6.4	6.78	966367.0
2014-06-05	AAWW-DELISTED	Stock	36.64	38.13	36.64	37.54	213177.0
2014-06-05	AAXJ	Stock	62.36	62.69	62.304	62.67	481305.0
2014-06-05	AAXN-DELISTED	Stock	13.22	13.37	12.95	13.36	597840.0
2014-06-05	AB	Stock	25.33	25.79	25.12	25.64	519400.0
2014-06-05	ABAC-DELISTED	Stock	2.111	2.1685	2.04	2.13	34730.0
2014-06-05	ABAX-DELISTED	Stock	41.6	42.37	41.4101	42.21	223474.0
2014-06-05	ABB-DELISTED	Stock	23.45	23.62	23.42	23.61	1671480.0
2014-06-05	ABBNY-DELISTED	Stock	23.45	23.62	23.42	23.61	1725986.0
2014-06-05	ABBV	Stock	54.55	55.32	54.36	55.3	4847300.0
2014-06-05	ABC-DELISTED	Stock	73.51	73.81	72.53	72.78	2362284.0
2014-06-05	ABCB	Stock	20.98	21.67	20.76	21.67	45800.0
2014-06-05	ABCD-DELISTED	Stock	2.12	2.19	2.116	2.17	8672.0
2014-06-05	ABCO-DELISTED	Stock	50.72	51.62	50.27	51.17	143558.0
2014-06-05	ABDC-DELISTED	Stock	14.65	14.75	14.6	14.74	17648.0
2014-06-05	ABE-DELISTED	Stock	14.1	14.24	14.03	14.24	14982.0
2014-06-05	ABEO	Stock	425.0	425.0	400.0	425.0	28.0
2014-06-05	ABEV	Stock	7.1	7.16	7.01	7.03	7930800.0
2014-06-05	ABG	Stock	66.17	66.2	64.96	65.78	213700.0
2014-06-05	ABGB-DELISTED	Stock	26.0	26.0	25.15	25.531	4078.0
2014-06-05	ABIL-DELISTED	Stock	9.78	9.7801	9.67	9.72	54980.0
2014-06-05	ABM	Stock	26.48	27.0	26.2	26.99	343500.0
2014-06-05	ABMD-DELISTED	Stock	22.99	23.36	22.758	23.36	155100.0
2014-06-05	ABR	Stock	7.24	7.3	7.22	7.25	49200.0
2014-06-05	ABR.A-DELISTED	Stock	24.17	24.25	24.15	24.15	8350.0
2014-06-05	ABR.B-DELISTED	Stock	23.729	23.729	23.729	23.729	1000.0
2014-06-05	ABR.C-DELISTED	Stock	25.0	25.0	24.95	24.9587	7645.0

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

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