PREVIEW / stock_daily / 2018-01-31

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-31.parquet
  size:    219 KB
  rows:    6,507
  symbols: 2,883

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-01-31	AAPL	Stock	41.7175	42.11	41.625	41.8575	129915600.0
2018-01-31	MSFT	Stock	93.75	95.4	93.51	95.01	48756300.0
2018-01-31	NVDA	Stock	6.1443	6.2318	6.1112	6.145	478576000.0
2018-01-31	AMZN	Stock	72.565	73.629	72.502	72.5445	128494000.0
2018-01-31	GOOGL	Stock	59.1905	59.316	58.605	59.111	36022700.0
2018-01-31	META	Stock	188.37	189.83	185.22	186.89	43275100.0
2018-01-31	TSLA	Stock	23.1673	23.746	23.0127	23.6207	93211500.0
2018-01-31	TLT	Stock	122.87	122.93	121.94	122.73	18045079.0
2018-01-31	ES	Stock	62.63	63.16	62.33	63.09	2518100.0
2018-01-31	CL	Stock	74.77	74.77	73.14	74.24	5458900.0
2018-01-31	A	Stock	73.77	74.39	73.24	73.43	2032800.0
2018-01-31	AA	Stock	52.75	53.36	51.25	52.02	4470100.0
2018-01-31	AAAP-DELISTED	Stock	82.15	82.15	80.24	80.46	208637.0
2018-01-31	AABA-DELISTED	Stock	79.0	80.56	79.0	79.86	5624435.0
2018-01-31	AAC-DELISTED	Stock	9.08	9.25	8.82	8.95	112557.0
2018-01-31	AACG	Stock	5.02	5.02	5.0	5.0	2200.0
2018-01-31	AAIC-DELISTED	Stock	10.82	10.9	10.39	10.5	957352.0
2018-01-31	AAL	Stock	53.08	54.71	53.0	54.32	5962900.0
2018-01-31	AAM.A-DELISTED	Stock	25.2515	25.479	25.13	25.47	26410.0
2018-01-31	AAMI	Stock	18.04	18.04	17.49	17.89	1439800.0
2018-01-31	AAOI	Stock	33.01	33.373	32.14	32.39	701300.0
2018-01-31	AAON	Stock	24.1333	24.4	23.78	24.2667	285300.0
2018-01-31	AAP	Stock	119.86	120.47	115.83	116.99	1235700.0
2018-01-31	AAT	Stock	34.99	35.27	34.76	35.26	223500.0
2018-01-31	AAU-DELISTED	Stock	0.9	0.9	0.88	0.89	139280.0
2018-01-31	AAUAF-DELISTED	Stock	0.9	0.9	0.88	0.89	141554.0
2018-01-31	AAV-DELISTED	Stock	3.3	3.35	3.15	3.2	289140.0
2018-01-31	AAWW-DELISTED	Stock	58.35	58.35	56.2	56.2	179294.0
2018-01-31	AAXJ	Stock	82.28	82.39	81.32	81.78	4074316.0
2018-01-31	AAXN-DELISTED	Stock	27.48	27.585	26.34	26.47	521047.0
2018-01-31	AB	Stock	27.6	27.85	27.23	27.3	217300.0
2018-01-31	ABAC-DELISTED	Stock	2.82	2.93	2.8143	2.8322	6428.0
2018-01-31	ABAX-DELISTED	Stock	75.0	75.41	71.24	71.65	344043.0
2018-01-31	ABB-DELISTED	Stock	28.22	28.24	27.765	27.86	1721518.0
2018-01-31	ABBNY-DELISTED	Stock	28.22	28.24	27.765	27.87	1788988.0
2018-01-31	ABBV	Stock	116.21	116.5	111.29	112.22	15744800.0
2018-01-31	ABC-DELISTED	Stock	102.98	103.04	99.06	99.69	2112521.0
2018-01-31	ABCB	Stock	54.85	55.25	53.55	53.55	154400.0
2018-01-31	ABCD-DELISTED	Stock	7.14	7.14	6.93	7.01	45166.0
2018-01-31	ABDC-DELISTED	Stock	7.99	8.14	7.9	7.95	68702.0
2018-01-31	ABE-DELISTED	Stock	15.66	15.69	15.65	15.684	3563.0
2018-01-31	ABEO	Stock	387.5	391.5	376.25	381.25	39852.0
2018-01-31	ABEOW-DELISTED	Stock	10.39	10.39	10.39	10.39	100.0
2018-01-31	ABEV	Stock	6.92	6.96	6.83	6.87	21163400.0
2018-01-31	ABG	Stock	74.55	74.9	72.0	72.65	166300.0
2018-01-31	ABIL-DELISTED	Stock	0.47	0.49	0.4116	0.47	139642.0
2018-01-31	ABLX-DELISTED	Stock	54.49	54.64	54.3	54.59	1273324.0
2018-01-31	ABM	Stock	38.46	38.76	38.01	38.03	1841400.0
2018-01-31	ABMD-DELISTED	Stock	236.1	237.31	233.49	234.88	247120.0
2018-01-31	ABR	Stock	8.2	8.25	8.1	8.15	665300.0

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

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