PREVIEW / stock_daily / 2014-10-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-09.parquet
  size:    221 KB
  rows:    6,595
  symbols: 3,541

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-10-09	AAPL	Stock	25.385	25.595	25.1525	25.255	309506000.0
2014-10-09	MSFT	Stock	46.5	46.8	45.74	45.85	34422800.0
2014-10-09	NVDA	Stock	0.4545	0.455	0.444	0.4478	306956000.0
2014-10-09	AMZN	Stock	16.0745	16.1135	15.726	15.7685	71758000.0
2014-10-09	GOOGL	Stock	29.0805	29.1265	28.4515	28.5405	48268760.0
2014-10-09	META	Stock	77.28	77.76	75.85	75.91	32487000.0
2014-10-09	TSLA	Stock	17.4833	17.7027	16.96	17.134	110419500.0
2014-10-09	TLT	Stock	119.27	119.67	118.78	118.87	10293812.0
2014-10-09	ES	Stock	46.76	47.1	46.07	46.1	2314000.0
2014-10-09	CL	Stock	65.52	65.92	65.15	65.2	4065400.0
2014-10-09	A	Stock	40.2575	40.2575	39.3634	39.3634	3531767.0
2014-10-09	AA.B-DELISTED	Stock	50.14	50.97	48.2	48.68	244956.0
2014-10-09	AABA-DELISTED	Stock	40.9	41.25	40.42	41.1	32392466.0
2014-10-09	AAC-DELISTED	Stock	19.16	19.55	19.0	19.39	111049.0
2014-10-09	AACG	Stock	4.33	4.36	4.33	4.35	3500.0
2014-10-09	AAIC-DELISTED	Stock	25.76	25.95	25.62	25.73	623727.0
2014-10-09	AAL	Stock	33.5	33.7	31.94	31.98	22634100.0
2014-10-09	AAMC-DELISTED	Stock	199.9353	199.9353	189.7059	192.5	40127.0
2014-10-09	AAME	Stock	4.0	4.0	4.0	4.0	1200.0
2014-10-09	AAOI	Stock	14.65	14.91	13.9	14.0	143300.0
2014-10-09	AAON	Stock	11.54	11.6133	11.2067	11.3133	221100.0
2014-10-09	AAP	Stock	135.72	136.75	133.06	133.99	700600.0
2014-10-09	AAT	Stock	34.8	34.94	34.41	34.46	106800.0
2014-10-09	AAU-DELISTED	Stock	1.37	1.37	1.29	1.3	74902.0
2014-10-09	AAUAF-DELISTED	Stock	1.35	1.35	1.27	1.3	78522.0
2014-10-09	AAV-DELISTED	Stock	4.77	4.8	4.51	4.53	300841.0
2014-10-09	AAVL-DELISTED	Stock	31.24	32.3	30.15	30.24	75703.0
2014-10-09	AAWW-DELISTED	Stock	32.91	33.13	32.1	32.16	253607.0
2014-10-09	AAXJ	Stock	61.5	61.5145	60.7	60.85	628524.0
2014-10-09	AAXN-DELISTED	Stock	14.46	14.97	14.36	14.715	1714320.0
2014-10-09	AB	Stock	25.55	25.59	25.02	25.12	244600.0
2014-10-09	ABAC-DELISTED	Stock	2.05	2.1	2.0	2.1	75987.0
2014-10-09	ABAX-DELISTED	Stock	48.03	48.137	47.04	47.64	212449.0
2014-10-09	ABB-DELISTED	Stock	21.37	21.41	20.84	20.89	3397578.0
2014-10-09	ABBNY-DELISTED	Stock	21.37	21.41	20.84	20.89	3527088.0
2014-10-09	ABBV	Stock	58.52	58.55	56.71	56.72	11911600.0
2014-10-09	ABC-DELISTED	Stock	77.89	78.46	77.14	77.21	1289461.0
2014-10-09	ABCB	Stock	22.69	22.69	22.07	22.18	54300.0
2014-10-09	ABCD-DELISTED	Stock	1.65	1.65	1.5101	1.55	5387.0
2014-10-09	ABCO-DELISTED	Stock	47.62	48.44	46.83	46.88	305940.0
2014-10-09	ABDC-DELISTED	Stock	12.87	12.931	12.45	12.74	58873.0
2014-10-09	ABE-DELISTED	Stock	14.03	14.04	13.89	13.89	10985.0
2014-10-09	ABEO	Stock	312.5	312.5	300.0	300.0	25.0
2014-10-09	ABEV	Stock	6.78	6.84	6.68	6.7	9653300.0
2014-10-09	ABG	Stock	67.87	68.17	66.22	66.35	160500.0
2014-10-09	ABGB-DELISTED	Stock	22.46	22.46	20.72	21.1	184981.0
2014-10-09	ABM	Stock	26.24	26.24	25.56	25.58	218500.0
2014-10-09	ABMD-DELISTED	Stock	23.8	23.8	23.03	23.09	163186.0
2014-10-09	ABR	Stock	6.63	6.7	6.56	6.59	38900.0
2014-10-09	ABR.A-DELISTED	Stock	24.75	24.75	24.66	24.7	8111.0

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

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