PREVIEW / stock_daily / 2014-08-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-22.parquet
  size:    220 KB
  rows:    6,600
  symbols: 3,553

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-08-22	AAPL	Stock	25.0725	25.3675	25.0475	25.33	176736000.0
2014-08-22	MSFT	Stock	45.35	45.47	45.07	45.15	18294500.0
2014-08-22	NVDA	Stock	0.4763	0.481	0.4732	0.477	251224000.0
2014-08-22	AMZN	Stock	16.6495	16.704	16.54	16.5795	44224000.0
2014-08-22	GOOGL	Stock	29.6635	29.7495	29.49	29.627	17549280.0
2014-08-22	META	Stock	74.34	74.73	73.57	74.57	20897000.0
2014-08-22	TSLA	Stock	16.9693	17.13	16.8407	17.1187	42501000.0
2014-08-22	TLT	Stock	116.74	117.43	116.21	117.29	10149859.0
2014-08-22	ES	Stock	45.27	45.36	44.85	45.16	1346200.0
2014-08-22	CL	Stock	64.9	64.97	64.53	64.57	1642200.0
2014-08-22	A	Stock	41.4163	41.5165	41.1159	41.2303	2012561.0
2014-08-22	AABA-DELISTED	Stock	37.7	38.2	37.63	38.01	14210096.0
2014-08-22	AACG	Stock	4.6	4.8	4.6	4.6	99100.0
2014-08-22	AAIC-DELISTED	Stock	27.88	27.93	27.75	27.87	145333.0
2014-08-22	AAL	Stock	39.6	40.21	39.55	39.85	5771400.0
2014-08-22	AAMC-DELISTED	Stock	175.9265	185.2941	175.7353	182.3529	84194.0
2014-08-22	AAME	Stock	4.16	4.17	4.14	4.15	4100.0
2014-08-22	AAOI	Stock	19.42	19.59	19.04	19.23	112100.0
2014-08-22	AAON	Stock	12.58	12.6133	12.3733	12.38	127800.0
2014-08-22	AAP	Stock	134.63	135.99	133.93	135.41	407000.0
2014-08-22	AAT	Stock	35.09	35.25	34.84	35.01	98500.0
2014-08-22	AAU-DELISTED	Stock	1.39	1.44	1.39	1.43	40892.0
2014-08-22	AAUAF-DELISTED	Stock	1.39	1.44	1.39	1.43	41610.0
2014-08-22	AAV-DELISTED	Stock	5.96	6.06	5.87	5.89	299000.0
2014-08-22	AAVL-DELISTED	Stock	30.16	30.92	30.01	30.53	101102.0
2014-08-22	AAWW-DELISTED	Stock	34.22	34.43	33.3525	33.85	108190.0
2014-08-22	AAXJ	Stock	65.77	65.97	65.48	65.71	224207.0
2014-08-22	AAXN-DELISTED	Stock	15.91	16.48	15.43	15.71	2710004.0
2014-08-22	AB	Stock	26.16	27.5	26.12	26.78	440800.0
2014-08-22	ABAC-DELISTED	Stock	1.9999	1.9999	1.91	1.95	12330.0
2014-08-22	ABAX-DELISTED	Stock	46.22	46.94	45.97	46.31	154950.0
2014-08-22	ABB-DELISTED	Stock	22.76	22.8	22.61	22.74	2361891.0
2014-08-22	ABBNY-DELISTED	Stock	22.76	22.8	22.61	22.73	2655989.0
2014-08-22	ABBV	Stock	54.87	55.27	54.36	55.2	9314600.0
2014-08-22	ABC-DELISTED	Stock	77.05	77.285	76.43	76.61	589476.0
2014-08-22	ABCB	Stock	23.02	23.45	22.93	23.34	160800.0
2014-08-22	ABCD-DELISTED	Stock	1.69	1.69	1.6	1.62	8987.0
2014-08-22	ABCO-DELISTED	Stock	50.33	50.73	49.87	49.87	160922.0
2014-08-22	ABDC-DELISTED	Stock	13.21	13.45	13.21	13.35	47177.0
2014-08-22	ABE-DELISTED	Stock	14.64	14.64	14.5741	14.5741	3206.0
2014-08-22	ABEO	Stock	375.0	437.5	375.0	437.5	2.0
2014-08-22	ABEV	Stock	7.11	7.13	7.02	7.07	7159600.0
2014-08-22	ABG	Stock	68.86	69.16	67.9	68.18	199300.0
2014-08-22	ABGB-DELISTED	Stock	26.68	26.75	26.1222	26.202	1597.0
2014-08-22	ABM	Stock	25.96	26.42	25.81	26.37	150000.0
2014-08-22	ABMD-DELISTED	Stock	24.86	25.09	24.61	24.87	135933.0
2014-08-22	ABR	Stock	6.99	6.99	6.94	6.98	158400.0
2014-08-22	ABR.A-DELISTED	Stock	24.71	24.7399	24.657	24.6639	8150.0
2014-08-22	ABR.B-DELISTED	Stock	24.1	24.22	24.1	24.11	5189.0
2014-08-22	ABR.C-DELISTED	Stock	25.0801	25.0801	25.02	25.02	2954.0

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

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