PREVIEW / stock_daily / 2019-03-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-19.parquet
  size:    220 KB
  rows:    6,527
  symbols: 2,599

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
2019-03-19	AAPL	Stock	47.0875	47.2475	46.48	46.6325	126585600.0
2019-03-19	MSFT	Stock	118.09	118.44	116.99	117.65	37588700.0
2019-03-19	NVDA	Stock	4.319	4.4375	4.302	4.3928	854972000.0
2019-03-19	AMZN	Stock	87.6755	89.208	87.6755	88.0925	127284000.0
2019-03-19	GOOGL	Stock	59.586	60.1702	59.4728	60.123	29788140.0
2019-03-19	META	Stock	161.48	163.82	160.82	161.57	25611500.0
2019-03-19	TSLA	Stock	17.8333	18.22	17.564	17.8313	177009000.0
2019-03-19	TLT	Stock	121.09	121.615	120.89	121.41	5220325.0
2019-03-19	ES	Stock	71.07	71.12	70.0	70.2	1690500.0
2019-03-19	CL	Stock	66.21	66.21	65.43	65.75	4623600.0
2019-03-19	A	Stock	81.27	81.77	81.03	81.2	1172600.0
2019-03-19	AA	Stock	29.03	29.32	28.49	28.62	2459700.0
2019-03-19	AABA-DELISTED	Stock	73.78	74.435	73.56	73.96	4152122.0
2019-03-19	AAC-DELISTED	Stock	2.46	2.51	2.4	2.41	94549.0
2019-03-19	AACG	Stock	1.08	1.08	1.0	1.06	122800.0
2019-03-19	AAIC-DELISTED	Stock	8.39	8.48	8.34	8.41	800216.0
2019-03-19	AAIC.C-DELISTED	Stock	23.39	23.44	23.33	23.4	51310.0
2019-03-19	AAL	Stock	31.5	32.12	31.38	31.59	6824500.0
2019-03-19	AAM.A-DELISTED	Stock	25.15	25.15	25.01	25.01	20035.0
2019-03-19	AAM.B-DELISTED	Stock	25.04	25.04	24.85	24.94	34980.0
2019-03-19	AAMC-DELISTED	Stock	10.2971	10.2971	10.2971	10.2971	938.0
2019-03-19	AAME	Stock	2.84	2.87	2.81	2.83	2000.0
2019-03-19	AAMI	Stock	13.93	14.1	13.61	13.62	364000.0
2019-03-19	AAOI	Stock	14.17	14.17	13.77	13.82	461300.0
2019-03-19	AAON	Stock	28.6667	28.7867	28.3133	28.58	116250.0
2019-03-19	AAP	Stock	161.44	164.93	161.17	163.42	1371600.0
2019-03-19	AAT	Stock	45.67	45.74	45.1	45.12	177300.0
2019-03-19	AAU-DELISTED	Stock	0.572	0.6011	0.572	0.6011	170170.0
2019-03-19	AAUAF-DELISTED	Stock	0.572	0.6011	0.572	0.6011	173958.0
2019-03-19	AAWW-DELISTED	Stock	50.16	50.16	48.8	49.06	115134.0
2019-03-19	AAXJ	Stock	71.07	71.26	70.83	71.08	1143997.0
2019-03-19	AAXN-DELISTED	Stock	51.28	53.24	51.0766	52.06	975836.0
2019-03-19	AB	Stock	29.54	29.64	29.04	29.07	175000.0
2019-03-19	ABB-DELISTED	Stock	19.7	19.74	19.51	19.545	2411621.0
2019-03-19	ABBNY-DELISTED	Stock	19.69	19.74	19.51	19.55	2497103.0
2019-03-19	ABBV	Stock	80.33	81.29	79.51	80.82	6335500.0
2019-03-19	ABC-DELISTED	Stock	80.49	81.7	80.38	81.09	699368.0
2019-03-19	ABCB	Stock	38.57	38.59	36.9	37.04	385800.0
2019-03-19	ABDC-DELISTED	Stock	7.58	7.7	7.58	7.6	36503.0
2019-03-19	ABEO	Stock	202.25	202.5	195.75	198.5	16288.0
2019-03-19	ABEV	Stock	4.53	4.59	4.5	4.53	24515100.0
2019-03-19	ABG	Stock	69.26	69.5	68.16	68.43	131000.0
2019-03-19	ABIL-DELISTED	Stock	2.0	2.0	1.86	1.915	163978.0
2019-03-19	ABM	Stock	34.78	35.17	34.54	34.73	443900.0
2019-03-19	ABMD-DELISTED	Stock	334.6	339.95	330.99	339.47	236824.0
2019-03-19	ABR	Stock	12.96	12.97	12.75	12.81	600500.0
2019-03-19	ABR.A-DELISTED	Stock	25.7265	25.7286	25.6388	25.6759	690.0
2019-03-19	ABR.B-DELISTED	Stock	25.32	25.4995	25.32	25.4995	8230.0
2019-03-19	ABR.C-DELISTED	Stock	25.63	25.83	25.59	25.8	2497.0
2019-03-19	ABT	Stock	79.18	80.25	79.02	79.96	6048600.0

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

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