PREVIEW / stock_daily / 2011-07-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-28.parquet
  size:    198 KB
  rows:    6,119
  symbols: 3,546

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-07-28	AAPL	Stock	13.9864	14.1782	13.8618	13.9936	594034000.0
2011-07-28	MSFT	Stock	27.29	28.07	27.21	27.72	83761400.0
2011-07-28	NVDA	Stock	0.3453	0.353	0.3398	0.3458	648176000.0
2011-07-28	AMZN	Stock	11.1635	11.2975	11.0115	11.195	107098000.0
2011-07-28	TSLA	Stock	1.84	1.9033	1.836	1.878	14080500.0
2011-07-28	TLT	Stock	96.11	96.31	95.71	96.02	7081715.0
2011-07-28	ES	Stock	34.87	34.91	34.47	34.51	992100.0
2011-07-28	CL	Stock	42.54	43.165	42.32	42.44	5712800.0
2011-07-28	A	Stock	30.3076	30.6009	29.9571	30.1717	10474515.0
2011-07-28	AABA-DELISTED	Stock	13.6	13.71	13.43	13.5	20385004.0
2011-07-28	AACC-DELISTED	Stock	4.49	4.58	4.38	4.51	8985.0
2011-07-28	AACG	Stock	9.31	9.31	9.0	9.15	10800.0
2011-07-28	AAIC-DELISTED	Stock	29.55	29.69	28.05	28.24	215853.0
2011-07-28	AAME	Stock	2.03	2.05	1.9	2.04	6500.0
2011-07-28	AAON	Stock	6.5096	7.0222	6.32	6.5393	152213.0
2011-07-28	AAP	Stock	55.77	55.77	54.54	54.78	1412000.0
2011-07-28	AAT	Stock	21.81	22.45	21.75	22.0	435800.0
2011-07-28	AATI-DELISTED	Stock	6.07	6.08	5.94	6.03	1117307.0
2011-07-28	AAU-DELISTED	Stock	3.42	3.549	3.42	3.52	174553.0
2011-07-28	AAUAF-DELISTED	Stock	3.42	3.549	3.42	3.53	174953.0
2011-07-28	AAV-DELISTED	Stock	7.23	7.31	7.0	7.05	748198.0
2011-07-28	AAWW-DELISTED	Stock	55.24	55.67	53.76	53.81	265771.0
2011-07-28	AAXJ	Stock	62.83	62.88	62.29	62.4	115719.0
2011-07-28	AAXN-DELISTED	Stock	4.1	4.17	4.06	4.13	366211.0
2011-07-28	AB	Stock	17.86	18.13	17.69	17.69	518600.0
2011-07-28	ABAC-DELISTED	Stock	2.56	2.7026	2.53	2.53	28837.0
2011-07-28	ABAX-DELISTED	Stock	27.59	29.06	27.49	27.72	185134.0
2011-07-28	ABB-DELISTED	Stock	23.95	24.15	23.81	23.85	3300819.0
2011-07-28	ABBC-DELISTED	Stock	9.64	9.89	9.556	9.76	52469.0
2011-07-28	ABBNY-DELISTED	Stock	23.95	24.15	23.81	23.83	3735408.0
2011-07-28	ABC-DELISTED	Stock	41.87	42.07	37.64	38.74	10669069.0
2011-07-28	ABCB	Stock	10.06	10.16	10.01	10.08	51300.0
2011-07-28	ABCD-DELISTED	Stock	3.17	3.26	3.17	3.24	12441.0
2011-07-28	ABCO-DELISTED	Stock	26.51	27.43	26.44	27.39	89811.0
2011-07-28	ABCW-DELISTED	Stock	0.66	0.68	0.65	0.68	17360.0
2011-07-28	ABD-DELISTED	Stock	8.31	8.89	8.24	8.42	730920.0
2011-07-28	ABE-DELISTED	Stock	18.87	19.09	18.87	18.95	18398.0
2011-07-28	ABEO	Stock	2612.5	2900.0	2612.5	2875.0	13.0
2011-07-28	ABFS-DELISTED	Stock	24.02	24.66	23.88	23.91	225339.0
2011-07-28	ABG	Stock	20.67	21.99	20.57	21.4	605600.0
2011-07-28	ABH-DELISTED	Stock	18.84	19.01	18.58	18.61	501202.0
2011-07-28	ABM	Stock	22.46	22.8	22.19	22.22	190100.0
2011-07-28	ABMD-DELISTED	Stock	16.04	16.57	15.95	16.5	194478.0
2011-07-28	ABR	Stock	4.24	4.63	4.24	4.47	72800.0
2011-07-28	ABT	Stock	24.8728	25.0072	24.7385	24.7673	10355148.0
2011-07-28	ABTL-DELISTED	Stock	4.95	5.15	4.95	5.0	32056.0
2011-07-28	ABUS	Stock	2.41	2.41	2.23	2.38	7300.0
2011-07-28	ABV-DELISTED	Stock	30.05	30.6	29.97	30.49	3959090.0
2011-07-28	ABVA-DELISTED	Stock	5.51	5.72	5.25	5.35	381631.0
2011-07-28	ABVT-DELISTED	Stock	61.28	61.63	59.99	60.92	170108.0

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

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