PREVIEW / stock_daily / 2010-08-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-09.parquet
  size:    190 KB
  rows:    5,963
  symbols: 3,510

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-08-09	AAPL	Stock	9.3386	9.3625	9.2704	9.3482	303128000.0
2010-08-09	MSFT	Stock	25.55	25.73	25.37	25.61	57096500.0
2010-08-09	NVDA	Stock	0.2412	0.2415	0.2352	0.241	466456000.0
2010-08-09	AMZN	Stock	6.423	6.4965	6.3925	6.4415	101716000.0
2010-08-09	TSLA	Stock	1.3267	1.332	1.2967	1.3067	12190500.0
2010-08-09	TLT	Stock	99.74	99.98	99.61	99.73	2578456.0
2010-08-09	ES	Stock	29.07	29.37	28.94	29.03	1336300.0
2010-08-09	CL	Stock	38.425	38.475	37.915	38.135	6702600.0
2010-08-09	A	Stock	20.6867	21.3662	20.6509	21.3305	5157222.0
2010-08-09	AABA-DELISTED	Stock	14.34	14.52	14.34	14.4	12194243.0
2010-08-09	AACC-DELISTED	Stock	4.46	4.5	4.33	4.49	8970.0
2010-08-09	AACG	Stock	2.96	3.1	2.96	3.1	2100.0
2010-08-09	AAI-DELISTED	Stock	4.72	4.74	4.65	4.68	1252100.0
2010-08-09	AAIC-DELISTED	Stock	20.21	20.97	20.02	20.9	56470.0
2010-08-09	AAME	Stock	1.3	1.3	1.24	1.24	4000.0
2010-08-09	AAON	Stock	4.8178	4.8178	4.7348	4.7565	258694.0
2010-08-09	AAP	Stock	52.76	53.42	52.76	53.26	867000.0
2010-08-09	AATI-DELISTED	Stock	3.25	3.35	3.22	3.35	89104.0
2010-08-09	AAU-DELISTED	Stock	0.995	1.18	0.9751	1.15	328876.0
2010-08-09	AAUAF-DELISTED	Stock	0.995	1.18	0.9751	1.15	329676.0
2010-08-09	AAV-DELISTED	Stock	6.34	6.36	6.22	6.32	214060.0
2010-08-09	AAWW-DELISTED	Stock	49.12	50.14	49.12	49.8	511179.0
2010-08-09	AAXJ	Stock	57.19	57.45	57.11	57.24	251901.0
2010-08-09	AAXN-DELISTED	Stock	4.1	4.1	4.02	4.07	189556.0
2010-08-09	AB	Stock	26.84	28.3	26.84	27.89	469700.0
2010-08-09	ABAC-DELISTED	Stock	3.8	4.0	3.8	3.9	30200.0
2010-08-09	ABAX-DELISTED	Stock	20.53	20.9	20.43	20.74	68450.0
2010-08-09	ABB-DELISTED	Stock	20.47	20.52	20.37	20.47	1276736.0
2010-08-09	ABBC-DELISTED	Stock	9.39	9.49	9.32	9.48	28259.0
2010-08-09	ABBNY-DELISTED	Stock	20.47	20.52	20.37	20.52	1283688.0
2010-08-09	ABC-DELISTED	Stock	30.26	30.36	29.89	30.03	2296069.0
2010-08-09	ABCB	Stock	9.51	9.71	9.15	9.6	29900.0
2010-08-09	ABCD-DELISTED	Stock	3.59	3.69	3.43	3.69	12961.0
2010-08-09	ABCO-DELISTED	Stock	21.85	22.35	21.74	22.22	85032.0
2010-08-09	ABCW-DELISTED	Stock	0.75	0.75	0.64	0.69	71270.0
2010-08-09	ABD-DELISTED	Stock	6.48	6.81	6.48	6.75	352650.0
2010-08-09	ABE-DELISTED	Stock	17.37	17.4901	17.37	17.49	8323.0
2010-08-09	ABEO	Stock	2625.0	2812.5	2500.0	2625.0	17.0
2010-08-09	ABFS-DELISTED	Stock	21.7	21.96	21.4501	21.92	233055.0
2010-08-09	ABG	Stock	14.02	14.44	13.94	14.42	277800.0
2010-08-09	ABII-DELISTED	Stock	75.87	76.13	75.79	76.07	110894.0
2010-08-09	ABK-DELISTED	Stock	0.9479	0.949	0.9	0.9101	27254259.0
2010-08-09	ABM	Stock	21.34	21.71	21.15	21.66	157100.0
2010-08-09	ABMD-DELISTED	Stock	10.28	10.46	10.14	10.2	186242.0
2010-08-09	ABR	Stock	5.84	5.89	5.65	5.74	45800.0
2010-08-09	ABT	Stock	24.2923	24.4458	24.1963	24.4122	9375573.0
2010-08-09	ABTL-DELISTED	Stock	5.25	5.45	4.95	5.25	6538.0
2010-08-09	ABV-DELISTED	Stock	105.91	106.95	105.8	106.05	461836.0
2010-08-09	ABVA-DELISTED	Stock	2.96	2.96	2.96	2.96	100.0
2010-08-09	ABVT-DELISTED	Stock	54.21	54.88	53.57	53.84	117503.0

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

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