PREVIEW / stock_daily / 2012-10-15

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-15.parquet
  size:    200 KB
  rows:    6,175
  symbols: 3,491

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-10-15	AAPL	Stock	22.5839	22.6832	22.2804	22.67	432502000.0
2012-10-15	MSFT	Stock	29.37	29.72	29.25	29.51	42440200.0
2012-10-15	NVDA	Stock	0.3163	0.32	0.3125	0.3198	249580000.0
2012-10-15	AMZN	Stock	12.1425	12.239	11.9255	12.209	59196000.0
2012-10-15	META	Stock	19.68	19.88	19.49	19.52	20189700.0
2012-10-15	TSLA	Stock	1.868	1.87	1.7907	1.822	22030500.0
2012-10-15	TLT	Stock	123.78	124.14	123.43	123.69	3036046.0
2012-10-15	ES	Stock	38.76	39.14	38.54	39.1	1078600.0
2012-10-15	CL	Stock	54.01	54.27	53.79	54.23	2830400.0
2012-10-15	A	Stock	26.6953	26.9313	26.4592	26.5951	3697710.0
2012-10-15	AABA-DELISTED	Stock	15.85	15.87	15.65	15.66	20354131.0
2012-10-15	AACC-DELISTED	Stock	7.74	8.0	7.54	7.99	17452.0
2012-10-15	AACG	Stock	5.16	5.24	5.16	5.17	1100.0
2012-10-15	AAIC-DELISTED	Stock	22.25	22.25	21.34	22.07	346144.0
2012-10-15	AAME	Stock	2.79	2.89	2.61	2.82	8400.0
2012-10-15	AAMRQ-DELISTED	Stock	0.3801	0.386	0.3751	0.38	685677.0
2012-10-15	AAON	Stock	5.4815	5.6	5.4341	5.5881	257513.0
2012-10-15	AAP	Stock	68.11	68.11	66.69	67.77	529100.0
2012-10-15	AAT	Stock	27.75	27.98	27.69	27.8	183000.0
2012-10-15	AAU-DELISTED	Stock	2.505	2.5363	2.495	2.5	127293.0
2012-10-15	AAUAF-DELISTED	Stock	2.51	2.5414	2.49	2.49	127341.0
2012-10-15	AAV-DELISTED	Stock	3.8	3.85	3.74	3.83	86138.0
2012-10-15	AAWW-DELISTED	Stock	51.79	51.79	50.7	51.2	135018.0
2012-10-15	AAXJ	Stock	56.3	56.55	56.08	56.4782	83722.0
2012-10-15	AAXN-DELISTED	Stock	5.98	6.1	5.9	6.09	301800.0
2012-10-15	AB	Stock	15.97	16.1	15.87	15.98	273900.0
2012-10-15	ABAC-DELISTED	Stock	1.21	1.41	1.19	1.3531	11937.0
2012-10-15	ABAX-DELISTED	Stock	36.59	37.1	36.0	36.3	64767.0
2012-10-15	ABB-DELISTED	Stock	18.93	19.05	18.8	19.03	1264477.0
2012-10-15	ABBNY-DELISTED	Stock	18.93	19.05	18.8	19.03	1268532.0
2012-10-15	ABC-DELISTED	Stock	39.5	39.93	39.37	39.91	1781259.0
2012-10-15	ABCB	Stock	12.49	12.5	12.14	12.48	20500.0
2012-10-15	ABCD-DELISTED	Stock	1.0	1.0201	0.97	0.97	15000.0
2012-10-15	ABCO-DELISTED	Stock	47.81	48.32	47.26	48.25	117862.0
2012-10-15	ABCW-DELISTED	Stock	0.35	0.38	0.35	0.37	37374.0
2012-10-15	ABE-DELISTED	Stock	20.56	20.59	20.56	20.59	201.0
2012-10-15	ABEO	Stock	475.0	500.0	475.0	475.0	28.0
2012-10-15	ABFS-DELISTED	Stock	8.19	8.36	8.15	8.25	225371.0
2012-10-15	ABG	Stock	29.51	29.9	28.79	29.83	250700.0
2012-10-15	ABM	Stock	18.12	18.15	17.95	18.06	282800.0
2012-10-15	ABMD-DELISTED	Stock	20.04	20.51	19.85	20.49	361894.0
2012-10-15	ABR	Stock	5.7	5.7	5.5	5.54	179400.0
2012-10-15	ABT	Stock	33.3461	34.5936	33.2501	34.5696	32805544.0
2012-10-15	ABTL-DELISTED	Stock	3.9	3.9	3.73	3.84	7964.0
2012-10-15	ABUS	Stock	4.12	4.12	3.96	3.98	5700.0
2012-10-15	ABV-DELISTED	Stock	40.06	40.8	39.91	40.67	1989326.0
2012-10-15	ABVA-DELISTED	Stock	4.64	4.64	4.6	4.6	2590.0
2012-10-15	ABX-DELISTED	Stock	38.74	38.86	38.2802	38.839	7085890.0
2012-10-15	ACAD	Stock	2.44	2.5	2.38	2.41	1035200.0
2012-10-15	ACAS-DELISTED	Stock	11.6	11.64	11.35	11.44	2905362.0

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

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