PREVIEW / stock_daily / 2011-07-11

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-11.parquet
  size:    198 KB
  rows:    6,133
  symbols: 3,563

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-11	AAPL	Stock	12.7264	12.8489	12.6007	12.6429	442674400.0
2011-07-11	MSFT	Stock	26.62	26.8	26.49	26.63	43999800.0
2011-07-11	NVDA	Stock	0.3785	0.38	0.3713	0.3723	714388000.0
2011-07-11	AMZN	Stock	10.837	10.875	10.55	10.6275	80674000.0
2011-07-11	TSLA	Stock	1.8933	1.902	1.8667	1.89	14637000.0
2011-07-11	TLT	Stock	96.04	96.8	95.7501	96.8	9760755.0
2011-07-11	ES	Stock	35.02	35.07	34.79	34.89	769300.0
2011-07-11	CL	Stock	43.935	44.335	43.87	44.15	4276000.0
2011-07-11	A	Stock	35.372	35.6938	35.0	35.1144	4169675.0
2011-07-11	AABA-DELISTED	Stock	15.43	15.44	14.99	15.05	21200578.0
2011-07-11	AACC-DELISTED	Stock	4.09	4.19	3.87	4.14	21525.0
2011-07-11	AACG	Stock	11.4	11.4	10.68	11.18	13800.0
2011-07-11	AAIC-DELISTED	Stock	30.54	30.55	30.19	30.25	30468.0
2011-07-11	AAME	Stock	2.02	2.06	2.02	2.05	8400.0
2011-07-11	AAON	Stock	6.7467	6.7467	6.6074	6.6519	205875.0
2011-07-11	AAP	Stock	58.89	59.16	58.03	58.52	971600.0
2011-07-11	AAT	Stock	22.78	22.99	22.62	22.81	113100.0
2011-07-11	AATI-DELISTED	Stock	6.07	6.08	6.06	6.08	194086.0
2011-07-11	AAU-DELISTED	Stock	3.83	3.94	3.67	3.81	454844.0
2011-07-11	AAUAF-DELISTED	Stock	3.82	3.93	3.67	3.82	455532.0
2011-07-11	AAV-DELISTED	Stock	7.63	7.6795	7.36	7.38	433701.0
2011-07-11	AAWW-DELISTED	Stock	62.31	63.25	61.57	61.99	281351.0
2011-07-11	AAXJ	Stock	61.89	62.21	61.34	61.52	585725.0
2011-07-11	AAXN-DELISTED	Stock	4.46	4.49	4.41	4.44	182476.0
2011-07-11	AB	Stock	19.68	20.27	19.6	20.04	610000.0
2011-07-11	ABAC-DELISTED	Stock	2.73	2.789	2.71	2.76	40200.0
2011-07-11	ABAX-DELISTED	Stock	29.25	29.63	29.12	29.22	78114.0
2011-07-11	ABB-DELISTED	Stock	25.65	25.69	25.26	25.55	3876531.0
2011-07-11	ABBC-DELISTED	Stock	10.53	10.53	10.24	10.3	35012.0
2011-07-11	ABBNY-DELISTED	Stock	25.65	25.69	25.26	25.55	3877891.0
2011-07-11	ABC-DELISTED	Stock	42.29	42.65	42.11	42.31	1446472.0
2011-07-11	ABCB	Stock	8.94	9.05	8.89	8.95	19500.0
2011-07-11	ABCD-DELISTED	Stock	3.34	3.44	3.25	3.35	16919.0
2011-07-11	ABCO-DELISTED	Stock	28.16	28.26	27.82	28.04	134355.0
2011-07-11	ABCW-DELISTED	Stock	0.7	0.73	0.68	0.73	36190.0
2011-07-11	ABD-DELISTED	Stock	8.11	8.18	7.93	7.99	138650.0
2011-07-11	ABE-DELISTED	Stock	18.84	18.913	18.75	18.82	31315.0
2011-07-11	ABEO	Stock	2175.0	2475.0	2175.0	2425.0	24.0
2011-07-11	ABFS-DELISTED	Stock	26.22	26.36	25.87	26.07	289311.0
2011-07-11	ABG	Stock	19.29	19.53	19.13	19.21	363300.0
2011-07-11	ABH-DELISTED	Stock	20.68	20.7	20.14	20.22	335781.0
2011-07-11	ABM	Stock	23.41	23.51	23.18	23.35	169400.0
2011-07-11	ABMD-DELISTED	Stock	16.46	16.5	16.3	16.32	214925.0
2011-07-11	ABR	Stock	4.67	4.72	4.6	4.65	48600.0
2011-07-11	ABT	Stock	25.4006	25.5302	25.3574	25.5158	11195498.0
2011-07-11	ABTL-DELISTED	Stock	5.75	5.95	5.65	5.9	15385.0
2011-07-11	ABUS	Stock	2.3	2.45	2.25	2.45	16900.0
2011-07-11	ABV-DELISTED	Stock	32.52	32.66	31.72	32.06	3168355.0
2011-07-11	ABVT-DELISTED	Stock	67.83	67.99	63.15	65.44	822653.0
2011-07-11	ABX-DELISTED	Stock	46.5	46.66	45.61	45.9	6316909.0

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

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