PREVIEW / stock_daily / 2010-06-17

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-17.parquet
  size:    189 KB
  rows:    5,901
  symbols: 3,472

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-17	AAPL	Stock	9.6643	9.7464	9.625	9.7096	872855200.0
2010-06-17	MSFT	Stock	26.56	26.67	26.04	26.37	47995500.0
2010-06-17	NVDA	Stock	0.3045	0.3062	0.294	0.3055	859068000.0
2010-06-17	AMZN	Stock	6.337	6.39	6.2345	6.2945	69580000.0
2010-06-17	TLT	Stock	97.15	98.23	97.07	97.85	5650874.0
2010-06-17	ES	Stock	26.69	27.0	26.53	26.99	1912600.0
2010-06-17	CL	Stock	40.41	40.47	40.085	40.45	3043600.0
2010-06-17	A	Stock	23.4621	23.4621	22.9041	23.226	3175138.0
2010-06-17	AABA-DELISTED	Stock	15.7	15.72	15.44	15.6	10588628.0
2010-06-17	AACC-DELISTED	Stock	4.62	4.7	4.5	4.59	48155.0
2010-06-17	AACG	Stock	3.32	3.36	3.31	3.31	2200.0
2010-06-17	AAI-DELISTED	Stock	5.54	5.62	5.4	5.45	2526151.0
2010-06-17	AAIC-DELISTED	Stock	20.4	20.53	20.03	20.35	40131.0
2010-06-17	AAON	Stock	4.8691	4.8691	4.7704	4.8395	151875.0
2010-06-17	AAP	Stock	52.12	52.34	51.55	51.89	688100.0
2010-06-17	AATI-DELISTED	Stock	3.75	3.75	3.57	3.61	286760.0
2010-06-17	AAU-DELISTED	Stock	0.89	1.01	0.89	0.97	147281.0
2010-06-17	AAUAF-DELISTED	Stock	0.89	1.01	0.89	0.97	162281.0
2010-06-17	AAV-DELISTED	Stock	6.98	7.11	6.85	7.03	763904.0
2010-06-17	AAWW-DELISTED	Stock	53.5	53.75	52.13	53.32	125909.0
2010-06-17	AAXJ	Stock	54.65	54.65	53.9	54.24	485853.0
2010-06-17	AAXN-DELISTED	Stock	4.15	4.18	4.1101	4.18	566436.0
2010-06-17	AB	Stock	28.99	29.26	28.82	29.21	224500.0
2010-06-17	ABAX-DELISTED	Stock	22.89	23.05	22.43	22.98	57845.0
2010-06-17	ABB-DELISTED	Stock	18.69	18.7	18.45	18.67	3167457.0
2010-06-17	ABBC-DELISTED	Stock	9.01	9.05	8.86	8.96	60790.0
2010-06-17	ABBNY-DELISTED	Stock	18.68	18.7	18.45	18.64	3238216.0
2010-06-17	ABC-DELISTED	Stock	33.26	33.27	32.49	32.77	4902368.0
2010-06-17	ABCB	Stock	10.4005	10.49	10.3806	10.4204	87113.0
2010-06-17	ABCD-DELISTED	Stock	4.4	4.52	4.34	4.4	27574.0
2010-06-17	ABCO-DELISTED	Stock	20.53	21.56	20.53	21.37	172895.0
2010-06-17	ABCW-DELISTED	Stock	0.8	0.85	0.69	0.73	87270.0
2010-06-17	ABD-DELISTED	Stock	5.33	5.36	5.0897	5.17	768420.0
2010-06-17	ABE-DELISTED	Stock	16.11	16.11	15.92	16.08	4430.0
2010-06-17	ABEO	Stock	3062.5	3062.5	2937.5	2937.5	14.0
2010-06-17	ABFS-DELISTED	Stock	21.88	21.89	21.04	21.46	462764.0
2010-06-17	ABG	Stock	13.29	13.31	12.83	12.96	284700.0
2010-06-17	ABII-DELISTED	Stock	62.24	63.09	62.17	62.5	36803.0
2010-06-17	ABK-DELISTED	Stock	0.81	0.81	0.74	0.78	7631888.0
2010-06-17	ABM	Stock	22.47	22.49	22.1	22.43	133000.0
2010-06-17	ABMD-DELISTED	Stock	9.85	9.9	9.79	9.88	74943.0
2010-06-17	ABR	Stock	5.08	5.34	5.01	5.25	264600.0
2010-06-17	ABT	Stock	23.4334	23.4382	23.1504	23.3327	16354731.0
2010-06-17	ABTL-DELISTED	Stock	6.5	6.5505	6.05	6.1	30900.0
2010-06-17	ABV-DELISTED	Stock	104.49	104.94	103.63	104.59	527462.0
2010-06-17	ABVT-DELISTED	Stock	47.5	47.72	46.97	47.65	106998.0
2010-06-17	ABX-DELISTED	Stock	44.18	44.94	43.89	44.84	12454236.0
2010-06-17	ACAD	Stock	1.33	1.33	1.24	1.31	479100.0
2010-06-17	ACAP-DELISTED	Stock	31.86	32.07	31.52	31.57	30880.0
2010-06-17	ACAS-DELISTED	Stock	5.78	5.79	5.49	5.6	4531022.0

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

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