PREVIEW / stock_daily / 2011-06-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-23.parquet
  size:    197 KB
  rows:    6,107
  symbols: 3,550

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
2011-06-23	AAPL	Stock	11.3907	11.8461	11.3614	11.8296	559759200.0
2011-06-23	MSFT	Stock	24.44	24.65	24.2	24.63	59470400.0
2011-06-23	NVDA	Stock	0.3885	0.408	0.385	0.4053	744024000.0
2011-06-23	AMZN	Stock	9.475	9.723	9.415	9.708	92192000.0
2011-06-23	TSLA	Stock	1.8133	1.848	1.7473	1.8473	17550000.0
2011-06-23	TLT	Stock	97.24	97.74	97.15	97.39	8587584.0
2011-06-23	ES	Stock	34.49	34.58	34.16	34.57	2257200.0
2011-06-23	CL	Stock	43.48	43.48	42.69	43.105	8119000.0
2011-06-23	A	Stock	34.4635	35.3934	33.9342	35.3219	4860007.0
2011-06-23	AABA-DELISTED	Stock	15.05	15.09	14.72	15.08	31444190.0
2011-06-23	AACC-DELISTED	Stock	3.59	3.85	3.55	3.66	58619.0
2011-06-23	AACG	Stock	10.25	10.26	10.06	10.06	7800.0
2011-06-23	AAIC-DELISTED	Stock	29.97	30.72	29.9	30.64	34636.0
2011-06-23	AAME	Stock	2.0	2.02	1.88	2.02	18000.0
2011-06-23	AAON	Stock	6.397	6.4711	6.2756	6.4533	195413.0
2011-06-23	AAP	Stock	58.31	59.08	58.06	59.01	1494400.0
2011-06-23	AAT	Stock	21.88	22.11	21.53	21.82	192700.0
2011-06-23	AATI-DELISTED	Stock	6.04	6.05	6.04	6.04	301110.0
2011-06-23	AAU-DELISTED	Stock	3.33	3.35	3.19	3.26	342404.0
2011-06-23	AAUAF-DELISTED	Stock	3.33	3.35	3.19	3.26	343304.0
2011-06-23	AAV-DELISTED	Stock	7.82	7.82	7.64	7.73	317156.0
2011-06-23	AAWW-DELISTED	Stock	58.28	58.53	56.57	58.31	182952.0
2011-06-23	AAXJ	Stock	59.25	59.77	58.87	59.77	844630.0
2011-06-23	AAXN-DELISTED	Stock	4.2299	4.38	4.17	4.38	420548.0
2011-06-23	AB	Stock	19.03	19.18	18.73	19.09	354700.0
2011-06-23	ABAC-DELISTED	Stock	2.18	2.49	2.18	2.44	11642.0
2011-06-23	ABAX-DELISTED	Stock	28.11	28.49	27.6	28.4	43002.0
2011-06-23	ABB-DELISTED	Stock	24.76	24.93	24.46	24.88	4759492.0
2011-06-23	ABBC-DELISTED	Stock	10.05	10.12	9.9	10.02	153348.0
2011-06-23	ABBNY-DELISTED	Stock	24.76	24.93	24.46	24.87	6047644.0
2011-06-23	ABC-DELISTED	Stock	40.96	41.38	40.41	41.32	2391773.0
2011-06-23	ABCB	Stock	8.71	8.89	8.65	8.76	43500.0
2011-06-23	ABCD-DELISTED	Stock	3.19	3.25	3.0	3.24	48352.0
2011-06-23	ABCO-DELISTED	Stock	26.33	26.71	26.05	26.65	90742.0
2011-06-23	ABCW-DELISTED	Stock	0.7	0.75	0.66	0.75	6300.0
2011-06-23	ABD-DELISTED	Stock	7.47	7.66	7.36	7.63	187090.0
2011-06-23	ABE-DELISTED	Stock	18.25	18.27	18.0	18.18	12950.0
2011-06-23	ABEO	Stock	2250.0	2250.0	2187.5	2250.0	9.0
2011-06-23	ABFS-DELISTED	Stock	22.13	22.75	21.82	22.67	402449.0
2011-06-23	ABG	Stock	16.7	17.42	16.61	17.41	451500.0
2011-06-23	ABH-DELISTED	Stock	21.75	22.0	21.38	21.89	420383.0
2011-06-23	ABM	Stock	23.02	23.26	22.61	23.06	248400.0
2011-06-23	ABMD-DELISTED	Stock	16.33	16.33	15.86	16.2	188080.0
2011-06-23	ABR	Stock	4.46	4.67	4.46	4.63	53800.0
2011-06-23	ABT	Stock	24.8344	24.964	24.5706	24.9112	14430388.0
2011-06-23	ABTL-DELISTED	Stock	4.9	5.0	4.75	4.9	12450.0
2011-06-23	ABUS	Stock	2.5	2.58	2.47	2.58	2200.0
2011-06-23	ABV-DELISTED	Stock	32.04	32.04	31.37	32.01	1166980.0
2011-06-23	ABVA-DELISTED	Stock	4.91	5.01	4.705	4.96	1362.0
2011-06-23	ABVT-DELISTED	Stock	69.91	70.99	69.57	70.27	278965.0

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

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