PREVIEW / stock_daily / 2010-03-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-09.parquet
  size:    191 KB
  rows:    5,942
  symbols: 3,504

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-09	AAPL	Stock	7.7968	8.0357	7.7818	7.965	920259200.0
2010-03-09	MSFT	Stock	28.56	29.11	28.55	28.8	50271600.0
2010-03-09	NVDA	Stock	0.4272	0.443	0.427	0.4388	830832000.0
2010-03-09	AMZN	Stock	6.4795	6.5405	6.3985	6.441	121416000.0
2010-03-09	TLT	Stock	89.98	90.0001	89.4	89.82	2573667.0
2010-03-09	ES	Stock	26.55	26.61	26.37	26.49	992900.0
2010-03-09	CL	Stock	41.81	42.465	41.74	42.25	4540800.0
2010-03-09	A	Stock	23.5551	23.8412	23.5122	23.7983	7083386.0
2010-03-09	AABA-DELISTED	Stock	16.41	16.72	16.4	16.53	20538187.0
2010-03-09	AACC-DELISTED	Stock	5.61	5.79	5.61	5.79	22932.0
2010-03-09	AACG	Stock	3.7	3.7	3.63	3.68	133800.0
2010-03-09	AAI-DELISTED	Stock	4.95	5.43	4.95	5.37	9881110.0
2010-03-09	AAIC-DELISTED	Stock	18.48	18.81	18.4	18.4	94912.0
2010-03-09	AAME	Stock	1.38	1.51	1.38	1.45	7400.0
2010-03-09	AAON	Stock	4.2489	4.3042	4.239	4.2588	393862.0
2010-03-09	AAP	Stock	42.04	42.36	41.79	41.94	2018700.0
2010-03-09	AATI-DELISTED	Stock	3.35	3.4101	3.33	3.37	195077.0
2010-03-09	AAU-DELISTED	Stock	0.9	0.93	0.8932	0.91	149880.0
2010-03-09	AAUAF-DELISTED	Stock	0.9	0.93	0.8932	0.91	153608.0
2010-03-09	AAV-DELISTED	Stock	7.2	7.69	7.18	7.6	737075.0
2010-03-09	AAWW-DELISTED	Stock	47.32	48.94	47.32	48.92	309053.0
2010-03-09	AAXJ	Stock	55.27	55.9	55.22	55.64	337912.0
2010-03-09	AAXN-DELISTED	Stock	6.95	7.35	6.95	7.15	1950392.0
2010-03-09	AB	Stock	27.65	28.36	27.55	28.3	631900.0
2010-03-09	ABAX-DELISTED	Stock	26.06	26.25	25.81	25.98	69193.0
2010-03-09	ABB-DELISTED	Stock	20.76	21.09	20.75	21.0	2174748.0
2010-03-09	ABBC-DELISTED	Stock	8.05	8.1	8.01	8.06	29307.0
2010-03-09	ABBNY-DELISTED	Stock	20.76	21.09	20.75	21.0	2425598.0
2010-03-09	ABC-DELISTED	Stock	28.02	28.16	27.9	28.0	2887475.0
2010-03-09	ABCB	Stock	9.7976	9.847	9.768	9.8272	15491.0
2010-03-09	ABCD-DELISTED	Stock	3.55	3.58	3.55	3.56	16950.0
2010-03-09	ABCO-DELISTED	Stock	15.89	16.145	15.89	16.145	198998.0
2010-03-09	ABCW-DELISTED	Stock	1.19	1.2	1.16	1.18	84130.0
2010-03-09	ABD-DELISTED	Stock	8.06	8.362	8.0	8.29	392180.0
2010-03-09	ABE-DELISTED	Stock	16.3	16.5568	16.3	16.47	14229.0
2010-03-09	ABEO	Stock	3250.0	3312.5	3150.0	3187.5	12.0
2010-03-09	ABFS-DELISTED	Stock	27.97	28.84	27.83	28.75	397516.0
2010-03-09	ABG	Stock	12.93	13.29	12.87	13.11	629100.0
2010-03-09	ABII-DELISTED	Stock	35.2	35.28	34.93	35.17	75032.0
2010-03-09	ABK-DELISTED	Stock	0.71	0.7999	0.7021	0.7581	15723955.0
2010-03-09	ABM	Stock	19.81	20.0	19.73	19.89	307700.0
2010-03-09	ABMD-DELISTED	Stock	10.9	10.99	10.41	10.88	209233.0
2010-03-09	ABR	Stock	2.8	2.85	2.73	2.83	217100.0
2010-03-09	ABT	Stock	26.0004	26.3698	25.9716	26.293	12287828.0
2010-03-09	ABTL-DELISTED	Stock	5.35	5.4	5.15	5.4	21924.0
2010-03-09	ABV-DELISTED	Stock	96.77	97.19	96.51	96.91	599189.0
2010-03-09	ABVA-DELISTED	Stock	2.5	2.5	2.5	2.5	500.0
2010-03-09	ABVT-DELISTED	Stock	62.7	63.5	62.59	63.16	129436.0
2010-03-09	ABX-DELISTED	Stock	39.26	39.86	39.12	39.5	7841800.0
2010-03-09	ACAD	Stock	1.3	1.41	1.3	1.41	656300.0

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

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