PREVIEW / stock_daily / 2014-01-23

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-23.parquet
  size:    218 KB
  rows:    6,473
  symbols: 3,552

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-01-23	AAPL	Stock	19.6407	19.875	19.4575	19.8636	403239200.0
2014-01-23	MSFT	Stock	36.09	36.13	35.52	36.06	43954000.0
2014-01-23	NVDA	Stock	0.3995	0.4038	0.3962	0.3993	185028000.0
2014-01-23	AMZN	Stock	20.05	20.3085	19.8895	19.9935	60508000.0
2014-01-23	META	Stock	56.37	56.68	55.69	56.63	47951800.0
2014-01-23	TSLA	Stock	11.8153	12.1587	11.5613	12.1	118011000.0
2014-01-23	TLT	Stock	105.88	107.09	105.88	106.79	12960976.0
2014-01-23	ES	Stock	43.22	43.37	43.0	43.13	1383600.0
2014-01-23	CL	Stock	63.43	63.74	63.23	63.44	3263800.0
2014-01-23	A	Stock	43.2618	43.2833	42.4964	42.5393	4282773.0
2014-01-23	AABA-DELISTED	Stock	39.31	39.77	39.14	39.41	14396437.0
2014-01-23	AACG	Stock	4.0	4.0	3.9	3.9	17800.0
2014-01-23	AAIC-DELISTED	Stock	26.54	26.5699	26.32	26.44	97330.0
2014-01-23	AAL	Stock	30.65	31.46	30.62	31.35	11394600.0
2014-01-23	AAMC-DELISTED	Stock	324.1559	331.7647	309.5	315.0	53655.0
2014-01-23	AAME	Stock	4.0	4.04	3.91	4.0	20100.0
2014-01-23	AAOI	Stock	13.84	14.36	13.6	13.73	38100.0
2014-01-23	AAON	Stock	15.1511	15.1822	14.5911	14.8178	302850.0
2014-01-23	AAP	Stock	116.81	117.53	115.29	116.33	659100.0
2014-01-23	AAT	Stock	32.1	32.49	31.83	32.46	113000.0
2014-01-23	AAU-DELISTED	Stock	1.59	1.65	1.53	1.607	171906.0
2014-01-23	AAUAF-DELISTED	Stock	1.59	1.65	1.53	1.607	174603.0
2014-01-23	AAV-DELISTED	Stock	4.27	4.3	4.24	4.28	141533.0
2014-01-23	AAWW-DELISTED	Stock	39.29	39.29	38.54	38.59	577558.0
2014-01-23	AAXJ	Stock	57.73	57.83	56.9656	57.3	996482.0
2014-01-23	AAXN-DELISTED	Stock	17.9	17.98	17.53	17.7	607203.0
2014-01-23	AB	Stock	22.98	23.05	22.53	22.6	261600.0
2014-01-23	ABAC-DELISTED	Stock	2.03	2.0701	1.93	2.02	66779.0
2014-01-23	ABAX-DELISTED	Stock	44.01	44.1	43.23	43.41	181329.0
2014-01-23	ABB-DELISTED	Stock	26.01	26.04	25.76	26.01	2840952.0
2014-01-23	ABBNY-DELISTED	Stock	26.01	26.04	25.76	26.02	3087421.0
2014-01-23	ABBV	Stock	48.74	49.06	48.39	48.87	7270500.0
2014-01-23	ABC-DELISTED	Stock	70.0	70.88	69.22	69.66	1927408.0
2014-01-23	ABCB	Stock	20.71	21.06	20.43	20.97	57400.0
2014-01-23	ABCD-DELISTED	Stock	2.12	2.12	1.9301	1.9301	5200.0
2014-01-23	ABCO-DELISTED	Stock	63.14	63.89	62.73	63.63	164449.0
2014-01-23	ABE-DELISTED	Stock	13.05	13.09	13.05	13.07	8529.0
2014-01-23	ABEO	Stock	462.5	487.5	462.5	475.0	32.0
2014-01-23	ABEV	Stock	7.22	7.23	6.86	7.0	20524500.0
2014-01-23	ABFS-DELISTED	Stock	35.48	35.48	34.69	34.95	177929.0
2014-01-23	ABG	Stock	49.67	50.27	49.11	49.37	266200.0
2014-01-23	ABGB-DELISTED	Stock	17.47	17.47	16.83	17.071	30866.0
2014-01-23	ABM	Stock	28.05	28.16	27.81	28.09	197300.0
2014-01-23	ABMD-DELISTED	Stock	27.4	27.57	26.84	27.24	234148.0
2014-01-23	ABR	Stock	6.91	7.03	6.9	7.03	150600.0
2014-01-23	ABR.A-DELISTED	Stock	24.97	25.0	24.97	24.97	2100.0
2014-01-23	ABR.B-DELISTED	Stock	22.82	22.94	22.65	22.94	2960.0
2014-01-23	ABT	Stock	37.9	37.93	37.22	37.43	10207300.0
2014-01-23	ABTL-DELISTED	Stock	17.57	17.99	17.18	17.75	222816.0
2014-01-23	ABUS	Stock	12.43	12.5	12.01	12.36	150900.0

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

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