PREVIEW / stock_daily / 2011-10-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-27.parquet
  size:    197 KB
  rows:    6,169
  symbols: 3,575

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-27	AAPL	Stock	14.5557	14.6071	14.3532	14.4532	494664800.0
2011-10-27	MSFT	Stock	27.13	27.4	26.65	27.25	74512400.0
2011-10-27	NVDA	Stock	0.379	0.385	0.3705	0.3813	577732000.0
2011-10-27	AMZN	Stock	10.213	10.43	10.055	10.339	215486000.0
2011-10-27	TSLA	Stock	1.8893	1.93	1.874	1.9173	13041000.0
2011-10-27	TLT	Stock	112.521	112.85	109.82	110.3	19390535.0
2011-10-27	ES	Stock	34.77	35.16	34.49	34.93	2469000.0
2011-10-27	CL	Stock	45.77	45.895	43.21	45.665	10546400.0
2011-10-27	A	Stock	27.0386	28.8984	26.5093	28.6123	12472816.0
2011-10-27	AABA-DELISTED	Stock	16.58	16.7	16.45	16.64	19426851.0
2011-10-27	AACC-DELISTED	Stock	3.1	3.1	3.01	3.02	11364.0
2011-10-27	AACG	Stock	9.5	9.5	9.0	9.0	3400.0
2011-10-27	AAIC-DELISTED	Stock	24.99	24.99	24.01	24.47	118205.0
2011-10-27	AAME	Stock	1.89	1.94	1.62	1.89	4100.0
2011-10-27	AAON	Stock	6.0919	6.8089	6.0919	6.7556	427950.0
2011-10-27	AAP	Stock	65.07	66.61	64.82	65.99	887700.0
2011-10-27	AAT	Stock	20.52	21.19	20.29	20.84	233200.0
2011-10-27	AATI-DELISTED	Stock	4.46	4.51	4.42	4.5	752845.0
2011-10-27	AAU-DELISTED	Stock	2.89	2.94	2.8107	2.88	166901.0
2011-10-27	AAUAF-DELISTED	Stock	2.89	2.94	2.8107	2.88	167501.0
2011-10-27	AAV-DELISTED	Stock	5.35	5.5	5.3	5.39	530813.0
2011-10-27	AAWW-DELISTED	Stock	40.82	43.45	40.01	42.74	232995.0
2011-10-27	AAXJ	Stock	54.99	56.63	54.8501	56.23	648181.0
2011-10-27	AAXN-DELISTED	Stock	4.96	5.02	4.92	5.02	783598.0
2011-10-27	AB	Stock	14.49	15.05	14.17	14.59	504500.0
2011-10-27	ABAC-DELISTED	Stock	1.52	1.75	1.47	1.72	58230.0
2011-10-27	ABAX-DELISTED	Stock	28.69	29.0	28.06	28.38	280916.0
2011-10-27	ABB-DELISTED	Stock	20.08	20.54	19.93	20.38	3280522.0
2011-10-27	ABBNY-DELISTED	Stock	20.08	20.54	19.93	20.38	3300909.0
2011-10-27	ABC-DELISTED	Stock	40.95	42.15	40.95	41.97	2948982.0
2011-10-27	ABCB	Stock	10.29	10.6	10.08	10.6	180100.0
2011-10-27	ABCD-DELISTED	Stock	3.2	3.65	3.14	3.62	112470.0
2011-10-27	ABCO-DELISTED	Stock	31.25	31.43	31.01	31.29	524854.0
2011-10-27	ABCW-DELISTED	Stock	0.53	0.53	0.49	0.53	42540.0
2011-10-27	ABD-DELISTED	Stock	6.99	7.25	6.79	7.07	652080.0
2011-10-27	ABE-DELISTED	Stock	18.22	18.52	17.98	18.42	16998.0
2011-10-27	ABEO	Stock	2075.0	2187.5	1912.5	2187.5	26.0
2011-10-27	ABFS-DELISTED	Stock	20.58	21.09	20.36	20.84	1391632.0
2011-10-27	ABG	Stock	19.86	20.19	19.39	19.53	702100.0
2011-10-27	ABH-DELISTED	Stock	16.47	17.13	16.11	16.88	404442.0
2011-10-27	ABM	Stock	20.84	21.52	20.68	21.4	504600.0
2011-10-27	ABMD-DELISTED	Stock	14.31	15.55	13.3	15.13	506931.0
2011-10-27	ABR	Stock	3.64	3.72	3.55	3.57	69300.0
2011-10-27	ABT	Stock	25.9668	26.0531	25.7461	25.9716	21076907.0
2011-10-27	ABTL-DELISTED	Stock	4.55	4.55	4.3	4.55	17165.0
2011-10-27	ABUS	Stock	1.7	1.7	1.61	1.7	11900.0
2011-10-27	ABV-DELISTED	Stock	34.63	34.79	33.71	33.86	5437233.0
2011-10-27	ABVA-DELISTED	Stock	5.38	5.6	5.29	5.579	83122.0
2011-10-27	ABVT-DELISTED	Stock	60.38	60.38	58.76	59.65	205591.0
2011-10-27	ABX-DELISTED	Stock	48.64	49.54	47.69	48.96	13879020.0

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

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