PREVIEW / stock_daily / 2012-09-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-11.parquet
  size:    200 KB
  rows:    6,157
  symbols: 3,493

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
2012-09-11	AAPL	Stock	23.7539	23.9321	23.4464	23.5925	503983200.0
2012-09-11	MSFT	Stock	30.69	30.91	30.61	30.79	25191800.0
2012-09-11	NVDA	Stock	0.3318	0.3413	0.3305	0.336	382808000.0
2012-09-11	AMZN	Stock	12.88	12.88	12.713	12.7835	50496000.0
2012-09-11	META	Stock	18.92	19.58	18.85	19.43	50508200.0
2012-09-11	TSLA	Stock	1.8507	1.8773	1.8267	1.8533	15223500.0
2012-09-11	TLT	Stock	124.02	124.1	123.29	123.55	3523500.0
2012-09-11	ES	Stock	38.17	38.21	37.92	37.94	1208700.0
2012-09-11	CL	Stock	51.65	51.84	51.28	51.41	5936400.0
2012-09-11	A	Stock	27.3534	27.382	27.0601	27.0601	4093903.0
2012-09-11	AABA-DELISTED	Stock	15.09	15.25	15.06	15.17	7444911.0
2012-09-11	AACC-DELISTED	Stock	6.73	6.78	6.73	6.76	9505.0
2012-09-11	AAIC-DELISTED	Stock	23.47	23.91	23.47	23.59	108500.0
2012-09-11	AAME	Stock	2.66	2.74	2.66	2.74	4400.0
2012-09-11	AAMRQ-DELISTED	Stock	0.4516	0.465	0.4516	0.4605	1434751.0
2012-09-11	AAON	Stock	5.6089	5.6889	5.5644	5.6593	101588.0
2012-09-11	AAP	Stock	70.08	70.74	69.8	70.55	768700.0
2012-09-11	AAT	Stock	27.42	27.57	27.42	27.48	145000.0
2012-09-11	AAU-DELISTED	Stock	2.7	2.88	2.7	2.85	289589.0
2012-09-11	AAUAF-DELISTED	Stock	2.75	2.88	2.72	2.85	290589.0
2012-09-11	AAV-DELISTED	Stock	3.63	3.71	3.625	3.71	212782.0
2012-09-11	AAWW-DELISTED	Stock	56.41	56.8113	55.62	55.72	220876.0
2012-09-11	AAXJ	Stock	54.18	54.5	54.1201	54.42	86609.0
2012-09-11	AAXN-DELISTED	Stock	5.23	5.48	5.23	5.47	464667.0
2012-09-11	AB	Stock	14.35	14.78	14.32	14.68	186900.0
2012-09-11	ABAC-DELISTED	Stock	1.13	1.177	1.13	1.139	12050.0
2012-09-11	ABAX-DELISTED	Stock	35.41	35.89	35.17	35.29	223007.0
2012-09-11	ABB-DELISTED	Stock	18.72	18.95	18.71	18.89	3046397.0
2012-09-11	ABBNY-DELISTED	Stock	18.72	18.95	18.71	18.9	3160024.0
2012-09-11	ABC-DELISTED	Stock	37.52	37.81	37.27	37.78	3944839.0
2012-09-11	ABCB	Stock	12.28	12.45	12.28	12.42	30000.0
2012-09-11	ABCD-DELISTED	Stock	1.05	1.05	0.98	0.981	22217.0
2012-09-11	ABCO-DELISTED	Stock	46.0	46.16	45.7	46.0	125282.0
2012-09-11	ABCW-DELISTED	Stock	0.39	0.44	0.368	0.37	22359.0
2012-09-11	ABE-DELISTED	Stock	20.15	20.1501	20.02	20.13	5555.0
2012-09-11	ABEO	Stock	662.5	712.5	662.5	662.5	5.0
2012-09-11	ABFS-DELISTED	Stock	7.96	8.535	7.96	8.46	526355.0
2012-09-11	ABG	Stock	29.74	30.24	29.44	29.46	413500.0
2012-09-11	ABM	Stock	18.65	18.88	18.55	18.68	412400.0
2012-09-11	ABMD-DELISTED	Stock	20.43	20.87	19.95	20.4	891916.0
2012-09-11	ABR	Stock	5.54	5.69	5.53	5.67	22000.0
2012-09-11	ABT	Stock	32.2713	32.3865	32.2426	32.3049	9660275.0
2012-09-11	ABTL-DELISTED	Stock	3.7	3.7	3.646	3.684	1592.0
2012-09-11	ABUS	Stock	3.22	3.31	3.22	3.31	1500.0
2012-09-11	ABV-DELISTED	Stock	37.47	37.82	37.21	37.72	1528227.0
2012-09-11	ABX-DELISTED	Stock	39.84	40.0	39.26	39.46	6028575.0
2012-09-11	ACAD	Stock	2.08	2.2	2.03	2.05	2612200.0
2012-09-11	ACAS-DELISTED	Stock	11.43	11.54	11.4	11.51	1690158.0
2012-09-11	ACAT-DELISTED	Stock	45.5	46.0	43.0	44.28	265840.0
2012-09-11	ACC-DELISTED	Stock	45.98	46.15	45.5	45.71	753125.0

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

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