PREVIEW / stock_daily / 2012-10-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-26.parquet
  size:    199 KB
  rows:    6,167
  symbols: 3,491

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-10-26	AAPL	Stock	21.7654	21.9286	21.1071	21.5714	1018432800.0
2012-10-26	MSFT	Stock	27.86	28.34	27.84	28.21	57790000.0
2012-10-26	NVDA	Stock	0.305	0.3068	0.3012	0.3012	389376000.0
2012-10-26	AMZN	Stock	11.43	11.9355	11.3345	11.912	227350000.0
2012-10-26	META	Stock	22.4	22.88	21.88	21.94	73175800.0
2012-10-26	TSLA	Stock	1.8353	1.8533	1.8013	1.8253	7161000.0
2012-10-26	TLT	Stock	121.44	122.65	121.27	122.64	5889484.0
2012-10-26	ES	Stock	39.08	39.15	38.66	38.96	1130200.0
2012-10-26	CL	Stock	52.35	52.495	51.85	51.935	4940400.0
2012-10-26	A	Stock	25.8727	25.9657	25.5365	25.7082	5215239.0
2012-10-26	AABA-DELISTED	Stock	16.54	16.82	16.52	16.79	23293852.0
2012-10-26	AACC-DELISTED	Stock	6.94	7.11	6.64	6.65	23205.0
2012-10-26	AACG	Stock	4.96	4.96	4.96	4.96	900.0
2012-10-26	AAIC-DELISTED	Stock	21.58	21.75	21.5	21.72	71203.0
2012-10-26	AAME	Stock	2.93	2.94	2.92	2.94	1100.0
2012-10-26	AAMRQ-DELISTED	Stock	0.362	0.373	0.3601	0.365	432594.0
2012-10-26	AAON	Stock	6.0148	6.1481	5.9793	6.1422	86063.0
2012-10-26	AAP	Stock	68.11	68.35	67.61	68.14	705000.0
2012-10-26	AAT	Stock	27.3	27.3	26.77	26.98	68200.0
2012-10-26	AAU-DELISTED	Stock	2.619	2.63	2.49	2.53	101502.0
2012-10-26	AAUAF-DELISTED	Stock	2.64	2.65	2.51	2.53	110395.0
2012-10-26	AAV-DELISTED	Stock	3.47	3.57	3.47	3.53	224309.0
2012-10-26	AAWW-DELISTED	Stock	54.38	54.75	53.54	54.2	79768.0
2012-10-26	AAXJ	Stock	56.43	56.5	56.06	56.39	494830.0
2012-10-26	AAXN-DELISTED	Stock	6.83	8.45	6.8284	8.0689	6105282.0
2012-10-26	AB	Stock	16.92	17.2	16.63	16.77	391700.0
2012-10-26	ABAC-DELISTED	Stock	1.26	1.37	1.25	1.27	5718.0
2012-10-26	ABAX-DELISTED	Stock	34.95	36.43	34.83	36.08	178051.0
2012-10-26	ABB-DELISTED	Stock	18.2	18.29	18.14	18.2	1901451.0
2012-10-26	ABBNY-DELISTED	Stock	18.2	18.29	18.14	18.19	1950400.0
2012-10-26	ABC-DELISTED	Stock	39.79	39.9	39.22	39.35	2564261.0
2012-10-26	ABCB	Stock	11.0	11.0	10.54	10.68	131100.0
2012-10-26	ABCD-DELISTED	Stock	0.95	0.95	0.92	0.93	10750.0
2012-10-26	ABCO-DELISTED	Stock	46.95	46.95	45.83	46.23	61473.0
2012-10-26	ABCW-DELISTED	Stock	0.36	0.375	0.36	0.37	40404.0
2012-10-26	ABE-DELISTED	Stock	20.55	20.61	20.55	20.61	300.0
2012-10-26	ABEO	Stock	450.0	475.0	425.0	475.0	112.0
2012-10-26	ABFS-DELISTED	Stock	7.67	7.83	7.42	7.46	269236.0
2012-10-26	ABG	Stock	30.42	30.74	30.24	30.55	190300.0
2012-10-26	ABM	Stock	18.5	18.89	18.48	18.87	275800.0
2012-10-26	ABMD-DELISTED	Stock	18.99	19.4	18.88	18.91	388649.0
2012-10-26	ABR	Stock	5.46	5.5	5.36	5.4	86900.0
2012-10-26	ABT	Stock	31.5804	31.6188	31.1534	31.4173	17067111.0
2012-10-26	ABTL-DELISTED	Stock	3.94	3.95	3.85	3.94	2144.0
2012-10-26	ABUS	Stock	3.85	3.99	3.8	3.99	19100.0
2012-10-26	ABV-DELISTED	Stock	40.2	40.62	39.97	40.49	1449198.0
2012-10-26	ABVA-DELISTED	Stock	4.48	4.48	4.4	4.4	1470.0
2012-10-26	ABX-DELISTED	Stock	39.67	39.67	39.13	39.18	5216850.0
2012-10-26	ACAD	Stock	2.32	2.36	2.25	2.27	675300.0
2012-10-26	ACAS-DELISTED	Stock	11.79	11.88	11.72	11.83	1634734.0

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

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