PREVIEW / stock_daily / 2019-11-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-11.parquet
  size:    220 KB
  rows:    6,559
  symbols: 2,440

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-11	AAPL	Stock	64.575	65.6175	64.57	65.55	81821200.0
2019-11-11	MSFT	Stock	145.34	146.42	144.73	146.11	14362600.0
2019-11-11	NVDA	Stock	5.1938	5.2278	5.107	5.2045	243436000.0
2019-11-11	AMZN	Stock	88.9	89.0	88.3565	88.5825	38920000.0
2019-11-11	GOOGL	Stock	65.2	65.245	64.7935	64.914	17237200.0
2019-11-11	META	Stock	189.93	190.08	188.54	189.61	8631200.0
2019-11-11	TSLA	Stock	22.93	23.2793	22.8	23.006	149800500.0
2019-11-11	TLT	Stock	135.38	135.39	134.64	135.0	4578098.0
2019-11-11	ES	Stock	79.38	79.55	78.92	79.29	1442800.0
2019-11-11	CL	Stock	66.4	66.8	65.95	66.54	2640400.0
2019-11-11	A	Stock	76.25	76.85	76.13	76.85	1149200.0
2019-11-11	AA	Stock	22.15	22.31	21.684	22.22	3124800.0
2019-11-11	AACG	Stock	1.72	1.72	1.72	1.72	800.0
2019-11-11	AAIC-DELISTED	Stock	5.77	5.86	5.721	5.84	243420.0
2019-11-11	AAIC.C-DELISTED	Stock	21.5	21.6	21.5	21.6	3042.0
2019-11-11	AAL	Stock	30.54	30.75	30.2	30.59	4109100.0
2019-11-11	AAM.A-DELISTED	Stock	26.55	26.6285	26.531	26.58	8589.0
2019-11-11	AAM.B-DELISTED	Stock	27.0385	27.11	27.0	27.07	4982.0
2019-11-11	AAME	Stock	1.9	1.92	1.81	1.88	3700.0
2019-11-11	AAMI	Stock	10.16	10.16	9.95	10.0	144700.0
2019-11-11	AAOI	Stock	10.76	12.58	10.67	12.15	1920400.0
2019-11-11	AAON	Stock	33.1267	33.7067	33.1267	33.5133	149100.0
2019-11-11	AAP	Stock	166.72	171.43	165.95	168.82	1805500.0
2019-11-11	AAT	Stock	46.62	47.03	46.4	46.91	161700.0
2019-11-11	AAU-DELISTED	Stock	0.459	0.4649	0.43	0.435	371298.0
2019-11-11	AAUAF-DELISTED	Stock	0.459	0.4649	0.43	0.435	374986.0
2019-11-11	AAWW-DELISTED	Stock	26.22	26.69	25.965	26.3	258042.0
2019-11-11	AAXJ	Stock	70.52	70.85	70.35	70.82	1079831.0
2019-11-11	AAXN-DELISTED	Stock	64.76	65.54	62.61	64.44	1002336.0
2019-11-11	AB	Stock	29.29	29.39	29.15	29.3	153000.0
2019-11-11	ABB-DELISTED	Stock	21.63	21.76	21.61	21.72	1342072.0
2019-11-11	ABBNY-DELISTED	Stock	21.63	21.76	21.61	21.72	1430051.0
2019-11-11	ABBV	Stock	84.95	85.68	83.9	85.66	8726300.0
2019-11-11	ABC-DELISTED	Stock	84.84	85.1	82.1	84.04	1485913.0
2019-11-11	ABCB	Stock	44.35	44.5	43.97	44.3	199200.0
2019-11-11	ABDC-DELISTED	Stock	8.96	9.0	8.8783	9.0	25173.0
2019-11-11	ABEO	Stock	66.75	66.75	61.5	62.25	6740.0
2019-11-11	ABEOW-DELISTED	Stock	0.17	0.17	0.15	0.15	1705.0
2019-11-11	ABEV	Stock	4.14	4.24	4.13	4.19	12555600.0
2019-11-11	ABG	Stock	108.24	110.09	107.06	109.85	68500.0
2019-11-11	ABIL-DELISTED	Stock	0.422	0.4352	0.39	0.4025	197820.0
2019-11-11	ABM	Stock	37.57	37.86	37.25	37.68	161700.0
2019-11-11	ABMD-DELISTED	Stock	217.84	221.32	216.91	220.04	335100.0
2019-11-11	ABR	Stock	15.4	15.4	14.85	15.0	2211400.0
2019-11-11	ABR.A-DELISTED	Stock	26.1824	26.2286	26.0785	26.22	2776.0
2019-11-11	ABR.B-DELISTED	Stock	25.9877	26.07	25.86	26.0699	2229.0
2019-11-11	ABR.C-DELISTED	Stock	26.426	26.65	26.4046	26.64	3530.0
2019-11-11	ABT	Stock	83.31	83.9	83.31	83.76	3139100.0
2019-11-11	ABTC	Stock	131700.0	132300.0	119700.0	124200.0	1.7066666666666668
2019-11-11	ABTS	Stock	29.25	36.3	29.1	34.5	2913.0

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

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