PREVIEW / stock_daily / 2012-11-28

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-28.parquet
  size:    200 KB
  rows:    6,192
  symbols: 3,498

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-11-28	AAPL	Stock	20.6168	20.9214	20.4379	20.8193	520864400.0
2012-11-28	MSFT	Stock	27.01	27.39	26.77	27.36	53018400.0
2012-11-28	NVDA	Stock	0.3028	0.308	0.299	0.3065	398332000.0
2012-11-28	AMZN	Stock	12.1225	12.3615	12.075	12.3555	54868000.0
2012-11-28	META	Stock	25.94	26.49	25.75	26.36	49205600.0
2012-11-28	TSLA	Stock	2.1333	2.286	2.1273	2.2153	22878000.0
2012-11-28	TLT	Stock	125.97	126.2	125.09	125.11	3570175.0
2012-11-28	ES	Stock	38.07	38.17	37.7	38.09	1750200.0
2012-11-28	CL	Stock	53.69	53.955	53.585	53.88	2202400.0
2012-11-28	A	Stock	26.5522	27.196	26.4163	27.1602	4828692.0
2012-11-28	AABA-DELISTED	Stock	18.78	18.95	18.53	18.885	29933115.0
2012-11-28	AACC-DELISTED	Stock	4.41	4.92	4.41	4.82	30615.0
2012-11-28	AACG	Stock	4.18	4.25	4.16	4.17	2200.0
2012-11-28	AAIC-DELISTED	Stock	21.1	21.21	20.82	20.99	147450.0
2012-11-28	AAME	Stock	2.94	2.94	2.93	2.94	1400.0
2012-11-28	AAMRQ-DELISTED	Stock	0.482	0.49	0.43	0.464	5577432.0
2012-11-28	AAON	Stock	6.2104	6.3526	6.1156	6.323	369225.0
2012-11-28	AAP	Stock	76.47	78.07	76.29	78.07	487900.0
2012-11-28	AAT	Stock	27.84	27.94	27.54	27.7	168200.0
2012-11-28	AAU-DELISTED	Stock	2.65	2.8	2.59	2.8	145831.0
2012-11-28	AAUAF-DELISTED	Stock	2.69	2.84	2.63	2.76	144061.0
2012-11-28	AAV-DELISTED	Stock	3.33	3.37	3.32	3.33	204648.0
2012-11-28	AAWW-DELISTED	Stock	41.61	43.07	41.61	42.83	250536.0
2012-11-28	AAXJ	Stock	56.9	57.63	56.75	57.6	195369.0
2012-11-28	AAXN-DELISTED	Stock	8.61	9.26	8.45	9.02	1262504.0
2012-11-28	AB	Stock	17.93	18.1	17.82	17.96	295400.0
2012-11-28	ABAC-DELISTED	Stock	0.87	0.87	0.8	0.85	9040.0
2012-11-28	ABAX-DELISTED	Stock	36.6	37.06	36.1	37.0	85288.0
2012-11-28	ABB-DELISTED	Stock	18.81	19.21	18.77	19.19	1764493.0
2012-11-28	ABBNY-DELISTED	Stock	18.81	19.21	18.77	19.18	1841223.0
2012-11-28	ABC-DELISTED	Stock	41.16	41.29	40.84	41.2	2259244.0
2012-11-28	ABCB	Stock	10.93	11.2	10.89	10.98	38100.0
2012-11-28	ABCD-DELISTED	Stock	1.0	1.1	1.0	1.03	12929.0
2012-11-28	ABCO-DELISTED	Stock	43.95	44.32	43.66	44.3	224691.0
2012-11-28	ABCW-DELISTED	Stock	0.41	0.42	0.38	0.4	22601.0
2012-11-28	ABE-DELISTED	Stock	20.05	20.16	19.9901	20.15	15130.0
2012-11-28	ABEO	Stock	437.5	462.5	425.0	437.5	86.0
2012-11-28	ABFS-DELISTED	Stock	8.46	8.68	8.31	8.4	504715.0
2012-11-28	ABG	Stock	29.71	30.05	29.19	29.99	349900.0
2012-11-28	ABM	Stock	18.87	19.05	18.81	19.05	218000.0
2012-11-28	ABMD-DELISTED	Stock	13.49	14.31	12.85	14.17	2227661.0
2012-11-28	ABR	Stock	5.17	5.2	5.13	5.14	47100.0
2012-11-28	ABT	Stock	30.6352	30.9903	30.5297	30.9807	8485619.0
2012-11-28	ABTL-DELISTED	Stock	3.85	3.87	3.8	3.85	4740.0
2012-11-28	ABUS	Stock	5.24	5.27	5.08	5.18	54000.0
2012-11-28	ABV-DELISTED	Stock	40.75	41.24	40.56	40.91	1479255.0
2012-11-28	ABVA-DELISTED	Stock	4.83	4.85	4.68	4.76	3804.0
2012-11-28	ABX-DELISTED	Stock	33.79	34.85	33.55	34.83	8027336.0
2012-11-28	ACAD	Stock	4.92	5.49	4.81	5.14	11239700.0
2012-11-28	ACAS-DELISTED	Stock	11.8	11.89	11.71	11.88	1374878.0

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

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