PREVIEW / stock_daily / 2013-12-17

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-17.parquet
  size:    218 KB
  rows:    6,493
  symbols: 3,565

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-17	AAPL	Stock	19.8504	19.98	19.7636	19.8211	229902400.0
2013-12-17	MSFT	Stock	36.94	37.11	36.33	36.52	45687700.0
2013-12-17	NVDA	Stock	0.3758	0.3788	0.3725	0.3778	274104000.0
2013-12-17	AMZN	Stock	19.5325	19.568	19.325	19.3825	46878000.0
2013-12-17	META	Stock	54.76	55.18	54.24	54.86	78751000.0
2013-12-17	TSLA	Stock	9.8387	10.3087	9.7547	10.164	157425000.0
2013-12-17	TLT	Stock	102.61	103.4	102.59	103.29	6015838.0
2013-12-17	ES	Stock	41.72	41.83	41.38	41.51	1376400.0
2013-12-17	CL	Stock	64.0	64.08	63.28	63.58	2243900.0
2013-12-17	A	Stock	40.0286	40.98	39.9213	40.3219	4484784.0
2013-12-17	AABA-DELISTED	Stock	39.99	40.0	39.4	39.5	8969321.0
2013-12-17	AACG	Stock	3.99	4.02	3.87	3.97	16200.0
2013-12-17	AAIC-DELISTED	Stock	26.0	26.14	25.81	25.84	124930.0
2013-12-17	AAL	Stock	26.47	26.59	25.95	26.1	11413200.0
2013-12-17	AAMC-DELISTED	Stock	304.3794	304.4118	286.1765	295.5882	65600.0
2013-12-17	AAME	Stock	4.02	4.04	3.95	3.98	6600.0
2013-12-17	AAOI	Stock	15.51	15.83	14.89	15.14	77500.0
2013-12-17	AAON	Stock	13.5556	13.8044	13.1289	13.2044	236250.0
2013-12-17	AAP	Stock	109.63	109.88	108.03	108.46	846300.0
2013-12-17	AAT	Stock	31.1	31.49	30.92	31.37	88000.0
2013-12-17	AAU-DELISTED	Stock	1.08	1.09	1.06	1.06	45479.0
2013-12-17	AAUAF-DELISTED	Stock	1.08	1.09	1.06	1.06	46243.0
2013-12-17	AAV-DELISTED	Stock	4.23	4.2511	4.23	4.24	60489.0
2013-12-17	AAWW-DELISTED	Stock	37.61	38.31	37.6	37.73	269817.0
2013-12-17	AAXJ	Stock	59.65	59.7	59.34	59.35	702215.0
2013-12-17	AAXN-DELISTED	Stock	16.94	16.98	16.25	16.28	1064254.0
2013-12-17	AB	Stock	21.33	21.38	21.01	21.21	254900.0
2013-12-17	ABAC-DELISTED	Stock	2.1901	2.339	2.18	2.23	39012.0
2013-12-17	ABAX-DELISTED	Stock	36.36	37.02	36.36	37.01	112907.0
2013-12-17	ABB-DELISTED	Stock	24.92	24.925	24.76	24.82	548084.0
2013-12-17	ABBNY-DELISTED	Stock	24.92	24.925	24.76	24.83	888530.0
2013-12-17	ABBV	Stock	53.43	53.92	53.0	53.63	7987300.0
2013-12-17	ABC-DELISTED	Stock	68.72	68.76	68.04	68.35	1444665.0
2013-12-17	ABCB	Stock	20.29	20.29	19.58	20.02	43500.0
2013-12-17	ABCD-DELISTED	Stock	1.73	1.7801	1.7	1.756	33955.0
2013-12-17	ABCO-DELISTED	Stock	62.36	63.58	61.855	63.27	155079.0
2013-12-17	ABE-DELISTED	Stock	19.84	19.85	19.72	19.78	40545.0
2013-12-17	ABEO	Stock	325.0	350.0	300.0	337.5	95.0
2013-12-17	ABEV	Stock	7.13	7.13	6.96	7.06	8273900.0
2013-12-17	ABFS-DELISTED	Stock	33.02	33.57	32.88	33.26	236541.0
2013-12-17	ABG	Stock	53.63	54.14	52.74	53.54	167600.0
2013-12-17	ABGB-DELISTED	Stock	13.25	13.2993	13.04	13.1	6925.0
2013-12-17	ABM	Stock	27.78	27.78	27.38	27.4	119600.0
2013-12-17	ABMD-DELISTED	Stock	26.65	26.65	26.09	26.43	142303.0
2013-12-17	ABR	Stock	6.45	6.6	6.45	6.58	67400.0
2013-12-17	ABR.A-DELISTED	Stock	23.99	23.99	23.9892	23.9892	2080.0
2013-12-17	ABR.B-DELISTED	Stock	21.75	21.75	21.75	21.75	2241.0
2013-12-17	ABT	Stock	36.45	36.64	36.31	36.61	6911800.0
2013-12-17	ABTL-DELISTED	Stock	11.36	12.64	11.36	12.39	242126.0
2013-12-17	ABUS	Stock	7.58	7.59	7.48	7.52	38800.0

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

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