PREVIEW / stock_daily / 2011-08-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-23.parquet
  size:    195 KB
  rows:    6,116
  symbols: 3,555

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-08-23	AAPL	Stock	12.8679	13.3443	12.75	13.3429	656835200.0
2011-08-23	MSFT	Stock	24.03	24.75	24.03	24.72	59670600.0
2011-08-23	NVDA	Stock	0.3058	0.331	0.3052	0.3308	938312000.0
2011-08-23	AMZN	Stock	8.946	9.742	8.926	9.6775	147032000.0
2011-08-23	TSLA	Stock	1.462	1.5407	1.4333	1.5307	13035000.0
2011-08-23	TLT	Stock	109.76	111.17	109.35	109.39	16017895.0
2011-08-23	ES	Stock	32.34	33.14	32.0	33.12	3280500.0
2011-08-23	CL	Stock	42.61	43.505	42.575	43.505	4991400.0
2011-08-23	A	Stock	21.9814	23.0615	21.6166	22.7897	11927876.0
2011-08-23	AABA-DELISTED	Stock	12.91	13.35	12.75	13.35	17109617.0
2011-08-23	AACC-DELISTED	Stock	3.88	4.18	3.88	4.05	12695.0
2011-08-23	AACG	Stock	8.56	8.79	8.33	8.38	7800.0
2011-08-23	AAIC-DELISTED	Stock	23.94	25.03	23.83	25.03	49766.0
2011-08-23	AAME	Stock	1.89	1.9	1.87	1.89	4100.0
2011-08-23	AAON	Stock	4.7111	4.8267	4.6044	4.8089	492413.0
2011-08-23	AAP	Stock	57.52	58.74	57.27	58.34	1138100.0
2011-08-23	AAT	Stock	18.38	19.31	18.36	19.09	224600.0
2011-08-23	AATI-DELISTED	Stock	5.83	5.95	5.78	5.89	513868.0
2011-08-23	AAU-DELISTED	Stock	3.18	3.2	3.01	3.03	255308.0
2011-08-23	AAUAF-DELISTED	Stock	3.18	3.2	3.01	3.04	260108.0
2011-08-23	AAV-DELISTED	Stock	5.22	5.42	5.15	5.42	671484.0
2011-08-23	AAWW-DELISTED	Stock	41.5	43.84	40.99	43.59	243174.0
2011-08-23	AAXJ	Stock	53.6	54.77	53.19	54.77	307417.0
2011-08-23	AAXN-DELISTED	Stock	3.81	4.14	3.78	4.11	495525.0
2011-08-23	AB	Stock	14.62	15.0	14.48	14.97	309800.0
2011-08-23	ABAC-DELISTED	Stock	2.22	2.32	2.16	2.31	29861.0
2011-08-23	ABAX-DELISTED	Stock	22.58	23.8	22.18	23.74	292846.0
2011-08-23	ABB-DELISTED	Stock	19.79	20.34	19.62	20.33	2587621.0
2011-08-23	ABBC-DELISTED	Stock	7.66	8.07	7.58	8.05	49787.0
2011-08-23	ABBNY-DELISTED	Stock	19.79	20.34	19.62	20.34	2597711.0
2011-08-23	ABC-DELISTED	Stock	37.42	38.29	37.21	38.26	3392793.0
2011-08-23	ABCB	Stock	8.9	9.12	8.81	9.0	88100.0
2011-08-23	ABCD-DELISTED	Stock	2.74	2.91	2.74	2.9	41319.0
2011-08-23	ABCO-DELISTED	Stock	28.38	30.23	28.1	30.11	263328.0
2011-08-23	ABCW-DELISTED	Stock	0.63	0.64	0.63	0.63	66380.0
2011-08-23	ABD-DELISTED	Stock	5.7249	6.0051	5.6148	5.9951	234170.0
2011-08-23	ABE-DELISTED	Stock	17.83	18.27	17.83	18.27	7318.0
2011-08-23	ABEO	Stock	2500.0	2612.5	2450.0	2612.5	10.0
2011-08-23	ABFS-DELISTED	Stock	18.54	18.98	18.13	18.96	214222.0
2011-08-23	ABG	Stock	16.28	17.31	15.85	17.2	589900.0
2011-08-23	ABH-DELISTED	Stock	15.96	16.24	15.62	16.07	368297.0
2011-08-23	ABM	Stock	18.76	19.62	18.46	19.61	221300.0
2011-08-23	ABMD-DELISTED	Stock	11.54	12.2	11.36	11.8	253765.0
2011-08-23	ABR	Stock	3.69	4.09	3.65	4.0	79200.0
2011-08-23	ABT	Stock	23.7069	24.2731	23.6925	24.2347	16419341.0
2011-08-23	ABTL-DELISTED	Stock	4.4095	4.5736	4.2902	4.3905	13818.0
2011-08-23	ABUS	Stock	2.25	2.25	1.95	1.95	5400.0
2011-08-23	ABV-DELISTED	Stock	32.9	34.12	32.73	34.12	3586760.0
2011-08-23	ABVA-DELISTED	Stock	4.67	4.99	4.67	4.9	5798.0
2011-08-23	ABVT-DELISTED	Stock	54.86	57.13	54.74	57.04	123517.0

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

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