PREVIEW / stock_daily / 2018-08-31

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-31.parquet
  size:    219 KB
  rows:    6,515
  symbols: 2,751

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-08-31	AAPL	Stock	56.6275	57.2175	56.5	56.9075	173360400.0
2018-08-31	MSFT	Stock	111.69	112.78	111.52	112.33	23222700.0
2018-08-31	NVDA	Stock	6.925	7.03	6.915	7.017	306592000.0
2018-08-31	AMZN	Stock	100.35	101.119	100.237	100.6355	84088000.0
2018-08-31	GOOGL	Stock	62.6105	62.6272	61.2877	61.59	42308480.0
2018-08-31	META	Stock	177.15	177.62	174.98	175.73	18065200.0
2018-08-31	TSLA	Stock	20.1333	20.354	19.9067	20.1107	80626500.0
2018-08-31	TLT	Stock	121.89	121.92	120.89	120.995	9677540.0
2018-08-31	ES	Stock	62.56	62.84	62.1	62.43	1291900.0
2018-08-31	CL	Stock	66.2	66.48	65.93	66.41	3257200.0
2018-08-31	A	Stock	67.14	67.55	67.05	67.54	1582400.0
2018-08-31	AA	Stock	44.1	45.04	44.04	44.67	2028600.0
2018-08-31	AABA-DELISTED	Stock	68.9	69.93	68.732	69.58	5456310.0
2018-08-31	AAC-DELISTED	Stock	8.78	9.02	8.6	8.86	92160.0
2018-08-31	AACG	Stock	2.12	2.19	2.02	2.17	496200.0
2018-08-31	AAIC-DELISTED	Stock	10.21	10.21	10.13	10.17	321715.0
2018-08-31	AAL	Stock	40.25	40.55	40.18	40.48	3464000.0
2018-08-31	AAM.A-DELISTED	Stock	25.5969	25.79	25.5969	25.73	13466.0
2018-08-31	AAM.B-DELISTED	Stock	25.16	25.21	25.1	25.2	99008.0
2018-08-31	AAMC-DELISTED	Stock	18.0294	18.6176	18.0294	18.25	6766.0
2018-08-31	AAME	Stock	2.75	2.75	2.75	2.75	1000.0
2018-08-31	AAMI	Stock	12.56	12.71	12.46	12.69	337900.0
2018-08-31	AAOI	Stock	41.51	41.87	41.221	41.36	380800.0
2018-08-31	AAON	Stock	27.0333	27.2733	26.5333	26.9333	351450.0
2018-08-31	AAP	Stock	161.47	164.34	161.47	164.03	960700.0
2018-08-31	AAT	Stock	39.15	39.56	39.15	39.5	149800.0
2018-08-31	AAU-DELISTED	Stock	0.63	0.6575	0.63	0.6418	79925.0
2018-08-31	AAUAF-DELISTED	Stock	0.63	0.6575	0.63	0.6418	87633.0
2018-08-31	AAV-DELISTED	Stock	3.05	3.1	2.9	2.95	100569.0
2018-08-31	AAWW-DELISTED	Stock	61.55	62.0	60.7	60.85	167167.0
2018-08-31	AAXJ	Stock	71.02	71.67	70.99	71.43	867285.0
2018-08-31	AAXN-DELISTED	Stock	66.24	68.485	66.24	68.24	331609.0
2018-08-31	AB	Stock	29.9	30.22	29.76	30.05	169400.0
2018-08-31	ABAC-DELISTED	Stock	1.73	1.75	1.71	1.75	970.0
2018-08-31	ABB-DELISTED	Stock	23.52	23.62	23.395	23.5	2055725.0
2018-08-31	ABBNY-DELISTED	Stock	23.52	23.62	23.395	23.51	2268647.0
2018-08-31	ABBV	Stock	96.25	96.69	95.72	95.98	4703100.0
2018-08-31	ABC-DELISTED	Stock	89.7	90.04	89.17	89.96	726397.0
2018-08-31	ABCB	Stock	49.05	49.8	48.95	49.65	271300.0
2018-08-31	ABCD-DELISTED	Stock	13.41	13.57	13.31	13.36	52920.0
2018-08-31	ABDC-DELISTED	Stock	6.09	6.2	6.05	6.2	30275.0
2018-08-31	ABEO	Stock	373.75	391.25	373.75	385.0	15004.0
2018-08-31	ABEOW-DELISTED	Stock	10.4	10.4	10.4	10.4	200.0
2018-08-31	ABEV	Stock	4.58	4.66	4.52	4.65	38052100.0
2018-08-31	ABG	Stock	74.35	74.9	73.95	74.5	101300.0
2018-08-31	ABIL-DELISTED	Stock	3.8	3.92	3.6212	3.79	56777.0
2018-08-31	ABM	Stock	31.54	31.76	31.37	31.72	327700.0
2018-08-31	ABMD-DELISTED	Stock	406.78	415.86	402.2	406.55	344241.0
2018-08-31	ABR	Stock	12.14	12.26	12.09	12.26	921700.0
2018-08-31	ABR.A-DELISTED	Stock	25.98	25.98	25.94	25.94	623.0

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

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