PREVIEW / stock_daily / 2011-04-08

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-08.parquet
  size:    197 KB
  rows:    6,069
  symbols: 3,544

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-04-08	AAPL	Stock	12.14	12.1482	11.9268	11.9664	377535200.0
2011-04-08	MSFT	Stock	26.17	26.28	25.96	26.07	39887600.0
2011-04-08	NVDA	Stock	0.456	0.456	0.4375	0.4388	746552000.0
2011-04-08	AMZN	Stock	9.263	9.311	9.139	9.2355	74528000.0
2011-04-08	TSLA	Stock	1.8387	1.84	1.7573	1.766	29196000.0
2011-04-08	TLT	Stock	89.93	90.32	89.85	89.88	7606271.0
2011-04-08	ES	Stock	34.78	34.78	34.26	34.53	1126100.0
2011-04-08	CL	Stock	40.795	40.92	40.48	40.64	3974000.0
2011-04-08	A	Stock	32.3247	32.6681	32.0243	32.1102	2798097.0
2011-04-08	AABA-DELISTED	Stock	17.07	17.11	16.77	16.78	12882502.0
2011-04-08	AACC-DELISTED	Stock	5.36	5.36	5.2	5.25	18489.0
2011-04-08	AACG	Stock	8.0	8.0	7.7	7.85	18000.0
2011-04-08	AAI-DELISTED	Stock	7.4	7.4	7.3	7.33	2576481.0
2011-04-08	AAIC-DELISTED	Stock	30.0	30.25	29.82	29.88	17559.0
2011-04-08	AAME	Stock	2.06	2.12	2.06	2.12	200.0
2011-04-08	AAON	Stock	6.5027	6.5027	6.2657	6.2775	94669.0
2011-04-08	AAP	Stock	67.58	67.66	66.22	66.46	874000.0
2011-04-08	AAT	Stock	21.6	21.61	21.13	21.37	158100.0
2011-04-08	AATI-DELISTED	Stock	3.75	3.96	3.75	3.96	517802.0
2011-04-08	AAU-DELISTED	Stock	4.86	4.97	4.67	4.68	752094.0
2011-04-08	AAUAF-DELISTED	Stock	4.86	4.97	4.67	4.69	752294.0
2011-04-08	AAV-DELISTED	Stock	8.95	9.1	8.89	8.96	397895.0
2011-04-08	AAWW-DELISTED	Stock	66.97	66.97	65.16	65.68	136135.0
2011-04-08	AAXJ	Stock	64.76	65.01	64.31	64.55	212591.0
2011-04-08	AAXN-DELISTED	Stock	4.03	4.04	3.86	3.89	578539.0
2011-04-08	AB	Stock	22.58	22.75	22.36	22.46	224000.0
2011-04-08	ABAC-DELISTED	Stock	3.85	3.9	3.7	3.71	53529.0
2011-04-08	ABAX-DELISTED	Stock	30.25	30.29	29.18	29.44	62724.0
2011-04-08	ABB-DELISTED	Stock	24.62	24.67	24.44	24.56	1249894.0
2011-04-08	ABBC-DELISTED	Stock	12.82	12.82	12.27	12.39	29130.0
2011-04-08	ABBNY-DELISTED	Stock	24.62	24.67	24.44	24.57	1252364.0
2011-04-08	ABC-DELISTED	Stock	40.86	40.91	40.06	40.19	2536455.0
2011-04-08	ABCB	Stock	10.03	10.03	9.71	9.79	30500.0
2011-04-08	ABCD-DELISTED	Stock	3.37	3.37	3.3	3.31	8541.0
2011-04-08	ABCO-DELISTED	Stock	25.07	25.23	24.38	24.52	31441.0
2011-04-08	ABCW-DELISTED	Stock	0.93	0.93	0.87	0.89	44440.0
2011-04-08	ABD-DELISTED	Stock	10.04	10.09	9.479	9.6	245210.0
2011-04-08	ABE-DELISTED	Stock	19.09	19.19	19.07	19.13	5599.0
2011-04-08	ABEO	Stock	2725.0	2737.5	2437.5	2687.5	5.0
2011-04-08	ABFS-DELISTED	Stock	26.2	26.2	25.03	25.22	200178.0
2011-04-08	ABG	Stock	19.11	19.12	18.18	18.25	262800.0
2011-04-08	ABH-DELISTED	Stock	27.64	27.68	26.9	27.07	586478.0
2011-04-08	ABM	Stock	25.56	25.56	24.88	25.08	169700.0
2011-04-08	ABMD-DELISTED	Stock	15.45	15.45	15.0	15.16	299058.0
2011-04-08	ABR	Stock	5.6	5.65	5.46	5.47	32900.0
2011-04-08	ABT	Stock	24.2491	24.3259	24.1435	24.2251	12129012.0
2011-04-08	ABTL-DELISTED	Stock	6.9007	7.0022	6.5963	6.85	33458.0
2011-04-08	ABUS	Stock	3.06	3.07	2.99	3.06	21200.0
2011-04-08	ABV-DELISTED	Stock	29.41	29.6	29.08	29.4	1715538.0
2011-04-08	ABVA-DELISTED	Stock	5.72	5.749	5.364	5.364	996.0

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

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