PREVIEW / stock_daily / 2014-06-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-09.parquet
  size:    219 KB
  rows:    6,563
  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-06-09	AAPL	Stock	23.175	23.47	22.9375	23.425	301660000.0
2014-06-09	MSFT	Stock	41.39	41.48	41.02	41.27	15019200.0
2014-06-09	NVDA	Stock	0.4753	0.4808	0.472	0.4763	247456000.0
2014-06-09	AMZN	Stock	16.5785	16.65	16.2825	16.375	64244000.0
2014-06-09	GOOGL	Stock	28.3375	28.6	28.261	28.5365	30599180.0
2014-06-09	META	Stock	62.4	63.34	61.79	62.88	37617000.0
2014-06-09	TSLA	Stock	13.8633	13.9993	13.6133	13.6873	42085500.0
2014-06-09	TLT	Stock	111.45	111.64	111.2	111.43	5167639.0
2014-06-09	ES	Stock	45.35	45.5	45.03	45.17	1320100.0
2014-06-09	CL	Stock	67.89	68.64	67.88	68.44	2260000.0
2014-06-09	A	Stock	42.2031	42.618	41.9886	42.4034	1661942.0
2014-06-09	AABA-DELISTED	Stock	35.86	36.32	35.54	36.05	13536058.0
2014-06-09	AACG	Stock	4.95	5.0	4.77	4.77	7900.0
2014-06-09	AAIC-DELISTED	Stock	27.96	28.04	27.82	27.83	248023.0
2014-06-09	AAL	Stock	44.0	44.43	43.07	43.59	11689500.0
2014-06-09	AAMC-DELISTED	Stock	322.6471	324.7029	311.1882	324.4118	43731.0
2014-06-09	AAME	Stock	3.63	3.7	3.63	3.68	12600.0
2014-06-09	AAOI	Stock	21.03	21.44	20.73	21.39	91600.0
2014-06-09	AAON	Stock	14.7511	15.0222	14.6667	14.9333	262125.0
2014-06-09	AAP	Stock	128.2	128.97	126.79	127.71	632500.0
2014-06-09	AAT	Stock	34.89	35.05	34.55	34.57	97500.0
2014-06-09	AAU-DELISTED	Stock	1.32	1.34	1.29	1.34	74723.0
2014-06-09	AAUAF-DELISTED	Stock	1.32	1.36	1.29	1.36	75147.0
2014-06-09	AAV-DELISTED	Stock	6.75	6.98	6.74	6.77	496460.0
2014-06-09	AAWW-DELISTED	Stock	37.87	38.8	37.712	38.8	106840.0
2014-06-09	AAXJ	Stock	62.83	62.97	62.64	62.94	312688.0
2014-06-09	AAXN-DELISTED	Stock	13.31	13.66	13.26	13.53	759150.0
2014-06-09	AB	Stock	26.0	26.05	25.66	25.74	231000.0
2014-06-09	ABAC-DELISTED	Stock	2.1499	2.17	2.11	2.14	22135.0
2014-06-09	ABAX-DELISTED	Stock	43.39	44.5	43.39	44.1	93013.0
2014-06-09	ABB-DELISTED	Stock	23.59	23.755	23.585	23.68	1531497.0
2014-06-09	ABBNY-DELISTED	Stock	23.59	23.755	23.585	23.69	1607820.0
2014-06-09	ABBV	Stock	54.42	54.88	53.72	53.84	6297500.0
2014-06-09	ABC-DELISTED	Stock	72.4	72.84	72.11	72.32	1412158.0
2014-06-09	ABCB	Stock	21.94	22.44	21.61	22.29	39400.0
2014-06-09	ABCD-DELISTED	Stock	2.07	2.08	1.92	2.0	72982.0
2014-06-09	ABCO-DELISTED	Stock	50.9	52.3	50.83	51.22	130669.0
2014-06-09	ABDC-DELISTED	Stock	14.8	14.89	14.51	14.73	22877.0
2014-06-09	ABE-DELISTED	Stock	14.35	14.88	14.35	14.57	33287.0
2014-06-09	ABEO	Stock	400.0	425.0	400.0	425.0	6.0
2014-06-09	ABEV	Stock	7.21	7.35	7.2	7.33	8139400.0
2014-06-09	ABG	Stock	65.58	65.92	64.79	65.24	272900.0
2014-06-09	ABGB-DELISTED	Stock	27.52	27.5598	27.18	27.42	9888.0
2014-06-09	ABIL-DELISTED	Stock	9.75	9.75	9.75	9.75	2000.0
2014-06-09	ABM	Stock	27.04	27.13	26.85	27.07	346000.0
2014-06-09	ABMD-DELISTED	Stock	23.44	23.62	23.14	23.4	112998.0
2014-06-09	ABR	Stock	7.23	7.27	7.17	7.2	156900.0
2014-06-09	ABR.A-DELISTED	Stock	24.28	24.32	24.24	24.32	7670.0
2014-06-09	ABR.B-DELISTED	Stock	23.6	23.83	23.6	23.83	6086.0
2014-06-09	ABR.C-DELISTED	Stock	25.1	25.1	24.95	24.98	15759.0

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

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