PREVIEW / stock_daily / 2011-10-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-21.parquet
  size:    194 KB
  rows:    6,075
  symbols: 3,512

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-21	AAPL	Stock	14.2179	14.255	13.9554	14.0311	621244400.0
2011-10-21	MSFT	Stock	27.15	27.19	26.8	27.16	76620600.0
2011-10-21	NVDA	Stock	0.3648	0.3708	0.356	0.362	628428000.0
2011-10-21	AMZN	Stock	11.8455	11.85	11.53	11.739	91450000.0
2011-10-21	TSLA	Stock	1.8267	1.8867	1.8007	1.8687	17139000.0
2011-10-21	TLT	Stock	113.86	114.2	113.13	113.13	9906282.0
2011-10-21	ES	Stock	33.75	33.92	33.48	33.76	1715700.0
2011-10-21	CL	Stock	45.925	46.96	45.855	46.96	6095600.0
2011-10-21	A	Stock	24.5207	25.3505	24.4707	25.2289	6025660.0
2011-10-21	AABA-DELISTED	Stock	16.38	16.39	16.055	16.12	29297632.0
2011-10-21	AACC-DELISTED	Stock	3.07	3.15	3.05	3.05	19100.0
2011-10-21	AACG	Stock	8.73	9.02	8.73	8.95	45400.0
2011-10-21	AAIC-DELISTED	Stock	24.55	24.6	24.0	24.45	56529.0
2011-10-21	AAME	Stock	1.79	1.88	1.77	1.88	2500.0
2011-10-21	AAON	Stock	5.68	5.7274	5.5793	5.6978	178538.0
2011-10-21	AAP	Stock	63.0	63.42	62.47	62.92	434500.0
2011-10-21	AAT	Stock	19.0	19.66	19.0	19.35	385500.0
2011-10-21	AATI-DELISTED	Stock	4.47	4.47	4.39	4.46	199869.0
2011-10-21	AAU-DELISTED	Stock	2.4	2.44	2.35	2.4	173988.0
2011-10-21	AAUAF-DELISTED	Stock	2.4	2.44	2.35	2.4	174288.0
2011-10-21	AAV-DELISTED	Stock	4.77	4.91	4.65	4.91	379055.0
2011-10-21	AAWW-DELISTED	Stock	34.8	36.95	34.4	36.56	291108.0
2011-10-21	AAXJ	Stock	50.68	51.31	50.6	51.25	480312.0
2011-10-21	AAXN-DELISTED	Stock	4.74	4.81	4.68	4.79	396993.0
2011-10-21	AB	Stock	14.3	14.44	13.89	14.34	324200.0
2011-10-21	ABAC-DELISTED	Stock	1.36	1.45	1.36	1.38	22900.0
2011-10-21	ABAX-DELISTED	Stock	24.12	24.58	23.981	24.56	121184.0
2011-10-21	ABB-DELISTED	Stock	18.8	19.09	18.76	19.09	1435006.0
2011-10-21	ABBNY-DELISTED	Stock	18.8	19.09	18.76	19.08	1435006.0
2011-10-21	ABC-DELISTED	Stock	39.17	39.72	39.05	39.71	1615158.0
2011-10-21	ABCB	Stock	9.64	9.64	9.49	9.6	113500.0
2011-10-21	ABCD-DELISTED	Stock	3.03	3.11	2.97	3.11	38327.0
2011-10-21	ABCO-DELISTED	Stock	31.92	31.92	30.86	31.2	281545.0
2011-10-21	ABCW-DELISTED	Stock	0.4894	0.5471	0.4894	0.4906	27150.0
2011-10-21	ABD-DELISTED	Stock	5.555	5.6851	5.3948	5.665	383170.0
2011-10-21	ABE-DELISTED	Stock	17.5	17.64	17.5	17.64	4388.0
2011-10-21	ABEO	Stock	2162.5	2162.5	2100.0	2162.5	4.0
2011-10-21	ABFS-DELISTED	Stock	18.6	18.67	18.24	18.47	362630.0
2011-10-21	ABG	Stock	19.82	20.12	19.43	19.65	395200.0
2011-10-21	ABH-DELISTED	Stock	15.39	15.5	14.99	15.1	567364.0
2011-10-21	ABM	Stock	19.7	19.88	19.03	19.86	324100.0
2011-10-21	ABMD-DELISTED	Stock	11.95	11.9592	11.64	11.7	178400.0
2011-10-21	ABR	Stock	3.36	3.53	3.36	3.51	38700.0
2011-10-21	ABT	Stock	26.1875	26.2211	25.7221	25.842	27857024.0
2011-10-21	ABTL-DELISTED	Stock	4.4	4.5	4.25	4.4	20361.0
2011-10-21	ABUS	Stock	1.61	1.75	1.6	1.75	2600.0
2011-10-21	ABV-DELISTED	Stock	33.72	34.11	33.46	33.5	3044351.0
2011-10-21	ABVA-DELISTED	Stock	5.09	5.1	4.96	5.04	11600.0
2011-10-21	ABVT-DELISTED	Stock	56.85	57.41	56.38	57.38	103926.0
2011-10-21	ABX-DELISTED	Stock	45.55	45.55	44.08	44.57	7349247.0

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

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