PREVIEW / stock_daily / 2018-11-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-19.parquet
  size:    221 KB
  rows:    6,583
  symbols: 2,727

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-19	AAPL	Stock	47.5	47.675	46.2475	46.465	167701200.0
2018-11-19	MSFT	Stock	108.27	108.56	103.55	104.62	44773900.0
2018-11-19	NVDA	Stock	4.0447	4.0455	3.6158	3.6175	1697820000.0
2018-11-19	AMZN	Stock	78.8505	79.0595	75.168	75.6145	155800000.0
2018-11-19	GOOGL	Stock	53.1695	53.4	51.1435	51.371	45683820.0
2018-11-19	META	Stock	137.61	137.75	131.21	131.55	44362700.0
2018-11-19	TSLA	Stock	23.756	24.45	23.5253	23.5647	145633500.0
2018-11-19	TLT	Stock	114.41	115.02	114.41	115.02	7027204.0
2018-11-19	ES	Stock	66.98	67.46	66.69	67.38	2452500.0
2018-11-19	CL	Stock	62.98	63.58	62.57	62.77	4480900.0
2018-11-19	A	Stock	64.67	64.96	62.4	62.61	3392100.0
2018-11-19	AA	Stock	35.81	35.995	32.25	33.49	4603100.0
2018-11-19	AABA-DELISTED	Stock	63.03	63.46	61.96	62.21	3333206.0
2018-11-19	AAC-DELISTED	Stock	2.01	2.03	1.96	1.96	694983.0
2018-11-19	AACG	Stock	0.98	1.04	0.98	1.03	89500.0
2018-11-19	AAIC-DELISTED	Stock	8.65	8.72	8.49	8.53	382580.0
2018-11-19	AAL	Stock	36.76	37.08	35.31	35.82	9421000.0
2018-11-19	AAM.A-DELISTED	Stock	24.13	24.25	24.0	24.01	17369.0
2018-11-19	AAM.B-DELISTED	Stock	24.25	24.2689	23.94	23.98	30974.0
2018-11-19	AAMC-DELISTED	Stock	13.5294	14.3765	13.3088	14.3765	11472.0
2018-11-19	AAME	Stock	2.93	3.05	2.93	3.05	2800.0
2018-11-19	AAMI	Stock	13.01	13.36	12.71	12.8	1293300.0
2018-11-19	AAOI	Stock	20.83	20.83	19.44	19.69	549600.0
2018-11-19	AAON	Stock	26.12	26.32	25.56	25.9733	807300.0
2018-11-19	AAP	Stock	179.15	182.49	176.9	177.75	856700.0
2018-11-19	AAT	Stock	39.3	39.93	39.27	39.91	321300.0
2018-11-19	AAU-DELISTED	Stock	0.52	0.5336	0.4999	0.5023	118725.0
2018-11-19	AAUAF-DELISTED	Stock	0.52	0.5336	0.4999	0.5023	125371.0
2018-11-19	AAWW-DELISTED	Stock	54.14	54.4121	52.45	52.75	181397.0
2018-11-19	AAXJ	Stock	65.6	65.73	65.02	65.14	520049.0
2018-11-19	AAXN-DELISTED	Stock	50.0	50.03	46.77	47.0	511879.0
2018-11-19	AB	Stock	29.64	29.8	29.21	29.32	208200.0
2018-11-19	ABAC-DELISTED	Stock	1.53	1.6199	1.53	1.59	1878.0
2018-11-19	ABB-DELISTED	Stock	20.17	20.2	19.85	19.88	2249682.0
2018-11-19	ABBNY-DELISTED	Stock	20.17	20.2	19.85	19.88	2372540.0
2018-11-19	ABBV	Stock	91.29	92.34	89.11	89.48	5971700.0
2018-11-19	ABC-DELISTED	Stock	89.1	91.37	88.15	90.84	1769878.0
2018-11-19	ABCB	Stock	44.36	44.96	42.85	43.89	186500.0
2018-11-19	ABCD-DELISTED	Stock	14.41	14.44	14.41	14.42	188027.0
2018-11-19	ABDC-DELISTED	Stock	6.36	6.6	6.32	6.45	64905.0
2018-11-19	ABEO	Stock	204.5	207.75	186.0	189.75	25748.0
2018-11-19	ABEOW-DELISTED	Stock	3.58	3.58	3.58	3.58	100.0
2018-11-19	ABEV	Stock	4.31	4.34	4.21	4.31	18521000.0
2018-11-19	ABG	Stock	69.03	69.78	68.69	69.12	210200.0
2018-11-19	ABIL-DELISTED	Stock	2.9899	3.04	2.91	2.92	28170.0
2018-11-19	ABM	Stock	31.33	31.58	30.67	31.32	331300.0
2018-11-19	ABMD-DELISTED	Stock	316.03	316.32	293.728	299.95	704833.0
2018-11-19	ABR	Stock	12.13	12.19	11.95	11.99	682300.0
2018-11-19	ABR.A-DELISTED	Stock	25.255	25.3	25.255	25.3	1200.0
2018-11-19	ABR.C-DELISTED	Stock	25.2905	25.2905	25.29	25.29	799.0

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

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