PREVIEW / stock_daily / 2010-03-11

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-11.parquet
  size:    191 KB
  rows:    5,915
  symbols: 3,497

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-11	AAPL	Stock	7.9968	8.0536	7.9757	8.0536	405700400.0
2010-03-11	MSFT	Stock	28.89	29.19	28.85	29.18	35349700.0
2010-03-11	NVDA	Stock	0.4362	0.4378	0.428	0.4298	540660000.0
2010-03-11	AMZN	Stock	6.5225	6.681	6.518	6.679	144816000.0
2010-03-11	TLT	Stock	89.39	90.14	89.37	89.92	2621503.0
2010-03-11	ES	Stock	26.36	26.8	26.36	26.67	1051300.0
2010-03-11	CL	Stock	41.625	42.04	41.39	42.04	4436200.0
2010-03-11	A	Stock	23.877	24.0343	23.784	24.02	3942360.0
2010-03-11	AABA-DELISTED	Stock	16.59	16.65	16.1	16.53	20731923.0
2010-03-11	AACC-DELISTED	Stock	5.85	6.0	5.4501	5.8	133277.0
2010-03-11	AACG	Stock	4.0	4.08	3.77	3.85	328500.0
2010-03-11	AAI-DELISTED	Stock	5.35	5.38	5.25	5.37	2142597.0
2010-03-11	AAIC-DELISTED	Stock	18.61	18.7	18.46	18.69	51951.0
2010-03-11	AAME	Stock	1.54	1.58	1.54	1.58	1100.0
2010-03-11	AAON	Stock	4.243	4.2884	4.243	4.2844	297169.0
2010-03-11	AAP	Stock	42.14	42.42	41.92	42.38	1361500.0
2010-03-11	AATI-DELISTED	Stock	3.41	3.47	3.4	3.43	186822.0
2010-03-11	AAU-DELISTED	Stock	0.94	0.94	0.9	0.9111	112800.0
2010-03-11	AAUAF-DELISTED	Stock	0.94	0.94	0.9	0.9111	113400.0
2010-03-11	AAV-DELISTED	Stock	7.96	8.07	7.79	7.88	489791.0
2010-03-11	AAWW-DELISTED	Stock	48.1	48.465	47.57	48.0	201763.0
2010-03-11	AAXJ	Stock	55.56	55.946	55.36	55.85	102325.0
2010-03-11	AAXN-DELISTED	Stock	7.06	7.16	7.0	7.025	833276.0
2010-03-11	AB	Stock	28.74	29.48	28.47	29.33	577200.0
2010-03-11	ABAX-DELISTED	Stock	26.49	26.98	26.44	26.96	82364.0
2010-03-11	ABB-DELISTED	Stock	20.8	20.88	20.67	20.87	1842196.0
2010-03-11	ABBC-DELISTED	Stock	8.07	8.1	8.04	8.09	30192.0
2010-03-11	ABBNY-DELISTED	Stock	20.8	20.88	20.67	20.88	1847146.0
2010-03-11	ABC-DELISTED	Stock	27.9	28.12	27.8	28.09	1678644.0
2010-03-11	ABCB	Stock	9.7877	9.926	9.7778	9.8668	26325.0
2010-03-11	ABCD-DELISTED	Stock	3.65	3.77	3.6	3.64	539734.0
2010-03-11	ABCO-DELISTED	Stock	15.952	16.493	15.922	16.403	267814.0
2010-03-11	ABCW-DELISTED	Stock	1.24	1.24	1.16	1.21	177320.0
2010-03-11	ABD-DELISTED	Stock	8.08	8.16	7.855	8.06	164600.0
2010-03-11	ABE-DELISTED	Stock	16.53	16.6	16.28	16.5836	12871.0
2010-03-11	ABEO	Stock	3137.5	3187.5	3062.5	3125.0	30.0
2010-03-11	ABFS-DELISTED	Stock	29.02	29.635	28.64	29.15	471850.0
2010-03-11	ABG	Stock	13.35	13.46	13.16	13.36	321300.0
2010-03-11	ABII-DELISTED	Stock	35.37	37.95	35.3	37.95	51268.0
2010-03-11	ABK-DELISTED	Stock	0.82	0.83	0.77	0.7901	12051161.0
2010-03-11	ABM	Stock	19.87	20.02	19.84	19.95	180800.0
2010-03-11	ABMD-DELISTED	Stock	10.86	10.96	10.72	10.78	137588.0
2010-03-11	ABR	Stock	2.95	2.95	2.83	2.86	115700.0
2010-03-11	ABT	Stock	26.4082	26.6529	26.317	26.6481	11900584.0
2010-03-11	ABTL-DELISTED	Stock	5.1	5.4	5.1	5.25	593.0
2010-03-11	ABV-DELISTED	Stock	97.07	97.39	96.46	96.8	410885.0
2010-03-11	ABVA-DELISTED	Stock	2.55	2.6	2.55	2.6	10720.0
2010-03-11	ABVT-DELISTED	Stock	56.0	56.9	54.8	54.97	303296.0
2010-03-11	ABX-DELISTED	Stock	38.56	39.2051	38.37	39.17	7668429.0
2010-03-11	ACAD	Stock	1.39	1.41	1.34	1.41	379000.0

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

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