PREVIEW / stock_daily / 2018-11-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-02.parquet
  size:    220 KB
  rows:    6,527
  symbols: 2,704

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-02	AAPL	Stock	52.3875	53.4125	51.3575	51.87	365314800.0
2018-11-02	MSFT	Stock	106.48	107.32	104.98	106.16	37680200.0
2018-11-02	NVDA	Stock	5.4432	5.55	5.2552	5.373	452960000.0
2018-11-02	AMZN	Stock	83.9295	84.872	82.5915	83.2765	139110000.0
2018-11-02	GOOGL	Stock	54.45	54.9	53.383	53.5745	43444300.0
2018-11-02	META	Stock	151.8	154.13	148.96	150.35	24708700.0
2018-11-02	TSLA	Stock	22.916	23.28	22.7273	23.094	117120000.0
2018-11-02	TLT	Stock	113.17	113.26	111.9	112.0	11315059.0
2018-11-02	ES	Stock	63.57	64.03	61.57	62.19	2104500.0
2018-11-02	CL	Stock	60.91	60.91	59.87	60.29	5253500.0
2018-11-02	A	Stock	65.8	66.61	65.44	65.93	2272100.0
2018-11-02	AA	Stock	37.0	37.69	36.41	36.93	2690000.0
2018-11-02	AABA-DELISTED	Stock	63.69	64.12	61.36	61.73	5047013.0
2018-11-02	AAC-DELISTED	Stock	5.99	6.1	5.75	5.76	178027.0
2018-11-02	AACG	Stock	1.27	1.28	1.15	1.17	106900.0
2018-11-02	AAIC-DELISTED	Stock	8.54	8.54	8.425	8.49	264881.0
2018-11-02	AAL	Stock	36.59	37.46	35.64	36.33	10039100.0
2018-11-02	AAM.A-DELISTED	Stock	24.94	24.94	24.73	24.74	10929.0
2018-11-02	AAM.B-DELISTED	Stock	24.78	24.7899	24.47	24.47	41688.0
2018-11-02	AAMC-DELISTED	Stock	14.7059	14.7059	14.0485	14.6618	3465.0
2018-11-02	AAME	Stock	2.74	3.1	2.74	3.1	3100.0
2018-11-02	AAMI	Stock	12.39	12.7	12.045	12.1	523400.0
2018-11-02	AAOI	Stock	20.11	20.85	19.72	20.49	871000.0
2018-11-02	AAON	Stock	25.5467	26.1333	24.6067	26.0067	653100.0
2018-11-02	AAP	Stock	165.02	165.69	163.72	165.0	1089200.0
2018-11-02	AAT	Stock	38.49	38.49	37.64	37.94	221600.0
2018-11-02	AAU-DELISTED	Stock	0.53	0.5492	0.5299	0.5465	116346.0
2018-11-02	AAUAF-DELISTED	Stock	0.53	0.5492	0.5299	0.5465	121413.0
2018-11-02	AAWW-DELISTED	Stock	53.5	56.3	53.5	55.26	427346.0
2018-11-02	AAXJ	Stock	66.27	66.58	65.06	65.64	1103209.0
2018-11-02	AAXN-DELISTED	Stock	61.93	62.855	60.6944	61.2	440544.0
2018-11-02	AB	Stock	28.75	28.96	28.16	28.48	286500.0
2018-11-02	ABAC-DELISTED	Stock	1.74	1.74	1.72	1.7267	1670.0
2018-11-02	ABB-DELISTED	Stock	20.69	20.73	20.34	20.43	2368538.0
2018-11-02	ABBNY-DELISTED	Stock	20.69	20.73	20.34	20.42	2469179.0
2018-11-02	ABBV	Stock	84.18	84.42	78.76	79.56	12781500.0
2018-11-02	ABC-DELISTED	Stock	91.71	91.98	88.06	88.57	785514.0
2018-11-02	ABCB	Stock	43.61	43.85	43.17	43.69	219300.0
2018-11-02	ABCD-DELISTED	Stock	14.36	14.53	14.31	14.45	384868.0
2018-11-02	ABDC-DELISTED	Stock	5.68	5.8655	5.6	5.85	65628.0
2018-11-02	ABEO	Stock	233.0	246.75	226.25	230.75	23692.0
2018-11-02	ABEOW-DELISTED	Stock	4.52	4.52	4.5	4.51	500.0
2018-11-02	ABEV	Stock	4.4	4.48	4.39	4.46	20992000.0
2018-11-02	ABG	Stock	68.66	68.89	67.35	68.12	247800.0
2018-11-02	ABIL-DELISTED	Stock	3.1	3.19	3.0993	3.13	19738.0
2018-11-02	ABM	Stock	31.94	32.16	31.47	32.01	342400.0
2018-11-02	ABMD-DELISTED	Stock	390.0	399.88	376.12	384.3	553202.0
2018-11-02	ABR	Stock	12.0	12.41	11.9	12.24	1954900.0
2018-11-02	ABR.A-DELISTED	Stock	25.6527	25.6999	25.63	25.63	7502.0
2018-11-02	ABR.B-DELISTED	Stock	25.4256	25.4256	25.36	25.36	700.0

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

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