PREVIEW / stock_daily / 2019-11-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-26.parquet
  size:    222 KB
  rows:    6,616
  symbols: 2,461

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-26	AAPL	Stock	66.735	66.79	65.625	66.0725	105207600.0
2019-11-26	MSFT	Stock	151.36	152.42	151.32	152.03	24620100.0
2019-11-26	NVDA	Stock	5.5125	5.5173	5.4185	5.425	385244000.0
2019-11-26	AMZN	Stock	88.996	89.8515	88.9175	89.847	63624000.0
2019-11-26	GOOGL	Stock	65.4955	65.7005	65.202	65.65	21941780.0
2019-11-26	META	Stock	200.0	200.15	198.04	198.97	11735500.0
2019-11-26	TSLA	Stock	22.3513	22.3667	21.8067	21.928	119211000.0
2019-11-26	TLT	Stock	141.0	141.31	140.94	141.13	4281650.0
2019-11-26	ES	Stock	82.05	82.93	81.99	82.72	3303400.0
2019-11-26	CL	Stock	67.2	67.8	67.02	67.79	3513800.0
2019-11-26	A	Stock	78.57	81.03	77.96	80.95	5329900.0
2019-11-26	AA	Stock	20.41	20.51	20.14	20.26	2739500.0
2019-11-26	AACG	Stock	1.8	1.84	1.8	1.81	10700.0
2019-11-26	AAIC-DELISTED	Stock	5.66	5.765	5.66	5.7	810903.0
2019-11-26	AAIC.C-DELISTED	Stock	21.8	21.96	21.8	21.96	1683.0
2019-11-26	AAL	Stock	28.95	29.07	28.57	29.05	5932800.0
2019-11-26	AAM.A-DELISTED	Stock	26.57	26.739	26.55	26.7	9229.0
2019-11-26	AAM.B-DELISTED	Stock	27.1	27.27	27.0361	27.27	10224.0
2019-11-26	AAMC-DELISTED	Stock	3.8265	3.9059	3.8237	3.9059	3312.0
2019-11-26	AAME	Stock	1.9	1.9	1.83	1.83	800.0
2019-11-26	AAMI	Stock	9.66	9.74	9.44	9.47	423700.0
2019-11-26	AAOI	Stock	10.21	10.85	10.21	10.55	934000.0
2019-11-26	AAON	Stock	32.92	33.48	32.6867	32.9	220950.0
2019-11-26	AAP	Stock	159.48	159.48	156.91	157.09	1004400.0
2019-11-26	AAT	Stock	46.49	46.88	46.32	46.76	303400.0
2019-11-26	AAU-DELISTED	Stock	0.5	0.5	0.46	0.4747	214599.0
2019-11-26	AAUAF-DELISTED	Stock	0.5	0.5	0.46	0.4747	238092.0
2019-11-26	AAWW-DELISTED	Stock	26.17	26.52	25.86	26.2	303716.0
2019-11-26	AAXJ	Stock	70.52	70.81	70.36	70.81	1094758.0
2019-11-26	AAXN-DELISTED	Stock	74.8	77.66	74.5	76.925	1309605.0
2019-11-26	AB	Stock	29.01	29.15	28.75	28.8	238700.0
2019-11-26	ABB-DELISTED	Stock	22.07	22.1	21.95	22.03	1089114.0
2019-11-26	ABBNY-DELISTED	Stock	22.07	22.1	21.95	22.02	1154278.0
2019-11-26	ABBV	Stock	88.15	88.19	86.93	87.72	6431400.0
2019-11-26	ABC-DELISTED	Stock	90.72	90.72	86.79	87.81	1465672.0
2019-11-26	ABCB	Stock	43.31	43.64	43.06	43.33	204000.0
2019-11-26	ABDC-DELISTED	Stock	9.06	9.0624	9.01	9.0277	40338.0
2019-11-26	ABEO	Stock	76.0	80.0	69.5	73.25	44144.0
2019-11-26	ABEOW-DELISTED	Stock	0.125	0.13	0.125	0.13	1839.0
2019-11-26	ABEV	Stock	4.21	4.24	4.14	4.22	26599100.0
2019-11-26	ABG	Stock	110.83	112.21	110.02	111.67	101500.0
2019-11-26	ABIL-DELISTED	Stock	0.3373	0.35	0.31	0.315	47070.0
2019-11-26	ABM	Stock	38.3	38.89	38.28	38.74	214400.0
2019-11-26	ABMD-DELISTED	Stock	187.62	195.045	186.0	194.26	821159.0
2019-11-26	ABR	Stock	14.99	15.04	14.83	14.91	1062600.0
2019-11-26	ABR.A-DELISTED	Stock	25.9065	26.14	25.83	26.14	6677.0
2019-11-26	ABR.B-DELISTED	Stock	25.75	25.7856	25.7124	25.7124	3675.0
2019-11-26	ABR.C-DELISTED	Stock	26.135	26.16	25.99	25.99	1100.0
2019-11-26	ABT	Stock	84.65	85.57	84.32	85.42	8764100.0
2019-11-26	ABTC	Stock	190500.0	285000.0	184200.0	232800.0	83.33333333333333

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

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