PREVIEW / stock_daily / 2011-10-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-18.parquet
  size:    194 KB
  rows:    6,102
  symbols: 3,540

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-18	AAPL	Stock	15.0629	15.1718	14.8568	15.08	881602400.0
2011-10-18	MSFT	Stock	26.94	27.4	26.8	27.31	52487900.0
2011-10-18	NVDA	Stock	0.3715	0.388	0.3692	0.387	590916000.0
2011-10-18	AMZN	Stock	12.1155	12.2305	11.831	12.194	92194000.0
2011-10-18	TSLA	Stock	1.82	1.8953	1.7807	1.8893	14995500.0
2011-10-18	TLT	Stock	116.14	116.818	114.3	115.2	12495570.0
2011-10-18	ES	Stock	32.93	33.5	32.65	33.33	1698300.0
2011-10-18	CL	Stock	45.3	46.41	45.185	46.17	4034200.0
2011-10-18	A	Stock	23.6266	24.1202	22.99	23.9485	8460137.0
2011-10-18	AABA-DELISTED	Stock	15.72	15.74	15.11	15.45	29495002.0
2011-10-18	AACC-DELISTED	Stock	3.1	3.1	3.1	3.1	2492.0
2011-10-18	AACG	Stock	9.0	9.0	8.79	8.94	3200.0
2011-10-18	AAIC-DELISTED	Stock	24.35	25.04	24.05	24.8	45574.0
2011-10-18	AAME	Stock	1.85	1.86	1.7	1.83	2400.0
2011-10-18	AAON	Stock	5.5556	5.8904	5.4815	5.8548	245025.0
2011-10-18	AAP	Stock	59.83	61.93	59.48	61.58	1094500.0
2011-10-18	AAT	Stock	18.39	19.18	18.19	18.94	115200.0
2011-10-18	AATI-DELISTED	Stock	4.41	4.53	4.38	4.5	347372.0
2011-10-18	AAU-DELISTED	Stock	2.41	2.5	2.29	2.44	292119.0
2011-10-18	AAUAF-DELISTED	Stock	2.44	2.52	2.32	2.44	289077.0
2011-10-18	AAV-DELISTED	Stock	4.56	4.88	4.5	4.83	899292.0
2011-10-18	AAWW-DELISTED	Stock	34.97	36.38	34.31	35.59	245974.0
2011-10-18	AAXJ	Stock	50.36	51.67	49.81	51.48	450567.0
2011-10-18	AAXN-DELISTED	Stock	4.52	4.73	4.47	4.7	294371.0
2011-10-18	AB	Stock	14.1	14.84	14.07	14.62	341800.0
2011-10-18	ABAC-DELISTED	Stock	1.5901	1.64	1.53	1.5522	6389.0
2011-10-18	ABAX-DELISTED	Stock	22.66	23.46	22.1	23.22	202071.0
2011-10-18	ABB-DELISTED	Stock	18.95	19.49	18.7	19.3	2381825.0
2011-10-18	ABBNY-DELISTED	Stock	18.95	19.49	18.7	19.28	2384163.0
2011-10-18	ABC-DELISTED	Stock	37.81	38.69	37.4	38.34	1624743.0
2011-10-18	ABCB	Stock	9.16	9.82	9.16	9.6	96400.0
2011-10-18	ABCD-DELISTED	Stock	2.98	3.07	2.95	3.03	67552.0
2011-10-18	ABCO-DELISTED	Stock	32.0	33.28	31.97	33.05	161106.0
2011-10-18	ABCW-DELISTED	Stock	0.4913	0.4987	0.4888	0.4987	21900.0
2011-10-18	ABD-DELISTED	Stock	5.42	5.74	5.33	5.66	251510.0
2011-10-18	ABE-DELISTED	Stock	17.3	17.59	17.3	17.34	2419.0
2011-10-18	ABEO	Stock	2175.0	2187.5	2050.0	2187.5	14.0
2011-10-18	ABFS-DELISTED	Stock	17.43	18.39	17.29	18.24	305952.0
2011-10-18	ABG	Stock	18.87	19.77	18.38	19.61	459600.0
2011-10-18	ABH-DELISTED	Stock	15.3	15.77	15.13	15.49	380683.0
2011-10-18	ABM	Stock	19.52	20.1	19.21	20.02	305700.0
2011-10-18	ABMD-DELISTED	Stock	11.8	11.95	11.61	11.84	149574.0
2011-10-18	ABR	Stock	3.28	3.38	3.26	3.34	83400.0
2011-10-18	ABT	Stock	24.9256	25.3382	24.7241	25.1607	15050229.0
2011-10-18	ABTL-DELISTED	Stock	4.5	4.5	4.3977	4.5	3148.0
2011-10-18	ABUS	Stock	1.78	1.78	1.68	1.74	6900.0
2011-10-18	ABV-DELISTED	Stock	32.75	33.65	32.64	33.47	2383870.0
2011-10-18	ABVA-DELISTED	Stock	4.83	5.12	4.83	5.12	33999.0
2011-10-18	ABVT-DELISTED	Stock	58.29	58.86	56.99	58.45	234886.0
2011-10-18	ABX-DELISTED	Stock	46.44	47.42	45.3	47.11	8513853.0

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

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