PREVIEW / stock_daily / 2013-10-17

all stock daily files

  file:    by_date/stock_daily/2013/2013-10-17.parquet
  size:    213 KB
  rows:    6,389
  symbols: 3,526

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-10-17	AAPL	Stock	17.8564	18.0279	17.8457	18.0179	253593200.0
2013-10-17	MSFT	Stock	34.45	34.99	34.37	34.92	31359200.0
2013-10-17	NVDA	Stock	0.387	0.3918	0.387	0.3908	213324000.0
2013-10-17	AMZN	Stock	15.3535	15.55	15.262	15.5385	52968000.0
2013-10-17	META	Stock	51.12	52.22	50.95	52.21	71522000.0
2013-10-17	TSLA	Stock	12.236	12.32	12.066	12.1867	100575000.0
2013-10-17	TLT	Stock	106.52	107.12	106.29	106.81	11306167.0
2013-10-17	ES	Stock	41.5	42.37	41.24	42.29	2722000.0
2013-10-17	CL	Stock	61.89	63.63	61.79	63.41	4795900.0
2013-10-17	A	Stock	36.6595	37.6967	36.5737	37.6609	4960663.0
2013-10-17	AABA-DELISTED	Stock	32.88	33.01	32.31	32.75	24841729.0
2013-10-17	AACG	Stock	4.53	4.82	4.53	4.58	3900.0
2013-10-17	AAIC-DELISTED	Stock	24.22	24.7964	24.145	24.67	127175.0
2013-10-17	AAMC-DELISTED	Stock	157.0559	157.6471	152.9412	155.5882	28268.0
2013-10-17	AAME	Stock	4.05	4.07	4.03	4.04	12900.0
2013-10-17	AAMRQ-DELISTED	Stock	5.42	5.66	5.4	5.62	18247510.0
2013-10-17	AAOI	Stock	10.09	10.55	10.0	10.44	63100.0
2013-10-17	AAON	Stock	11.8356	12.16	11.7867	12.1067	237150.0
2013-10-17	AAP	Stock	96.65	97.97	95.82	97.22	3577600.0
2013-10-17	AAT	Stock	32.41	33.3	32.3	33.28	164200.0
2013-10-17	AAU-DELISTED	Stock	1.29	1.35	1.27	1.32	108254.0
2013-10-17	AAUAF-DELISTED	Stock	1.29	1.35	1.27	1.31	109521.0
2013-10-17	AAV-DELISTED	Stock	3.8	3.972	3.8	3.96	201698.0
2013-10-17	AAWW-DELISTED	Stock	44.38	45.4	44.34	45.37	224977.0
2013-10-17	AAXJ	Stock	60.69	61.27	60.68	61.2	450425.0
2013-10-17	AAXN-DELISTED	Stock	15.09	15.7999	15.08	15.7	1898642.0
2013-10-17	AB	Stock	20.7	21.44	20.7	21.36	719300.0
2013-10-17	ABAC-DELISTED	Stock	1.78	1.8387	1.67	1.7	127929.0
2013-10-17	ABAX-DELISTED	Stock	38.68	39.01	37.04	38.08	381919.0
2013-10-17	ABB-DELISTED	Stock	23.22	23.44	23.19	23.4	1091020.0
2013-10-17	ABBNY-DELISTED	Stock	23.22	23.44	23.19	23.41	1163213.0
2013-10-17	ABBV	Stock	46.95	48.32	46.95	48.17	7242400.0
2013-10-17	ABC-DELISTED	Stock	63.77	64.8	63.65	64.63	1642319.0
2013-10-17	ABCB	Stock	17.84	17.98	17.75	17.9	67600.0
2013-10-17	ABCD-DELISTED	Stock	1.3899	1.39	1.25	1.2601	35338.0
2013-10-17	ABCO-DELISTED	Stock	66.6	67.64	66.6	67.36	201050.0
2013-10-17	ABE-DELISTED	Stock	20.13	20.34	20.05	20.34	2394.0
2013-10-17	ABEO	Stock	487.5	487.5	425.0	475.0	40.0
2013-10-17	ABFS-DELISTED	Stock	24.19	26.19	24.061	25.84	817448.0
2013-10-17	ABG	Stock	52.42	53.66	51.82	53.62	392800.0
2013-10-17	ABGB-DELISTED	Stock	12.33	12.78	12.26	12.4	1562715.0
2013-10-17	ABM	Stock	27.0	27.37	26.97	27.37	284600.0
2013-10-17	ABMD-DELISTED	Stock	20.27	20.53	20.12	20.415	294427.0
2013-10-17	ABR	Stock	6.91	7.05	6.89	7.0	230000.0
2013-10-17	ABR.A-DELISTED	Stock	24.33	24.98	24.33	24.74	8400.0
2013-10-17	ABR.B-DELISTED	Stock	23.48	23.56	23.47	23.49	4000.0
2013-10-17	ABT	Stock	35.89	37.27	35.89	37.17	17370200.0
2013-10-17	ABTL-DELISTED	Stock	8.73	8.8	8.2	8.26	285299.0
2013-10-17	ABUS	Stock	8.38	8.77	8.12	8.53	1500900.0
2013-10-17	ABV-DELISTED	Stock	39.16	39.7	39.08	39.63	1137846.0

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

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