PREVIEW / stock_daily / 2013-12-16

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-16.parquet
  size:    218 KB
  rows:    6,488
  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
2013-12-16	AAPL	Stock	19.8221	20.0943	19.8218	19.9107	282592800.0
2013-12-16	MSFT	Stock	36.73	37.0	36.54	36.89	31734200.0
2013-12-16	NVDA	Stock	0.3758	0.3793	0.3755	0.376	237620000.0
2013-12-16	AMZN	Stock	19.2515	19.585	19.25	19.4485	45034000.0
2013-12-16	META	Stock	53.25	54.5	52.91	53.81	85119000.0
2013-12-16	TSLA	Stock	9.8987	10.0287	9.74	9.8627	100129500.0
2013-12-16	TLT	Stock	103.58	103.69	102.73	102.83	6376381.0
2013-12-16	ES	Stock	41.76	42.09	41.63	41.74	2203300.0
2013-12-16	CL	Stock	64.14	64.4	63.83	64.04	2676600.0
2013-12-16	A	Stock	39.5207	39.907	39.392	39.5136	2356329.0
2013-12-16	AABA-DELISTED	Stock	39.97	40.27	39.6	39.73	10660224.0
2013-12-16	AACG	Stock	4.0	4.03	3.93	3.93	15400.0
2013-12-16	AAIC-DELISTED	Stock	25.95	26.17	25.882	25.99	92623.0
2013-12-16	AAL	Stock	26.63	26.77	26.35	26.61	13181300.0
2013-12-16	AAMC-DELISTED	Stock	317.6324	317.6324	299.7059	304.4118	65158.0
2013-12-16	AAME	Stock	4.04	4.05	4.01	4.04	23000.0
2013-12-16	AAOI	Stock	14.93	15.87	14.71	15.48	92400.0
2013-12-16	AAON	Stock	13.4489	13.9511	13.3689	13.6	206550.0
2013-12-16	AAP	Stock	110.01	110.4	108.88	109.27	774400.0
2013-12-16	AAT	Stock	30.98	31.25	30.77	31.16	184000.0
2013-12-16	AAU-DELISTED	Stock	1.05	1.1	1.05	1.08	40947.0
2013-12-16	AAUAF-DELISTED	Stock	1.05	1.1	1.05	1.07	41430.0
2013-12-16	AAV-DELISTED	Stock	4.4	4.4	4.24	4.25	135935.0
2013-12-16	AAWW-DELISTED	Stock	37.13	38.75	36.9	37.74	424534.0
2013-12-16	AAXJ	Stock	59.65	60.09	59.65	59.81	503350.0
2013-12-16	AAXN-DELISTED	Stock	16.05	17.17	15.94	16.9	2666431.0
2013-12-16	AB	Stock	21.5	21.76	21.36	21.39	270300.0
2013-12-16	ABAC-DELISTED	Stock	2.18	2.27	2.15	2.21	28507.0
2013-12-16	ABAX-DELISTED	Stock	36.05	36.814	35.75	36.47	80573.0
2013-12-16	ABB-DELISTED	Stock	24.9	25.01	24.81	24.89	819419.0
2013-12-16	ABBNY-DELISTED	Stock	24.9	25.01	24.81	24.9	869691.0
2013-12-16	ABBV	Stock	53.42	54.78	52.98	53.37	9846300.0
2013-12-16	ABC-DELISTED	Stock	68.84	69.14	68.14	68.46	1598403.0
2013-12-16	ABCB	Stock	20.12	20.44	19.62	20.34	66700.0
2013-12-16	ABCD-DELISTED	Stock	1.72	1.73	1.66	1.73	18439.0
2013-12-16	ABCO-DELISTED	Stock	61.45	62.89	61.0	62.56	168145.0
2013-12-16	ABE-DELISTED	Stock	19.9	19.96	19.86	19.86	31409.0
2013-12-16	ABEO	Stock	350.0	350.0	325.0	350.0	17.0
2013-12-16	ABEV	Stock	6.97	7.17	6.96	7.04	8305400.0
2013-12-16	ABFS-DELISTED	Stock	33.78	33.88	32.72	33.19	416032.0
2013-12-16	ABG	Stock	52.03	53.49	51.46	53.43	166100.0
2013-12-16	ABGB-DELISTED	Stock	13.49	13.54	13.38	13.42	2695.0
2013-12-16	ABM	Stock	27.65	27.99	27.4	27.83	171700.0
2013-12-16	ABMD-DELISTED	Stock	26.75	26.86	26.22	26.64	247554.0
2013-12-16	ABR	Stock	6.54	6.6	6.48	6.48	110000.0
2013-12-16	ABR.A-DELISTED	Stock	24.27	24.27	23.69	23.9799	6400.0
2013-12-16	ABR.B-DELISTED	Stock	21.9999	21.9999	21.7246	21.7246	2700.0
2013-12-16	ABT	Stock	36.45	36.81	36.32	36.53	6704900.0
2013-12-16	ABTL-DELISTED	Stock	11.3249	11.58	10.854	11.38	202981.0
2013-12-16	ABUS	Stock	7.26	7.59	7.26	7.54	145000.0

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

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