PREVIEW / stock_daily / 2014-10-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-16.parquet
  size:    221 KB
  rows:    6,630
  symbols: 3,569

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-16	AAPL	Stock	23.8875	24.43	23.8525	24.065	288618000.0
2014-10-16	MSFT	Stock	42.53	43.08	42.22	42.74	49040400.0
2014-10-16	NVDA	Stock	0.4282	0.4412	0.4272	0.4362	351116000.0
2014-10-16	AMZN	Stock	14.6915	15.341	14.6915	15.143	94626000.0
2014-10-16	GOOGL	Stock	26.35	27.0495	26.2475	26.846	76100920.0
2014-10-16	META	Stock	70.79	73.35	70.58	72.63	53529000.0
2014-10-16	TSLA	Stock	14.648	15.328	14.6067	15.09	80989500.0
2014-10-16	TLT	Stock	124.12	124.13	121.44	121.75	18098188.0
2014-10-16	ES	Stock	47.08	47.27	46.33	46.94	2998100.0
2014-10-16	CL	Stock	62.81	63.4	62.53	63.11	4995000.0
2014-10-16	A	Stock	36.3233	37.2818	36.1588	36.9886	7496216.0
2014-10-16	AA.B-DELISTED	Stock	46.0	46.92	45.53	46.9	123116.0
2014-10-16	AABA-DELISTED	Stock	36.95	38.5	36.92	38.12	25868514.0
2014-10-16	AAC-DELISTED	Stock	19.13	19.85	19.0	19.4	60031.0
2014-10-16	AACG	Stock	4.35	4.35	4.34	4.35	4700.0
2014-10-16	AAIC-DELISTED	Stock	25.24	25.75	25.11	25.67	266901.0
2014-10-16	AAL	Stock	30.63	33.4	30.0	32.97	24983100.0
2014-10-16	AAMC-DELISTED	Stock	185.5882	195.5588	183.9735	195.5588	20635.0
2014-10-16	AAME	Stock	3.84	3.97	3.78	3.94	2300.0
2014-10-16	AAMI	Stock	13.75	14.0	13.75	13.91	617800.0
2014-10-16	AAOI	Stock	13.03	15.35	13.03	15.1	472700.0
2014-10-16	AAON	Stock	11.92	12.24	11.84	11.9667	382950.0
2014-10-16	AAP	Stock	131.52	134.15	131.4	132.43	1085800.0
2014-10-16	AAT	Stock	34.97	35.43	34.86	35.13	137800.0
2014-10-16	AAU-DELISTED	Stock	1.3	1.3202	1.29	1.3	39898.0
2014-10-16	AAUAF-DELISTED	Stock	1.3	1.3	1.27	1.3	41270.0
2014-10-16	AAV-DELISTED	Stock	4.19	4.51	4.18	4.42	430292.0
2014-10-16	AAVL-DELISTED	Stock	30.98	30.98	28.76	30.4	33037.0
2014-10-16	AAWW-DELISTED	Stock	32.0	33.705	32.0	32.94	170618.0
2014-10-16	AAXJ	Stock	59.22	60.48	59.15	60.1	1301599.0
2014-10-16	AAXN-DELISTED	Stock	14.31	15.13	14.11	14.96	1367300.0
2014-10-16	AB	Stock	22.5	23.81	22.4	23.63	321800.0
2014-10-16	ABAC-DELISTED	Stock	2.06	2.1	1.88	2.1	54658.0
2014-10-16	ABAX-DELISTED	Stock	47.48	48.98	47.48	48.065	227627.0
2014-10-16	ABB-DELISTED	Stock	19.94	20.52	19.92	20.3701	2174565.0
2014-10-16	ABBNY-DELISTED	Stock	19.94	20.52	19.92	20.37	2330851.0
2014-10-16	ABBV	Stock	55.8	55.9	52.84	52.9	61236700.0
2014-10-16	ABC-DELISTED	Stock	75.38	75.8699	74.32	75.01	2068048.0
2014-10-16	ABCB	Stock	23.26	24.0	22.62	23.84	194400.0
2014-10-16	ABCO-DELISTED	Stock	50.03	50.84	49.39	50.29	200632.0
2014-10-16	ABDC-DELISTED	Stock	11.97	12.5	11.86	12.49	60552.0
2014-10-16	ABE-DELISTED	Stock	13.39	13.6401	13.37	13.6	7786.0
2014-10-16	ABEO	Stock	262.5	300.0	225.0	287.5	92.0
2014-10-16	ABEV	Stock	6.28	6.47	6.25	6.32	18317000.0
2014-10-16	ABG	Stock	64.13	65.01	63.43	63.96	471700.0
2014-10-16	ABGB-DELISTED	Stock	17.73	19.119	17.73	18.93	15980.0
2014-10-16	ABM	Stock	25.36	25.99	25.36	25.85	215800.0
2014-10-16	ABMD-DELISTED	Stock	22.54	23.09	22.54	22.91	177430.0
2014-10-16	ABR	Stock	6.32	6.57	6.32	6.52	61400.0
2014-10-16	ABR.A-DELISTED	Stock	24.1705	24.2	24.1705	24.2	1330.0

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

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