PREVIEW / stock_daily / 2012-05-29

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-29.parquet
  size:    199 KB
  rows:    6,186
  symbols: 3,542

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-29	AAPL	Stock	20.3893	20.5	20.1896	20.4382	380508800.0
2012-05-29	MSFT	Stock	29.38	29.72	29.22	29.56	37758800.0
2012-05-29	NVDA	Stock	0.315	0.32	0.3138	0.318	310000000.0
2012-05-29	AMZN	Stock	10.715	10.8275	10.6145	10.7375	53878000.0
2012-05-29	META	Stock	31.48	31.69	28.65	28.84	78063400.0
2012-05-29	TSLA	Stock	2.0007	2.1287	2.0007	2.1127	24750000.0
2012-05-29	TLT	Stock	123.39	123.81	123.0	123.02	5874172.0
2012-05-29	ES	Stock	36.5	36.81	36.31	36.75	6587200.0
2012-05-29	CL	Stock	49.58	49.75	49.375	49.68	2796200.0
2012-05-29	A	Stock	29.6638	30.2217	29.6352	30.1717	5696570.0
2012-05-29	AABA-DELISTED	Stock	15.4001	15.55	15.28	15.48	18237784.0
2012-05-29	AACC-DELISTED	Stock	5.51	5.84	5.5	5.72	35448.0
2012-05-29	AACG	Stock	6.23	6.23	6.15	6.15	1200.0
2012-05-29	AAIC-DELISTED	Stock	22.34	22.49	22.29	22.43	28598.0
2012-05-29	AAME	Stock	2.73	2.8	2.67	2.8	4700.0
2012-05-29	AAMRQ-DELISTED	Stock	0.465	0.479	0.46	0.47	662618.0
2012-05-29	AAON	Stock	5.7778	5.8163	5.683	5.7126	249750.0
2012-05-29	AAP	Stock	74.14	74.3	72.87	74.21	1360900.0
2012-05-29	AAT	Stock	23.06	23.35	23.0	23.34	52800.0
2012-05-29	AAU-DELISTED	Stock	2.04	2.04	1.909	1.94	122250.0
2012-05-29	AAUAF-DELISTED	Stock	2.04	2.04	1.909	1.97	122550.0
2012-05-29	AAV-DELISTED	Stock	2.87	2.96	2.87	2.92	194729.0
2012-05-29	AAWW-DELISTED	Stock	46.72	47.6	46.23	47.35	191770.0
2012-05-29	AAXJ	Stock	51.31	51.56	51.09	51.41	261100.0
2012-05-29	AAXN-DELISTED	Stock	5.48	5.55	5.36	5.46	669232.0
2012-05-29	AB	Stock	13.5	13.64	13.36	13.5	89500.0
2012-05-29	ABAC-DELISTED	Stock	1.48	1.5	1.4	1.5	6700.0
2012-05-29	ABAX-DELISTED	Stock	32.68	33.34	32.63	33.07	65676.0
2012-05-29	ABB-DELISTED	Stock	16.47	16.57	16.33	16.46	2097474.0
2012-05-29	ABBNY-DELISTED	Stock	16.47	16.57	16.33	16.48	2109874.0
2012-05-29	ABC-DELISTED	Stock	37.0	37.1	36.39	36.51	2191481.0
2012-05-29	ABCB	Stock	11.48	11.68	11.26	11.55	45900.0
2012-05-29	ABCD-DELISTED	Stock	1.35	1.41	1.29	1.34	19115.0
2012-05-29	ABCO-DELISTED	Stock	47.75	49.02	47.33	48.81	256094.0
2012-05-29	ABCW-DELISTED	Stock	0.4819	0.5121	0.4819	0.4819	8740.0
2012-05-29	ABE-DELISTED	Stock	17.94	18.14	17.94	18.07	15196.0
2012-05-29	ABEO	Stock	1125.0	1125.0	1037.5	1100.0	100.0
2012-05-29	ABFS-DELISTED	Stock	13.1	13.24	13.08	13.18	174894.0
2012-05-29	ABG	Stock	26.76	27.65	26.33	27.63	334900.0
2012-05-29	ABM	Stock	21.92	22.19	21.63	21.73	209600.0
2012-05-29	ABMD-DELISTED	Stock	20.9	21.3	20.03	20.79	806938.0
2012-05-29	ABR	Stock	5.98	6.08	5.92	6.04	45800.0
2012-05-29	ABT	Stock	29.9635	30.0115	29.6804	29.8148	10048979.0
2012-05-29	ABTL-DELISTED	Stock	3.6419	3.7431	3.6419	3.65	18632.0
2012-05-29	ABUS	Stock	2.01	2.15	2.0	2.15	22800.0
2012-05-29	ABV-DELISTED	Stock	38.38	38.68	38.05	38.28	2659543.0
2012-05-29	ABVA-DELISTED	Stock	4.215	4.4	4.215	4.39	2100.0
2012-05-29	ABVT-DELISTED	Stock	83.44	83.44	83.29	83.43	104738.0
2012-05-29	ABX-DELISTED	Stock	40.18	40.37	38.49	38.92	7062661.0
2012-05-29	ACAD	Stock	1.46	1.46	1.39	1.41	238900.0

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

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