PREVIEW / stock_daily / 2015-04-16

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-16.parquet
  size:    223 KB
  rows:    6,636
  symbols: 3,515

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
2015-04-16	AAPL	Stock	31.57	31.775	31.5275	31.5425	113476000.0
2015-04-16	MSFT	Stock	41.95	42.34	41.82	42.16	22509700.0
2015-04-16	NVDA	Stock	0.5625	0.5672	0.5582	0.5622	155284000.0
2015-04-16	AMZN	Stock	19.1845	19.3725	19.1775	19.302	41608000.0
2015-04-16	GOOGL	Stock	26.9175	27.2615	26.905	27.176	31721760.0
2015-04-16	META	Stock	82.47	83.07	82.15	82.31	13769700.0
2015-04-16	TSLA	Stock	13.8467	13.9447	13.7527	13.78	24886500.0
2015-04-16	TLT	Stock	130.83	130.86	129.41	129.96	7085505.0
2015-04-16	ES	Stock	50.14	50.41	49.46	50.35	1848000.0
2015-04-16	CL	Stock	69.96	70.3	69.66	70.08	2166500.0
2015-04-16	A	Stock	43.14	43.36	43.06	43.13	1070200.0
2015-04-16	AA.B-DELISTED	Stock	45.89	45.93	43.55	45.54	61210.0
2015-04-16	AABA-DELISTED	Stock	45.83	46.13	45.53	45.79	13091658.0
2015-04-16	AAC-DELISTED	Stock	31.62	32.29	31.18	31.93	84297.0
2015-04-16	AACG	Stock	4.26	4.48	4.26	4.4	1300.0
2015-04-16	AAIC-DELISTED	Stock	24.12	24.234	23.95	24.06	164966.0
2015-04-16	AAL	Stock	47.81	48.91	47.75	48.24	7155900.0
2015-04-16	AAMC-DELISTED	Stock	67.9735	69.3735	67.6471	68.5235	29811.0
2015-04-16	AAME	Stock	3.97	3.97	3.97	3.97	100.0
2015-04-16	AAMI	Stock	18.42	19.16	18.37	18.99	310700.0
2015-04-16	AAOI	Stock	13.63	14.73	13.63	14.53	299400.0
2015-04-16	AAON	Stock	16.3333	16.3667	16.16	16.18	172200.0
2015-04-16	AAP	Stock	149.13	151.31	148.32	150.0	716400.0
2015-04-16	AAT	Stock	41.32	41.53	40.84	41.25	82700.0
2015-04-16	AAU-DELISTED	Stock	0.86	0.868	0.8	0.84	116771.0
2015-04-16	AAUAF-DELISTED	Stock	0.84	0.845	0.7961	0.8372	120718.0
2015-04-16	AAV-DELISTED	Stock	5.88	5.97	5.8681	5.93	87175.0
2015-04-16	AAVL-DELISTED	Stock	41.35	42.56	41.0	42.1	245339.0
2015-04-16	AAWW-DELISTED	Stock	44.52	44.85	44.16	44.49	145529.0
2015-04-16	AAXJ	Stock	68.67	69.28	68.54	69.03	1985058.0
2015-04-16	AAXN-DELISTED	Stock	27.01	28.61	26.85	27.81	3117689.0
2015-04-16	AB	Stock	31.79	31.95	31.67	31.87	185900.0
2015-04-16	ABAC-DELISTED	Stock	1.6501	1.71	1.62	1.701	16584.0
2015-04-16	ABAX-DELISTED	Stock	63.91	64.25	63.26	63.77	40890.0
2015-04-16	ABB-DELISTED	Stock	22.05	22.06	21.88	21.96	1475503.0
2015-04-16	ABBNY-DELISTED	Stock	22.05	22.06	21.88	21.97	1586918.0
2015-04-16	ABBV	Stock	61.8	62.91	61.65	62.59	9815600.0
2015-04-16	ABC-DELISTED	Stock	113.41	114.06	112.525	113.84	902296.0
2015-04-16	ABCB	Stock	26.59	26.59	26.17	26.31	61100.0
2015-04-16	ABCD-DELISTED	Stock	2.96	3.04	2.96	2.99	4800.0
2015-04-16	ABCO-DELISTED	Stock	53.89	54.48	53.33	53.58	240002.0
2015-04-16	ABCW-DELISTED	Stock	34.4999	34.6	34.34	34.43	5601.0
2015-04-16	ABDC-DELISTED	Stock	13.79	13.94	13.69	13.9	30006.0
2015-04-16	ABE-DELISTED	Stock	13.28	13.47	13.28	13.47	9992.0
2015-04-16	ABEO	Stock	81.25	85.0	80.5	83.0	8508.0
2015-04-16	ABEOW-DELISTED	Stock	1.251	1.41	1.25	1.35	76000.0
2015-04-16	ABEV	Stock	6.28	6.34	6.26	6.32	16395200.0
2015-04-16	ABG	Stock	86.57	86.91	85.72	85.85	158300.0
2015-04-16	ABGB-DELISTED	Stock	17.18	17.2	16.94	17.09	24596.0
2015-04-16	ABIL-DELISTED	Stock	9.9759	10.08	9.9	10.0799	9900.0

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

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