PREVIEW / stock_daily / 2011-09-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-07.parquet
  size:    194 KB
  rows:    6,095
  symbols: 3,525

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-09-07	AAPL	Stock	13.77	13.7714	13.6429	13.7118	350576800.0
2011-09-07	MSFT	Stock	25.69	26.0	25.57	26.0	41961000.0
2011-09-07	NVDA	Stock	0.3562	0.366	0.3465	0.3562	1606620000.0
2011-09-07	AMZN	Stock	10.94	11.0095	10.711	10.995	105916000.0
2011-09-07	TSLA	Stock	1.5593	1.6	1.552	1.5893	6888000.0
2011-09-07	TLT	Stock	112.28	112.37	111.31	111.51	11524280.0
2011-09-07	ES	Stock	33.69	33.83	33.59	33.8	1345600.0
2011-09-07	CL	Stock	44.915	45.91	44.855	45.905	6716600.0
2011-09-07	A	Stock	24.628	25.6795	24.6209	25.5293	8880655.0
2011-09-07	AABA-DELISTED	Stock	13.76	14.0	13.24	13.61	75308186.0
2011-09-07	AACC-DELISTED	Stock	4.1	4.23	4.08	4.09	22908.0
2011-09-07	AACG	Stock	9.68	9.86	9.68	9.7	4300.0
2011-09-07	AAIC-DELISTED	Stock	26.0	26.075	25.31	25.55	58880.0
2011-09-07	AAME	Stock	2.03	2.03	1.96	2.0	1900.0
2011-09-07	AAON	Stock	4.8	5.04	4.8	5.0163	255825.0
2011-09-07	AAP	Stock	60.28	60.98	60.02	60.95	858700.0
2011-09-07	AAT	Stock	19.45	19.88	19.1	19.67	151100.0
2011-09-07	AATI-DELISTED	Stock	5.97	5.97	5.93	5.94	692369.0
2011-09-07	AAU-DELISTED	Stock	3.3	3.42	3.22	3.39	148620.0
2011-09-07	AAUAF-DELISTED	Stock	3.3	3.42	3.22	3.39	158820.0
2011-09-07	AAV-DELISTED	Stock	5.54	5.6	5.43	5.44	394666.0
2011-09-07	AAWW-DELISTED	Stock	44.0	46.19	43.32	46.13	312857.0
2011-09-07	AAXJ	Stock	55.69	56.18	55.39	56.14	300530.0
2011-09-07	AAXN-DELISTED	Stock	4.41	4.47	4.3608	4.45	314762.0
2011-09-07	AB	Stock	16.74	17.0	16.55	16.83	287500.0
2011-09-07	ABAC-DELISTED	Stock	2.24	2.35	2.1	2.15	31715.0
2011-09-07	ABAX-DELISTED	Stock	24.25	25.32	24.25	25.21	111914.0
2011-09-07	ABB-DELISTED	Stock	19.18	19.49	19.1	19.48	4890200.0
2011-09-07	ABBC-DELISTED	Stock	8.07	8.59	8.03	8.56	52416.0
2011-09-07	ABBNY-DELISTED	Stock	19.18	19.49	19.1	19.46	4918584.0
2011-09-07	ABC-DELISTED	Stock	39.39	40.0	39.05	39.98	1503958.0
2011-09-07	ABCB	Stock	8.73	9.09	8.64	9.04	95400.0
2011-09-07	ABCD-DELISTED	Stock	3.08	3.08	2.98	3.03	49238.0
2011-09-07	ABCO-DELISTED	Stock	30.09	30.55	29.88	30.41	215040.0
2011-09-07	ABCW-DELISTED	Stock	0.6	0.65	0.58	0.62	21070.0
2011-09-07	ABD-DELISTED	Stock	6.15	6.36	6.14	6.25	326180.0
2011-09-07	ABE-DELISTED	Stock	18.46	18.63	18.3	18.59	31294.0
2011-09-07	ABEO	Stock	2500.0	2725.0	2387.5	2500.0	9.0
2011-09-07	ABFS-DELISTED	Stock	18.66	19.05	18.55	19.04	338600.0
2011-09-07	ABG	Stock	17.56	18.98	17.51	18.95	753900.0
2011-09-07	ABH-DELISTED	Stock	15.55	16.63	15.55	16.25	254175.0
2011-09-07	ABM	Stock	19.77	20.36	19.61	20.33	245800.0
2011-09-07	ABMD-DELISTED	Stock	11.6	11.74	11.34	11.59	391050.0
2011-09-07	ABR	Stock	4.09	4.2	3.98	4.16	49400.0
2011-09-07	ABT	Stock	24.868	25.1703	24.7481	25.0935	13351188.0
2011-09-07	ABTL-DELISTED	Stock	4.591	4.716	4.5233	4.709	4410.0
2011-09-07	ABUS	Stock	2.02	2.02	1.91	2.01	14400.0
2011-09-07	ABV-DELISTED	Stock	33.77	33.86	33.43	33.75	2261901.0
2011-09-07	ABVA-DELISTED	Stock	4.55	4.84	4.55	4.7	1700.0
2011-09-07	ABVT-DELISTED	Stock	58.83	59.75	58.23	58.8	279561.0

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

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