PREVIEW / stock_daily / 2014-10-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-15.parquet
  size:    223 KB
  rows:    6,660
  symbols: 3,575

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
2014-10-15	AAPL	Stock	24.4925	24.7875	23.795	24.385	403734400.0
2014-10-15	MSFT	Stock	43.0	43.39	42.1	43.22	60218700.0
2014-10-15	NVDA	Stock	0.4232	0.4382	0.4205	0.436	404428000.0
2014-10-15	AMZN	Stock	15.2175	15.395	14.955	15.2985	106878000.0
2014-10-15	GOOGL	Stock	27.104	27.1958	26.4211	27.0365	76724440.0
2014-10-15	META	Stock	71.69	73.8	70.32	73.21	61528000.0
2014-10-15	TSLA	Stock	14.6667	15.3993	14.488	15.3133	137209500.0
2014-10-15	TLT	Stock	124.58	127.68	121.84	122.53	37408948.0
2014-10-15	ES	Stock	47.43	47.96	46.37	47.56	3298500.0
2014-10-15	CL	Stock	63.67	64.04	62.68	63.53	5418100.0
2014-10-15	A	Stock	36.3877	37.1102	35.6223	37.0458	6604012.0
2014-10-15	AA.B-DELISTED	Stock	45.74	46.77	44.894	46.74	172978.0
2014-10-15	AABA-DELISTED	Stock	37.27	38.08	36.2	37.82	39965209.0
2014-10-15	AAC-DELISTED	Stock	18.1	19.5	18.0	19.43	44131.0
2014-10-15	AACG	Stock	4.3	4.35	4.3	4.32	5000.0
2014-10-15	AAIC-DELISTED	Stock	25.59	25.66	24.95	25.47	899091.0
2014-10-15	AAL	Stock	30.22	32.62	29.49	31.69	39941300.0
2014-10-15	AAMC-DELISTED	Stock	176.4735	191.7471	176.4735	189.4118	24055.0
2014-10-15	AAME	Stock	3.78	3.96	3.77	3.94	4200.0
2014-10-15	AAMI	Stock	13.9	14.11	13.85	14.0	568900.0
2014-10-15	AAOI	Stock	13.03	13.78	12.83	13.41	314200.0
2014-10-15	AAON	Stock	11.4667	12.1667	11.3333	12.0867	247050.0
2014-10-15	AAP	Stock	131.76	134.95	130.14	133.51	1117700.0
2014-10-15	AAT	Stock	34.69	35.45	34.55	35.16	214400.0
2014-10-15	AAU-DELISTED	Stock	1.32	1.32	1.27	1.3	83665.0
2014-10-15	AAUAF-DELISTED	Stock	1.32	1.32	1.27	1.3	84175.0
2014-10-15	AAV-DELISTED	Stock	4.25	4.375	4.08	4.35	627702.0
2014-10-15	AAVL-DELISTED	Stock	29.56	30.88	28.741	30.54	77569.0
2014-10-15	AAWW-DELISTED	Stock	31.87	32.765	31.25	32.52	228289.0
2014-10-15	AAXJ	Stock	60.16	60.46	59.2108	60.31	537301.0
2014-10-15	AAXN-DELISTED	Stock	13.79	14.85	13.61	14.685	1632189.0
2014-10-15	AB	Stock	23.01	23.52	22.51	22.95	684500.0
2014-10-15	ABAC-DELISTED	Stock	2.06	2.1	1.86	2.0599	47022.0
2014-10-15	ABAX-DELISTED	Stock	47.32	48.43	46.874	48.04	109186.0
2014-10-15	ABB-DELISTED	Stock	20.32	20.51	20.1	20.47	2567478.0
2014-10-15	ABBNY-DELISTED	Stock	20.32	20.51	20.1	20.47	2658987.0
2014-10-15	ABBV	Stock	52.33	55.72	52.06	54.63	122740200.0
2014-10-15	ABC-DELISTED	Stock	75.79	76.41	74.51	76.02	2060642.0
2014-10-15	ABCB	Stock	23.36	23.53	23.09	23.51	116700.0
2014-10-15	ABCD-DELISTED	Stock	1.49	1.5	1.4096	1.48	23377.0
2014-10-15	ABCO-DELISTED	Stock	48.18	50.49	47.72	50.34	325789.0
2014-10-15	ABDC-DELISTED	Stock	12.2	13.28	12.01	12.1	69211.0
2014-10-15	ABE-DELISTED	Stock	13.55	13.69	13.45	13.6806	11691.0
2014-10-15	ABEO	Stock	262.5	275.0	262.5	275.0	37.0
2014-10-15	ABEV	Stock	6.56	6.56	6.34	6.47	18536500.0
2014-10-15	ABG	Stock	62.79	65.24	62.22	65.21	520000.0
2014-10-15	ABGB-DELISTED	Stock	17.93	18.23	17.73	17.971	65497.0
2014-10-15	ABM	Stock	25.11	25.93	24.97	25.78	255900.0
2014-10-15	ABMD-DELISTED	Stock	23.06	23.06	22.33	22.93	141813.0
2014-10-15	ABR	Stock	6.5	6.56	6.32	6.44	110300.0

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

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