PREVIEW / stock_daily / 2018-10-31

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-31.parquet
  size:    222 KB
  rows:    6,594
  symbols: 2,741

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-10-31	AAPL	Stock	54.22	55.1125	54.155	54.715	153435600.0
2018-10-31	MSFT	Stock	105.44	108.14	105.39	106.81	51062400.0
2018-10-31	NVDA	Stock	5.2413	5.3148	5.1002	5.2708	745772000.0
2018-10-31	AMZN	Stock	78.4995	81.1955	78.2545	79.9005	187804000.0
2018-10-31	GOOGL	Stock	53.41	55.4	53.41	54.529	70916420.0
2018-10-31	META	Stock	155.0	156.4	148.96	151.79	60101300.0
2018-10-31	TSLA	Stock	22.1693	22.8	21.94	22.488	114364500.0
2018-10-31	TLT	Stock	113.74	113.96	113.21	113.58	8706583.0
2018-10-31	ES	Stock	63.7	63.9	62.77	63.26	1839100.0
2018-10-31	CL	Stock	60.1	60.23	58.71	59.55	8714200.0
2018-10-31	A	Stock	64.35	65.98	64.19	64.79	3820700.0
2018-10-31	AA	Stock	34.82	35.821	34.6	34.99	3380700.0
2018-10-31	AABA-DELISTED	Stock	59.04	60.11	58.94	60.09	5352031.0
2018-10-31	AAC-DELISTED	Stock	5.48	5.675	4.9101	5.51	277906.0
2018-10-31	AACG	Stock	1.1	1.14	1.07	1.12	113700.0
2018-10-31	AAIC-DELISTED	Stock	8.4	8.48	8.3601	8.41	490474.0
2018-10-31	AAL	Stock	35.16	35.9	34.81	35.08	11132800.0
2018-10-31	AAM.A-DELISTED	Stock	24.729	24.85	24.6519	24.8	9212.0
2018-10-31	AAM.B-DELISTED	Stock	24.78	24.78	24.52	24.6753	15220.0
2018-10-31	AAMC-DELISTED	Stock	12.8324	14.4118	12.0618	14.4118	19662.0
2018-10-31	AAME	Stock	3.05	3.05	2.73	2.8	5100.0
2018-10-31	AAMI	Stock	11.54	11.7	11.34	11.4	1147700.0
2018-10-31	AAOI	Stock	20.32	20.5	19.6	19.63	901600.0
2018-10-31	AAON	Stock	23.1467	23.6467	22.9	22.9933	355950.0
2018-10-31	AAP	Stock	166.09	166.09	159.67	159.76	1749400.0
2018-10-31	AAT	Stock	38.95	39.49	37.82	38.36	412100.0
2018-10-31	AAU-DELISTED	Stock	0.53	0.5394	0.51	0.5201	113902.0
2018-10-31	AAUAF-DELISTED	Stock	0.53	0.5394	0.51	0.5201	115516.0
2018-10-31	AAWW-DELISTED	Stock	49.08	52.09	49.05	51.73	427446.0
2018-10-31	AAXJ	Stock	63.07	63.33	62.77	62.99	865915.0
2018-10-31	AAXN-DELISTED	Stock	58.85	62.14	58.85	61.72	571121.0
2018-10-31	AB	Stock	29.15	29.38	28.75	28.91	539500.0
2018-10-31	ABAC-DELISTED	Stock	1.69	1.73	1.69	1.73	300.0
2018-10-31	ABB-DELISTED	Stock	20.14	20.23	20.04	20.06	2314089.0
2018-10-31	ABBNY-DELISTED	Stock	20.14	20.23	20.04	20.06	2416428.0
2018-10-31	ABBV	Stock	80.98	81.58	77.74	77.85	14068500.0
2018-10-31	ABC-DELISTED	Stock	88.01	89.22	87.13	87.99	781965.0
2018-10-31	ABCB	Stock	43.19	43.53	42.73	42.89	273900.0
2018-10-31	ABCD-DELISTED	Stock	14.4	14.43	14.36	14.36	323476.0
2018-10-31	ABDC-DELISTED	Stock	5.63	5.6955	5.58	5.65	72349.0
2018-10-31	ABEO	Stock	223.5	226.75	214.5	215.0	25608.0
2018-10-31	ABEOW-DELISTED	Stock	4.5	4.53	4.38	4.48	7265.0
2018-10-31	ABEV	Stock	4.31	4.37	4.23	4.33	37436500.0
2018-10-31	ABG	Stock	65.67	65.7	63.24	65.1	442800.0
2018-10-31	ABIL-DELISTED	Stock	2.98	3.12	2.85	3.12	75195.0
2018-10-31	ABM	Stock	31.38	31.43	30.7	30.75	1620400.0
2018-10-31	ABMD-DELISTED	Stock	338.0	352.455	333.88	342.38	664149.0
2018-10-31	ABR	Stock	12.05	12.15	12.01	12.08	1246300.0
2018-10-31	ABR.A-DELISTED	Stock	25.65	25.66	25.6296	25.65	6508.0
2018-10-31	ABR.B-DELISTED	Stock	25.38	25.38	25.38	25.38	200.0

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

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