PREVIEW / stock_daily / 2010-10-18

all stock daily files

  file:    by_date/stock_daily/2010/2010-10-18.parquet
  size:    192 KB
  rows:    5,997
  symbols: 3,520

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-10-18	AAPL	Stock	11.3739	11.3929	11.2246	11.3571	1093010800.0
2010-10-18	MSFT	Stock	25.59	25.95	25.45	25.82	48330500.0
2010-10-18	NVDA	Stock	0.2825	0.2852	0.2775	0.284	448156000.0
2010-10-18	AMZN	Stock	8.25	8.2595	8.091	8.178	126626000.0
2010-10-18	TSLA	Stock	1.368	1.376	1.348	1.3487	2442000.0
2010-10-18	TLT	Stock	101.2	101.45	100.78	101.08	5592388.0
2010-10-18	ES	Stock	30.75	31.05	30.21	30.42	5094800.0
2010-10-18	CL	Stock	38.1	38.47	38.05	38.365	5691400.0
2010-10-18	A	Stock	24.671	24.8712	24.4134	24.7926	2889666.0
2010-10-18	AABA-DELISTED	Stock	16.22	16.28	15.75	15.93	35887782.0
2010-10-18	AACC-DELISTED	Stock	5.76	5.79	5.66	5.79	24147.0
2010-10-18	AACG	Stock	3.21	3.29	3.21	3.29	6700.0
2010-10-18	AAI-DELISTED	Stock	7.38	7.39	7.37	7.38	3628552.0
2010-10-18	AAIC-DELISTED	Stock	23.38	23.72	23.21	23.49	46367.0
2010-10-18	AAME	Stock	1.69	1.72	1.69	1.72	7100.0
2010-10-18	AAON	Stock	4.8691	4.8711	4.8257	4.8612	158456.0
2010-10-18	AAP	Stock	61.28	61.3	60.04	60.36	463400.0
2010-10-18	AATI-DELISTED	Stock	3.93	3.97	3.88	3.95	111492.0
2010-10-18	AAU-DELISTED	Stock	2.76	2.77	2.65	2.73	241558.0
2010-10-18	AAUAF-DELISTED	Stock	2.76	2.77	2.65	2.73	242758.0
2010-10-18	AAV-DELISTED	Stock	6.4	6.47	6.4	6.45	267987.0
2010-10-18	AAWW-DELISTED	Stock	55.37	56.75	55.1	56.4	200859.0
2010-10-18	AAXJ	Stock	62.94	63.35	62.68	63.31	203397.0
2010-10-18	AAXN-DELISTED	Stock	4.18	4.49	4.16	4.48	740166.0
2010-10-18	AB	Stock	26.3	26.6	26.02	26.6	295000.0
2010-10-18	ABAC-DELISTED	Stock	6.0	6.05	5.66	5.95	140316.0
2010-10-18	ABAX-DELISTED	Stock	24.42	24.88	24.26	24.7	52534.0
2010-10-18	ABB-DELISTED	Stock	22.36	22.4625	22.25	22.37	1611230.0
2010-10-18	ABBC-DELISTED	Stock	10.74	10.87	10.7	10.85	34740.0
2010-10-18	ABBNY-DELISTED	Stock	22.36	22.4625	22.25	22.35	1636807.0
2010-10-18	ABC-DELISTED	Stock	32.34	32.53	32.19	32.34	2525436.0
2010-10-18	ABCB	Stock	9.34	9.66	8.8	9.55	80800.0
2010-10-18	ABCD-DELISTED	Stock	3.21	3.4	3.21	3.36	25286.0
2010-10-18	ABCO-DELISTED	Stock	23.65	23.82	23.39	23.75	84138.0
2010-10-18	ABCW-DELISTED	Stock	0.69	0.69	0.67	0.68	32620.0
2010-10-18	ABD-DELISTED	Stock	6.07	6.16	6.0	6.13	120150.0
2010-10-18	ABE-DELISTED	Stock	19.19	19.34	19.18	19.34	5844.0
2010-10-18	ABEO	Stock	3575.0	3687.5	3525.0	3687.5	98.0
2010-10-18	ABFS-DELISTED	Stock	24.45	25.39	24.0	25.37	413787.0
2010-10-18	ABG	Stock	14.61	15.1	14.56	15.08	189000.0
2010-10-18	ABK-DELISTED	Stock	1.06	1.1	0.86	0.9159	48479591.0
2010-10-18	ABM	Stock	22.25	22.65	22.16	22.55	366900.0
2010-10-18	ABMD-DELISTED	Stock	11.01	11.09	10.79	10.87	149410.0
2010-10-18	ABR	Stock	5.37	5.45	5.28	5.45	55700.0
2010-10-18	ABT	Stock	25.5158	25.7509	25.4534	25.7509	12793247.0
2010-10-18	ABTL-DELISTED	Stock	4.4897	4.4897	4.1969	4.2103	71192.0
2010-10-18	ABV-DELISTED	Stock	140.55	141.97	139.01	140.75	844547.0
2010-10-18	ABVA-DELISTED	Stock	2.84	2.85	2.75	2.85	5900.0
2010-10-18	ABVT-DELISTED	Stock	54.5	55.15	54.27	54.72	107999.0
2010-10-18	ABX-DELISTED	Stock	47.53	47.97	47.08	47.84	7967695.0

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

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