PREVIEW / stock_daily / 2011-07-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-18.parquet
  size:    198 KB
  rows:    6,142
  symbols: 3,558

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-07-18	AAPL	Stock	13.0511	13.3804	13.0457	13.35	572653200.0
2011-07-18	MSFT	Stock	26.63	26.9	26.26	26.59	44501900.0
2011-07-18	NVDA	Stock	0.3498	0.3518	0.3405	0.345	818200000.0
2011-07-18	AMZN	Stock	10.6265	10.6695	10.4145	10.5765	57962000.0
2011-07-18	TSLA	Stock	1.8227	1.83	1.7753	1.8153	12778500.0
2011-07-18	TLT	Stock	96.06	96.17	95.2	95.24	8206444.0
2011-07-18	ES	Stock	34.89	34.91	34.22	34.29	2012100.0
2011-07-18	CL	Stock	44.225	44.445	43.81	43.995	4148000.0
2011-07-18	A	Stock	33.412	33.4478	32.0529	32.5179	9249308.0
2011-07-18	AABA-DELISTED	Stock	14.69	14.7	14.365	14.41	24328787.0
2011-07-18	AACC-DELISTED	Stock	4.14	4.6	4.13	4.52	24611.0
2011-07-18	AACG	Stock	10.67	10.76	10.67	10.67	2000.0
2011-07-18	AAIC-DELISTED	Stock	30.82	30.82	29.74	30.08	72967.0
2011-07-18	AAME	Stock	2.09	2.09	2.09	2.09	100.0
2011-07-18	AAON	Stock	6.9481	6.9748	6.8119	6.8681	136350.0
2011-07-18	AAP	Stock	55.2	55.41	54.58	54.82	1190700.0
2011-07-18	AAT	Stock	22.71	22.71	22.02	22.28	136000.0
2011-07-18	AATI-DELISTED	Stock	6.08	6.09	6.07	6.07	664984.0
2011-07-18	AAU-DELISTED	Stock	3.9398	3.97	3.75	3.8	347295.0
2011-07-18	AAUAF-DELISTED	Stock	3.95	3.98	3.76	3.79	346999.0
2011-07-18	AAV-DELISTED	Stock	7.54	7.58	7.39	7.45	339606.0
2011-07-18	AAWW-DELISTED	Stock	56.42	56.73	54.23	54.32	204220.0
2011-07-18	AAXJ	Stock	61.0	61.21	60.58	60.86	257784.0
2011-07-18	AAXN-DELISTED	Stock	4.26	4.26	4.17	4.18	235815.0
2011-07-18	AB	Stock	18.36	18.36	17.89	17.95	414400.0
2011-07-18	ABAC-DELISTED	Stock	2.82	2.84	2.65	2.66	30088.0
2011-07-18	ABAX-DELISTED	Stock	28.84	28.85	28.13	28.46	29376.0
2011-07-18	ABB-DELISTED	Stock	24.75	24.85	24.4906	24.72	4626137.0
2011-07-18	ABBC-DELISTED	Stock	10.21	10.21	9.95	10.02	16888.0
2011-07-18	ABBNY-DELISTED	Stock	24.75	24.85	24.4906	24.74	4627337.0
2011-07-18	ABC-DELISTED	Stock	41.17	41.69	40.73	41.21	1739472.0
2011-07-18	ABCB	Stock	9.25	9.45	9.25	9.38	73400.0
2011-07-18	ABCD-DELISTED	Stock	3.34	3.38	3.34	3.37	19998.0
2011-07-18	ABCO-DELISTED	Stock	27.7	27.91	26.58	26.88	101927.0
2011-07-18	ABCW-DELISTED	Stock	0.75	0.75	0.68	0.68	39480.0
2011-07-18	ABD-DELISTED	Stock	7.73	7.8	7.43	7.45	177400.0
2011-07-18	ABE-DELISTED	Stock	18.89	18.891	18.77	18.85	36214.0
2011-07-18	ABEO	Stock	2350.0	2625.0	2350.0	2562.5	14.0
2011-07-18	ABFS-DELISTED	Stock	26.08	26.24	25.73	25.85	281642.0
2011-07-18	ABG	Stock	19.46	19.52	18.94	19.5	357400.0
2011-07-18	ABH-DELISTED	Stock	19.52	19.68	19.19	19.28	427815.0
2011-07-18	ABM	Stock	23.28	23.4	23.05	23.15	247800.0
2011-07-18	ABMD-DELISTED	Stock	16.32	16.45	16.25	16.42	169163.0
2011-07-18	ABR	Stock	4.46	4.5	4.4	4.43	45700.0
2011-07-18	ABT	Stock	25.3958	25.4438	25.0791	25.2087	11167778.0
2011-07-18	ABTL-DELISTED	Stock	5.3981	5.3981	5.1505	5.2	5241.0
2011-07-18	ABUS	Stock	2.32	2.32	2.3	2.3	6600.0
2011-07-18	ABV-DELISTED	Stock	31.0	31.46	30.81	31.41	1736762.0
2011-07-18	ABVA-DELISTED	Stock	4.7	4.7	4.61	4.65	1300.0
2011-07-18	ABVT-DELISTED	Stock	65.96	66.022	64.37	64.75	159096.0

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

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