PREVIEW / stock_daily / 2018-04-04

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-04.parquet
  size:    216 KB
  rows:    6,487
  symbols: 2,840

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
2018-04-04	AAPL	Stock	41.22	43.0025	41.1925	42.9025	138422000.0
2018-04-04	MSFT	Stock	87.85	92.76	87.73	92.33	35560000.0
2018-04-04	NVDA	Stock	5.3752	5.6665	5.35	5.656	789168000.0
2018-04-04	AMZN	Stock	67.912	70.7695	67.644	70.5285	139646000.0
2018-04-04	GOOGL	Stock	49.9115	51.637	49.8255	51.4855	50723960.0
2018-04-04	META	Stock	152.03	155.56	150.51	155.1	49885600.0
2018-04-04	TSLA	Stock	16.852	19.2247	16.8	19.1293	298450500.0
2018-04-04	TLT	Stock	121.35	121.46	120.6	120.69	6654312.0
2018-04-04	ES	Stock	59.12	59.8	58.77	59.53	2609400.0
2018-04-04	CL	Stock	70.52	72.01	70.32	71.65	3569200.0
2018-04-04	A	Stock	64.15	65.65	63.65	65.45	5084100.0
2018-04-04	AA	Stock	44.4	47.07	44.21	46.92	3667500.0
2018-04-04	AABA-DELISTED	Stock	68.19	69.56	67.95	69.5169	7104608.0
2018-04-04	AAC-DELISTED	Stock	11.03	11.4	10.82	11.31	99121.0
2018-04-04	AACG	Stock	5.15	5.38	5.15	5.25	17000.0
2018-04-04	AAIC-DELISTED	Stock	10.95	11.26	10.94	11.21	466506.0
2018-04-04	AAL	Stock	50.6	52.1	50.51	52.04	3955000.0
2018-04-04	AAM.A-DELISTED	Stock	24.9205	25.0	24.9205	25.0	22552.0
2018-04-04	AAM.B-DELISTED	Stock	24.76	24.98	24.76	24.97	108975.0
2018-04-04	AAME	Stock	3.44	3.45	3.22	3.45	700.0
2018-04-04	AAMI	Stock	15.09	15.57	15.08	15.53	357900.0
2018-04-04	AAOI	Stock	23.01	24.61	22.54	24.29	919000.0
2018-04-04	AAON	Stock	23.8667	24.2333	23.6333	23.9	479550.0
2018-04-04	AAP	Stock	110.09	114.98	109.82	114.48	851900.0
2018-04-04	AAT	Stock	33.98	34.61	33.8	34.51	324500.0
2018-04-04	AAU-DELISTED	Stock	0.8128	0.8128	0.7966	0.8	185107.0
2018-04-04	AAUAF-DELISTED	Stock	0.8128	0.8128	0.7966	0.8	189842.0
2018-04-04	AAV-DELISTED	Stock	3.0	3.1	2.975	3.1	592914.0
2018-04-04	AAWW-DELISTED	Stock	59.75	61.55	58.95	61.2	152118.0
2018-04-04	AAXJ	Stock	74.89	76.96	74.7	76.86	647772.0
2018-04-04	AAXN-DELISTED	Stock	41.91	42.65	40.56	41.98	1305803.0
2018-04-04	AB	Stock	25.95	26.7	25.95	26.65	221900.0
2018-04-04	ABAC-DELISTED	Stock	2.25	2.39	2.21	2.311	21339.0
2018-04-04	ABAX-DELISTED	Stock	67.77	70.57	67.77	70.18	63603.0
2018-04-04	ABB-DELISTED	Stock	22.1	22.29	21.92	22.27	4002354.0
2018-04-04	ABBNY-DELISTED	Stock	22.12	22.29	21.92	22.28	5624316.0
2018-04-04	ABBV	Stock	88.71	93.41	88.63	92.94	8841700.0
2018-04-04	ABC-DELISTED	Stock	82.76	86.68	82.72	86.25	1309941.0
2018-04-04	ABCB	Stock	52.4	53.78	52.4	53.6	159200.0
2018-04-04	ABCD-DELISTED	Stock	10.8	11.38	10.55	11.33	258274.0
2018-04-04	ABDC-DELISTED	Stock	6.95	7.224	6.95	7.09	63578.0
2018-04-04	ABE-DELISTED	Stock	14.58	14.75	14.58	14.75	6122.0
2018-04-04	ABEO	Stock	345.0	378.75	345.0	378.75	28988.0
2018-04-04	ABEV	Stock	7.09	7.24	7.06	7.21	16229300.0
2018-04-04	ABG	Stock	62.95	66.6	62.95	66.35	149800.0
2018-04-04	ABIL-DELISTED	Stock	2.79	3.0899	2.37	2.73	89306.0
2018-04-04	ABLX-DELISTED	Stock	54.7	54.85	54.58	54.63	45301.0
2018-04-04	ABM	Stock	32.77	33.42	32.66	33.38	748100.0
2018-04-04	ABMD-DELISTED	Stock	277.93	289.23	275.39	288.31	288558.0
2018-04-04	ABR	Stock	8.73	8.81	8.72	8.79	503800.0

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

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