PREVIEW / stock_daily / 2014-12-08

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-08.parquet
  size:    222 KB
  rows:    6,661
  symbols: 3,562

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-12-08	AAPL	Stock	28.525	28.6625	27.905	28.1	230659600.0
2014-12-08	MSFT	Stock	48.26	48.35	47.45	47.7	26663100.0
2014-12-08	NVDA	Stock	0.526	0.5312	0.5158	0.52	226944000.0
2014-12-08	AMZN	Stock	15.5785	15.828	15.241	15.332	72784000.0
2014-12-08	GOOGL	Stock	26.461	26.6908	26.35	26.5365	64636360.0
2014-12-08	META	Stock	76.18	77.25	75.4	76.52	25733900.0
2014-12-08	TSLA	Stock	14.7693	14.9907	14.156	14.2907	138384000.0
2014-12-08	TLT	Stock	121.42	122.835	121.1382	122.57	6021774.0
2014-12-08	ES	Stock	51.42	52.12	51.25	51.95	2191600.0
2014-12-08	CL	Stock	69.5	69.81	69.22	69.44	2613700.0
2014-12-08	A	Stock	42.23	42.51	41.42	41.51	1425800.0
2014-12-08	AA.B-DELISTED	Stock	52.2	52.416	51.15	51.4	77580.0
2014-12-08	AABA-DELISTED	Stock	50.52	50.9	49.22	49.6399	17374818.0
2014-12-08	AAC-DELISTED	Stock	31.65	33.322	30.89	30.94	56640.0
2014-12-08	AACG	Stock	3.13	3.48	3.13	3.3	3100.0
2014-12-08	AAIC-DELISTED	Stock	27.79	27.79	27.5	27.53	235411.0
2014-12-08	AAL	Stock	50.44	51.32	50.15	50.82	16167300.0
2014-12-08	AAMC-DELISTED	Stock	142.6676	142.6676	134.1324	134.1324	28461.0
2014-12-08	AAME	Stock	3.88	3.88	3.78	3.88	2300.0
2014-12-08	AAMI	Stock	15.78	16.03	15.65	15.92	229400.0
2014-12-08	AAOI	Stock	10.11	10.17	9.59	9.78	428700.0
2014-12-08	AAON	Stock	14.0267	14.2333	13.88	13.98	225900.0
2014-12-08	AAP	Stock	154.89	154.89	152.89	153.68	817200.0
2014-12-08	AAT	Stock	39.17	40.07	39.17	39.61	126400.0
2014-12-08	AAU-DELISTED	Stock	1.05	1.05	1.0	1.01	65559.0
2014-12-08	AAUAF-DELISTED	Stock	1.05	1.05	1.0	1.01	65959.0
2014-12-08	AAV-DELISTED	Stock	4.47	4.47	4.29	4.39	261040.0
2014-12-08	AAVL-DELISTED	Stock	43.81	44.48	43.1	44.26	76846.0
2014-12-08	AAWW-DELISTED	Stock	47.32	47.67	46.25	46.7	221708.0
2014-12-08	AAXJ	Stock	62.35	62.44	62.07	62.15	828192.0
2014-12-08	AAXN-DELISTED	Stock	24.0	24.0999	21.66	23.335	8355819.0
2014-12-08	AB	Stock	25.75	25.96	24.75	25.07	1012000.0
2014-12-08	ABAC-DELISTED	Stock	2.03	2.07	2.02	2.021	5695.0
2014-12-08	ABAX-DELISTED	Stock	57.26	58.06	56.44	56.65	124384.0
2014-12-08	ABB-DELISTED	Stock	21.68	21.74	21.499	21.56	1609689.0
2014-12-08	ABBNY-DELISTED	Stock	21.68	21.74	21.499	21.56	1677758.0
2014-12-08	ABBV	Stock	69.81	70.76	69.35	69.42	5452100.0
2014-12-08	ABC-DELISTED	Stock	92.01	92.84	91.97	92.54	1347944.0
2014-12-08	ABCB	Stock	25.25	25.88	25.25	25.43	86600.0
2014-12-08	ABCD-DELISTED	Stock	1.6109	1.6901	1.6109	1.65	5522.0
2014-12-08	ABCO-DELISTED	Stock	38.95	39.57	38.28	38.41	483903.0
2014-12-08	ABDC-DELISTED	Stock	12.59	12.84	12.36	12.4	30271.0
2014-12-08	ABE-DELISTED	Stock	13.95	14.09	13.84	13.89	3896.0
2014-12-08	ABEV	Stock	6.11	6.13	5.99	5.99	17530600.0
2014-12-08	ABG	Stock	76.52	77.24	75.64	76.23	270600.0
2014-12-08	ABGB-DELISTED	Stock	12.61	12.67	12.35	12.39	54418.0
2014-12-08	ABIL-DELISTED	Stock	9.92	9.92	9.92	9.92	1000.0
2014-12-08	ABM	Stock	27.23	27.61	26.88	27.04	158100.0
2014-12-08	ABMD-DELISTED	Stock	36.41	37.0	36.25	36.49	302099.0
2014-12-08	ABR	Stock	6.72	6.73	6.61	6.64	76700.0

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

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