PREVIEW / stock_daily / 2018-04-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-06.parquet
  size:    216 KB
  rows:    6,442
  symbols: 2,809

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-06	AAPL	Stock	42.7425	43.12	42.05	42.095	140021200.0
2018-04-06	MSFT	Stock	91.49	92.46	89.48	90.23	38026000.0
2018-04-06	NVDA	Stock	5.4308	5.54	5.3268	5.3562	662988000.0
2018-04-06	AMZN	Stock	71.4985	72.625	70.013	70.2615	117646000.0
2018-04-06	GOOGL	Stock	51.155	51.8	50.3125	50.4975	40133660.0
2018-04-06	META	Stock	157.73	161.42	156.81	157.2	41644800.0
2018-04-06	TSLA	Stock	20.0667	20.6187	19.7	19.9533	202804500.0
2018-04-06	TLT	Stock	120.66	121.15	120.2199	121.1	8831225.0
2018-04-06	ES	Stock	60.06	60.41	59.44	59.65	1769300.0
2018-04-06	CL	Stock	71.65	72.41	71.14	71.64	2922600.0
2018-04-06	A	Stock	65.01	65.56	63.38	63.65	3578600.0
2018-04-06	AA	Stock	47.18	48.74	47.1	48.05	4066400.0
2018-04-06	AABA-DELISTED	Stock	68.48	69.48	67.38	67.55	7273887.0
2018-04-06	AAC-DELISTED	Stock	11.61	11.77	11.33	11.48	49667.0
2018-04-06	AACG	Stock	5.3	5.33	5.3	5.3	13700.0
2018-04-06	AAIC-DELISTED	Stock	11.29	11.5	11.29	11.35	643913.0
2018-04-06	AAL	Stock	51.71	51.96	49.81	50.29	4302600.0
2018-04-06	AAM.A-DELISTED	Stock	24.91	24.95	24.81	24.89	21169.0
2018-04-06	AAM.B-DELISTED	Stock	24.84	24.9	24.75	24.8	147398.0
2018-04-06	AAMC-DELISTED	Stock	18.5294	18.5294	18.3676	18.3676	3009.0
2018-04-06	AAME	Stock	3.44	3.44	3.35	3.35	1000.0
2018-04-06	AAMI	Stock	15.19	15.31	14.73	14.84	549500.0
2018-04-06	AAOI	Stock	24.5	24.977	23.75	24.09	597100.0
2018-04-06	AAON	Stock	23.3667	23.5333	22.7	22.8667	392100.0
2018-04-06	AAP	Stock	115.63	116.37	110.77	111.91	1291200.0
2018-04-06	AAT	Stock	34.77	35.04	34.28	34.43	502600.0
2018-04-06	AAU-DELISTED	Stock	0.8	0.8145	0.79	0.7925	86450.0
2018-04-06	AAUAF-DELISTED	Stock	0.8	0.8145	0.79	0.7925	95053.0
2018-04-06	AAV-DELISTED	Stock	3.2	3.3	3.1	3.15	785030.0
2018-04-06	AAWW-DELISTED	Stock	62.45	63.17	60.25	60.8	116068.0
2018-04-06	AAXJ	Stock	76.33	76.78	75.06	75.37	3235501.0
2018-04-06	AAXN-DELISTED	Stock	42.47	42.95	41.55	41.85	874929.0
2018-04-06	AB	Stock	26.55	26.7	26.08	26.35	342000.0
2018-04-06	ABAC-DELISTED	Stock	2.4661	2.49	2.4183	2.45	14972.0
2018-04-06	ABAX-DELISTED	Stock	70.39	71.15	68.21	68.85	101223.0
2018-04-06	ABB-DELISTED	Stock	22.57	22.715	22.17	22.33	2014430.0
2018-04-06	ABBNY-DELISTED	Stock	22.57	22.715	22.17	22.32	2192111.0
2018-04-06	ABBV	Stock	91.45	92.77	88.79	89.78	6761200.0
2018-04-06	ABC-DELISTED	Stock	86.29	87.08	84.62	85.42	1382556.0
2018-04-06	ABCB	Stock	53.25	53.55	51.5	52.0	210200.0
2018-04-06	ABCD-DELISTED	Stock	11.29	11.51	10.86	11.1	220805.0
2018-04-06	ABDC-DELISTED	Stock	7.18	7.25	7.13	7.16	59042.0
2018-04-06	ABE-DELISTED	Stock	14.9	14.9	14.738	14.7899	3308.0
2018-04-06	ABEO	Stock	358.75	360.0	347.5	350.0	23504.0
2018-04-06	ABEV	Stock	6.95	6.99	6.75	6.86	43694000.0
2018-04-06	ABG	Stock	67.4	68.45	65.95	66.5	275900.0
2018-04-06	ABIL-DELISTED	Stock	2.61	2.92	2.54	2.7301	41521.0
2018-04-06	ABLX-DELISTED	Stock	54.61	54.655	54.52	54.61	28753.0
2018-04-06	ABM	Stock	33.27	33.49	32.34	32.63	675800.0
2018-04-06	ABMD-DELISTED	Stock	290.16	294.075	282.37	286.22	250270.0

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

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