PREVIEW / stock_daily / 2014-12-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-09.parquet
  size:    223 KB
  rows:    6,644
  symbols: 3,550

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-09	AAPL	Stock	27.5475	28.575	27.3375	28.53	240832000.0
2014-12-09	MSFT	Stock	47.11	47.92	47.05	47.59	24330500.0
2014-12-09	NVDA	Stock	0.5168	0.5195	0.509	0.5182	239448000.0
2014-12-09	AMZN	Stock	15.1495	15.682	15.057	15.625	80990000.0
2014-12-09	GOOGL	Stock	26.2938	26.8325	26.1705	26.8055	43376260.0
2014-12-09	META	Stock	75.2	76.93	74.78	76.84	25358600.0
2014-12-09	TSLA	Stock	13.956	14.5153	13.618	14.4593	141472500.0
2014-12-09	TLT	Stock	123.6	123.97	122.96	123.2	6639727.0
2014-12-09	ES	Stock	51.97	52.34	51.8	52.24	2665900.0
2014-12-09	CL	Stock	68.93	69.37	68.77	69.33	2781900.0
2014-12-09	A	Stock	40.99	41.43	40.98	41.4	1798100.0
2014-12-09	AA.B-DELISTED	Stock	50.66	51.0599	50.05	50.79	97192.0
2014-12-09	AABA-DELISTED	Stock	48.75	50.53	48.29	50.5	17808949.0
2014-12-09	AAC-DELISTED	Stock	30.89	32.64	30.245	32.51	57079.0
2014-12-09	AACG	Stock	3.41	3.48	3.3	3.37	4800.0
2014-12-09	AAIC-DELISTED	Stock	27.5	28.01	27.22	28.01	249061.0
2014-12-09	AAL	Stock	49.1	49.2	47.39	48.31	20575400.0
2014-12-09	AAMC-DELISTED	Stock	130.8824	134.4059	125.4441	132.6471	65127.0
2014-12-09	AAME	Stock	3.87	3.88	3.8	3.88	2100.0
2014-12-09	AAMI	Stock	15.9	16.34	15.77	15.94	612800.0
2014-12-09	AAOI	Stock	9.59	10.25	9.38	10.25	368400.0
2014-12-09	AAON	Stock	13.8	14.48	13.78	14.46	241200.0
2014-12-09	AAP	Stock	152.01	158.65	152.01	158.25	1242000.0
2014-12-09	AAT	Stock	39.31	40.28	39.31	40.14	120300.0
2014-12-09	AAU-DELISTED	Stock	1.0	1.07	0.999	1.01	322080.0
2014-12-09	AAUAF-DELISTED	Stock	1.01	1.08	1.009	1.01	320811.0
2014-12-09	AAV-DELISTED	Stock	4.37	4.66	4.35	4.54	229174.0
2014-12-09	AAVL-DELISTED	Stock	43.91	49.07	43.57	46.84	341743.0
2014-12-09	AAWW-DELISTED	Stock	45.77	46.62	44.7701	46.39	246230.0
2014-12-09	AAXJ	Stock	61.48	61.5	61.185	61.44	2055215.0
2014-12-09	AAXN-DELISTED	Stock	21.57	23.32	21.06	23.26	4833963.0
2014-12-09	AB	Stock	23.72	25.3	23.31	25.14	617400.0
2014-12-09	ABAC-DELISTED	Stock	2.02	2.02	2.0168	2.0168	6100.0
2014-12-09	ABAX-DELISTED	Stock	55.9	57.5199	55.9	57.32	142158.0
2014-12-09	ABB-DELISTED	Stock	21.42	21.635	21.41	21.62	1508997.0
2014-12-09	ABBNY-DELISTED	Stock	21.42	21.635	21.41	21.61	1697273.0
2014-12-09	ABBV	Stock	68.21	69.19	67.61	69.14	6833800.0
2014-12-09	ABC-DELISTED	Stock	91.45	92.25	90.77	92.08	1182540.0
2014-12-09	ABCB	Stock	25.24	26.0	25.05	25.94	105800.0
2014-12-09	ABCD-DELISTED	Stock	1.61	1.65	1.6	1.65	22544.0
2014-12-09	ABCO-DELISTED	Stock	37.89	38.53	37.89	38.32	393645.0
2014-12-09	ABDC-DELISTED	Stock	12.38	12.51	12.06	12.12	84786.0
2014-12-09	ABE-DELISTED	Stock	13.7801	13.89	13.765	13.89	8564.0
2014-12-09	ABEO	Stock	165.0	175.0	165.0	175.0	64.0
2014-12-09	ABEV	Stock	5.99	6.08	5.91	6.04	20520300.0
2014-12-09	ABG	Stock	74.79	76.78	74.79	76.7	262000.0
2014-12-09	ABGB-DELISTED	Stock	12.16	12.44	12.08	12.31	32539.0
2014-12-09	ABIL-DELISTED	Stock	9.91	9.92	9.83	9.83	900.0
2014-12-09	ABM	Stock	26.0	28.2	25.94	28.16	410700.0
2014-12-09	ABMD-DELISTED	Stock	36.11	37.84	35.755	37.8	360211.0

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

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