PREVIEW / stock_daily / 2010-03-29

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-29.parquet
  size:    191 KB
  rows:    5,946
  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-03-29	AAPL	Stock	8.3214	8.3525	8.2721	8.2996	540744400.0
2010-03-29	MSFT	Stock	29.71	29.82	29.55	29.59	33336000.0
2010-03-29	NVDA	Stock	0.4362	0.44	0.4302	0.439	394456000.0
2010-03-29	AMZN	Stock	6.7685	6.8315	6.7165	6.756	92538000.0
2010-03-29	TLT	Stock	88.78	88.85	88.31	88.61	3245248.0
2010-03-29	ES	Stock	27.11	27.55	27.11	27.54	753700.0
2010-03-29	CL	Stock	42.175	42.615	42.125	42.49	2998400.0
2010-03-29	A	Stock	24.5422	24.8212	24.5207	24.6066	5377687.0
2010-03-29	AABA-DELISTED	Stock	16.5	16.68	16.46	16.56	14882585.0
2010-03-29	AACC-DELISTED	Stock	6.36	6.39	6.28	6.3	31563.0
2010-03-29	AACG	Stock	3.97	4.3	3.97	4.3	13000.0
2010-03-29	AAI-DELISTED	Stock	5.09	5.17	5.04	5.06	1646471.0
2010-03-29	AAIC-DELISTED	Stock	17.94	18.08	17.79	17.938	25365.0
2010-03-29	AAME	Stock	1.39	1.41	1.38	1.38	5100.0
2010-03-29	AAON	Stock	4.3437	4.399	4.324	4.3477	134156.0
2010-03-29	AAP	Stock	42.65	42.65	42.0	42.19	1278900.0
2010-03-29	AATI-DELISTED	Stock	3.74	3.75	3.55	3.56	123762.0
2010-03-29	AAU-DELISTED	Stock	0.91	0.91	0.9	0.9	116394.0
2010-03-29	AAUAF-DELISTED	Stock	0.91	0.91	0.9	0.9	116694.0
2010-03-29	AAV-DELISTED	Stock	6.64	6.97	6.55	6.92	847329.0
2010-03-29	AAWW-DELISTED	Stock	53.25	53.5	52.07	52.72	241139.0
2010-03-29	AAXJ	Stock	56.73	56.84	56.43	56.73	47893.0
2010-03-29	AAXN-DELISTED	Stock	6.01	6.07	5.9	6.07	813574.0
2010-03-29	AB	Stock	30.55	30.6	30.16	30.51	295300.0
2010-03-29	ABAX-DELISTED	Stock	27.01	27.18	26.69	27.05	87687.0
2010-03-29	ABB-DELISTED	Stock	21.45	21.52	21.298	21.47	1355263.0
2010-03-29	ABBC-DELISTED	Stock	8.22	8.28	8.07	8.16	52021.0
2010-03-29	ABBNY-DELISTED	Stock	21.45	21.52	21.298	21.49	1356513.0
2010-03-29	ABC-DELISTED	Stock	28.76	28.93	28.62	28.86	2060866.0
2010-03-29	ABCB	Stock	9.1166	9.4052	8.1014	8.5991	89424.0
2010-03-29	ABCD-DELISTED	Stock	4.0	4.0	3.76	3.85	13164.0
2010-03-29	ABCO-DELISTED	Stock	15.78	16.0	15.78	15.98	101808.0
2010-03-29	ABCW-DELISTED	Stock	1.1797	1.1797	1.1305	1.16	91730.0
2010-03-29	ABD-DELISTED	Stock	7.695	7.815	7.625	7.815	214860.0
2010-03-29	ABE-DELISTED	Stock	16.63	16.84	16.63	16.84	10801.0
2010-03-29	ABEO	Stock	3137.5	3187.5	3000.0	3125.0	6.0
2010-03-29	ABFS-DELISTED	Stock	29.45	30.08	29.25	29.78	228538.0
2010-03-29	ABG	Stock	14.05	14.14	13.66	13.68	333700.0
2010-03-29	ABII-DELISTED	Stock	51.0	52.48	51.0	51.6	81999.0
2010-03-29	ABK-DELISTED	Stock	0.5149	0.5718	0.5149	0.5478	17109096.0
2010-03-29	ABM	Stock	20.9	20.97	20.55	20.75	608300.0
2010-03-29	ABMD-DELISTED	Stock	10.65	10.9	10.65	10.83	162141.0
2010-03-29	ABR	Stock	3.37	3.39	3.22	3.27	157400.0
2010-03-29	ABT	Stock	25.4678	25.5014	25.2999	25.487	22003752.0
2010-03-29	ABTL-DELISTED	Stock	5.1	5.8	5.1	5.35	13021.0
2010-03-29	ABV-DELISTED	Stock	92.45	92.585	90.91	92.09	669706.0
2010-03-29	ABVA-DELISTED	Stock	2.58	2.58	2.5	2.5	1100.0
2010-03-29	ABVT-DELISTED	Stock	51.25	51.57	50.74	51.25	66206.0
2010-03-29	ABX-DELISTED	Stock	37.73	37.97	37.34	37.85	9056375.0
2010-03-29	ACAD	Stock	1.58	1.62	1.55	1.58	440100.0

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

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