PREVIEW / stock_daily / 2012-09-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-26.parquet
  size:    199 KB
  rows:    6,143
  symbols: 3,482

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-26	AAPL	Stock	23.8836	24.0246	23.6143	23.7564	576503200.0
2012-09-26	MSFT	Stock	30.28	30.6	30.04	30.17	54672000.0
2012-09-26	NVDA	Stock	0.334	0.3342	0.3255	0.3295	436812000.0
2012-09-26	AMZN	Stock	12.62	12.7305	12.4115	12.4835	58410000.0
2012-09-26	META	Stock	20.15	20.78	19.8	20.62	38271900.0
2012-09-26	TSLA	Stock	1.844	1.8933	1.832	1.836	22908000.0
2012-09-26	TLT	Stock	124.56	125.09	124.45	125.04	7193305.0
2012-09-26	ES	Stock	38.15	38.54	38.05	38.1	1118100.0
2012-09-26	CL	Stock	53.39	53.885	53.325	53.375	3162000.0
2012-09-26	A	Stock	27.525	27.525	27.0959	27.3748	5228520.0
2012-09-26	AABA-DELISTED	Stock	15.73	15.81	15.545	15.6	12681746.0
2012-09-26	AACC-DELISTED	Stock	7.5	7.5	7.27	7.41	13433.0
2012-09-26	AACG	Stock	4.85	4.96	4.66	4.8	3700.0
2012-09-26	AAIC-DELISTED	Stock	23.99	24.08	23.64	23.8	421073.0
2012-09-26	AAME	Stock	2.75	2.75	2.75	2.75	100.0
2012-09-26	AAMRQ-DELISTED	Stock	0.4	0.42	0.385	0.4035	1533106.0
2012-09-26	AAON	Stock	5.84	5.923	5.7659	5.7867	216338.0
2012-09-26	AAP	Stock	67.55	68.07	67.15	67.84	826400.0
2012-09-26	AAT	Stock	26.95	26.95	26.64	26.72	177500.0
2012-09-26	AAU-DELISTED	Stock	2.68	2.74	2.64	2.69	237599.0
2012-09-26	AAUAF-DELISTED	Stock	2.67	2.73	2.6301	2.7	243574.0
2012-09-26	AAV-DELISTED	Stock	3.72	3.73	3.65	3.66	116208.0
2012-09-26	AAWW-DELISTED	Stock	52.66	52.77	51.48	52.18	266479.0
2012-09-26	AAXJ	Stock	55.48	55.56	55.14	55.34	148995.0
2012-09-26	AAXN-DELISTED	Stock	5.82	5.93	5.725	5.88	443293.0
2012-09-26	AB	Stock	15.74	15.79	15.36	15.53	151000.0
2012-09-26	ABAC-DELISTED	Stock	1.3	1.5	1.15	1.32	25260.0
2012-09-26	ABAX-DELISTED	Stock	36.89	37.39	36.14	36.31	75113.0
2012-09-26	ABB-DELISTED	Stock	18.9	18.96	18.72	18.87	1439739.0
2012-09-26	ABBNY-DELISTED	Stock	18.9	18.96	18.72	18.88	1500944.0
2012-09-26	ABC-DELISTED	Stock	38.9	39.15	38.59	38.66	2661384.0
2012-09-26	ABCB	Stock	12.67	12.9	12.66	12.71	28100.0
2012-09-26	ABCD-DELISTED	Stock	0.981	0.9822	0.981	0.981	1100.0
2012-09-26	ABCO-DELISTED	Stock	46.95	47.5	46.73	47.02	110471.0
2012-09-26	ABCW-DELISTED	Stock	0.39	0.42	0.38	0.38	33150.0
2012-09-26	ABE-DELISTED	Stock	20.25	20.25	20.09	20.12	32020.0
2012-09-26	ABEO	Stock	562.5	562.5	500.0	562.5	6.0
2012-09-26	ABFS-DELISTED	Stock	7.84	8.15	7.68	8.12	715874.0
2012-09-26	ABG	Stock	28.08	28.19	27.67	27.7	174300.0
2012-09-26	ABM	Stock	18.98	19.02	18.86	18.99	348400.0
2012-09-26	ABMD-DELISTED	Stock	22.17	22.33	21.4	21.45	279657.0
2012-09-26	ABR	Stock	6.08	6.12	5.95	5.97	53000.0
2012-09-26	ABT	Stock	33.3797	33.4708	33.1494	33.1974	11930179.0
2012-09-26	ABTL-DELISTED	Stock	3.7	3.73	3.65	3.73	8568.0
2012-09-26	ABUS	Stock	3.86	3.93	3.75	3.84	6300.0
2012-09-26	ABV-DELISTED	Stock	38.47	38.48	37.88	38.06	1473427.0
2012-09-26	ABVA-DELISTED	Stock	4.7	4.7	4.7	4.7	600.0
2012-09-26	ABX-DELISTED	Stock	40.3	41.16	39.9	40.94	9326386.0
2012-09-26	ACAD	Stock	2.52	2.58	2.31	2.53	2081300.0
2012-09-26	ACAS-DELISTED	Stock	11.51	11.51	11.29	11.32	2116611.0

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

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