PREVIEW / stock_daily / 2010-07-22

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-22.parquet
  size:    189 KB
  rows:    5,938
  symbols: 3,489

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-22	AAPL	Stock	9.2029	9.2857	9.1182	9.2507	645318800.0
2010-07-22	MSFT	Stock	25.51	25.99	25.47	25.84	73016400.0
2010-07-22	NVDA	Stock	0.262	0.2663	0.2605	0.2635	462612000.0
2010-07-22	AMZN	Stock	5.9355	6.0435	5.901	6.0035	300068000.0
2010-07-22	TSLA	Stock	1.3667	1.4167	1.358	1.4	14367000.0
2010-07-22	TLT	Stock	101.51	101.52	100.82	100.85	5760084.0
2010-07-22	ES	Stock	27.53	27.89	27.51	27.79	923700.0
2010-07-22	CL	Stock	41.545	41.68	41.17	41.285	5431600.0
2010-07-22	A	Stock	19.9928	20.6509	19.9928	20.5436	5102001.0
2010-07-22	AABA-DELISTED	Stock	13.91	14.1704	13.81	13.88	37516442.0
2010-07-22	AACC-DELISTED	Stock	3.97	4.6	3.97	4.48	79894.0
2010-07-22	AACG	Stock	2.92	3.0	2.92	3.0	300.0
2010-07-22	AAI-DELISTED	Stock	4.85	4.85	4.64	4.69	4435213.0
2010-07-22	AAIC-DELISTED	Stock	18.23	18.33	17.92	18.13	61876.0
2010-07-22	AAME	Stock	1.3	1.3	1.2	1.2	1000.0
2010-07-22	AAON	Stock	4.6914	4.8138	4.6499	4.8	365006.0
2010-07-22	AAP	Stock	52.27	53.45	52.27	53.1	2021700.0
2010-07-22	AATI-DELISTED	Stock	3.37	3.46	3.34	3.4	168581.0
2010-07-22	AAU-DELISTED	Stock	0.9	0.959	0.9	0.94	125375.0
2010-07-22	AAUAF-DELISTED	Stock	0.9	0.959	0.9	0.94	129975.0
2010-07-22	AAV-DELISTED	Stock	6.2	6.47	6.2	6.45	356791.0
2010-07-22	AAWW-DELISTED	Stock	55.76	57.75	55.15	57.48	272749.0
2010-07-22	AAXJ	Stock	55.02	55.59	54.82	55.41	967384.0
2010-07-22	AAXN-DELISTED	Stock	4.4	4.42	4.26	4.4	886740.0
2010-07-22	AB	Stock	26.65	27.57	26.65	27.23	353100.0
2010-07-22	ABAC-DELISTED	Stock	4.25	4.59	4.15	4.2	62700.0
2010-07-22	ABAX-DELISTED	Stock	18.66	18.77	18.42	18.53	155057.0
2010-07-22	ABB-DELISTED	Stock	19.44	19.8	19.41	19.59	7949593.0
2010-07-22	ABBC-DELISTED	Stock	8.94	9.05	8.9	9.04	47032.0
2010-07-22	ABBNY-DELISTED	Stock	19.44	19.8	19.41	19.57	8056424.0
2010-07-22	ABC-DELISTED	Stock	32.45	32.46	29.53	29.63	16816165.0
2010-07-22	ABCB	Stock	9.88	10.42	9.84	10.3	83900.0
2010-07-22	ABCD-DELISTED	Stock	3.19	3.25	3.11	3.25	44407.0
2010-07-22	ABCO-DELISTED	Stock	21.02	21.44	21.0	21.26	152390.0
2010-07-22	ABCW-DELISTED	Stock	0.53	0.6	0.53	0.56	36400.0
2010-07-22	ABD-DELISTED	Stock	4.99	5.2609	4.99	5.23	319070.0
2010-07-22	ABE-DELISTED	Stock	16.86	17.1355	16.85	17.08	13395.0
2010-07-22	ABEO	Stock	2437.5	2450.0	2312.5	2375.0	19.0
2010-07-22	ABFS-DELISTED	Stock	21.24	21.78	20.87	21.75	452715.0
2010-07-22	ABG	Stock	10.99	11.89	10.99	11.85	333500.0
2010-07-22	ABII-DELISTED	Stock	74.62	74.94	73.97	74.46	87181.0
2010-07-22	ABK-DELISTED	Stock	0.704	0.78	0.6851	0.74	12741166.0
2010-07-22	ABM	Stock	21.04	21.2	20.92	21.02	328300.0
2010-07-22	ABMD-DELISTED	Stock	11.01	11.21	10.95	10.96	233671.0
2010-07-22	ABR	Stock	6.25	6.25	6.05	6.05	176500.0
2010-07-22	ABT	Stock	23.5198	23.7693	23.2031	23.515	22413089.0
2010-07-22	ABTL-DELISTED	Stock	5.4	5.5995	5.2	5.55	35642.0
2010-07-22	ABV-DELISTED	Stock	108.0	109.78	107.43	109.63	617925.0
2010-07-22	ABVT-DELISTED	Stock	49.43	49.84	48.71	49.65	459435.0
2010-07-22	ABX-DELISTED	Stock	42.16	42.81	41.98	42.27	7299190.0

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

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