PREVIEW / stock_daily / 2018-09-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-18.parquet
  size:    219 KB
  rows:    6,544
  symbols: 2,761

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-09-18	AAPL	Stock	54.4475	55.4625	54.28	54.56	126286800.0
2018-09-18	MSFT	Stock	112.19	113.7	111.72	113.21	22170900.0
2018-09-18	NVDA	Stock	6.8522	6.956	6.7688	6.7755	299520000.0
2018-09-18	AMZN	Stock	95.9325	97.91	95.772	97.0525	85374000.0
2018-09-18	GOOGL	Stock	58.133	59.0665	58.0712	58.3555	32314020.0
2018-09-18	META	Stock	159.39	161.76	158.87	160.3	22465200.0
2018-09-18	TSLA	Stock	19.7793	20.176	18.3667	18.9973	248212500.0
2018-09-18	TLT	Stock	118.06	118.065	117.16	117.31	10182303.0
2018-09-18	ES	Stock	63.62	63.88	63.35	63.64	807600.0
2018-09-18	CL	Stock	68.76	68.86	68.19	68.26	2625300.0
2018-09-18	A	Stock	69.1	69.27	68.41	68.93	1780400.0
2018-09-18	AA	Stock	43.49	43.8	42.73	43.12	2707100.0
2018-09-18	AABA-DELISTED	Stock	65.32	66.08	64.53	64.97	7394934.0
2018-09-18	AAC-DELISTED	Stock	7.36	7.6	7.23	7.24	106151.0
2018-09-18	AACG	Stock	1.3	1.3	1.25	1.25	87500.0
2018-09-18	AAIC-DELISTED	Stock	10.13	10.15	10.04	10.14	379361.0
2018-09-18	AAL	Stock	40.36	40.86	39.65	40.79	5548300.0
2018-09-18	AAM.A-DELISTED	Stock	25.33	25.33	25.26	25.289	16073.0
2018-09-18	AAM.B-DELISTED	Stock	24.86	24.89	24.8	24.86	74688.0
2018-09-18	AAME	Stock	2.95	2.95	2.95	2.95	900.0
2018-09-18	AAMI	Stock	12.59	12.76	12.59	12.7	476300.0
2018-09-18	AAOI	Stock	33.83	34.42	32.5	32.54	1230200.0
2018-09-18	AAON	Stock	27.1	27.2	26.4867	26.6333	172200.0
2018-09-18	AAP	Stock	159.75	167.8	159.0	167.65	1272400.0
2018-09-18	AAT	Stock	38.51	38.58	38.28	38.28	248800.0
2018-09-18	AAU-DELISTED	Stock	0.67	0.67	0.64	0.6466	67371.0
2018-09-18	AAUAF-DELISTED	Stock	0.67	0.67	0.64	0.6466	69386.0
2018-09-18	AAV-DELISTED	Stock	2.6	2.6	2.5	2.55	88525.0
2018-09-18	AAWW-DELISTED	Stock	63.55	63.95	62.7	63.35	201920.0
2018-09-18	AAXJ	Stock	69.06	69.46	69.06	69.34	343103.0
2018-09-18	AAXN-DELISTED	Stock	69.05	70.75	68.95	69.07	458142.0
2018-09-18	AB	Stock	30.45	30.53	29.6	30.1	432700.0
2018-09-18	ABAC-DELISTED	Stock	2.4	2.46	2.2	2.255	20515.0
2018-09-18	ABB-DELISTED	Stock	23.9	24.0474	23.8946	24.01	1444431.0
2018-09-18	ABBNY-DELISTED	Stock	23.9	24.0474	23.8946	24.01	1509077.0
2018-09-18	ABBV	Stock	95.35	96.06	92.41	92.61	10240500.0
2018-09-18	ABC-DELISTED	Stock	86.56	88.06	86.32	87.33	866995.0
2018-09-18	ABCB	Stock	47.35	47.65	46.9	47.0	324600.0
2018-09-18	ABCD-DELISTED	Stock	12.54	12.64	12.34	12.45	57834.0
2018-09-18	ABDC-DELISTED	Stock	6.42	6.4361	6.22	6.22	42468.0
2018-09-18	ABEO	Stock	353.75	356.25	337.5	342.5	15368.0
2018-09-18	ABEOW-DELISTED	Stock	8.6	8.6	8.55	8.55	1500.0
2018-09-18	ABEV	Stock	4.47	4.61	4.45	4.56	35124700.0
2018-09-18	ABG	Stock	71.05	71.4	70.45	70.75	333400.0
2018-09-18	ABIL-DELISTED	Stock	3.53	3.7199	3.31	3.41	172110.0
2018-09-18	ABM	Stock	34.62	35.16	34.6	34.99	610500.0
2018-09-18	ABMD-DELISTED	Stock	369.06	380.64	368.55	376.76	441672.0
2018-09-18	ABR	Stock	12.02	12.09	11.98	11.99	894700.0
2018-09-18	ABR.A-DELISTED	Stock	25.8756	25.8756	25.83	25.83	829.0
2018-09-18	ABR.B-DELISTED	Stock	25.44	25.6	25.43	25.6	1500.0

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

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