PREVIEW / stock_daily / 2019-11-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-07.parquet
  size:    222 KB
  rows:    6,630
  symbols: 2,489

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
2019-11-07	AAPL	Stock	64.685	65.0875	64.5275	64.8575	94940400.0
2019-11-07	MSFT	Stock	143.84	144.88	143.77	144.26	17786700.0
2019-11-07	NVDA	Stock	5.2778	5.2925	5.1635	5.2085	280340000.0
2019-11-07	AMZN	Stock	90.188	90.295	89.174	89.41	53022000.0
2019-11-07	GOOGL	Stock	64.714	66.1325	64.6875	65.347	45140100.0
2019-11-07	META	Stock	191.91	193.44	189.47	190.42	13473000.0
2019-11-07	TSLA	Stock	21.9427	22.7667	21.868	22.3693	217009500.0
2019-11-07	TLT	Stock	136.35	136.36	134.45	135.48	19214106.0
2019-11-07	ES	Stock	80.68	81.11	78.72	79.39	2050800.0
2019-11-07	CL	Stock	66.58	66.94	65.93	66.87	4332100.0
2019-11-07	A	Stock	76.34	76.38	75.68	75.91	860900.0
2019-11-07	AA	Stock	22.4	23.065	22.3	22.56	2963600.0
2019-11-07	AACG	Stock	1.75	1.75	1.72	1.72	10400.0
2019-11-07	AAIC-DELISTED	Stock	5.83	5.84	5.76	5.76	277154.0
2019-11-07	AAIC.C-DELISTED	Stock	21.35	21.5	21.35	21.4224	7089.0
2019-11-07	AAL	Stock	31.21	31.44	30.75	30.89	6342400.0
2019-11-07	AAM.A-DELISTED	Stock	26.612	26.612	26.469	26.47	13693.0
2019-11-07	AAM.B-DELISTED	Stock	27.03	27.21	26.93	26.93	12217.0
2019-11-07	AAMC-DELISTED	Stock	3.7224	3.8913	3.5235	3.6765	38634.0
2019-11-07	AAME	Stock	1.96	1.97	1.9	1.97	4100.0
2019-11-07	AAMI	Stock	10.16	10.305	10.055	10.1	318600.0
2019-11-07	AAOI	Stock	10.45	11.35	9.72	10.69	2450000.0
2019-11-07	AAON	Stock	33.3267	33.52	32.8333	33.02	119100.0
2019-11-07	AAP	Stock	170.45	171.36	168.83	169.28	669100.0
2019-11-07	AAT	Stock	47.34	47.8	46.83	46.96	364400.0
2019-11-07	AAU-DELISTED	Stock	0.4827	0.49	0.4768	0.4895	113533.0
2019-11-07	AAUAF-DELISTED	Stock	0.4827	0.49	0.4768	0.4895	120123.0
2019-11-07	AAWW-DELISTED	Stock	26.5	27.06	26.22	26.46	362860.0
2019-11-07	AAXJ	Stock	72.07	72.34	71.97	72.01	639684.0
2019-11-07	AAXN-DELISTED	Stock	53.23	55.73	52.2	52.3	1044587.0
2019-11-07	AB	Stock	29.76	29.77	29.51	29.57	108600.0
2019-11-07	ABB-DELISTED	Stock	21.73	21.81	21.62	21.66	1377128.0
2019-11-07	ABBNY-DELISTED	Stock	21.73	21.81	21.62	21.67	1636675.0
2019-11-07	ABBV	Stock	82.21	82.59	81.08	82.01	6561500.0
2019-11-07	ABC-DELISTED	Stock	86.34	87.77	83.86	84.02	1579556.0
2019-11-07	ABCB	Stock	44.29	44.76	44.17	44.4	214600.0
2019-11-07	ABDC-DELISTED	Stock	8.78	8.85	8.77	8.85	13072.0
2019-11-07	ABEO	Stock	65.75	68.5	64.5	68.0	6284.0
2019-11-07	ABEV	Stock	4.26	4.29	4.24	4.26	15666400.0
2019-11-07	ABG	Stock	108.97	109.2	107.9	108.13	126100.0
2019-11-07	ABIL-DELISTED	Stock	0.46	0.48	0.44	0.4465	71756.0
2019-11-07	ABM	Stock	37.53	37.93	36.3	37.42	217900.0
2019-11-07	ABMD-DELISTED	Stock	216.07	221.85	215.839	219.13	358183.0
2019-11-07	ABR	Stock	15.19	15.71	15.09	15.53	6014400.0
2019-11-07	ABR.A-DELISTED	Stock	26.01	26.02	25.9	25.94	9000.0
2019-11-07	ABR.B-DELISTED	Stock	25.91	25.9901	25.91	25.91	1700.0
2019-11-07	ABR.C-DELISTED	Stock	26.12	26.3428	26.11	26.31	7290.0
2019-11-07	ABT	Stock	83.13	83.58	82.91	83.39	6020400.0
2019-11-07	ABTC	Stock	124500.0	129600.0	121800.0	126600.0	1.1733333333333333
2019-11-07	ABTS	Stock	30.0	30.0	29.25	29.25	2660.0

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

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