PREVIEW / stock_daily / 2018-11-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-21.parquet
  size:    219 KB
  rows:    6,523
  symbols: 2,682

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-21	AAPL	Stock	44.9325	45.0675	44.1375	44.195	124496800.0
2018-11-21	MSFT	Stock	103.6	104.43	102.24	103.11	28130600.0
2018-11-21	NVDA	Stock	3.8655	3.8825	3.5903	3.6178	1025496000.0
2018-11-21	AMZN	Stock	77.1495	77.5	75.75	75.8365	114336000.0
2018-11-21	GOOGL	Stock	52.2655	52.7352	51.9728	52.1715	29703440.0
2018-11-21	META	Stock	134.4	137.19	134.13	134.82	25469700.0
2018-11-21	TSLA	Stock	23.4667	23.54	22.4933	22.546	70302000.0
2018-11-21	TLT	Stock	114.89	115.09	114.54	115.02	4951058.0
2018-11-21	ES	Stock	67.33	67.44	66.24	66.42	1605200.0
2018-11-21	CL	Stock	62.55	62.75	61.78	61.92	3935300.0
2018-11-21	A	Stock	67.66	68.67	67.19	67.72	3557600.0
2018-11-21	AA	Stock	33.2	33.39	32.71	32.8	1697200.0
2018-11-21	AABA-DELISTED	Stock	62.11	62.8901	61.87	62.17	3891676.0
2018-11-21	AAC-DELISTED	Stock	1.93	2.0079	1.93	2.0	613985.0
2018-11-21	AACG	Stock	1.0	1.01	0.98	0.98	34100.0
2018-11-21	AAIC-DELISTED	Stock	8.35	8.47	8.28	8.39	318163.0
2018-11-21	AAL	Stock	36.09	37.51	35.97	36.31	8701500.0
2018-11-21	AAM.A-DELISTED	Stock	23.86	24.09	23.86	23.92	9097.0
2018-11-21	AAM.B-DELISTED	Stock	23.8	24.07	23.8	24.07	38272.0
2018-11-21	AAMC-DELISTED	Stock	13.9706	13.9706	13.3853	13.5353	9551.0
2018-11-21	AAME	Stock	3.08	3.09	2.83	2.83	1900.0
2018-11-21	AAMI	Stock	12.68	12.99	12.62	12.89	516600.0
2018-11-21	AAOI	Stock	19.9	20.69	19.9	20.26	508500.0
2018-11-21	AAON	Stock	24.62	25.04	24.14	24.5	234300.0
2018-11-21	AAP	Stock	171.5	176.09	171.41	174.67	893700.0
2018-11-21	AAT	Stock	39.74	40.27	39.43	39.55	168800.0
2018-11-21	AAU-DELISTED	Stock	0.494	0.543	0.492	0.5131	85253.0
2018-11-21	AAUAF-DELISTED	Stock	0.494	0.543	0.492	0.5131	89285.0
2018-11-21	AAWW-DELISTED	Stock	50.69	51.46	50.18	50.28	179532.0
2018-11-21	AAXJ	Stock	65.02	65.54	64.98	65.11	1833103.0
2018-11-21	AAXN-DELISTED	Stock	45.76	47.17	45.56	46.74	463328.0
2018-11-21	AB	Stock	29.58	30.22	29.44	29.88	265900.0
2018-11-21	ABAC-DELISTED	Stock	1.59	1.59	1.5	1.54	8485.0
2018-11-21	ABB-DELISTED	Stock	19.98	20.18	19.93	19.96	2138765.0
2018-11-21	ABBNY-DELISTED	Stock	19.98	20.18	19.93	19.96	2203096.0
2018-11-21	ABBV	Stock	88.5	88.78	85.37	86.15	6532500.0
2018-11-21	ABC-DELISTED	Stock	88.52	89.3	87.1	87.43	938872.0
2018-11-21	ABCB	Stock	42.6	43.11	41.98	42.46	202400.0
2018-11-21	ABCD-DELISTED	Stock	14.45	14.46	14.42	14.46	158386.0
2018-11-21	ABDC-DELISTED	Stock	6.31	6.45	6.2	6.43	54602.0
2018-11-21	ABEO	Stock	194.75	200.75	193.25	199.0	19020.0
2018-11-21	ABEOW-DELISTED	Stock	3.95	3.96	3.95	3.95	10553.0
2018-11-21	ABEV	Stock	4.22	4.29	4.19	4.26	17546000.0
2018-11-21	ABG	Stock	67.67	69.47	67.67	68.42	91900.0
2018-11-21	ABIL-DELISTED	Stock	3.79	8.14	3.77	5.33	32226279.0
2018-11-21	ABM	Stock	30.17	30.71	29.89	30.33	275300.0
2018-11-21	ABMD-DELISTED	Stock	306.62	315.14	300.41	301.61	327365.0
2018-11-21	ABR	Stock	11.82	11.98	11.73	11.88	1313000.0
2018-11-21	ABR.A-DELISTED	Stock	25.25	25.25	25.2101	25.25	600.0
2018-11-21	ABR.B-DELISTED	Stock	24.8697	25.2	24.8697	25.1999	840.0

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

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