PREVIEW / stock_daily / 2010-08-27

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-27.parquet
  size:    189 KB
  rows:    5,939
  symbols: 3,482

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-27	AAPL	Stock	8.6339	8.6646	8.4129	8.6293	548391200.0
2010-08-27	MSFT	Stock	23.88	24.02	23.51	23.93	60939400.0
2010-08-27	NVDA	Stock	0.2465	0.255	0.2402	0.253	1060416000.0
2010-08-27	AMZN	Stock	6.273	6.332	6.1125	6.332	101600000.0
2010-08-27	TSLA	Stock	1.3167	1.3247	1.3	1.3133	5694000.0
2010-08-27	TLT	Stock	107.77	108.33	105.2	105.35	13514371.0
2010-08-27	ES	Stock	28.7	29.26	28.47	29.22	1937000.0
2010-08-27	CL	Stock	37.09	37.235	36.56	37.125	6941600.0
2010-08-27	A	Stock	19.8069	20.0644	19.3348	20.0	4677708.0
2010-08-27	AABA-DELISTED	Stock	13.24	13.47	13.03	13.4265	12681230.0
2010-08-27	AACC-DELISTED	Stock	3.99	4.12	3.77	4.1	38722.0
2010-08-27	AACG	Stock	2.9	2.9	2.9	2.9	15300.0
2010-08-27	AAI-DELISTED	Stock	4.5	4.56	4.38	4.54	1122120.0
2010-08-27	AAIC-DELISTED	Stock	19.4	19.73	19.21	19.4	117398.0
2010-08-27	AAON	Stock	4.2548	4.3911	4.1956	4.3793	192881.0
2010-08-27	AAP	Stock	55.02	55.94	54.24	55.58	954600.0
2010-08-27	AATI-DELISTED	Stock	3.47	3.5	3.36	3.5	90091.0
2010-08-27	AAU-DELISTED	Stock	2.08	2.101	1.9589	2.03	393183.0
2010-08-27	AAUAF-DELISTED	Stock	2.05	2.07	1.93	2.03	399520.0
2010-08-27	AAV-DELISTED	Stock	5.86	5.93	5.73	5.89	287753.0
2010-08-27	AAWW-DELISTED	Stock	45.61	46.66	44.74	45.38	440381.0
2010-08-27	AAXJ	Stock	54.76	55.28	54.16	55.25	731416.0
2010-08-27	AAXN-DELISTED	Stock	3.63	3.72	3.5801	3.72	351415.0
2010-08-27	AB	Stock	24.22	24.75	23.88	24.63	279900.0
2010-08-27	ABAC-DELISTED	Stock	3.8099	3.9	3.8054	3.9	6400.0
2010-08-27	ABAX-DELISTED	Stock	18.5	18.86	18.05	18.84	55129.0
2010-08-27	ABB-DELISTED	Stock	19.21	19.31	18.88	19.3	1690943.0
2010-08-27	ABBC-DELISTED	Stock	9.97	10.19	9.94	10.17	132622.0
2010-08-27	ABBNY-DELISTED	Stock	19.21	19.31	18.88	19.3	1955671.0
2010-08-27	ABC-DELISTED	Stock	27.72	27.75	27.08	27.701	3012162.0
2010-08-27	ABCB	Stock	8.15	8.42	8.03	8.38	59400.0
2010-08-27	ABCD-DELISTED	Stock	2.99	3.04	2.97	3.03	34716.0
2010-08-27	ABCO-DELISTED	Stock	20.62	20.62	20.46	20.5	268552.0
2010-08-27	ABCW-DELISTED	Stock	0.62	0.64	0.62	0.63	43030.0
2010-08-27	ABD-DELISTED	Stock	5.76	5.88	5.57	5.88	280680.0
2010-08-27	ABE-DELISTED	Stock	16.85	17.17	16.85	17.08	21464.0
2010-08-27	ABEO	Stock	2437.5	2625.0	2437.5	2625.0	13.0
2010-08-27	ABFS-DELISTED	Stock	20.87	21.34	20.42	21.29	268622.0
2010-08-27	ABG	Stock	12.2	12.5	11.75	12.49	186600.0
2010-08-27	ABII-DELISTED	Stock	74.03	74.22	73.75	74.11	89801.0
2010-08-27	ABK-DELISTED	Stock	0.51	0.5381	0.48	0.5059	8904022.0
2010-08-27	ABM	Stock	19.8	20.26	19.75	20.24	272000.0
2010-08-27	ABMD-DELISTED	Stock	9.08	9.27	8.91	9.14	214122.0
2010-08-27	ABR	Stock	4.54	4.95	4.54	4.79	62900.0
2010-08-27	ABT	Stock	23.7789	23.942	23.515	23.9132	9445394.0
2010-08-27	ABTL-DELISTED	Stock	4.5011	4.5728	4.3584	4.45	7677.0
2010-08-27	ABV-DELISTED	Stock	107.67	108.62	106.99	108.58	445953.0
2010-08-27	ABVT-DELISTED	Stock	50.81	51.47	49.925	51.21	61705.0
2010-08-27	ABX-DELISTED	Stock	45.8	46.54	45.41	46.5	9105081.0
2010-08-27	ACAD	Stock	1.01	1.03	1.0	1.03	243800.0

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

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