PREVIEW / stock_daily / 2014-11-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-06.parquet
  size:    222 KB
  rows:    6,617
  symbols: 3,544

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-11-06	AAPL	Stock	27.15	27.1975	26.95	27.175	139874000.0
2014-11-06	MSFT	Stock	47.86	48.86	47.79	48.7	33037800.0
2014-11-06	NVDA	Stock	0.5043	0.5062	0.4965	0.5055	394088000.0
2014-11-06	AMZN	Stock	14.8345	14.85	14.6145	14.832	75162000.0
2014-11-06	GOOGL	Stock	27.775	27.84	27.529	27.5845	33014420.0
2014-11-06	META	Stock	74.89	75.6	74.31	75.26	21383000.0
2014-11-06	TSLA	Stock	15.6327	16.446	15.2333	16.0813	230320500.0
2014-11-06	TLT	Stock	118.6	118.9299	118.305	118.39	5901871.0
2014-11-06	ES	Stock	50.55	50.56	49.33	49.5	3521900.0
2014-11-06	CL	Stock	68.18	68.2	67.74	68.11	2507300.0
2014-11-06	A	Stock	40.39	41.41	40.26	41.37	2968300.0
2014-11-06	AA.B-DELISTED	Stock	51.26	52.0	50.85	51.33	48626.0
2014-11-06	AABA-DELISTED	Stock	47.37	47.98	46.6	47.92	21122874.0
2014-11-06	AAC-DELISTED	Stock	21.5	26.4	21.15	23.33	475679.0
2014-11-06	AACG	Stock	4.14	4.18	4.12	4.18	2100.0
2014-11-06	AAIC-DELISTED	Stock	27.25	27.4	27.21	27.38	173239.0
2014-11-06	AAL	Stock	42.59	44.13	42.59	43.14	14477200.0
2014-11-06	AAMC-DELISTED	Stock	147.0588	150.5882	147.0585	150.5882	10472.0
2014-11-06	AAME	Stock	3.67	3.72	3.52	3.72	5700.0
2014-11-06	AAMI	Stock	15.0	15.739	14.81	15.4	213800.0
2014-11-06	AAOI	Stock	15.88	16.05	15.57	15.95	392100.0
2014-11-06	AAON	Stock	13.0333	13.92	12.7667	13.9133	290250.0
2014-11-06	AAP	Stock	138.5	147.5	137.17	145.56	3398600.0
2014-11-06	AAT	Stock	38.78	38.86	38.24	38.33	143500.0
2014-11-06	AAU-DELISTED	Stock	1.0	1.04	0.9719	1.03	236725.0
2014-11-06	AAUAF-DELISTED	Stock	1.0	1.04	0.9719	1.03	238257.0
2014-11-06	AAV-DELISTED	Stock	4.22	4.59	4.11	4.56	450256.0
2014-11-06	AAVL-DELISTED	Stock	33.4	34.8	33.02	34.75	32262.0
2014-11-06	AAWW-DELISTED	Stock	39.0	41.0	37.65	40.85	629429.0
2014-11-06	AAXJ	Stock	62.07	62.1745	61.855	61.91	1565498.0
2014-11-06	AAXN-DELISTED	Stock	18.65	18.72	18.19	18.42	1568750.0
2014-11-06	AB	Stock	26.24	26.24	25.65	25.75	266200.0
2014-11-06	ABAC-DELISTED	Stock	2.27	2.3	2.2	2.28	52544.0
2014-11-06	ABAX-DELISTED	Stock	54.31	54.71	53.57	53.86	137559.0
2014-11-06	ABB-DELISTED	Stock	22.33	22.35	22.17	22.2	1377885.0
2014-11-06	ABBNY-DELISTED	Stock	22.33	22.35	22.17	22.19	1698955.0
2014-11-06	ABBV	Stock	62.75	63.39	62.42	62.71	5152400.0
2014-11-06	ABC-DELISTED	Stock	87.96	88.11	86.82	87.39	2148022.0
2014-11-06	ABCB	Stock	24.74	24.94	24.74	24.85	50800.0
2014-11-06	ABCD-DELISTED	Stock	1.52	1.57	1.51	1.51	27983.0
2014-11-06	ABCO-DELISTED	Stock	54.44	54.6199	53.86	54.28	269212.0
2014-11-06	ABCW-DELISTED	Stock	31.2	31.31	31.2	31.2	600.0
2014-11-06	ABDC-DELISTED	Stock	12.92	13.027	12.63	12.99	26668.0
2014-11-06	ABE-DELISTED	Stock	13.98	14.02	13.96	14.0	4493.0
2014-11-06	ABEO	Stock	262.5	262.5	218.75	243.75	132.0
2014-11-06	ABEV	Stock	6.41	6.45	6.32	6.34	19341100.0
2014-11-06	ABG	Stock	70.76	73.09	70.76	72.82	396400.0
2014-11-06	ABGB-DELISTED	Stock	18.68	18.8556	18.4801	18.56	19050.0
2014-11-06	ABM	Stock	27.16	27.46	27.16	27.36	89900.0
2014-11-06	ABMD-DELISTED	Stock	31.86	32.12	31.36	31.66	248845.0

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

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