PREVIEW / stock_daily / 2010-07-15

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-15.parquet
  size:    188 KB
  rows:    5,892
  symbols: 3,458

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-07-15	AAPL	Stock	8.8654	9.1775	8.8321	8.9804	824866000.0
2010-07-15	MSFT	Stock	25.5	25.59	24.98	25.51	56934700.0
2010-07-15	NVDA	Stock	0.276	0.2763	0.2648	0.268	953088000.0
2010-07-15	AMZN	Stock	6.0065	6.124	5.963	6.103	120954000.0
2010-07-15	TSLA	Stock	1.3293	1.4333	1.2667	1.326	56097000.0
2010-07-15	TLT	Stock	99.74	100.59	99.7	100.31	6996382.0
2010-07-15	ES	Stock	27.33	27.67	27.12	27.61	1531800.0
2010-07-15	CL	Stock	41.575	41.73	41.255	41.545	3370600.0
2010-07-15	A	Stock	20.4721	20.5508	20.1216	20.3147	5779052.0
2010-07-15	AABA-DELISTED	Stock	15.31	15.39	15.04	15.35	12563469.0
2010-07-15	AACC-DELISTED	Stock	4.14	4.19	3.85	4.06	30560.0
2010-07-15	AAI-DELISTED	Stock	5.0	5.0	4.82	4.93	2292747.0
2010-07-15	AAIC-DELISTED	Stock	18.56	18.57	18.0	18.24	43658.0
2010-07-15	AAME	Stock	1.28	1.31	1.26	1.26	6100.0
2010-07-15	AAON	Stock	4.7012	4.7012	4.6064	4.6558	155925.0
2010-07-15	AAP	Stock	52.63	53.21	52.08	53.06	1016500.0
2010-07-15	AATI-DELISTED	Stock	3.38	3.47	3.26	3.43	122296.0
2010-07-15	AAU-DELISTED	Stock	0.8876	0.8923	0.8724	0.88	25532.0
2010-07-15	AAUAF-DELISTED	Stock	0.8852	0.89	0.87	0.88	25800.0
2010-07-15	AAV-DELISTED	Stock	6.39	6.47	6.27	6.44	429861.0
2010-07-15	AAWW-DELISTED	Stock	57.03	57.13	54.6	56.79	264024.0
2010-07-15	AAXJ	Stock	54.73	54.73	54.06	54.62	298093.0
2010-07-15	AAXN-DELISTED	Stock	3.78	3.89	3.73	3.77	437352.0
2010-07-15	AB	Stock	28.6	28.66	27.88	28.25	142900.0
2010-07-15	ABAX-DELISTED	Stock	19.18	19.4	18.82	18.98	166783.0
2010-07-15	ABB-DELISTED	Stock	18.73	18.78	18.43	18.75	2783512.0
2010-07-15	ABBC-DELISTED	Stock	8.99	9.04	8.841	9.01	39210.0
2010-07-15	ABBNY-DELISTED	Stock	18.73	18.78	18.43	18.76	2884999.0
2010-07-15	ABC-DELISTED	Stock	32.72	32.93	32.5	32.7	3542685.0
2010-07-15	ABCB	Stock	10.47	10.49	10.07	10.24	37400.0
2010-07-15	ABCD-DELISTED	Stock	3.49	3.63	3.48	3.48	30133.0
2010-07-15	ABCO-DELISTED	Stock	21.07	21.07	20.5	20.9	79047.0
2010-07-15	ABCW-DELISTED	Stock	0.5455	0.5455	0.4624	0.49	32440.0
2010-07-15	ABD-DELISTED	Stock	5.59	5.59	5.15	5.29	398660.0
2010-07-15	ABE-DELISTED	Stock	16.7	16.76	16.59	16.74	43915.0
2010-07-15	ABEO	Stock	2375.0	2812.5	2375.0	2625.0	46.0
2010-07-15	ABFS-DELISTED	Stock	22.34	22.34	21.41	21.75	466325.0
2010-07-15	ABG	Stock	11.06	11.13	10.69	11.04	204300.0
2010-07-15	ABII-DELISTED	Stock	74.65	75.34	74.65	74.88	93074.0
2010-07-15	ABK-DELISTED	Stock	0.74	0.74	0.7	0.716	5121946.0
2010-07-15	ABM	Stock	21.64	21.64	20.97	21.21	406400.0
2010-07-15	ABMD-DELISTED	Stock	11.17	11.35	11.01	11.24	418357.0
2010-07-15	ABR	Stock	6.04	6.04	5.62	5.84	119300.0
2010-07-15	ABT	Stock	22.9632	23.0832	22.8769	23.04	12081075.0
2010-07-15	ABTL-DELISTED	Stock	6.0513	6.1026	5.9487	6.0	10916.0
2010-07-15	ABV-DELISTED	Stock	106.16	106.59	104.23	106.48	772039.0
2010-07-15	ABVT-DELISTED	Stock	49.06	49.06	47.7	48.49	82224.0
2010-07-15	ABX-DELISTED	Stock	43.32	43.35	42.43	43.1	7952965.0
2010-07-15	ACAD	Stock	1.06	1.09	1.04	1.09	176200.0
2010-07-15	ACAP-DELISTED	Stock	40.88	40.9	40.75	40.78	193149.0

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

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