PREVIEW / stock_daily / 2010-08-17

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-17.parquet
  size:    190 KB
  rows:    5,951
  symbols: 3,493

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-17	AAPL	Stock	8.9314	9.0939	8.9	8.9989	422640400.0
2010-08-17	MSFT	Stock	24.71	24.96	24.6	24.71	52912600.0
2010-08-17	NVDA	Stock	0.231	0.236	0.2288	0.2318	481224000.0
2010-08-17	AMZN	Stock	6.367	6.499	6.3395	6.443	100894000.0
2010-08-17	TSLA	Stock	1.264	1.2933	1.252	1.2767	6718500.0
2010-08-17	TLT	Stock	104.85	104.8599	104.0	104.25	6756766.0
2010-08-17	ES	Stock	29.05	29.41	28.77	29.24	1146300.0
2010-08-17	CL	Stock	38.22	38.39	38.0	38.225	3880600.0
2010-08-17	A	Stock	20.5651	21.123	20.329	20.9442	10206518.0
2010-08-17	AABA-DELISTED	Stock	13.84	14.0	13.75	13.93	13242061.0
2010-08-17	AACC-DELISTED	Stock	4.17	4.33	3.99	4.11	110584.0
2010-08-17	AACG	Stock	2.93	2.95	2.9	2.93	3200.0
2010-08-17	AAI-DELISTED	Stock	4.64	4.7	4.56	4.67	1239287.0
2010-08-17	AAIC-DELISTED	Stock	19.99	20.74	19.72	20.44	36465.0
2010-08-17	AAON	Stock	4.4227	4.5412	4.4227	4.4899	180731.0
2010-08-17	AAP	Stock	54.37	54.94	54.12	54.5	1200500.0
2010-08-17	AATI-DELISTED	Stock	3.25	3.33	3.14	3.25	93843.0
2010-08-17	AAU-DELISTED	Stock	1.73	1.8099	1.7	1.7	389465.0
2010-08-17	AAUAF-DELISTED	Stock	1.73	1.8099	1.7	1.7	391480.0
2010-08-17	AAV-DELISTED	Stock	6.05	6.39	6.041	6.23	537314.0
2010-08-17	AAWW-DELISTED	Stock	46.41	47.83	45.04	47.03	352464.0
2010-08-17	AAXJ	Stock	55.63	56.02	55.53	55.61	659374.0
2010-08-17	AAXN-DELISTED	Stock	4.0	4.06	3.96	4.06	277110.0
2010-08-17	AB	Stock	25.58	26.09	25.57	25.7	381600.0
2010-08-17	ABAC-DELISTED	Stock	4.2	4.2001	4.01	4.17	25575.0
2010-08-17	ABAX-DELISTED	Stock	19.87	20.0	19.7	19.93	114961.0
2010-08-17	ABB-DELISTED	Stock	19.61	19.85	19.54	19.7	1651817.0
2010-08-17	ABBC-DELISTED	Stock	9.66	9.9	9.61	9.86	47205.0
2010-08-17	ABBNY-DELISTED	Stock	19.61	19.85	19.54	19.67	1656521.0
2010-08-17	ABC-DELISTED	Stock	28.95	29.56	28.73	29.48	2801694.0
2010-08-17	ABCB	Stock	8.75	9.05	8.7	8.94	106000.0
2010-08-17	ABCD-DELISTED	Stock	3.25	3.26	3.17	3.22	28045.0
2010-08-17	ABCO-DELISTED	Stock	21.43	21.92	21.23	21.85	209942.0
2010-08-17	ABCW-DELISTED	Stock	0.63	0.63	0.6202	0.63	22280.0
2010-08-17	ABD-DELISTED	Stock	6.11	6.3924	6.11	6.32	663030.0
2010-08-17	ABE-DELISTED	Stock	17.27	17.4599	17.27	17.41	7906.0
2010-08-17	ABEO	Stock	2375.0	2375.0	2225.0	2312.5	30.0
2010-08-17	ABFS-DELISTED	Stock	20.0	20.44	19.98	20.24	174967.0
2010-08-17	ABG	Stock	12.96	13.29	12.79	13.04	236600.0
2010-08-17	ABII-DELISTED	Stock	75.73	75.73	75.19	75.27	63878.0
2010-08-17	ABK-DELISTED	Stock	0.6794	0.6794	0.6201	0.63	13859222.0
2010-08-17	ABM	Stock	20.63	21.05	20.45	20.75	194800.0
2010-08-17	ABMD-DELISTED	Stock	9.91	10.01	9.75	9.82	141574.0
2010-08-17	ABR	Stock	5.04	5.11	5.0	5.01	43000.0
2010-08-17	ABT	Stock	24.2299	24.417	24.11	24.3211	12592330.0
2010-08-17	ABTL-DELISTED	Stock	4.55	5.0005	4.4345	4.6	30386.0
2010-08-17	ABV-DELISTED	Stock	108.28	110.35	107.69	109.37	870833.0
2010-08-17	ABVT-DELISTED	Stock	50.94	51.82	50.87	51.67	164412.0
2010-08-17	ABX-DELISTED	Stock	44.07	44.48	43.53	44.37	6560989.0
2010-08-17	ACAD	Stock	1.05	1.08	0.99	1.01	564700.0

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

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