PREVIEW / stock_daily / 2010-07-01

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-01.parquet
  size:    188 KB
  rows:    5,917
  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
2010-07-01	AAPL	Stock	9.0821	9.1	8.6864	8.8743	1022896000.0
2010-07-01	MSFT	Stock	23.09	23.32	22.73	23.16	92239400.0
2010-07-01	NVDA	Stock	0.256	0.2612	0.2482	0.2595	737008000.0
2010-07-01	AMZN	Stock	5.445	5.5845	5.335	5.548	170596000.0
2010-07-01	TSLA	Stock	1.6667	1.728	1.3513	1.464	123282000.0
2010-07-01	TLT	Stock	101.57	102.66	101.38	101.6	12893782.0
2010-07-01	ES	Stock	25.51	25.6	25.24	25.53	1432200.0
2010-07-01	CL	Stock	39.31	39.49	38.8	39.42	7912800.0
2010-07-01	A	Stock	20.3863	20.4649	19.628	20.2289	6993495.0
2010-07-01	AABA-DELISTED	Stock	13.95	14.15	13.75	14.09	33050740.0
2010-07-01	AACC-DELISTED	Stock	4.17	4.24	4.01	4.08	20050.0
2010-07-01	AACG	Stock	3.01	3.01	2.83	2.84	900.0
2010-07-01	AAI-DELISTED	Stock	4.85	4.95	4.7	4.86	3784409.0
2010-07-01	AAIC-DELISTED	Stock	18.98	18.98	18.18	18.61	46665.0
2010-07-01	AAME	Stock	1.32	1.38	1.32	1.38	12300.0
2010-07-01	AAON	Stock	4.6025	4.7407	4.557	4.7091	287550.0
2010-07-01	AAP	Stock	50.38	51.92	50.1	51.7	1712300.0
2010-07-01	AATI-DELISTED	Stock	3.19	3.31	3.09	3.09	251117.0
2010-07-01	AAU-DELISTED	Stock	0.91	0.91	0.86	0.86	125487.0
2010-07-01	AAUAF-DELISTED	Stock	0.91	0.91	0.86	0.86	128887.0
2010-07-01	AAV-DELISTED	Stock	5.78	5.84	5.535	5.71	292731.0
2010-07-01	AAWW-DELISTED	Stock	47.77	48.7	45.66	47.46	306860.0
2010-07-01	AAXJ	Stock	52.03	52.29	51.3	52.16	235608.0
2010-07-01	AAXN-DELISTED	Stock	3.58	3.79	3.55	3.71	1946684.0
2010-07-01	AB	Stock	25.66	26.19	24.46	25.15	721100.0
2010-07-01	ABAX-DELISTED	Stock	21.4	21.4	20.49	20.85	147168.0
2010-07-01	ABB-DELISTED	Stock	17.69	17.77	17.2717	17.6	6307182.0
2010-07-01	ABBC-DELISTED	Stock	8.72	8.87	8.63	8.85	44277.0
2010-07-01	ABBNY-DELISTED	Stock	17.69	17.77	17.2717	17.59	6328817.0
2010-07-01	ABC-DELISTED	Stock	31.63	31.64	30.31	30.96	8300228.0
2010-07-01	ABCB	Stock	9.6	9.8	9.6	9.76	120700.0
2010-07-01	ABCD-DELISTED	Stock	3.6	3.7	3.4	3.57	33913.0
2010-07-01	ABCO-DELISTED	Stock	21.43	21.5	20.82	21.43	234266.0
2010-07-01	ABCW-DELISTED	Stock	0.4407	0.4877	0.422	0.45	81110.0
2010-07-01	ABD-DELISTED	Stock	5.01	5.17	4.77	5.11	749110.0
2010-07-01	ABE-DELISTED	Stock	15.8	15.8	15.6001	15.76	18059.0
2010-07-01	ABEO	Stock	2437.5	2737.5	2375.0	2562.5	32.0
2010-07-01	ABFS-DELISTED	Stock	20.85	21.0	19.7	20.14	532434.0
2010-07-01	ABG	Stock	10.53	10.62	9.81	10.27	846200.0
2010-07-01	ABII-DELISTED	Stock	73.9	74.83	73.34	73.91	329537.0
2010-07-01	ABK-DELISTED	Stock	0.67	0.69	0.64	0.643	5785796.0
2010-07-01	ABM	Stock	20.97	21.06	20.33	20.76	308100.0
2010-07-01	ABMD-DELISTED	Stock	9.66	9.83	9.31	9.78	197171.0
2010-07-01	ABR	Stock	5.19	5.3	4.88	4.94	120500.0
2010-07-01	ABT	Stock	22.3347	22.3875	21.9317	22.2915	17965402.0
2010-07-01	ABTL-DELISTED	Stock	5.7	5.75	5.6	5.75	19324.0
2010-07-01	ABV-DELISTED	Stock	101.75	102.01	98.55	101.31	1305757.0
2010-07-01	ABVT-DELISTED	Stock	47.22	47.3	45.88	46.73	272973.0
2010-07-01	ABX-DELISTED	Stock	45.08	45.34	42.4	43.08	13111326.0
2010-07-01	ACAD	Stock	1.07	1.08	1.0	1.02	249500.0

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

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