PREVIEW / stock_daily / 2011-05-05

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-05.parquet
  size:    199 KB
  rows:    6,126
  symbols: 3,573

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-05-05	AAPL	Stock	12.4429	12.5339	12.3589	12.3839	335969200.0
2011-05-05	MSFT	Stock	26.05	26.08	25.68	25.79	55600000.0
2011-05-05	NVDA	Stock	0.4625	0.472	0.4562	0.4665	544000000.0
2011-05-05	AMZN	Stock	9.933	10.05	9.806	9.8555	92000000.0
2011-05-05	TSLA	Stock	1.8133	1.8293	1.7447	1.7627	18277500.0
2011-05-05	TLT	Stock	94.92	95.63	94.809	95.49	9588272.0
2011-05-05	ES	Stock	35.6	35.63	35.15	35.26	1505500.0
2011-05-05	CL	Stock	42.71	42.805	42.38	42.45	5351800.0
2011-05-05	A	Stock	35.3147	35.7296	35.0644	35.1717	4840715.0
2011-05-05	AABA-DELISTED	Stock	18.12	18.56	18.05	18.43	30502778.0
2011-05-05	AACC-DELISTED	Stock	5.09	5.09	5.0	5.0	26719.0
2011-05-05	AACG	Stock	7.83	8.0	7.81	8.0	4600.0
2011-05-05	AAIC-DELISTED	Stock	29.05	29.21	28.6	28.91	61562.0
2011-05-05	AAME	Stock	2.04	2.07	2.0	2.04	13200.0
2011-05-05	AAON	Stock	6.2519	6.5185	6.0978	6.3407	396900.0
2011-05-05	AAP	Stock	65.5	66.55	65.12	65.86	1061700.0
2011-05-05	AAT	Stock	21.85	22.05	21.66	21.89	86900.0
2011-05-05	AATI-DELISTED	Stock	3.95	4.2	3.95	4.02	282599.0
2011-05-05	AAU-DELISTED	Stock	4.21	4.23	3.71	3.85	1246701.0
2011-05-05	AAUAF-DELISTED	Stock	4.21	4.23	3.71	3.85	1247301.0
2011-05-05	AAV-DELISTED	Stock	7.79	7.8297	7.58	7.67	578896.0
2011-05-05	AAWW-DELISTED	Stock	62.49	63.37	62.335	63.09	440139.0
2011-05-05	AAXJ	Stock	62.93	63.38	62.64	62.98	487320.0
2011-05-05	AAXN-DELISTED	Stock	4.33	4.42	4.29	4.39	371409.0
2011-05-05	AB	Stock	21.78	22.08	21.52	21.8	444200.0
2011-05-05	ABAC-DELISTED	Stock	3.24	3.2599	3.15	3.15	38168.0
2011-05-05	ABAX-DELISTED	Stock	28.2	28.36	27.54	27.59	75161.0
2011-05-05	ABB-DELISTED	Stock	26.03	26.19	25.71	25.79	3486828.0
2011-05-05	ABBC-DELISTED	Stock	12.01	12.33	11.93	12.11	61206.0
2011-05-05	ABBNY-DELISTED	Stock	26.05	26.19	25.71	25.79	3499423.0
2011-05-05	ABC-DELISTED	Stock	40.61	41.385	40.39	41.03	2267660.0
2011-05-05	ABCB	Stock	9.31	9.5	9.17	9.27	279600.0
2011-05-05	ABCD-DELISTED	Stock	3.23	3.33	3.23	3.25	41502.0
2011-05-05	ABCO-DELISTED	Stock	24.32	25.45	23.67	25.26	262718.0
2011-05-05	ABCW-DELISTED	Stock	0.81	0.81	0.8	0.8	31290.0
2011-05-05	ABD-DELISTED	Stock	9.38	9.65	9.278	9.45	270500.0
2011-05-05	ABE-DELISTED	Stock	18.88	18.899	18.52	18.7	15109.0
2011-05-05	ABEO	Stock	2662.5	2875.0	2662.5	2875.0	3.0
2011-05-05	ABFS-DELISTED	Stock	23.17	24.13	22.99	23.69	1226256.0
2011-05-05	ABG	Stock	16.56	16.94	16.3	16.5	341700.0
2011-05-05	ABH-DELISTED	Stock	26.0	26.67	25.8	26.17	285497.0
2011-05-05	ABM	Stock	23.94	24.35	23.8	24.0	301200.0
2011-05-05	ABMD-DELISTED	Stock	16.54	17.08	16.33	16.62	156496.0
2011-05-05	ABR	Stock	5.05	5.13	4.99	5.02	101300.0
2011-05-05	ABT	Stock	25.3526	25.4006	25.1175	25.2231	13459983.0
2011-05-05	ABTL-DELISTED	Stock	6.4008	6.6469	6.2038	6.45	31144.0
2011-05-05	ABUS	Stock	3.0	3.0	2.79	2.84	5000.0
2011-05-05	ABV-DELISTED	Stock	31.17	32.7	31.14	32.06	3726182.0
2011-05-05	ABVA-DELISTED	Stock	6.45	6.56	6.45	6.55	37408.0
2011-05-05	ABVT-DELISTED	Stock	66.89	66.89	65.4729	65.62	376344.0

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

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