PREVIEW / stock_daily / 2010-03-22

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-22.parquet
  size:    192 KB
  rows:    5,966
  symbols: 3,528

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-03-22	AAPL	Stock	7.8739	8.0714	7.8625	8.0268	456419600.0
2010-03-22	MSFT	Stock	29.5	29.7	29.39	29.6	37718200.0
2010-03-22	NVDA	Stock	0.4258	0.44	0.4258	0.4382	435336000.0
2010-03-22	AMZN	Stock	6.51	6.548	6.432	6.5235	107668000.0
2010-03-22	TLT	Stock	91.35	91.49	91.22	91.36	2452341.0
2010-03-22	ES	Stock	27.07	27.21	26.94	27.09	1170100.0
2010-03-22	CL	Stock	42.185	42.805	42.185	42.475	4573800.0
2010-03-22	A	Stock	23.7911	24.1989	23.6695	24.1202	3946694.0
2010-03-22	AABA-DELISTED	Stock	16.36	16.54	16.32	16.33	18560222.0
2010-03-22	AACC-DELISTED	Stock	6.21	6.4	6.1	6.28	22945.0
2010-03-22	AACG	Stock	4.05	4.07	3.9	4.0	32100.0
2010-03-22	AAI-DELISTED	Stock	4.97	5.0812	4.91	5.07	2047063.0
2010-03-22	AAIC-DELISTED	Stock	18.63	18.79	18.0	18.05	17268.0
2010-03-22	AAME	Stock	1.44	1.45	1.43	1.45	2300.0
2010-03-22	AAON	Stock	4.2667	4.3457	4.237	4.3437	165544.0
2010-03-22	AAP	Stock	43.17	43.85	43.02	43.64	1125700.0
2010-03-22	AATI-DELISTED	Stock	3.43	3.7	3.4	3.64	481971.0
2010-03-22	AAU-DELISTED	Stock	0.905	0.9352	0.905	0.93	97102.0
2010-03-22	AAUAF-DELISTED	Stock	0.905	0.9352	0.905	0.93	100102.0
2010-03-22	AAV-DELISTED	Stock	7.04	7.15	6.95	7.06	853883.0
2010-03-22	AAWW-DELISTED	Stock	48.25	49.16	48.25	48.55	238631.0
2010-03-22	AAXJ	Stock	55.5	56.03	55.16	55.99	65807.0
2010-03-22	AAXN-DELISTED	Stock	6.27	6.48	6.15	6.44	786008.0
2010-03-22	AB	Stock	28.76	29.1	28.29	29.1	319000.0
2010-03-22	ABAX-DELISTED	Stock	27.67	28.28	27.3	28.19	134448.0
2010-03-22	ABB-DELISTED	Stock	20.88	21.42	20.87	21.33	2584776.0
2010-03-22	ABBC-DELISTED	Stock	8.24	8.47	8.24	8.38	31047.0
2010-03-22	ABBNY-DELISTED	Stock	20.88	21.42	20.87	21.35	2588010.0
2010-03-22	ABC-DELISTED	Stock	28.62	29.31	28.5	29.29	4793204.0
2010-03-22	ABCB	Stock	9.3729	9.5408	9.3631	9.5309	21769.0
2010-03-22	ABCD-DELISTED	Stock	3.79	3.89	3.77	3.89	7853.0
2010-03-22	ABCO-DELISTED	Stock	16.065	16.435	16.045	16.4	85258.0
2010-03-22	ABCW-DELISTED	Stock	1.05	1.32	1.0405	1.18	434300.0
2010-03-22	ABD-DELISTED	Stock	7.105	7.355	7.025	7.325	218550.0
2010-03-22	ABE-DELISTED	Stock	16.46	16.6999	16.46	16.67	10526.0
2010-03-22	ABEO	Stock	3075.0	3237.5	3075.0	3187.5	9.0
2010-03-22	ABFS-DELISTED	Stock	28.98	29.9799	28.67	29.87	410607.0
2010-03-22	ABG	Stock	13.83	14.05	13.74	14.02	199100.0
2010-03-22	ABII-DELISTED	Stock	52.25	53.82	50.5	52.38	123891.0
2010-03-22	ABK-DELISTED	Stock	0.7398	0.77	0.7213	0.77	9378715.0
2010-03-22	ABM	Stock	20.15	20.8	20.15	20.66	227800.0
2010-03-22	ABMD-DELISTED	Stock	10.03	10.36	10.03	10.19	137499.0
2010-03-22	ABR	Stock	2.59	2.76	2.56	2.69	185000.0
2010-03-22	ABT	Stock	25.6213	26.0196	25.5733	25.8468	15663610.0
2010-03-22	ABTL-DELISTED	Stock	5.5	5.5	5.25	5.45	19599.0
2010-03-22	ABV-DELISTED	Stock	93.0	93.3	92.5	93.16	618558.0
2010-03-22	ABVA-DELISTED	Stock	2.5	2.65	2.5	2.65	7850.0
2010-03-22	ABVT-DELISTED	Stock	54.75	55.34	54.25	54.63	181737.0
2010-03-22	ABX-DELISTED	Stock	38.9	39.42	38.5	39.41	8802112.0
2010-03-22	ACAD	Stock	1.63	1.64	1.57	1.57	281400.0

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

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