PREVIEW / stock_daily / 2014-07-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-21.parquet
  size:    220 KB
  rows:    6,603
  symbols: 3,575

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-07-21	AAPL	Stock	23.7475	23.75	23.43	23.485	156316000.0
2014-07-21	MSFT	Stock	44.56	45.16	44.22	44.84	37604400.0
2014-07-21	NVDA	Stock	0.4593	0.467	0.4593	0.4638	243364000.0
2014-07-21	AMZN	Stock	17.905	18.0855	17.836	17.988	45568000.0
2014-07-21	GOOGL	Stock	30.0675	30.208	29.7225	29.922	44802220.0
2014-07-21	META	Stock	68.81	69.96	68.5	69.4	49539000.0
2014-07-21	TSLA	Stock	14.4833	14.8807	14.448	14.7027	57333000.0
2014-07-21	TLT	Stock	115.01	115.63	115.01	115.09	5726280.0
2014-07-21	ES	Stock	45.48	45.55	45.13	45.45	1129300.0
2014-07-21	CL	Stock	68.56	68.89	68.44	68.76	1516400.0
2014-07-21	A	Stock	39.9571	40.7368	39.907	40.5651	2773492.0
2014-07-21	AABA-DELISTED	Stock	33.35	33.64	33.16	33.275	17744683.0
2014-07-21	AACG	Stock	4.42	4.42	4.2	4.23	3500.0
2014-07-21	AAIC-DELISTED	Stock	26.62	26.76	26.55	26.67	110902.0
2014-07-21	AAL	Stock	42.91	42.95	42.25	42.48	5679500.0
2014-07-21	AAMC-DELISTED	Stock	219.4618	225.2941	215.0	219.7206	63424.0
2014-07-21	AAME	Stock	3.93	4.07	3.81	3.87	35300.0
2014-07-21	AAOI	Stock	21.5	22.67	21.5	22.32	97800.0
2014-07-21	AAON	Stock	14.04	14.2	13.7933	14.0933	172350.0
2014-07-21	AAP	Stock	130.31	131.0	128.48	128.55	411300.0
2014-07-21	AAT	Stock	35.45	35.66	35.31	35.44	121700.0
2014-07-21	AAU-DELISTED	Stock	1.5	1.5	1.4	1.4255	204255.0
2014-07-21	AAUAF-DELISTED	Stock	1.5	1.5	1.4	1.44	204905.0
2014-07-21	AAV-DELISTED	Stock	5.5	5.5	5.27	5.33	237897.0
2014-07-21	AAWW-DELISTED	Stock	35.83	35.895	35.33	35.71	135924.0
2014-07-21	AAXJ	Stock	63.71	64.1	63.55	64.0	118200.0
2014-07-21	AAXN-DELISTED	Stock	11.29	11.55	11.0604	11.455	848933.0
2014-07-21	AB	Stock	27.62	27.84	27.51	27.72	200800.0
2014-07-21	ABAC-DELISTED	Stock	2.16	2.17	2.07	2.13	63800.0
2014-07-21	ABAX-DELISTED	Stock	42.29	42.57	41.96	42.23	143795.0
2014-07-21	ABB-DELISTED	Stock	22.62	22.8899	22.61	22.81	1889168.0
2014-07-21	ABBNY-DELISTED	Stock	22.62	22.8899	22.61	22.8	1938335.0
2014-07-21	ABBV	Stock	54.14	54.45	53.91	54.0	22334900.0
2014-07-21	ABC-DELISTED	Stock	72.92	73.0	72.38	72.76	949087.0
2014-07-21	ABCB	Stock	21.07	21.28	20.9	21.03	49800.0
2014-07-21	ABCD-DELISTED	Stock	1.89	1.93	1.83	1.85	94303.0
2014-07-21	ABCO-DELISTED	Stock	49.46	50.64	49.46	49.9	209501.0
2014-07-21	ABDC-DELISTED	Stock	13.8	13.8804	13.5	13.72	75002.0
2014-07-21	ABE-DELISTED	Stock	14.55	14.63	14.55	14.6	3428.0
2014-07-21	ABEO	Stock	287.5	437.5	287.5	337.5	814.0
2014-07-21	ABEV	Stock	7.41	7.56	7.37	7.53	13775100.0
2014-07-21	ABG	Stock	70.8	71.1	69.8	70.78	180200.0
2014-07-21	ABGB-DELISTED	Stock	26.59	27.04	26.5001	27.0399	3084.0
2014-07-21	ABM	Stock	25.59	25.71	25.44	25.57	120900.0
2014-07-21	ABMD-DELISTED	Stock	24.77	25.4	24.478	25.3	147959.0
2014-07-21	ABR	Stock	7.08	7.15	7.05	7.1	226800.0
2014-07-21	ABR.A-DELISTED	Stock	24.86	24.9699	24.86	24.9	8210.0
2014-07-21	ABR.B-DELISTED	Stock	24.7	24.7	24.66	24.69	800.0
2014-07-21	ABR.C-DELISTED	Stock	25.27	25.3799	25.27	25.3799	1050.0
2014-07-21	ABRN-DELISTED	Stock	25.03	25.15	25.03	25.04	9952.0

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

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