PREVIEW / stock_daily / 2010-06-04

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-04.parquet
  size:    189 KB
  rows:    5,943
  symbols: 3,505

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-06-04	AAPL	Stock	9.2218	9.3536	9.0939	9.1414	758304400.0
2010-06-04	MSFT	Stock	26.1	26.57	25.62	25.79	89832200.0
2010-06-04	NVDA	Stock	0.3083	0.3138	0.3008	0.3025	671456000.0
2010-06-04	AMZN	Stock	6.3165	6.41	6.109	6.1385	109954000.0
2010-06-04	TLT	Stock	96.94	97.95	96.7	97.79	7479657.0
2010-06-04	ES	Stock	25.86	25.97	25.29	25.36	1782700.0
2010-06-04	CL	Stock	38.995	39.195	38.515	38.62	5903800.0
2010-06-04	A	Stock	22.6109	22.6824	21.6094	21.7024	6045931.0
2010-06-04	AABA-DELISTED	Stock	15.11	15.38	14.96	15.01	20939412.0
2010-06-04	AACC-DELISTED	Stock	5.25	5.8	5.15	5.15	57304.0
2010-06-04	AACG	Stock	3.15	3.36	3.15	3.3	400.0
2010-06-04	AAI-DELISTED	Stock	5.58	5.86	5.58	5.62	2457931.0
2010-06-04	AAIC-DELISTED	Stock	18.68	19.25	18.59	18.68	25319.0
2010-06-04	AAME	Stock	1.37	1.37	1.37	1.37	300.0
2010-06-04	AAON	Stock	4.6716	4.721	4.5116	4.5412	487519.0
2010-06-04	AAP	Stock	50.73	51.07	50.01	50.16	1759100.0
2010-06-04	AATI-DELISTED	Stock	3.54	3.63	3.54	3.6	567450.0
2010-06-04	AAU-DELISTED	Stock	0.9483	0.9754	0.9	0.93	230616.0
2010-06-04	AAUAF-DELISTED	Stock	0.9322	0.9588	0.89	0.9342	234801.0
2010-06-04	AAV-DELISTED	Stock	6.3	6.65	6.24	6.29	695160.0
2010-06-04	AAWW-DELISTED	Stock	51.5	51.555	48.9	49.21	349695.0
2010-06-04	AAXJ	Stock	52.49	52.49	51.21	51.4	303800.0
2010-06-04	AAXN-DELISTED	Stock	4.21	4.32	4.18	4.3	1045755.0
2010-06-04	AB	Stock	28.02	28.69	27.75	28.15	315300.0
2010-06-04	ABAX-DELISTED	Stock	22.68	23.07	21.7	21.74	146855.0
2010-06-04	ABB-DELISTED	Stock	16.85	16.93	16.38	16.48	3264616.0
2010-06-04	ABBC-DELISTED	Stock	8.96	9.06	8.65	8.69	108150.0
2010-06-04	ABBNY-DELISTED	Stock	16.84	16.93	16.38	16.45	3278419.0
2010-06-04	ABC-DELISTED	Stock	31.53	31.71	30.66	30.74	5470808.0
2010-06-04	ABCB	Stock	10.6891	10.719	10.3507	10.4005	154130.0
2010-06-04	ABCD-DELISTED	Stock	4.72	4.75	4.6	4.6	15532.0
2010-06-04	ABCO-DELISTED	Stock	18.975	19.13	18.76	18.85	133768.0
2010-06-04	ABCW-DELISTED	Stock	0.83	0.83	0.77	0.81	39780.0
2010-06-04	ABD-DELISTED	Stock	6.2998	6.3497	5.9903	6.0402	624370.0
2010-06-04	ABE-DELISTED	Stock	15.15	15.38	15.01	15.08	12449.0
2010-06-04	ABEO	Stock	2812.5	2875.0	2812.5	2862.5	1.0
2010-06-04	ABFS-DELISTED	Stock	22.46	22.86	21.96	22.08	625971.0
2010-06-04	ABG	Stock	12.89	12.96	12.44	12.59	604100.0
2010-06-04	ABII-DELISTED	Stock	54.25	55.15	53.355	55.0	314987.0
2010-06-04	ABK-DELISTED	Stock	1.13	1.1799	1.12	1.15	10005095.0
2010-06-04	ABM	Stock	21.34	21.69	20.44	20.52	746800.0
2010-06-04	ABMD-DELISTED	Stock	9.72	9.98	9.53	9.56	232622.0
2010-06-04	ABR	Stock	3.38	4.04	3.36	4.03	407000.0
2010-06-04	ABT	Stock	22.5698	22.5986	22.2483	22.3251	21442059.0
2010-06-04	ABTL-DELISTED	Stock	5.8992	6.9807	5.5059	5.85	290698.0
2010-06-04	ABV-DELISTED	Stock	95.97	96.13	94.65	95.84	1136397.0
2010-06-04	ABVA-DELISTED	Stock	2.72	2.72	2.64	2.72	1100.0
2010-06-04	ABVT-DELISTED	Stock	46.45	46.45	44.61	44.85	102538.0
2010-06-04	ABX-DELISTED	Stock	41.78	42.25	41.17	41.43	11171317.0
2010-06-04	ACAD	Stock	1.34	1.35	1.26	1.29	278800.0

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

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