PREVIEW / stock_daily / 2014-09-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-04.parquet
  size:    221 KB
  rows:    6,643
  symbols: 3,593

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-09-04	AAPL	Stock	24.7125	25.0225	24.4475	24.53	342872000.0
2014-09-04	MSFT	Stock	44.74	45.27	44.72	45.26	26475500.0
2014-09-04	NVDA	Stock	0.4912	0.5038	0.491	0.5008	491832000.0
2014-09-04	AMZN	Stock	17.1845	17.469	17.179	17.2975	79312000.0
2014-09-04	GOOGL	Stock	29.6065	29.9	29.53	29.657	32691700.0
2014-09-04	META	Stock	75.89	76.93	75.53	75.95	26676000.0
2014-09-04	TSLA	Stock	18.934	19.428	18.6933	19.0693	125125500.0
2014-09-04	TLT	Stock	116.62	116.88	115.93	115.95	12534367.0
2014-09-04	ES	Stock	45.66	45.89	45.42	45.86	1220900.0
2014-09-04	CL	Stock	64.48	64.63	64.08	64.31	3288600.0
2014-09-04	A	Stock	41.5737	41.8383	41.2017	41.2661	1105259.0
2014-09-04	AABA-DELISTED	Stock	39.14	39.34	38.96	39.18	13597672.0
2014-09-04	AACG	Stock	4.55	4.64	4.51	4.64	12200.0
2014-09-04	AAIC-DELISTED	Stock	27.12	27.34	27.02	27.16	3324291.0
2014-09-04	AAL	Stock	39.37	39.98	38.36	38.47	12004000.0
2014-09-04	AAMC-DELISTED	Stock	220.5882	220.5882	212.2652	214.4412	36978.0
2014-09-04	AAME	Stock	4.06	4.06	4.03	4.03	1600.0
2014-09-04	AAOI	Stock	19.6	20.74	19.53	20.49	230500.0
2014-09-04	AAON	Stock	12.3733	12.84	12.3733	12.6	247650.0
2014-09-04	AAP	Stock	138.3	139.58	137.95	138.27	439400.0
2014-09-04	AAT	Stock	35.51	35.67	35.05	35.2	77200.0
2014-09-04	AAU-DELISTED	Stock	1.455	1.56	1.44	1.44	1197073.0
2014-09-04	AAUAF-DELISTED	Stock	1.45	1.55	1.44	1.45	1233232.0
2014-09-04	AAV-DELISTED	Stock	5.94	6.03	5.615	5.69	536757.0
2014-09-04	AAVL-DELISTED	Stock	30.9	31.59	29.96	30.72	80099.0
2014-09-04	AAWW-DELISTED	Stock	34.14	34.77	34.0	34.43	234700.0
2014-09-04	AAXJ	Stock	66.47	66.54	66.07	66.38	502280.0
2014-09-04	AAXN-DELISTED	Stock	17.28	18.3896	17.27	17.55	7390616.0
2014-09-04	AB	Stock	27.19	27.33	26.82	26.88	202700.0
2014-09-04	ABAC-DELISTED	Stock	1.7	1.7	1.48	1.57	46679.0
2014-09-04	ABAX-DELISTED	Stock	48.57	49.09	48.19	48.31	62320.0
2014-09-04	ABB-DELISTED	Stock	23.31	23.345	23.02	23.12	1166025.0
2014-09-04	ABBNY-DELISTED	Stock	23.31	23.345	23.02	23.11	1220760.0
2014-09-04	ABBV	Stock	55.36	55.6	55.09	55.54	10019400.0
2014-09-04	ABC-DELISTED	Stock	77.32	77.94	77.08	77.36	754457.0
2014-09-04	ABCB	Stock	22.86	23.06	22.68	22.72	58500.0
2014-09-04	ABCD-DELISTED	Stock	1.65	1.65	1.55	1.56	107318.0
2014-09-04	ABCO-DELISTED	Stock	48.6	48.92	48.11	48.16	146434.0
2014-09-04	ABDC-DELISTED	Stock	13.5	13.85	13.4505	13.66	88355.0
2014-09-04	ABE-DELISTED	Stock	14.9	14.9	14.84	14.87	16287.0
2014-09-04	ABEO	Stock	400.0	412.5	375.0	412.5	9.0
2014-09-04	ABEV	Stock	7.19	7.26	7.16	7.24	9879000.0
2014-09-04	ABG	Stock	72.06	72.96	71.68	71.82	286500.0
2014-09-04	ABGB-DELISTED	Stock	29.26	30.75	29.26	30.16	62610.0
2014-09-04	ABM	Stock	28.0	28.98	27.76	27.96	476500.0
2014-09-04	ABMD-DELISTED	Stock	25.52	25.67	24.92	25.04	139663.0
2014-09-04	ABR	Stock	6.95	6.97	6.88	6.88	80300.0
2014-09-04	ABR.A-DELISTED	Stock	24.87	24.92	24.8	24.85	12636.0
2014-09-04	ABR.B-DELISTED	Stock	24.3278	24.36	24.2501	24.28	3350.0
2014-09-04	ABR.C-DELISTED	Stock	25.2	25.26	25.15	25.25	4490.0

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

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