PREVIEW / stock_daily / 2011-10-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-19.parquet
  size:    193 KB
  rows:    6,071
  symbols: 3,508

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-19	AAPL	Stock	14.3339	14.5864	14.2071	14.2364	1104059600.0
2011-10-19	MSFT	Stock	27.37	27.47	27.01	27.13	42880000.0
2011-10-19	NVDA	Stock	0.3875	0.3942	0.3783	0.3793	557568000.0
2011-10-19	AMZN	Stock	12.0335	12.1665	11.4625	11.5765	134302000.0
2011-10-19	TSLA	Stock	1.868	1.8707	1.82	1.838	11893500.0
2011-10-19	TLT	Stock	114.54	115.74	114.16	115.16	6629256.0
2011-10-19	ES	Stock	33.33	33.67	33.2	33.36	1374300.0
2011-10-19	CL	Stock	46.03	46.44	45.975	46.09	3479600.0
2011-10-19	A	Stock	23.8269	24.1845	23.4907	23.598	4883354.0
2011-10-19	AABA-DELISTED	Stock	16.05	16.79	15.73	15.9	53813683.0
2011-10-19	AACC-DELISTED	Stock	3.0	3.1	3.0	3.1	2222.0
2011-10-19	AACG	Stock	9.1	9.16	8.76	8.76	5900.0
2011-10-19	AAIC-DELISTED	Stock	24.79	24.96	24.23	24.28	22252.0
2011-10-19	AAME	Stock	1.81	1.85	1.8	1.82	1300.0
2011-10-19	AAON	Stock	5.8548	5.8874	5.6089	5.6385	191363.0
2011-10-19	AAP	Stock	61.31	62.23	61.11	61.8	1002100.0
2011-10-19	AAT	Stock	18.83	18.85	18.25	18.54	154200.0
2011-10-19	AATI-DELISTED	Stock	4.49	4.49	4.385	4.4	135956.0
2011-10-19	AAU-DELISTED	Stock	2.46	2.5	2.32	2.37	263236.0
2011-10-19	AAUAF-DELISTED	Stock	2.46	2.5	2.32	2.36	264436.0
2011-10-19	AAV-DELISTED	Stock	4.85	4.94	4.7	4.76	520731.0
2011-10-19	AAWW-DELISTED	Stock	35.66	35.69	33.54	34.01	161592.0
2011-10-19	AAXJ	Stock	51.45	51.46	50.89	50.94	9487035.0
2011-10-19	AAXN-DELISTED	Stock	4.67	4.7	4.58	4.61	200209.0
2011-10-19	AB	Stock	14.52	14.69	14.3	14.44	215200.0
2011-10-19	ABAC-DELISTED	Stock	1.55	1.625	1.37	1.45	26800.0
2011-10-19	ABAX-DELISTED	Stock	23.29	24.3876	23.27	23.76	201479.0
2011-10-19	ABB-DELISTED	Stock	18.91	18.95	18.41	18.48	2563962.0
2011-10-19	ABBNY-DELISTED	Stock	18.91	18.95	18.41	18.49	2665662.0
2011-10-19	ABC-DELISTED	Stock	38.41	38.81	38.03	38.21	1710108.0
2011-10-19	ABCB	Stock	9.54	9.72	9.46	9.52	44100.0
2011-10-19	ABCD-DELISTED	Stock	3.03	3.04	2.92	2.95	28996.0
2011-10-19	ABCO-DELISTED	Stock	33.02	33.02	31.84	31.98	156272.0
2011-10-19	ABCW-DELISTED	Stock	0.5	0.5	0.5	0.5	1470.0
2011-10-19	ABD-DELISTED	Stock	5.62	5.73	5.45	5.52	236810.0
2011-10-19	ABE-DELISTED	Stock	17.43	18.03	17.39	17.66	5202.0
2011-10-19	ABEO	Stock	2062.5	2237.5	2062.5	2175.0	14.0
2011-10-19	ABFS-DELISTED	Stock	18.17	18.26	17.29	17.39	200777.0
2011-10-19	ABG	Stock	19.48	19.84	19.18	19.35	334100.0
2011-10-19	ABH-DELISTED	Stock	15.46	15.54	15.03	15.19	247282.0
2011-10-19	ABM	Stock	19.91	20.32	19.6	19.72	146700.0
2011-10-19	ABMD-DELISTED	Stock	11.83	11.97	11.72	11.81	220778.0
2011-10-19	ABR	Stock	3.32	3.36	3.3	3.36	26800.0
2011-10-19	ABT	Stock	26.6433	26.6817	25.4102	25.5494	78108378.0
2011-10-19	ABTL-DELISTED	Stock	4.5	4.5	4.5	4.5	1258.0
2011-10-19	ABUS	Stock	1.61	1.7	1.6	1.7	25800.0
2011-10-19	ABV-DELISTED	Stock	33.61	33.995	33.43	33.52	2616761.0
2011-10-19	ABVA-DELISTED	Stock	5.4	5.4	4.95	5.06	21760.0
2011-10-19	ABVT-DELISTED	Stock	58.14	58.71	56.8	57.14	52206.0
2011-10-19	ABX-DELISTED	Stock	47.39	47.52	44.71	44.86	10947669.0

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

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