PREVIEW / stock_daily / 2018-10-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-08.parquet
  size:    220 KB
  rows:    6,518
  symbols: 2,718

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-10-08	AAPL	Stock	55.5525	56.2	55.05	55.9425	118655600.0
2018-10-08	MSFT	Stock	111.66	112.03	109.34	110.85	29640600.0
2018-10-08	NVDA	Stock	6.6625	6.779	6.502	6.6442	408612000.0
2018-10-08	AMZN	Stock	93.7	95.1	91.533	93.221	147864000.0
2018-10-08	GOOGL	Stock	58.0	58.793	56.77	57.796	46190780.0
2018-10-08	META	Stock	155.54	158.34	154.39	157.25	24046000.0
2018-10-08	TSLA	Stock	17.6347	17.8507	16.6	16.704	202090500.0
2018-10-08	TLT	Stock	112.99	113.11	112.64	112.66	5855890.0
2018-10-08	ES	Stock	62.65	63.23	62.24	62.83	1316200.0
2018-10-08	CL	Stock	64.66	65.55	64.51	65.35	4090800.0
2018-10-08	A	Stock	69.96	70.05	68.97	69.5	2179400.0
2018-10-08	AA	Stock	41.0	41.01	38.27	38.74	7466700.0
2018-10-08	AABA-DELISTED	Stock	63.23	63.82	62.44	63.09	8697421.0
2018-10-08	AAC-DELISTED	Stock	6.97	7.14	6.97	7.08	92305.0
2018-10-08	AACG	Stock	1.15	1.15	1.08	1.08	37300.0
2018-10-08	AAIC-DELISTED	Stock	8.89	8.97	8.85	8.93	204176.0
2018-10-08	AAL	Stock	36.44	36.85	35.6	35.9	7879300.0
2018-10-08	AAM.A-DELISTED	Stock	24.17	24.1876	23.99	24.155	16364.0
2018-10-08	AAM.B-DELISTED	Stock	24.1	24.15	23.72	24.0641	44140.0
2018-10-08	AAMC-DELISTED	Stock	17.1676	17.1676	15.3265	15.3265	6803.0
2018-10-08	AAME	Stock	2.74	2.74	2.37	2.55	3300.0
2018-10-08	AAMI	Stock	12.54	12.945	12.415	12.93	764100.0
2018-10-08	AAOI	Stock	23.73	24.23	22.12	22.85	1107800.0
2018-10-08	AAON	Stock	22.8	23.4267	22.5667	23.0933	383850.0
2018-10-08	AAP	Stock	165.4	169.16	165.4	168.36	784700.0
2018-10-08	AAT	Stock	36.7	37.52	36.7	37.45	154300.0
2018-10-08	AAU-DELISTED	Stock	0.59	0.6089	0.581	0.599	301649.0
2018-10-08	AAUAF-DELISTED	Stock	0.59	0.6089	0.581	0.599	304164.0
2018-10-08	AAWW-DELISTED	Stock	59.3	59.84	58.42	59.5	186179.0
2018-10-08	AAXJ	Stock	65.68	66.31	65.58	66.19	536247.0
2018-10-08	AAXN-DELISTED	Stock	62.46	64.335	61.55	63.41	565946.0
2018-10-08	AB	Stock	30.43	30.59	30.1	30.27	216800.0
2018-10-08	ABAC-DELISTED	Stock	1.837	1.89	1.837	1.89	1025.0
2018-10-08	ABB-DELISTED	Stock	22.32	22.5	22.265	22.48	1282159.0
2018-10-08	ABBNY-DELISTED	Stock	22.32	22.5	22.265	22.48	1600690.0
2018-10-08	ABBV	Stock	94.07	95.37	93.75	94.81	3305500.0
2018-10-08	ABC-DELISTED	Stock	90.6	92.245	90.6	91.29	983762.0
2018-10-08	ABCB	Stock	45.66	46.23	45.38	45.85	237800.0
2018-10-08	ABCD-DELISTED	Stock	11.51	11.65	11.011	11.5101	67491.0
2018-10-08	ABDC-DELISTED	Stock	6.07	6.09	6.02	6.03	22165.0
2018-10-08	ABEO	Stock	288.0	292.5	271.25	277.75	25248.0
2018-10-08	ABEOW-DELISTED	Stock	6.4	6.4	6.3694	6.4	3300.0
2018-10-08	ABEV	Stock	4.83	4.84	4.74	4.79	44485300.0
2018-10-08	ABG	Stock	62.98	63.83	62.46	63.54	181000.0
2018-10-08	ABIL-DELISTED	Stock	3.44	3.47	3.35	3.4396	24757.0
2018-10-08	ABM	Stock	31.83	32.13	31.71	32.11	701900.0
2018-10-08	ABMD-DELISTED	Stock	414.17	415.55	388.39	398.94	542230.0
2018-10-08	ABR	Stock	11.5	11.56	11.42	11.56	447100.0
2018-10-08	ABR.A-DELISTED	Stock	25.66	25.66	25.36	25.4	6005.0
2018-10-08	ABR.B-DELISTED	Stock	25.25	25.25	25.1406	25.1768	7193.0

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

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