PREVIEW / stock_daily / 2018-11-30

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-30.parquet
  size:    223 KB
  rows:    6,628
  symbols: 2,747

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-11-30	AAPL	Stock	45.0725	45.0825	44.2575	44.645	158126000.0
2018-11-30	MSFT	Stock	110.7	110.97	109.36	110.89	33665600.0
2018-11-30	NVDA	Stock	3.9438	4.0965	3.893	4.0858	729564000.0
2018-11-30	AMZN	Stock	83.975	84.8	83.325	84.5085	115236000.0
2018-11-30	GOOGL	Stock	54.7815	55.4825	54.159	55.4825	59666800.0
2018-11-30	META	Stock	138.26	140.97	137.36	140.61	25732600.0
2018-11-30	TSLA	Stock	22.7887	23.44	22.5507	23.3653	84436500.0
2018-11-30	TLT	Stock	115.31	115.42	114.98	115.33	9126693.0
2018-11-30	ES	Stock	67.29	68.39	67.04	68.34	3012100.0
2018-11-30	CL	Stock	62.83	63.59	62.7	63.52	3568700.0
2018-11-30	A	Stock	71.63	72.65	71.34	72.35	2279500.0
2018-11-30	AA	Stock	31.04	32.46	30.942	31.81	5353800.0
2018-11-30	AABA-DELISTED	Stock	64.55	65.74	64.52	65.65	7675320.0
2018-11-30	AAC-DELISTED	Stock	2.0	2.1	1.95	1.97	245136.0
2018-11-30	AACG	Stock	1.07	1.13	1.06	1.09	63800.0
2018-11-30	AAIC-DELISTED	Stock	8.49	8.59	8.43	8.59	278351.0
2018-11-30	AAL	Stock	38.42	40.2	38.42	40.16	10015700.0
2018-11-30	AAM.A-DELISTED	Stock	23.26	23.26	23.17	23.17	37586.0
2018-11-30	AAM.B-DELISTED	Stock	23.27	23.45	23.15	23.45	90071.0
2018-11-30	AAMC-DELISTED	Stock	14.1088	14.7059	14.0618	14.2382	12478.0
2018-11-30	AAME	Stock	2.85	2.88	2.61	2.83	6200.0
2018-11-30	AAMI	Stock	13.04	13.17	13.0	13.17	382100.0
2018-11-30	AAOI	Stock	20.29	20.59	19.94	20.59	574000.0
2018-11-30	AAON	Stock	25.38	26.3667	25.1667	25.3	301050.0
2018-11-30	AAP	Stock	177.78	178.91	175.01	177.71	1399600.0
2018-11-30	AAT	Stock	40.79	41.78	40.79	41.62	444000.0
2018-11-30	AAU-DELISTED	Stock	0.51	0.6	0.51	0.5705	417022.0
2018-11-30	AAUAF-DELISTED	Stock	0.51	0.6	0.51	0.5705	424056.0
2018-11-30	AAWW-DELISTED	Stock	52.45	53.64	52.45	53.295	142913.0
2018-11-30	AAXJ	Stock	66.45	66.78	66.21	66.77	1421597.0
2018-11-30	AAXN-DELISTED	Stock	43.71	44.28	42.83	43.48	1092203.0
2018-11-30	AB	Stock	30.0	30.52	30.0	30.21	245400.0
2018-11-30	ABAC-DELISTED	Stock	1.5212	1.6107	1.44	1.61	26786.0
2018-11-30	ABB-DELISTED	Stock	20.16	20.34	20.14	20.265	1714358.0
2018-11-30	ABBNY-DELISTED	Stock	20.16	20.34	20.14	20.28	1770568.0
2018-11-30	ABBV	Stock	90.26	94.27	89.87	94.27	12031700.0
2018-11-30	ABC-DELISTED	Stock	90.68	90.87	87.67	88.9	1726187.0
2018-11-30	ABCB	Stock	42.57	43.1	42.55	42.83	235600.0
2018-11-30	ABCD-DELISTED	Stock	14.47	14.48	14.46	14.48	177609.0
2018-11-30	ABDC-DELISTED	Stock	6.55	6.569	6.43	6.5	24098.0
2018-11-30	ABEO	Stock	195.5	205.75	194.0	205.0	25988.0
2018-11-30	ABEOW-DELISTED	Stock	4.1	4.2	4.1	4.2	4500.0
2018-11-30	ABEV	Stock	4.26	4.32	4.22	4.27	21731300.0
2018-11-30	ABG	Stock	69.07	69.86	68.66	69.12	253300.0
2018-11-30	ABIL-DELISTED	Stock	2.67	2.77	2.62	2.6949	335979.0
2018-11-30	ABM	Stock	31.2	31.8	31.07	31.68	388400.0
2018-11-30	ABMD-DELISTED	Stock	334.36	335.98	329.04	332.66	352173.0
2018-11-30	ABR	Stock	11.83	11.99	11.83	11.85	6123100.0
2018-11-30	ABR.A-DELISTED	Stock	25.4929	25.5159	25.4929	25.5159	548.0
2018-11-30	ABR.B-DELISTED	Stock	25.1292	25.2	25.1292	25.1735	5223.0

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

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