PREVIEW / stock_daily / 2018-09-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-21.parquet
  size:    221 KB
  rows:    6,543
  symbols: 2,745

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-09-21	AAPL	Stock	55.195	55.34	54.3225	54.415	384986800.0
2018-09-21	MSFT	Stock	114.0	115.29	113.51	114.26	71229700.0
2018-09-21	NVDA	Stock	6.669	6.715	6.5528	6.5862	435128000.0
2018-09-21	AMZN	Stock	97.711	97.8655	95.525	95.7505	137118000.0
2018-09-21	GOOGL	Stock	59.746	59.829	58.603	58.606	91222380.0
2018-09-21	META	Stock	166.64	167.25	162.81	162.93	45994800.0
2018-09-21	TSLA	Stock	19.8467	20.0387	19.6913	19.94	75757500.0
2018-09-21	TLT	Stock	116.87	117.275	116.84	117.1	6173846.0
2018-09-21	ES	Stock	61.57	62.47	61.33	62.16	2685800.0
2018-09-21	CL	Stock	68.79	69.29	68.77	69.09	4687500.0
2018-09-21	A	Stock	71.43	71.46	70.56	70.72	3119700.0
2018-09-21	AA	Stock	43.36	44.0	42.92	43.79	4939900.0
2018-09-21	AABA-DELISTED	Stock	69.11	69.36	67.74	67.89	5422464.0
2018-09-21	AAC-DELISTED	Stock	7.16	7.46	7.09	7.39	244448.0
2018-09-21	AACG	Stock	1.13	1.21	1.12	1.13	73200.0
2018-09-21	AAIC-DELISTED	Stock	10.12	10.22	10.11	10.14	492998.0
2018-09-21	AAL	Stock	42.04	43.89	41.99	43.6	10743100.0
2018-09-21	AAM.A-DELISTED	Stock	25.13	25.19	25.1	25.14	23186.0
2018-09-21	AAM.B-DELISTED	Stock	24.78	24.7892	24.71	24.71	23555.0
2018-09-21	AAMC-DELISTED	Stock	17.6471	18.2059	17.5588	17.5588	5525.0
2018-09-21	AAME	Stock	2.7	2.7	2.35	2.6	9900.0
2018-09-21	AAMI	Stock	12.91	12.99	12.87	12.98	728700.0
2018-09-21	AAOI	Stock	32.85	33.09	32.497	32.72	841300.0
2018-09-21	AAON	Stock	26.9333	27.0667	26.5333	26.5667	471900.0
2018-09-21	AAP	Stock	170.82	171.33	168.2	168.44	1605300.0
2018-09-21	AAT	Stock	37.56	37.83	37.48	37.59	1232300.0
2018-09-21	AAU-DELISTED	Stock	0.63	0.63	0.6104	0.63	89719.0
2018-09-21	AAUAF-DELISTED	Stock	0.6201	0.63	0.6104	0.63	92820.0
2018-09-21	AAV-DELISTED	Stock	2.5	2.55	2.45	2.525	60221.0
2018-09-21	AAWW-DELISTED	Stock	64.75	64.85	63.3	63.35	317336.0
2018-09-21	AAXJ	Stock	71.2	71.42	71.1	71.27	1137312.0
2018-09-21	AAXN-DELISTED	Stock	65.7	66.58	64.371	64.79	1013919.0
2018-09-21	AB	Stock	30.7	30.81	30.45	30.5	129300.0
2018-09-21	ABAC-DELISTED	Stock	2.2	2.26	2.19	2.26	4070.0
2018-09-21	ABB-DELISTED	Stock	24.44	24.45	24.3	24.31	1563300.0
2018-09-21	ABBNY-DELISTED	Stock	24.44	24.45	24.3	24.31	1616134.0
2018-09-21	ABBV	Stock	92.85	93.33	92.05	92.26	9953500.0
2018-09-21	ABC-DELISTED	Stock	91.16	91.7	89.62	90.11	1576762.0
2018-09-21	ABCB	Stock	49.15	49.56	48.25	48.4	1516700.0
2018-09-21	ABCD-DELISTED	Stock	12.17	12.19	11.7205	12.05	105791.0
2018-09-21	ABDC-DELISTED	Stock	6.23	6.28	6.2089	6.2301	23175.0
2018-09-21	ABEO	Stock	348.75	352.5	312.5	315.75	128728.0
2018-09-21	ABEV	Stock	4.62	4.75	4.61	4.68	31324800.0
2018-09-21	ABG	Stock	72.6	73.0	72.0	72.25	467800.0
2018-09-21	ABIL-DELISTED	Stock	3.5	4.74	3.5	4.4	639071.0
2018-09-21	ABM	Stock	33.87	34.06	33.58	33.76	797500.0
2018-09-21	ABMD-DELISTED	Stock	381.33	386.72	380.97	384.89	1230963.0
2018-09-21	ABR	Stock	11.58	11.72	11.56	11.62	2304100.0
2018-09-21	ABR.A-DELISTED	Stock	25.6418	25.7648	25.58	25.7648	4865.0
2018-09-21	ABR.B-DELISTED	Stock	25.68	25.68	25.5528	25.5728	500.0

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

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