PREVIEW / stock_daily / 2014-07-30

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-30.parquet
  size:    221 KB
  rows:    6,582
  symbols: 3,544

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-30	AAPL	Stock	24.61	24.675	24.4175	24.5375	132040000.0
2014-07-30	MSFT	Stock	44.07	44.1	43.29	43.58	31921400.0
2014-07-30	NVDA	Stock	0.4472	0.4532	0.446	0.452	246184000.0
2014-07-30	AMZN	Stock	16.0725	16.1365	15.925	16.1255	79380000.0
2014-07-30	GOOGL	Stock	29.7905	29.9225	29.635	29.772	24311520.0
2014-07-30	META	Stock	74.21	75.19	74.13	74.68	36853000.0
2014-07-30	TSLA	Stock	14.7947	15.3067	14.736	15.2613	73917000.0
2014-07-30	TLT	Stock	115.15	115.38	114.17	114.32	12260525.0
2014-07-30	ES	Stock	45.69	45.95	44.8	44.93	1473400.0
2014-07-30	CL	Stock	66.46	66.73	66.02	66.11	3740600.0
2014-07-30	A	Stock	40.2146	40.6366	40.0715	40.6152	1917077.0
2014-07-30	AABA-DELISTED	Stock	35.83	36.99	35.8	36.595	27157888.0
2014-07-30	AACG	Stock	4.76	4.83	4.69	4.71	3300.0
2014-07-30	AAIC-DELISTED	Stock	26.9	26.9009	26.26	26.35	485153.0
2014-07-30	AAL	Stock	39.9	40.26	39.3	39.55	10757600.0
2014-07-30	AAMC-DELISTED	Stock	205.8824	205.8824	198.8235	205.7941	25157.0
2014-07-30	AAME	Stock	4.08	4.09	4.08	4.09	300.0
2014-07-30	AAOI	Stock	19.31	19.55	18.75	19.0	251600.0
2014-07-30	AAON	Stock	13.4533	13.4667	13.0733	13.3067	185400.0
2014-07-30	AAP	Stock	123.2	124.5	123.01	124.2	522800.0
2014-07-30	AAT	Stock	35.72	35.82	34.83	34.93	162600.0
2014-07-30	AAU-DELISTED	Stock	1.42	1.46	1.39	1.44	52795.0
2014-07-30	AAUAF-DELISTED	Stock	1.4	1.44	1.37	1.44	54024.0
2014-07-30	AAV-DELISTED	Stock	5.42	5.43	5.32	5.39	329116.0
2014-07-30	AAWW-DELISTED	Stock	35.3	35.55	34.86	35.34	241337.0
2014-07-30	AAXJ	Stock	66.03	66.03	65.24	65.55	756903.0
2014-07-30	AAXN-DELISTED	Stock	12.33	13.57	12.25	13.35	3800672.0
2014-07-30	AB	Stock	26.7	27.23	26.06	26.29	232300.0
2014-07-30	ABAC-DELISTED	Stock	1.99	2.01	1.9501	2.01	22516.0
2014-07-30	ABAX-DELISTED	Stock	48.13	48.35	47.33	47.7	198850.0
2014-07-30	ABB-DELISTED	Stock	23.48	23.58	23.34	23.48	1845667.0
2014-07-30	ABBNY-DELISTED	Stock	23.48	23.58	23.34	23.47	2188438.0
2014-07-30	ABBV	Stock	53.28	53.89	53.03	53.75	12680100.0
2014-07-30	ABC-DELISTED	Stock	77.99	78.46	77.693	77.96	1131690.0
2014-07-30	ABCB	Stock	21.4	21.78	21.25	21.76	133200.0
2014-07-30	ABCD-DELISTED	Stock	1.85	1.85	1.84	1.85	3373.0
2014-07-30	ABCO-DELISTED	Stock	51.44	51.78	50.78	51.22	205890.0
2014-07-30	ABDC-DELISTED	Stock	13.77	13.98	13.55	13.55	75877.0
2014-07-30	ABE-DELISTED	Stock	14.68	14.68	14.42	14.5	5764.0
2014-07-30	ABEO	Stock	362.5	362.5	312.5	312.5	212.0
2014-07-30	ABEV	Stock	7.32	7.34	7.22	7.27	14181000.0
2014-07-30	ABG	Stock	69.65	69.9	68.64	69.26	243400.0
2014-07-30	ABGB-DELISTED	Stock	27.5	27.5	27.0756	27.37	4298.0
2014-07-30	ABM	Stock	25.1	25.12	24.85	24.99	96800.0
2014-07-30	ABMD-DELISTED	Stock	26.57	26.94	26.37	26.73	351103.0
2014-07-30	ABR	Stock	7.11	7.12	7.06	7.1	60500.0
2014-07-30	ABR.A-DELISTED	Stock	25.12	25.12	25.05	25.06	4738.0
2014-07-30	ABR.B-DELISTED	Stock	24.57	24.68	24.57	24.57	2400.0
2014-07-30	ABR.C-DELISTED	Stock	25.5	25.5	25.44	25.44	400.0
2014-07-30	ABRN-DELISTED	Stock	24.8	24.809	24.74	24.78	20064.0

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

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