PREVIEW / stock_daily / 2018-03-22

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-22.parquet
  size:    217 KB
  rows:    6,489
  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-03-22	AAPL	Stock	42.5	43.17	42.15	42.2125	165963200.0
2018-03-22	MSFT	Stock	91.27	91.75	89.66	89.79	38604700.0
2018-03-22	NVDA	Stock	6.15	6.197	6.0085	6.0463	551196000.0
2018-03-22	AMZN	Stock	78.2735	78.6925	77.12	77.246	126412000.0
2018-03-22	GOOGL	Stock	54.0005	54.196	52.482	52.6575	69312160.0
2018-03-22	META	Stock	166.13	170.27	163.72	164.89	73743000.0
2018-03-22	TSLA	Stock	20.926	21.2547	20.5453	20.6067	74097000.0
2018-03-22	TLT	Stock	120.31	120.82	119.67	120.26	12136574.0
2018-03-22	ES	Stock	57.59	58.81	57.28	57.51	1967700.0
2018-03-22	CL	Stock	68.55	69.58	68.55	68.82	4115800.0
2018-03-22	A	Stock	68.7	69.2	67.33	67.47	1690000.0
2018-03-22	AA	Stock	47.4	48.089	44.86	44.92	4370000.0
2018-03-22	AABA-DELISTED	Stock	76.52	77.17	74.345	74.59	6442693.0
2018-03-22	AAC-DELISTED	Stock	12.62	12.9	12.48	12.49	49609.0
2018-03-22	AACG	Stock	5.25	5.28	5.22	5.22	4200.0
2018-03-22	AAIC-DELISTED	Stock	11.57	11.7565	11.55	11.6	635531.0
2018-03-22	AAL	Stock	53.58	54.18	52.29	52.31	4871300.0
2018-03-22	AAM.A-DELISTED	Stock	25.05	25.14	25.05	25.0799	35954.0
2018-03-22	AAMC-DELISTED	Stock	17.6324	17.7	17.6324	17.7	5998.0
2018-03-22	AAME	Stock	3.1	3.25	3.1	3.1	700.0
2018-03-22	AAMI	Stock	15.71	15.8	15.46	15.5	969100.0
2018-03-22	AAOI	Stock	26.5	26.97	25.91	25.96	947900.0
2018-03-22	AAON	Stock	25.9333	26.8333	25.6	25.7	488850.0
2018-03-22	AAP	Stock	114.02	115.14	111.63	111.71	1042400.0
2018-03-22	AAT	Stock	32.39	32.95	32.39	32.52	379600.0
2018-03-22	AAU-DELISTED	Stock	0.85	0.85	0.82	0.8348	53389.0
2018-03-22	AAUAF-DELISTED	Stock	0.85	0.85	0.82	0.8323	62242.0
2018-03-22	AAV-DELISTED	Stock	3.1	3.175	3.0	3.125	644246.0
2018-03-22	AAWW-DELISTED	Stock	62.75	63.05	60.95	61.65	301444.0
2018-03-22	AAXJ	Stock	77.75	77.99	76.784	76.82	812752.0
2018-03-22	AAXN-DELISTED	Stock	38.56	39.3	38.31	38.56	776060.0
2018-03-22	AB	Stock	26.2	26.55	25.75	25.9	388000.0
2018-03-22	ABAC-DELISTED	Stock	2.3775	2.42	2.3775	2.42	300.0
2018-03-22	ABAX-DELISTED	Stock	73.11	74.58	72.19	72.49	95477.0
2018-03-22	ABB-DELISTED	Stock	23.63	23.64	23.14	23.16	2585910.0
2018-03-22	ABBNY-DELISTED	Stock	23.63	23.64	23.14	23.17	2666762.0
2018-03-22	ABBV	Stock	104.19	104.5	95.52	98.1	26861200.0
2018-03-22	ABC-DELISTED	Stock	88.4	88.4	84.66	84.94	4316701.0
2018-03-22	ABCB	Stock	55.4	55.65	53.85	53.85	291100.0
2018-03-22	ABCD-DELISTED	Stock	10.0	10.55	9.7785	10.28	235764.0
2018-03-22	ABDC-DELISTED	Stock	7.08	7.08	6.61	6.93	201562.0
2018-03-22	ABE-DELISTED	Stock	14.91	14.91	14.8434	14.8434	1718.0
2018-03-22	ABEO	Stock	385.0	392.5	370.0	370.0	26540.0
2018-03-22	ABEV	Stock	7.19	7.25	7.12	7.18	11190300.0
2018-03-22	ABG	Stock	64.65	65.85	64.15	64.15	149900.0
2018-03-22	ABIL-DELISTED	Stock	0.39	0.39	0.3233	0.34	173588.0
2018-03-22	ABLX-DELISTED	Stock	54.01	54.09	53.4	53.8	27061.0
2018-03-22	ABM	Stock	34.19	34.64	33.54	33.54	644000.0
2018-03-22	ABMD-DELISTED	Stock	289.64	291.57	285.95	286.39	291548.0
2018-03-22	ABR	Stock	8.87	8.91	8.79	8.81	602700.0

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

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