PREVIEW / stock_daily / 2010-03-31

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-31.parquet
  size:    192 KB
  rows:    5,945
  symbols: 3,515

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-31	AAPL	Stock	8.4104	8.4504	8.3736	8.3929	430659600.0
2010-03-31	MSFT	Stock	29.64	29.72	29.17	29.29	63760000.0
2010-03-31	NVDA	Stock	0.439	0.441	0.4328	0.435	389840000.0
2010-03-31	AMZN	Stock	6.8	6.84	6.724	6.7885	92012000.0
2010-03-31	TLT	Stock	89.22	89.52	88.95	89.5	4263866.0
2010-03-31	ES	Stock	27.79	27.88	27.53	27.64	914700.0
2010-03-31	CL	Stock	42.595	42.775	42.485	42.63	3754600.0
2010-03-31	A	Stock	24.7139	24.7353	24.5279	24.5994	5293387.0
2010-03-31	AABA-DELISTED	Stock	16.57	16.58	16.42	16.52	11782517.0
2010-03-31	AACC-DELISTED	Stock	6.28	6.61	6.28	6.28	24807.0
2010-03-31	AACG	Stock	4.31	4.31	4.0	4.03	8500.0
2010-03-31	AAI-DELISTED	Stock	5.04	5.15	5.03	5.07	2473511.0
2010-03-31	AAIC-DELISTED	Stock	18.02	18.05	17.812	17.82	26856.0
2010-03-31	AAME	Stock	1.49	1.49	1.44	1.48	3000.0
2010-03-31	AAON	Stock	4.4721	4.5531	4.4069	4.4681	456131.0
2010-03-31	AAP	Stock	42.22	42.5	41.89	41.92	1191200.0
2010-03-31	AATI-DELISTED	Stock	3.53	3.63	3.47	3.49	184409.0
2010-03-31	AAU-DELISTED	Stock	0.891	0.91	0.8894	0.91	82642.0
2010-03-31	AAUAF-DELISTED	Stock	0.891	0.91	0.8899	0.91	82797.0
2010-03-31	AAV-DELISTED	Stock	6.93	7.06	6.79	6.79	582071.0
2010-03-31	AAWW-DELISTED	Stock	53.13	53.54	53.0	53.02	159841.0
2010-03-31	AAXJ	Stock	56.49	56.946	56.2801	56.72	175519.0
2010-03-31	AAXN-DELISTED	Stock	6.01	6.03	5.86	5.87	838767.0
2010-03-31	AB	Stock	30.32	31.08	30.32	30.66	213300.0
2010-03-31	ABAX-DELISTED	Stock	27.47	28.09	27.13	27.19	95520.0
2010-03-31	ABB-DELISTED	Stock	21.72	21.96	21.62	21.85	1652440.0
2010-03-31	ABBC-DELISTED	Stock	8.01	8.12	7.84	7.9	120695.0
2010-03-31	ABBNY-DELISTED	Stock	21.72	21.96	21.62	21.84	1658504.0
2010-03-31	ABC-DELISTED	Stock	29.27	29.27	28.75	28.92	2383648.0
2010-03-31	ABCB	Stock	8.6886	9.1863	8.6886	8.9872	55463.0
2010-03-31	ABCD-DELISTED	Stock	4.02	4.03	3.96	4.0	10756.0
2010-03-31	ABCO-DELISTED	Stock	15.845	16.055	15.728	15.75	120796.0
2010-03-31	ABCW-DELISTED	Stock	1.1	1.1595	1.0901	1.1	77550.0
2010-03-31	ABD-DELISTED	Stock	7.74	7.82	7.57	7.68	308910.0
2010-03-31	ABE-DELISTED	Stock	17.08	17.08	16.91	17.02	45442.0
2010-03-31	ABEO	Stock	3100.0	3187.5	3062.5	3137.5	13.0
2010-03-31	ABFS-DELISTED	Stock	29.66	30.36	29.35	29.9	383604.0
2010-03-31	ABG	Stock	13.56	13.68	13.27	13.3	427400.0
2010-03-31	ABII-DELISTED	Stock	52.04	52.14	51.43	51.72	127165.0
2010-03-31	ABK-DELISTED	Stock	0.57	0.587	0.55	0.555	8614585.0
2010-03-31	ABM	Stock	20.93	21.31	20.75	21.2	472700.0
2010-03-31	ABMD-DELISTED	Stock	10.93	10.93	10.23	10.33	294473.0
2010-03-31	ABR	Stock	3.25	3.25	3.2	3.24	97900.0
2010-03-31	ABT	Stock	25.2183	25.4246	25.0504	25.2759	15870363.0
2010-03-31	ABTL-DELISTED	Stock	5.5	5.5	5.15	5.25	11770.0
2010-03-31	ABV-DELISTED	Stock	92.88	93.02	91.5999	91.74	802455.0
2010-03-31	ABVA-DELISTED	Stock	2.5	2.55	2.5	2.5	563.0
2010-03-31	ABVT-DELISTED	Stock	50.63	51.11	50.545	50.8	206297.0
2010-03-31	ABX-DELISTED	Stock	38.39	38.71	38.05	38.35	10124701.0
2010-03-31	ACAD	Stock	1.56	1.56	1.5	1.51	303500.0

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

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