PREVIEW / stock_daily / 2010-09-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-23.parquet
  size:    190 KB
  rows:    5,923
  symbols: 3,479

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-09-23	AAPL	Stock	10.2261	10.4557	10.2143	10.3186	786116800.0
2010-09-23	MSFT	Stock	24.51	24.59	24.36	24.43	46201800.0
2010-09-23	NVDA	Stock	0.288	0.2995	0.2855	0.2905	1240872000.0
2010-09-23	AMZN	Stock	7.56	7.796	7.5485	7.6425	141312000.0
2010-09-23	TSLA	Stock	1.326	1.3427	1.3	1.304	10021500.0
2010-09-23	TLT	Stock	105.41	105.455	104.24	104.912	7412180.0
2010-09-23	ES	Stock	29.15	29.23	28.93	28.98	1557600.0
2010-09-23	CL	Stock	38.97	39.215	38.82	39.03	5026800.0
2010-09-23	A	Stock	21.8097	22.1102	21.7096	21.8598	3913841.0
2010-09-23	AABA-DELISTED	Stock	13.92	14.24	13.92	14.17	16712649.0
2010-09-23	AACC-DELISTED	Stock	4.45	4.5112	4.45	4.5	22492.0
2010-09-23	AACG	Stock	2.99	2.99	2.9	2.9	18600.0
2010-09-23	AAI-DELISTED	Stock	4.37	4.51	4.34	4.4	1169212.0
2010-09-23	AAIC-DELISTED	Stock	23.6	23.6	22.66	22.91	54740.0
2010-09-23	AAME	Stock	1.82	1.82	1.82	1.82	100.0
2010-09-23	AAON	Stock	4.4958	4.5946	4.4602	4.5215	226800.0
2010-09-23	AAP	Stock	59.61	60.21	58.86	58.86	981600.0
2010-09-23	AATI-DELISTED	Stock	3.36	3.5	3.3	3.42	163586.0
2010-09-23	AAU-DELISTED	Stock	2.64	2.85	2.63	2.73	305272.0
2010-09-23	AAUAF-DELISTED	Stock	2.64	2.85	2.63	2.73	304972.0
2010-09-23	AAV-DELISTED	Stock	6.02	6.09	5.97	5.97	364353.0
2010-09-23	AAWW-DELISTED	Stock	55.2	55.81	53.45	54.03	259288.0
2010-09-23	AAXJ	Stock	58.81	59.12	58.56	58.66	184050.0
2010-09-23	AAXN-DELISTED	Stock	3.9	3.99	3.86	3.86	272368.0
2010-09-23	AB	Stock	25.52	25.74	25.1	25.11	218400.0
2010-09-23	ABAC-DELISTED	Stock	3.7801	3.83	3.65	3.8	8200.0
2010-09-23	ABAX-DELISTED	Stock	21.47	21.93	21.192	21.86	90399.0
2010-09-23	ABB-DELISTED	Stock	20.68	20.84	20.58	20.61	792217.0
2010-09-23	ABBC-DELISTED	Stock	10.3	10.37	10.0	10.03	61057.0
2010-09-23	ABBNY-DELISTED	Stock	20.68	20.84	20.58	20.64	811939.0
2010-09-23	ABC-DELISTED	Stock	30.24	30.91	30.05	30.33	3442601.0
2010-09-23	ABCB	Stock	8.71	9.07	8.6	8.77	87300.0
2010-09-23	ABCD-DELISTED	Stock	3.16	3.32	3.16	3.21	32981.0
2010-09-23	ABCO-DELISTED	Stock	21.27	21.41	21.26	21.28	102094.0
2010-09-23	ABCW-DELISTED	Stock	0.68	0.72	0.68	0.68	51840.0
2010-09-23	ABD-DELISTED	Stock	5.74	5.9705	5.47	5.53	364670.0
2010-09-23	ABE-DELISTED	Stock	17.9	18.069	17.84	17.92	10254.0
2010-09-23	ABEO	Stock	2650.0	2775.0	2625.0	2750.0	19.0
2010-09-23	ABFS-DELISTED	Stock	23.39	23.73	22.8	22.87	265605.0
2010-09-23	ABG	Stock	12.44	12.88	12.42	12.69	181200.0
2010-09-23	ABII-DELISTED	Stock	75.62	76.37	75.62	76.27	68230.0
2010-09-23	ABK-DELISTED	Stock	0.54	0.585	0.5325	0.544	6562158.0
2010-09-23	ABM	Stock	21.6	21.83	21.41	21.46	250000.0
2010-09-23	ABMD-DELISTED	Stock	10.41	10.47	10.15	10.17	144654.0
2010-09-23	ABR	Stock	4.94	4.97	4.85	4.88	66300.0
2010-09-23	ABT	Stock	24.7337	24.916	24.7097	24.7577	8975823.0
2010-09-23	ABTL-DELISTED	Stock	4.1488	4.3006	4.1488	4.25	12618.0
2010-09-23	ABV-DELISTED	Stock	120.35	122.39	119.85	120.55	417690.0
2010-09-23	ABVA-DELISTED	Stock	2.81	3.17	2.81	2.97	1700.0
2010-09-23	ABVT-DELISTED	Stock	51.75	52.85	51.64	52.26	74577.0

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

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