PREVIEW / stock_daily / 2017-04-04

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-04.parquet
  size:    214 KB
  rows:    6,454
  symbols: 3,029

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
2017-04-04	AAPL	Stock	35.8125	36.2225	35.7925	36.1925	79565600.0
2017-04-04	MSFT	Stock	65.39	65.81	65.28	65.73	12997400.0
2017-04-04	NVDA	Stock	2.585	2.6105	2.5085	2.5195	1271280000.0
2017-04-04	AMZN	Stock	44.575	45.427	44.514	45.3415	99694000.0
2017-04-04	GOOGL	Stock	42.4	42.65	42.3752	42.6285	26969880.0
2017-04-04	META	Stock	141.86	142.09	141.27	141.73	12948600.0
2017-04-04	TSLA	Stock	19.7927	20.3207	19.6353	20.2467	152019000.0
2017-04-04	TLT	Stock	121.37	121.59	120.95	121.01	6976660.0
2017-04-04	ES	Stock	58.83	59.04	58.56	58.86	2147800.0
2017-04-04	CL	Stock	73.5	73.77	73.18	73.62	4043800.0
2017-04-04	A	Stock	53.2	53.24	52.48	52.62	2017100.0
2017-04-04	AA	Stock	34.03	34.5	33.821	34.23	2297000.0
2017-04-04	AAAP-DELISTED	Stock	39.4	39.91	39.4	39.82	42191.0
2017-04-04	AABA-DELISTED	Stock	46.3	46.47	46.12	46.24	4521057.0
2017-04-04	AAC-DELISTED	Stock	8.47	8.55	8.2	8.35	119687.0
2017-04-04	AACG	Stock	4.16	4.16	3.84	3.9	13800.0
2017-04-04	AAIC-DELISTED	Stock	14.03	14.13	13.9	14.12	384699.0
2017-04-04	AAL	Stock	42.09	42.23	40.82	40.9	7254700.0
2017-04-04	AAM.A-DELISTED	Stock	25.23	25.3	25.18	25.25	221817.0
2017-04-04	AAMC-DELISTED	Stock	21.1324	21.1324	19.5588	19.7059	28662.0
2017-04-04	AAME	Stock	4.0	4.0	3.85	3.85	2100.0
2017-04-04	AAMI	Stock	15.03	15.18	15.01	15.12	357900.0
2017-04-04	AAOI	Stock	53.21	53.9	50.56	51.19	1896700.0
2017-04-04	AAON	Stock	22.8667	23.3	22.8667	23.1667	226950.0
2017-04-04	AAP	Stock	144.93	145.22	142.67	143.04	1072000.0
2017-04-04	AAT	Stock	41.79	41.94	41.6	41.85	262300.0
2017-04-04	AAU-DELISTED	Stock	1.15	1.2	1.15	1.2	279185.0
2017-04-04	AAUAF-DELISTED	Stock	1.15	1.2	1.15	1.2	280423.0
2017-04-04	AAV-DELISTED	Stock	6.6	6.85	6.575	6.8	73107.0
2017-04-04	AAWW-DELISTED	Stock	53.5	54.35	53.45	54.05	66952.0
2017-04-04	AAXJ	Stock	63.15	63.38	63.09	63.31	1048642.0
2017-04-04	AAXN-DELISTED	Stock	22.47	22.64	21.97	21.99	1015249.0
2017-04-04	AB	Stock	22.35	22.6	22.1	22.55	312100.0
2017-04-04	ABAC-DELISTED	Stock	2.34	2.596	2.3	2.3	31557.0
2017-04-04	ABAX-DELISTED	Stock	48.58	49.05	46.9099	47.38	67651.0
2017-04-04	ABB-DELISTED	Stock	23.26	23.46	23.22	23.45	2117049.0
2017-04-04	ABBNY-DELISTED	Stock	23.26	23.46	23.22	23.46	2397689.0
2017-04-04	ABBV	Stock	65.12	65.3	64.83	65.11	3457900.0
2017-04-04	ABC-DELISTED	Stock	87.06	87.99	86.71	86.95	1204253.0
2017-04-04	ABCB	Stock	44.9	45.55	44.17	45.35	198400.0
2017-04-04	ABCD-DELISTED	Stock	4.85	4.9	4.8	4.86	26762.0
2017-04-04	ABCO-DELISTED	Stock	46.8	47.04	46.25	46.65	319093.0
2017-04-04	ABDC-DELISTED	Stock	13.86	14.09	13.5552	13.79	61478.0
2017-04-04	ABE-DELISTED	Stock	13.32	13.38	13.32	13.37	2767.0
2017-04-04	ABEO	Stock	126.25	130.0	126.25	127.5	6048.0
2017-04-04	ABEV	Stock	5.71	5.79	5.69	5.78	8740100.0
2017-04-04	ABG	Stock	57.45	57.55	56.25	56.75	279400.0
2017-04-04	ABIL-DELISTED	Stock	1.845	1.8799	1.6	1.81	33174.0
2017-04-04	ABM	Stock	42.36	42.61	42.29	42.54	227200.0
2017-04-04	ABMD-DELISTED	Stock	125.15	126.26	123.6	124.1	267206.0

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

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