PREVIEW / stock_daily / 2012-05-03

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-03.parquet
  size:    199 KB
  rows:    6,198
  symbols: 3,559

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
2012-05-03	AAPL	Stock	21.0893	21.1214	20.725	20.7793	390549600.0
2012-05-03	MSFT	Stock	31.88	31.9	31.61	31.76	31501300.0
2012-05-03	NVDA	Stock	0.322	0.324	0.3138	0.3158	419536000.0
2012-05-03	AMZN	Stock	11.487	11.6265	11.4015	11.4725	81110000.0
2012-05-03	TSLA	Stock	2.2607	2.2667	2.142	2.164	12619500.0
2012-05-03	TLT	Stock	116.64	117.37	116.56	117.22	3522807.0
2012-05-03	ES	Stock	37.04	37.38	35.63	35.82	4820300.0
2012-05-03	CL	Stock	50.07	50.405	49.875	49.995	4760600.0
2012-05-03	A	Stock	30.8655	30.8655	30.1717	30.1931	2398129.0
2012-05-03	AABA-DELISTED	Stock	15.64	15.65	15.325	15.4	10713570.0
2012-05-03	AACC-DELISTED	Stock	5.42	5.5	5.36	5.47	27426.0
2012-05-03	AACG	Stock	6.81	6.83	6.41	6.83	4800.0
2012-05-03	AAIC-DELISTED	Stock	23.43	23.51	23.25	23.28	51880.0
2012-05-03	AAME	Stock	2.91	2.91	2.83	2.91	2600.0
2012-05-03	AAMRQ-DELISTED	Stock	0.565	0.5825	0.555	0.56	980521.0
2012-05-03	AAON	Stock	5.997	6.0415	5.6533	5.7393	270000.0
2012-05-03	AAP	Stock	92.32	92.52	91.44	91.95	517100.0
2012-05-03	AAT	Stock	24.13	24.19	23.9	24.0	186000.0
2012-05-03	AAU-DELISTED	Stock	2.22	2.3	2.0	2.12	212699.0
2012-05-03	AAUAF-DELISTED	Stock	2.22	2.3	2.0	2.11	213399.0
2012-05-03	AAV-DELISTED	Stock	3.41	3.41	3.24	3.27	305605.0
2012-05-03	AAWW-DELISTED	Stock	51.54	53.12	49.86	52.31	1171235.0
2012-05-03	AAXJ	Stock	56.66	56.77	56.251	56.4	111935.0
2012-05-03	AAXN-DELISTED	Stock	4.93	4.96	4.77	4.93	556277.0
2012-05-03	AB	Stock	14.08	14.4	13.84	14.01	361100.0
2012-05-03	ABAC-DELISTED	Stock	1.63	1.8	1.62	1.65	36540.0
2012-05-03	ABAX-DELISTED	Stock	34.98	35.07	34.28	34.71	70734.0
2012-05-03	ABB-DELISTED	Stock	18.11	18.15	17.82	17.9	2410760.0
2012-05-03	ABBNY-DELISTED	Stock	18.11	18.15	17.82	17.91	2413796.0
2012-05-03	ABC-DELISTED	Stock	37.16	37.19	36.44	36.55	3197420.0
2012-05-03	ABCB	Stock	12.15	12.24	11.99	12.14	48000.0
2012-05-03	ABCD-DELISTED	Stock	2.23	2.23	2.12	2.17	28756.0
2012-05-03	ABCO-DELISTED	Stock	45.7	49.16	45.7	48.3	635469.0
2012-05-03	ABCW-DELISTED	Stock	0.6426	0.6426	0.6426	0.6426	100.0
2012-05-03	ABE-DELISTED	Stock	19.58	19.58	19.51	19.58	500.0
2012-05-03	ABEO	Stock	1187.5	1237.5	1150.0	1225.0	74.0
2012-05-03	ABFS-DELISTED	Stock	15.58	15.82	15.36	15.39	892127.0
2012-05-03	ABG	Stock	28.42	28.65	27.51	27.76	440000.0
2012-05-03	ABH-DELISTED	Stock	12.1	12.72	12.1	12.51	1012037.0
2012-05-03	ABM	Stock	22.84	22.91	22.52	22.69	153000.0
2012-05-03	ABMD-DELISTED	Stock	23.81	24.21	23.41	23.73	793912.0
2012-05-03	ABR	Stock	5.65	5.69	5.5	5.67	36000.0
2012-05-03	ABT	Stock	30.0211	30.3234	29.9587	30.2514	18093372.0
2012-05-03	ABTL-DELISTED	Stock	4.6	4.6	4.45	4.6	18575.0
2012-05-03	ABUS	Stock	2.37	2.49	2.27	2.49	16300.0
2012-05-03	ABV-DELISTED	Stock	42.03	42.27	41.73	42.17	3343683.0
2012-05-03	ABVA-DELISTED	Stock	4.05	4.08	4.03	4.08	2909.0
2012-05-03	ABVT-DELISTED	Stock	83.07	83.24	83.05	83.17	403896.0
2012-05-03	ABX-DELISTED	Stock	38.9	38.98	37.45	37.98	11145669.0
2012-05-03	ACAD	Stock	1.59	1.59	1.55	1.55	125900.0

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

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