PREVIEW / stock_daily / 2013-09-26

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-26.parquet
  size:    212 KB
  rows:    6,387
  symbols: 3,531

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-09-26	AAPL	Stock	17.3571	17.4486	17.2821	17.365	237221600.0
2013-09-26	MSFT	Stock	32.64	33.0	32.59	32.77	28504000.0
2013-09-26	NVDA	Stock	0.394	0.3948	0.3895	0.3918	148816000.0
2013-09-26	AMZN	Stock	15.695	15.9685	15.663	15.906	39798000.0
2013-09-26	META	Stock	50.01	50.6	49.5	50.39	98220100.0
2013-09-26	TSLA	Stock	12.4467	12.6453	12.374	12.576	99216000.0
2013-09-26	TLT	Stock	106.48	106.62	106.19	106.3	5117071.0
2013-09-26	ES	Stock	41.45	41.68	41.34	41.44	1155200.0
2013-09-26	CL	Stock	59.63	60.41	59.49	60.39	2687700.0
2013-09-26	A	Stock	37.1674	37.2818	36.8097	37.2604	3747059.0
2013-09-26	AABA-DELISTED	Stock	31.65	33.0	31.58	32.74	39075162.0
2013-09-26	AACG	Stock	4.91	5.06	4.9	4.9	104000.0
2013-09-26	AAIC-DELISTED	Stock	25.81	25.81	24.67	24.75	366122.0
2013-09-26	AAMC-DELISTED	Stock	141.1765	154.4118	141.1765	151.1765	109738.0
2013-09-26	AAME	Stock	4.05	4.05	4.02	4.03	9000.0
2013-09-26	AAMRQ-DELISTED	Stock	4.53	4.72	4.18	4.35	15211872.0
2013-09-26	AAON	Stock	11.8089	11.8444	11.5511	11.8	106875.0
2013-09-26	AAP	Stock	81.6	82.09	81.41	81.68	541400.0
2013-09-26	AAT	Stock	30.9	31.2	30.72	31.17	76000.0
2013-09-26	AAU-DELISTED	Stock	1.4	1.44	1.38	1.42	147842.0
2013-09-26	AAUAF-DELISTED	Stock	1.4	1.44	1.38	1.42	148042.0
2013-09-26	AAV-DELISTED	Stock	3.66	3.71	3.64	3.65	71035.0
2013-09-26	AAWW-DELISTED	Stock	45.38	46.565	45.0001	46.23	215678.0
2013-09-26	AAXJ	Stock	59.35	59.46	59.05	59.39	637431.0
2013-09-26	AAXN-DELISTED	Stock	15.03	15.2	14.9	15.16	944573.0
2013-09-26	AB	Stock	19.74	20.07	19.66	19.98	213000.0
2013-09-26	ABAC-DELISTED	Stock	0.8198	0.8301	0.78	0.828	55250.0
2013-09-26	ABAX-DELISTED	Stock	41.94	42.01	41.47	41.77	103687.0
2013-09-26	ABB-DELISTED	Stock	23.81	23.91	23.61	23.74	1095112.0
2013-09-26	ABBNY-DELISTED	Stock	23.81	23.91	23.61	23.74	1107839.0
2013-09-26	ABBV	Stock	45.33	45.62	44.81	45.0	5033900.0
2013-09-26	ABC-DELISTED	Stock	61.14	61.44	60.69	61.16	858889.0
2013-09-26	ABCB	Stock	18.87	18.98	18.66	18.78	39000.0
2013-09-26	ABCD-DELISTED	Stock	1.6199	1.62	1.51	1.51	13428.0
2013-09-26	ABCO-DELISTED	Stock	58.36	58.94	58.14	58.68	93939.0
2013-09-26	ABE-DELISTED	Stock	19.64	19.6967	19.64	19.691	1705.0
2013-09-26	ABEO	Stock	450.0	562.5	425.0	562.5	64.0
2013-09-26	ABFS-DELISTED	Stock	25.5	26.25	25.31	25.83	438532.0
2013-09-26	ABG	Stock	53.62	53.95	53.24	53.82	355000.0
2013-09-26	ABM	Stock	26.43	26.58	26.24	26.5	143700.0
2013-09-26	ABMD-DELISTED	Stock	18.93	19.279	18.36	18.64	605092.0
2013-09-26	ABR	Stock	6.88	6.92	6.82	6.9	183700.0
2013-09-26	ABR.A-DELISTED	Stock	24.6775	24.6775	24.6775	24.6775	100.0
2013-09-26	ABR.B-DELISTED	Stock	23.49	23.49	23.49	23.49	200.0
2013-09-26	ABT	Stock	33.75	33.87	33.48	33.66	8040800.0
2013-09-26	ABTL-DELISTED	Stock	7.34	7.38	7.27	7.28	23272.0
2013-09-26	ABUS	Stock	7.23	7.69	7.05	7.64	242300.0
2013-09-26	ABV-DELISTED	Stock	39.15	39.38	38.96	39.03	2510869.0
2013-09-26	ABX-DELISTED	Stock	18.75	18.93	18.36	18.54	10953112.0
2013-09-26	ACAD	Stock	24.73	26.76	24.73	26.21	2196900.0

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

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