PREVIEW / stock_daily / 2010-05-17

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-17.parquet
  size:    192 KB
  rows:    5,966
  symbols: 3,511

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
2010-05-17	AAPL	Stock	9.0964	9.1493	8.8468	9.0793	762834800.0
2010-05-17	MSFT	Stock	29.12	29.23	28.45	28.94	46053300.0
2010-05-17	NVDA	Stock	0.3245	0.3288	0.3145	0.3248	856060000.0
2010-05-17	AMZN	Stock	6.412	6.4975	6.29	6.4455	112844000.0
2010-05-17	TLT	Stock	94.72	95.71	94.47	94.53	6302355.0
2010-05-17	ES	Stock	26.71	26.82	26.26	26.58	924100.0
2010-05-17	CL	Stock	41.49	42.09	41.445	41.905	5550400.0
2010-05-17	A	Stock	24.3348	24.6781	24.0272	24.4564	5824767.0
2010-05-17	AABA-DELISTED	Stock	16.41	16.47	15.96	16.27	19922855.0
2010-05-17	AACC-DELISTED	Stock	7.83	7.83	7.33	7.53	29652.0
2010-05-17	AACG	Stock	3.61	3.61	3.51	3.51	700.0
2010-05-17	AAI-DELISTED	Stock	5.28	5.35	5.07	5.34	4109932.0
2010-05-17	AAIC-DELISTED	Stock	20.6	21.25	20.19	20.89	61855.0
2010-05-17	AAON	Stock	4.7802	4.9205	4.7526	4.9165	779625.0
2010-05-17	AAP	Stock	45.0	45.86	44.86	45.75	1959500.0
2010-05-17	AATI-DELISTED	Stock	3.66	3.71	3.59	3.62	218470.0
2010-05-17	AAU-DELISTED	Stock	1.15	1.18	1.09	1.09	204980.0
2010-05-17	AAUAF-DELISTED	Stock	1.15	1.18	1.09	1.09	209780.0
2010-05-17	AAV-DELISTED	Stock	6.44	6.58	6.05	6.21	681738.0
2010-05-17	AAWW-DELISTED	Stock	52.09	53.24	50.63	51.97	406199.0
2010-05-17	AAXJ	Stock	53.84	54.008	52.64	53.55	219653.0
2010-05-17	AAXN-DELISTED	Stock	5.07	5.1	4.95	5.07	793677.0
2010-05-17	AB	Stock	29.69	30.34	28.83	29.65	499300.0
2010-05-17	ABAX-DELISTED	Stock	24.57	24.8	24.07	24.72	91304.0
2010-05-17	ABB-DELISTED	Stock	17.67	17.77	17.2	17.56	6969509.0
2010-05-17	ABBC-DELISTED	Stock	10.0	10.0	9.8	9.95	35257.0
2010-05-17	ABBNY-DELISTED	Stock	17.68	17.77	17.2	17.58	7055725.0
2010-05-17	ABC-DELISTED	Stock	31.34	31.71	30.94	31.42	3791457.0
2010-05-17	ABCB	Stock	10.918	10.928	10.6393	10.7986	100577.0
2010-05-17	ABCD-DELISTED	Stock	5.09	5.21	5.0	5.1	36461.0
2010-05-17	ABCO-DELISTED	Stock	19.42	19.805	18.815	19.135	136418.0
2010-05-17	ABCW-DELISTED	Stock	0.8779	0.8779	0.7911	0.82	231600.0
2010-05-17	ABD-DELISTED	Stock	7.71	7.91	7.07	7.35	535020.0
2010-05-17	ABE-DELISTED	Stock	15.59	15.6	15.36	15.53	14050.0
2010-05-17	ABEO	Stock	2875.0	3062.5	2875.0	3062.5	5.0
2010-05-17	ABFS-DELISTED	Stock	28.47	28.9	27.51	28.39	511819.0
2010-05-17	ABG	Stock	14.24	14.4	13.31	13.67	320300.0
2010-05-17	ABII-DELISTED	Stock	46.78	48.97	46.74	48.62	45565.0
2010-05-17	ABK-DELISTED	Stock	1.43	1.48	1.33	1.47	27932049.0
2010-05-17	ABM	Stock	22.14	22.6	21.51	22.59	242500.0
2010-05-17	ABMD-DELISTED	Stock	9.66	9.8	9.35	9.57	173099.0
2010-05-17	ABR	Stock	3.99	4.06	3.85	4.04	112600.0
2010-05-17	ABT	Stock	23.3087	23.3998	22.9728	23.2367	15486453.0
2010-05-17	ABTL-DELISTED	Stock	5.25	5.35	5.25	5.35	13919.0
2010-05-17	ABV-DELISTED	Stock	98.3	99.27	96.2815	98.43	613798.0
2010-05-17	ABVT-DELISTED	Stock	47.87	47.9499	46.76	46.83	181538.0
2010-05-17	ABX-DELISTED	Stock	45.8	45.8	43.89	44.39	10869038.0
2010-05-17	ACAD	Stock	1.48	1.5	1.4	1.48	335800.0
2010-05-17	ACAP-DELISTED	Stock	33.07	33.25	32.01	32.14	47237.0
2010-05-17	ACAS-DELISTED	Stock	5.54	5.65	5.21	5.37	8858538.0

> showing 50 of 5,966 rows — these rows as CSV

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