PREVIEW / stock_daily / 2011-10-17

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-17.parquet
  size:    193 KB
  rows:    6,056
  symbols: 3,498

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
2011-10-17	AAPL	Stock	15.0621	15.2393	14.855	14.9996	686044800.0
2011-10-17	MSFT	Stock	27.11	27.42	26.85	26.98	39453300.0
2011-10-17	NVDA	Stock	0.3885	0.3885	0.3715	0.3735	611780000.0
2011-10-17	AMZN	Stock	12.2145	12.3355	12.0335	12.1165	95580000.0
2011-10-17	TSLA	Stock	1.8573	1.8667	1.8173	1.828	11317500.0
2011-10-17	TLT	Stock	114.3	115.97	114.22	115.92	9668809.0
2011-10-17	ES	Stock	33.29	33.39	32.84	32.88	1578500.0
2011-10-17	CL	Stock	45.95	46.29	45.415	45.47	3115600.0
2011-10-17	A	Stock	23.6195	23.9342	23.4335	23.6552	6988882.0
2011-10-17	AABA-DELISTED	Stock	15.96	16.04	15.65	15.7	21027810.0
2011-10-17	AACC-DELISTED	Stock	3.1	3.13	3.06	3.1	41141.0
2011-10-17	AACG	Stock	8.63	8.9	8.6	8.9	2700.0
2011-10-17	AAIC-DELISTED	Stock	24.71	24.83	24.24	24.25	37880.0
2011-10-17	AAME	Stock	1.8	1.8	1.79	1.8	500.0
2011-10-17	AAON	Stock	5.6711	5.7126	5.5378	5.5526	255150.0
2011-10-17	AAP	Stock	60.52	61.23	59.32	59.58	1013600.0
2011-10-17	AAT	Stock	18.5	18.6	18.27	18.33	78800.0
2011-10-17	AATI-DELISTED	Stock	4.47	4.48	4.4	4.41	137457.0
2011-10-17	AAU-DELISTED	Stock	2.56	2.56	2.49	2.49	168100.0
2011-10-17	AAUAF-DELISTED	Stock	2.54	2.54	2.47	2.49	168770.0
2011-10-17	AAV-DELISTED	Stock	4.67	4.75	4.55	4.5999	622050.0
2011-10-17	AAWW-DELISTED	Stock	35.42	36.21	34.56	34.86	197539.0
2011-10-17	AAXJ	Stock	51.98	51.98	50.49	50.54	905829.0
2011-10-17	AAXN-DELISTED	Stock	4.66	4.68	4.49	4.51	330622.0
2011-10-17	AB	Stock	14.3	14.36	13.96	14.12	293400.0
2011-10-17	ABAC-DELISTED	Stock	1.69	1.69	1.54	1.63	19082.0
2011-10-17	ABAX-DELISTED	Stock	23.8	24.5	22.47	22.63	123536.0
2011-10-17	ABB-DELISTED	Stock	19.25	19.28	18.8775	18.97	2765174.0
2011-10-17	ABBNY-DELISTED	Stock	19.25	19.28	18.8775	18.98	2771074.0
2011-10-17	ABC-DELISTED	Stock	37.9	38.25	37.82	37.89	1194318.0
2011-10-17	ABCB	Stock	9.53	9.59	9.02	9.07	53700.0
2011-10-17	ABCD-DELISTED	Stock	3.05	3.05	2.94	2.96	27102.0
2011-10-17	ABCO-DELISTED	Stock	32.28	32.46	31.79	31.9	194089.0
2011-10-17	ABCW-DELISTED	Stock	0.49	0.55	0.49	0.51	7520.0
2011-10-17	ABD-DELISTED	Stock	5.7	5.71	5.3599	5.4	234440.0
2011-10-17	ABE-DELISTED	Stock	17.48	17.53	17.33	17.5	4215.0
2011-10-17	ABEO	Stock	2075.0	2250.0	2025.0	2175.0	5.0
2011-10-17	ABFS-DELISTED	Stock	18.02	18.2608	17.32	17.38	211450.0
2011-10-17	ABG	Stock	19.18	19.59	18.83	18.93	315000.0
2011-10-17	ABH-DELISTED	Stock	15.84	15.91	15.25	15.36	352692.0
2011-10-17	ABM	Stock	20.42	20.59	19.43	19.52	305500.0
2011-10-17	ABMD-DELISTED	Stock	12.22	12.34	11.63	11.77	124385.0
2011-10-17	ABR	Stock	3.27	3.31	3.26	3.28	49300.0
2011-10-17	ABT	Stock	25.1463	25.3095	24.9208	24.9688	13514798.0
2011-10-17	ABTL-DELISTED	Stock	4.3	4.55	4.25	4.45	5028.0
2011-10-17	ABUS	Stock	2.05	2.05	1.74	1.78	4000.0
2011-10-17	ABV-DELISTED	Stock	33.0	33.55	32.64	32.68	2195404.0
2011-10-17	ABVA-DELISTED	Stock	5.1	5.1	4.92	5.0	3368.0
2011-10-17	ABVT-DELISTED	Stock	58.82	59.7	57.53	58.07	107333.0
2011-10-17	ABX-DELISTED	Stock	48.17	48.25	47.03	47.18	3657854.0

> showing 50 of 6,056 rows — these rows as CSV

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