PREVIEW / stock_daily / 2010-07-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-23.parquet
  size:    189 KB
  rows:    5,923
  symbols: 3,478

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-07-23	AAPL	Stock	9.1818	9.2993	9.1529	9.2836	533388800.0
2010-07-23	MSFT	Stock	25.84	26.02	25.25	25.81	108520100.0
2010-07-23	NVDA	Stock	0.2632	0.2635	0.2565	0.259	817604000.0
2010-07-23	AMZN	Stock	5.2965	5.964	5.29	5.9435	848422000.0
2010-07-23	TSLA	Stock	1.4127	1.4373	1.404	1.4193	9804000.0
2010-07-23	TLT	Stock	100.8	100.97	99.69	99.78	6259014.0
2010-07-23	ES	Stock	27.7	27.96	27.43	27.95	1206600.0
2010-07-23	CL	Stock	41.275	41.75	41.135	41.735	3247400.0
2010-07-23	A	Stock	20.4292	21.0372	20.3505	20.9585	5194129.0
2010-07-23	AABA-DELISTED	Stock	13.79	14.0381	13.52	13.99	34032871.0
2010-07-23	AACC-DELISTED	Stock	4.46	4.52	4.24	4.51	34123.0
2010-07-23	AACG	Stock	3.0	3.04	3.0	3.04	1500.0
2010-07-23	AAI-DELISTED	Stock	4.66	4.74	4.6	4.7	2354270.0
2010-07-23	AAIC-DELISTED	Stock	18.04	18.44	17.91	18.41	61195.0
2010-07-23	AAME	Stock	1.3	1.3	1.23	1.24	2900.0
2010-07-23	AAON	Stock	4.7644	4.9146	4.717	4.9047	389306.0
2010-07-23	AAP	Stock	53.15	54.24	53.0	54.17	838000.0
2010-07-23	AATI-DELISTED	Stock	3.39	3.47	3.36	3.41	124787.0
2010-07-23	AAU-DELISTED	Stock	0.92	0.9699	0.92	0.957	92251.0
2010-07-23	AAUAF-DELISTED	Stock	0.92	0.9699	0.92	0.957	97251.0
2010-07-23	AAV-DELISTED	Stock	6.45	6.47	6.361	6.44	334854.0
2010-07-23	AAWW-DELISTED	Stock	57.16	57.74	56.45	57.5	308153.0
2010-07-23	AAXJ	Stock	55.48	56.08	55.29	55.94	580875.0
2010-07-23	AAXN-DELISTED	Stock	4.39	4.39	4.16	4.2	1234712.0
2010-07-23	AB	Stock	27.17	27.44	26.55	26.74	533200.0
2010-07-23	ABAC-DELISTED	Stock	4.15	4.25	3.88	3.96	70200.0
2010-07-23	ABAX-DELISTED	Stock	18.39	19.67	18.15	18.57	144203.0
2010-07-23	ABB-DELISTED	Stock	19.61	20.09	19.46	20.05	5526218.0
2010-07-23	ABBC-DELISTED	Stock	8.99	9.04	8.96	9.02	101560.0
2010-07-23	ABBNY-DELISTED	Stock	19.61	20.09	19.46	20.04	5637209.0
2010-07-23	ABC-DELISTED	Stock	29.67	30.72	28.95	30.54	17024080.0
2010-07-23	ABCB	Stock	10.2	10.2	9.41	9.49	399200.0
2010-07-23	ABCD-DELISTED	Stock	3.22	3.355	3.16	3.34	25709.0
2010-07-23	ABCO-DELISTED	Stock	21.13	22.04	21.07	21.87	92658.0
2010-07-23	ABCW-DELISTED	Stock	0.5396	0.5685	0.5107	0.53	71990.0
2010-07-23	ABD-DELISTED	Stock	5.2	5.37	5.15	5.31	377230.0
2010-07-23	ABE-DELISTED	Stock	17.12	17.2	17.12	17.17	6900.0
2010-07-23	ABEO	Stock	2375.0	2375.0	2250.0	2312.5	14.0
2010-07-23	ABFS-DELISTED	Stock	21.5	22.83	21.5	22.77	416394.0
2010-07-23	ABG	Stock	11.76	12.35	11.72	12.32	214400.0
2010-07-23	ABII-DELISTED	Stock	74.3	74.79	74.2	74.42	74693.0
2010-07-23	ABK-DELISTED	Stock	0.7581	0.78	0.72	0.7523	9049639.0
2010-07-23	ABM	Stock	20.98	21.34	20.89	21.29	367400.0
2010-07-23	ABMD-DELISTED	Stock	10.92	11.31	10.85	11.3	144570.0
2010-07-23	ABR	Stock	6.05	6.19	6.02	6.15	200000.0
2010-07-23	ABT	Stock	23.5006	23.587	23.3087	23.4766	18181117.0
2010-07-23	ABTL-DELISTED	Stock	5.4916	5.5402	5.1028	5.2	21930.0
2010-07-23	ABV-DELISTED	Stock	108.44	109.7	108.02	108.57	734045.0
2010-07-23	ABVA-DELISTED	Stock	2.53	2.53	2.53	2.53	950.0
2010-07-23	ABVT-DELISTED	Stock	49.44	51.2599	49.43	51.16	259742.0

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

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