PREVIEW / stock_daily / 2010-03-17

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-17.parquet
  size:    191 KB
  rows:    5,936
  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-17	AAPL	Stock	8.0321	8.0875	7.9739	8.0043	450956800.0
2010-03-17	MSFT	Stock	29.5	29.87	29.4	29.63	50385700.0
2010-03-17	NVDA	Stock	0.4465	0.4585	0.4465	0.4525	651168000.0
2010-03-17	AMZN	Stock	6.6205	6.6345	6.561	6.567	87176000.0
2010-03-17	TLT	Stock	91.31	91.47	91.07	91.47	3481160.0
2010-03-17	ES	Stock	27.28	27.28	27.02	27.16	1301900.0
2010-03-17	CL	Stock	42.365	42.365	41.9	42.315	4796600.0
2010-03-17	A	Stock	23.9199	24.0629	23.834	23.877	3926003.0
2010-03-17	AABA-DELISTED	Stock	16.28	16.63	16.27	16.5	13699330.0
2010-03-17	AACC-DELISTED	Stock	6.1	6.44	6.061	6.35	12867.0
2010-03-17	AACG	Stock	4.26	4.26	4.16	4.17	20900.0
2010-03-17	AAI-DELISTED	Stock	5.42	5.45	5.29	5.29	3293684.0
2010-03-17	AAIC-DELISTED	Stock	18.42	18.42	18.15	18.26	11427.0
2010-03-17	AAME	Stock	1.5	1.53	1.48	1.48	1000.0
2010-03-17	AAON	Stock	4.1916	4.3062	4.0928	4.239	500175.0
2010-03-17	AAP	Stock	42.47	42.59	42.11	42.35	1653100.0
2010-03-17	AATI-DELISTED	Stock	3.39	3.55	3.36	3.51	1157598.0
2010-03-17	AAU-DELISTED	Stock	0.93	0.96	0.93	0.9399	95650.0
2010-03-17	AAUAF-DELISTED	Stock	0.93	0.96	0.93	0.9399	96350.0
2010-03-17	AAV-DELISTED	Stock	7.85	7.85	7.63	7.63	1162744.0
2010-03-17	AAWW-DELISTED	Stock	49.11	49.98	48.7	49.82	224534.0
2010-03-17	AAXJ	Stock	56.65	57.016	56.35	56.73	202586.0
2010-03-17	AAXN-DELISTED	Stock	6.85	6.88	6.68	6.71	1017365.0
2010-03-17	AB	Stock	29.47	29.89	29.32	29.84	324000.0
2010-03-17	ABAX-DELISTED	Stock	27.53	28.0255	27.52	27.89	193222.0
2010-03-17	ABB-DELISTED	Stock	21.61	21.74	21.51	21.57	1611539.0
2010-03-17	ABBC-DELISTED	Stock	8.44	8.46	8.24	8.31	48789.0
2010-03-17	ABBNY-DELISTED	Stock	21.61	21.74	21.51	21.56	1614202.0
2010-03-17	ABC-DELISTED	Stock	28.57	28.58	28.18	28.21	3080921.0
2010-03-17	ABCB	Stock	9.5013	9.6199	9.2841	9.4322	31185.0
2010-03-17	ABCD-DELISTED	Stock	3.91	3.94	3.85	3.88	13225.0
2010-03-17	ABCO-DELISTED	Stock	16.378	16.678	16.378	16.472	61321.0
2010-03-17	ABCW-DELISTED	Stock	1.35	1.4	1.26	1.34	199740.0
2010-03-17	ABD-DELISTED	Stock	7.42	7.55	7.25	7.49	200770.0
2010-03-17	ABE-DELISTED	Stock	16.84	16.87	16.5	16.77	26264.0
2010-03-17	ABEO	Stock	2987.5	3250.0	2987.5	3187.5	10.0
2010-03-17	ABFS-DELISTED	Stock	30.04	30.21	29.341	29.46	481099.0
2010-03-17	ABG	Stock	14.07	14.24	14.01	14.05	184100.0
2010-03-17	ABII-DELISTED	Stock	46.12	54.03	45.79	51.64	509534.0
2010-03-17	ABK-DELISTED	Stock	0.7806	0.815	0.77	0.778	9650550.0
2010-03-17	ABM	Stock	19.7	20.21	19.7	20.09	209300.0
2010-03-17	ABMD-DELISTED	Stock	10.28	10.48	10.23	10.33	167245.0
2010-03-17	ABR	Stock	2.99	3.04	2.99	3.0	76400.0
2010-03-17	ABT	Stock	26.3122	26.3314	26.0531	26.1491	15366194.0
2010-03-17	ABTL-DELISTED	Stock	5.4503	5.6997	5.4473	5.4997	17853.0
2010-03-17	ABV-DELISTED	Stock	97.19	97.34	96.57	96.97	557846.0
2010-03-17	ABVA-DELISTED	Stock	2.64	2.64	2.64	2.64	400.0
2010-03-17	ABVT-DELISTED	Stock	54.75	55.02	54.69	54.91	291944.0
2010-03-17	ABX-DELISTED	Stock	40.29	40.61	40.075	40.17	9114511.0
2010-03-17	ACAD	Stock	1.67	1.67	1.54	1.57	649400.0

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

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