PREVIEW / stock_daily / 2010-01-22

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-22.parquet
  size:    189 KB
  rows:    5,911
  symbols: 3,502

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-01-22	AAPL	Stock	7.385	7.4107	7.0414	7.0625	881767600.0
2010-01-22	MSFT	Stock	30.0	30.2	28.84	28.96	102004600.0
2010-01-22	NVDA	Stock	0.4213	0.429	0.409	0.4115	1067916000.0
2010-01-22	AMZN	Stock	6.28	6.3835	6.038	6.0715	231378000.0
2010-01-22	TLT	Stock	92.09	92.31	91.765	92.0	3667182.0
2010-01-22	ES	Stock	26.01	26.28	25.45	25.46	1178300.0
2010-01-22	CL	Stock	39.525	40.59	39.18	40.355	10959000.0
2010-01-22	A	Stock	21.7096	21.7096	20.8083	20.8655	4263061.0
2010-01-22	AABA-DELISTED	Stock	16.11	16.21	15.81	15.88	24980297.0
2010-01-22	AACC-DELISTED	Stock	5.79	6.386	5.79	6.14	49275.0
2010-01-22	AACG	Stock	4.29	4.29	3.63	3.86	52300.0
2010-01-22	AAI-DELISTED	Stock	5.62	5.67	5.28	5.3699	4547286.0
2010-01-22	AAIC-DELISTED	Stock	15.87	15.98	14.85	14.93	25822.0
2010-01-22	AAME	Stock	1.41	1.44	1.35	1.44	13700.0
2010-01-22	AAON	Stock	3.763	3.8874	3.763	3.8281	360956.0
2010-01-22	AAP	Stock	39.13	40.64	39.13	39.74	2629300.0
2010-01-22	AATI-DELISTED	Stock	3.96	4.02	3.78	3.8	448355.0
2010-01-22	AAU-DELISTED	Stock	0.98	1.01	0.961	1.0	141811.0
2010-01-22	AAUAF-DELISTED	Stock	0.98	1.01	0.961	1.0	146911.0
2010-01-22	AAV-DELISTED	Stock	6.57	6.84	6.53	6.57	570536.0
2010-01-22	AAWW-DELISTED	Stock	37.83	37.9	36.8	37.06	396839.0
2010-01-22	AAXJ	Stock	54.64	54.74	53.54	53.77	359272.0
2010-01-22	AAXN-DELISTED	Stock	5.88	6.09	5.58	5.74	1225480.0
2010-01-22	AB	Stock	28.89	29.01	27.45	27.87	596300.0
2010-01-22	ABAX-DELISTED	Stock	23.97	24.24	23.44	23.6	108030.0
2010-01-22	ABB-DELISTED	Stock	18.4	18.54	17.94	18.0	5739787.0
2010-01-22	ABBC-DELISTED	Stock	7.02	7.07	7.0	7.0	29202.0
2010-01-22	ABBNY-DELISTED	Stock	18.4	18.54	17.94	17.99	5740887.0
2010-01-22	ABC-DELISTED	Stock	26.47	26.8	26.02	26.66	4314114.0
2010-01-22	ABCB	Stock	8.8889	9.0964	8.5038	8.9483	53156.0
2010-01-22	ABCD-DELISTED	Stock	4.0	4.03	4.0	4.0	7728.0
2010-01-22	ABCO-DELISTED	Stock	15.935	16.015	15.8	15.845	119650.0
2010-01-22	ABCW-DELISTED	Stock	1.1883	1.3433	1.1883	1.24	257330.0
2010-01-22	ABD-DELISTED	Stock	8.235	8.295	8.115	8.215	488490.0
2010-01-22	ABE-DELISTED	Stock	16.3	16.3593	16.13	16.13	9324.0
2010-01-22	ABEO	Stock	3737.5	3750.0	3500.0	3550.0	134.0
2010-01-22	ABFS-DELISTED	Stock	26.35	26.9	25.81	26.3	539077.0
2010-01-22	ABG	Stock	12.54	12.54	11.64	11.72	270800.0
2010-01-22	ABII-DELISTED	Stock	41.46	42.66	41.355	42.2	21682.0
2010-01-22	ABK-DELISTED	Stock	0.77	0.77	0.7087	0.72	7231571.0
2010-01-22	ABM	Stock	19.54	19.89	19.45	19.51	125600.0
2010-01-22	ABMD-DELISTED	Stock	8.48	8.51	8.25	8.45	340646.0
2010-01-22	ABR	Stock	2.35	2.35	2.22	2.23	86400.0
2010-01-22	ABT	Stock	26.5473	26.7057	26.1011	26.1539	14599208.0
2010-01-22	ABTL-DELISTED	Stock	5.05	5.25	5.0	5.25	13882.0
2010-01-22	ABV-DELISTED	Stock	99.09	99.99	97.16	98.88	798063.0
2010-01-22	ABVA-DELISTED	Stock	2.802	2.802	2.75	2.7501	650.0
2010-01-22	ABVT-DELISTED	Stock	62.69	64.7	62.29	62.3	88536.0
2010-01-22	ABX-DELISTED	Stock	36.3	37.52	36.11	36.48	17336837.0
2010-01-22	ACAD	Stock	1.36	1.37	1.32	1.34	325100.0

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

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