PREVIEW / stock_daily / 2011-11-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-15.parquet
  size:    196 KB
  rows:    6,121
  symbols: 3,548

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-11-15	AAPL	Stock	13.6	13.9107	13.5518	13.8868	430810800.0
2011-11-15	MSFT	Stock	26.56	26.94	26.4	26.74	43874200.0
2011-11-15	NVDA	Stock	0.3638	0.3748	0.3628	0.372	505660000.0
2011-11-15	AMZN	Stock	10.9	11.0165	10.713	10.8915	114780000.0
2011-11-15	TSLA	Stock	2.1947	2.2933	2.182	2.262	13365000.0
2011-11-15	TLT	Stock	117.695	118.46	116.72	117.35	7587448.0
2011-11-15	ES	Stock	34.84	34.99	34.53	34.89	2022400.0
2011-11-15	CL	Stock	44.38	44.555	44.185	44.395	4131400.0
2011-11-15	A	Stock	27.1531	27.5894	26.6166	27.3605	5856641.0
2011-11-15	AABA-DELISTED	Stock	15.93	16.05	15.7	15.93	17515314.0
2011-11-15	AACC-DELISTED	Stock	2.83	3.08	2.83	3.0	11763.0
2011-11-15	AACG	Stock	9.75	9.85	9.75	9.85	5500.0
2011-11-15	AAIC-DELISTED	Stock	21.54	22.46	21.34	22.41	36079.0
2011-11-15	AAME	Stock	1.8	2.0	1.8	2.0	29500.0
2011-11-15	AAON	Stock	6.317	6.5274	6.317	6.5007	186975.0
2011-11-15	AAP	Stock	68.12	69.0	67.69	68.45	797500.0
2011-11-15	AAT	Stock	19.78	20.86	19.72	20.36	177700.0
2011-11-15	AATI-DELISTED	Stock	4.16	4.23	4.15	4.23	261304.0
2011-11-15	AAU-DELISTED	Stock	2.75	2.78	2.66	2.74	127096.0
2011-11-15	AAUAF-DELISTED	Stock	2.75	2.78	2.66	2.74	127796.0
2011-11-15	AAV-DELISTED	Stock	5.09	5.35	5.09	5.31	353361.0
2011-11-15	AAWW-DELISTED	Stock	37.19	39.51	37.19	39.23	274378.0
2011-11-15	AAXJ	Stock	53.01	53.51	52.65	53.27	417438.0
2011-11-15	AAXN-DELISTED	Stock	5.66	5.83	5.62	5.79	260531.0
2011-11-15	AB	Stock	13.13	13.44	13.08	13.37	391800.0
2011-11-15	ABAC-DELISTED	Stock	2.15	2.15	1.91	1.96	35500.0
2011-11-15	ABAX-DELISTED	Stock	26.53	27.93	26.53	27.73	113412.0
2011-11-15	ABB-DELISTED	Stock	18.53	18.67	18.23	18.6	2270234.0
2011-11-15	ABBNY-DELISTED	Stock	18.53	18.67	18.23	18.61	2270034.0
2011-11-15	ABC-DELISTED	Stock	38.99	39.46	38.7	39.33	1887959.0
2011-11-15	ABCB	Stock	10.05	10.29	10.05	10.14	37900.0
2011-11-15	ABCD-DELISTED	Stock	3.14	3.16	3.01	3.145	35453.0
2011-11-15	ABCO-DELISTED	Stock	35.04	35.95	34.79	35.62	192209.0
2011-11-15	ABCW-DELISTED	Stock	0.4661	0.4855	0.457	0.47	28240.0
2011-11-15	ABD-DELISTED	Stock	6.96	7.302	6.88	7.23	157200.0
2011-11-15	ABE-DELISTED	Stock	18.18	18.27	18.03	18.2	1980.0
2011-11-15	ABEO	Stock	1650.0	1687.5	1587.5	1675.0	63.0
2011-11-15	ABFS-DELISTED	Stock	20.68	21.37	20.5917	21.26	367875.0
2011-11-15	ABG	Stock	18.64	19.27	18.63	19.19	863600.0
2011-11-15	ABH-DELISTED	Stock	15.52	15.63	15.17	15.52	197857.0
2011-11-15	ABM	Stock	20.04	20.97	20.04	20.82	208400.0
2011-11-15	ABMD-DELISTED	Stock	18.52	19.47	18.42	19.35	396541.0
2011-11-15	ABR	Stock	3.68	3.73	3.66	3.7	19600.0
2011-11-15	ABT	Stock	26.1203	26.2834	25.9668	26.1491	13053981.0
2011-11-15	ABTL-DELISTED	Stock	4.1375	4.2128	4.0117	4.1125	65071.0
2011-11-15	ABUS	Stock	1.65	1.65	1.65	1.65	7000.0
2011-11-15	ABV-DELISTED	Stock	33.52	33.97	33.23	33.92	1827109.0
2011-11-15	ABVA-DELISTED	Stock	5.15	5.2	5.15	5.2	13931.0
2011-11-15	ABVT-DELISTED	Stock	59.39	60.16	59.0	59.77	105103.0
2011-11-15	ABX-DELISTED	Stock	52.04	52.63	51.62	52.3	4351241.0

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

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