PREVIEW / stock_daily / 2014-07-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-09.parquet
  size:    220 KB
  rows:    6,587
  symbols: 3,569

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-09	AAPL	Stock	23.86	23.9875	23.69	23.8475	145744000.0
2014-07-09	MSFT	Stock	41.98	41.99	41.53	41.67	18445900.0
2014-07-09	NVDA	Stock	0.4678	0.4798	0.4643	0.4778	387668000.0
2014-07-09	AMZN	Stock	16.2355	16.51	16.1575	16.4985	63322000.0
2014-07-09	GOOGL	Stock	28.9475	29.205	28.85	29.168	27461120.0
2014-07-09	META	Stock	63.41	65.12	63.15	64.97	51432000.0
2014-07-09	TSLA	Stock	14.7513	14.948	14.614	14.8707	61731000.0
2014-07-09	TLT	Stock	112.66	113.14	112.38	112.83	6395169.0
2014-07-09	ES	Stock	45.94	46.04	45.45	45.81	1054300.0
2014-07-09	CL	Stock	69.53	69.89	69.42	69.65	2497500.0
2014-07-09	A	Stock	40.8083	40.8298	40.4292	40.701	1787343.0
2014-07-09	AABA-DELISTED	Stock	34.72	35.07	34.68	34.855	12144884.0
2014-07-09	AACG	Stock	4.32	4.54	4.25	4.4	35400.0
2014-07-09	AAIC-DELISTED	Stock	26.65	26.81	26.59	26.71	125193.0
2014-07-09	AAL	Stock	42.08	42.35	40.51	41.99	20468300.0
2014-07-09	AAMC-DELISTED	Stock	188.5589	194.7059	181.4706	185.8971	42265.0
2014-07-09	AAME	Stock	3.96	4.13	3.86	3.86	11800.0
2014-07-09	AAOI	Stock	22.48	23.38	22.22	22.97	213800.0
2014-07-09	AAON	Stock	14.5822	14.7333	14.5156	14.5867	168075.0
2014-07-09	AAP	Stock	132.71	133.61	131.23	133.58	673400.0
2014-07-09	AAT	Stock	35.0	35.0	34.5	34.81	101900.0
2014-07-09	AAU-DELISTED	Stock	1.41	1.59	1.41	1.561	852516.0
2014-07-09	AAUAF-DELISTED	Stock	1.41	1.59	1.41	1.56	855895.0
2014-07-09	AAV-DELISTED	Stock	6.3	6.35	6.26	6.32	289581.0
2014-07-09	AAWW-DELISTED	Stock	36.1	36.1	35.29	35.56	185212.0
2014-07-09	AAXJ	Stock	63.69	63.88	63.48	63.86	247321.0
2014-07-09	AAXN-DELISTED	Stock	12.09	12.36	11.27	11.37	2381869.0
2014-07-09	AB	Stock	26.48	26.57	26.28	26.35	201600.0
2014-07-09	ABAC-DELISTED	Stock	2.03	2.08	2.03	2.05	5400.0
2014-07-09	ABAX-DELISTED	Stock	43.05	43.3933	43.0	43.32	195390.0
2014-07-09	ABB-DELISTED	Stock	22.86	23.03	22.84	23.01	1455855.0
2014-07-09	ABBNY-DELISTED	Stock	22.86	23.03	22.84	23.02	1679625.0
2014-07-09	ABBV	Stock	55.56	55.64	54.82	55.01	11516300.0
2014-07-09	ABC-DELISTED	Stock	73.1	73.26	72.67	72.97	642814.0
2014-07-09	ABCB	Stock	22.07	22.19	21.8	21.82	14300.0
2014-07-09	ABCD-DELISTED	Stock	2.09	2.09	2.02	2.02	3700.0
2014-07-09	ABCO-DELISTED	Stock	51.56	52.4	51.26	52.25	153370.0
2014-07-09	ABDC-DELISTED	Stock	14.36	14.575	14.0	14.01	98087.0
2014-07-09	ABE-DELISTED	Stock	14.4	14.54	14.4	14.5399	17208.0
2014-07-09	ABEO	Stock	337.5	350.0	337.5	350.0	14.0
2014-07-09	ABEV	Stock	7.15	7.22	7.05	7.12	17302500.0
2014-07-09	ABG	Stock	70.96	71.42	70.89	71.12	136300.0
2014-07-09	ABGB-DELISTED	Stock	25.81	26.23	25.81	26.19	5880.0
2014-07-09	ABM	Stock	26.43	26.48	26.18	26.2	193900.0
2014-07-09	ABMD-DELISTED	Stock	24.91	25.2	24.65	25.02	300657.0
2014-07-09	ABR	Stock	6.89	6.94	6.89	6.91	50900.0
2014-07-09	ABR.A-DELISTED	Stock	24.6499	24.74	24.6287	24.72	9135.0
2014-07-09	ABRN-DELISTED	Stock	25.09	25.0999	24.92	25.02	4716.0
2014-07-09	ABT	Stock	41.21	41.38	40.95	41.27	3562400.0
2014-07-09	ABTL-DELISTED	Stock	12.4	12.43	12.09	12.27	82420.0

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

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