PREVIEW / stock_daily / 2020-01-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-21.parquet
  size:    223 KB
  rows:    6,658
  symbols: 2,445

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
2020-01-21	AAPL	Stock	79.2975	79.755	79.0	79.1425	110843200.0
2020-01-21	MSFT	Stock	166.68	168.19	166.43	166.5	29517200.0
2020-01-21	NVDA	Stock	6.1953	6.2323	6.1642	6.1985	217916000.0
2020-01-21	AMZN	Stock	93.25	94.7135	93.0	94.6	74156000.0
2020-01-21	GOOGL	Stock	73.95	74.4942	73.5105	74.1125	48932020.0
2020-01-21	META	Stock	222.16	222.37	219.12	221.44	14275800.0
2020-01-21	TSLA	Stock	35.35	36.572	35.2273	36.48	267052500.0
2020-01-21	TLT	Stock	138.81	139.65	138.77	139.47	6794885.0
2020-01-21	ES	Stock	88.93	89.85	88.6	89.8	2227700.0
2020-01-21	CL	Stock	71.07	71.38	70.25	71.29	6470400.0
2020-01-21	A	Stock	89.8	90.15	89.46	89.61	2697400.0
2020-01-21	AA	Stock	17.58	17.62	17.1	17.12	6603300.0
2020-01-21	AACG	Stock	1.41	1.47	1.41	1.41	7300.0
2020-01-21	AAIC-DELISTED	Stock	5.73	5.76	5.72	5.74	647805.0
2020-01-21	AAIC.C-DELISTED	Stock	22.26	22.26	22.1	22.1286	11354.0
2020-01-21	AAL	Stock	27.97	27.99	27.05	27.2	16409400.0
2020-01-21	AAM.A-DELISTED	Stock	26.95	26.97	26.77	26.97	9343.0
2020-01-21	AAM.B-DELISTED	Stock	27.3	27.3	27.19	27.2338	14736.0
2020-01-21	AAMC-DELISTED	Stock	3.7882	4.0025	3.7882	3.9529	19761.0
2020-01-21	AAME	Stock	1.82	2.0	1.81	1.9	2400.0
2020-01-21	AAMI	Stock	10.03	10.1	9.932	10.0	383900.0
2020-01-21	AAOI	Stock	14.06	14.1	13.5	13.7	1156800.0
2020-01-21	AAON	Stock	34.9467	35.62	34.82	35.2333	179850.0
2020-01-21	AAP	Stock	150.62	150.62	147.86	149.0	797300.0
2020-01-21	AAT	Stock	46.87	47.57	46.68	47.55	285400.0
2020-01-21	AAU-DELISTED	Stock	0.5792	0.5792	0.52	0.535	289070.0
2020-01-21	AAUAF-DELISTED	Stock	0.5792	0.5792	0.52	0.5354	305883.0
2020-01-21	AAWW-DELISTED	Stock	27.83	27.95	26.69	27.18	191630.0
2020-01-21	AAXJ	Stock	74.28	74.45	74.03	74.18	1418771.0
2020-01-21	AAXN-DELISTED	Stock	73.25	75.4399	73.25	75.26	401822.0
2020-01-21	AB	Stock	33.02	33.09	32.65	32.98	376700.0
2020-01-21	ABB-DELISTED	Stock	23.92	23.95	23.75	23.76	1674370.0
2020-01-21	ABBNY-DELISTED	Stock	23.92	23.95	23.75	23.75	1796313.0
2020-01-21	ABBV	Stock	87.68	88.53	87.57	87.99	13552000.0
2020-01-21	ABC-DELISTED	Stock	90.82	91.37	90.2	91.25	998938.0
2020-01-21	ABCB	Stock	43.26	43.64	42.69	42.89	267400.0
2020-01-21	ABDC-DELISTED	Stock	9.21	9.43	9.21	9.39	24429.0
2020-01-21	ABEO	Stock	63.75	73.0	62.75	69.5	116940.0
2020-01-21	ABEV	Stock	4.42	4.48	4.41	4.41	26101800.0
2020-01-21	ABG	Stock	102.0	103.46	101.81	102.93	156100.0
2020-01-21	ABM	Stock	39.64	39.87	39.38	39.45	329700.0
2020-01-21	ABMD-DELISTED	Stock	182.58	192.745	180.74	189.9	797627.0
2020-01-21	ABR	Stock	14.7	14.78	14.67	14.77	1328500.0
2020-01-21	ABR.A-DELISTED	Stock	26.48	26.48	26.4265	26.4265	945.0
2020-01-21	ABR.B-DELISTED	Stock	26.1735	26.2013	26.1735	26.2013	847.0
2020-01-21	ABR.C-DELISTED	Stock	26.6324	26.6324	26.6324	26.6324	100.0
2020-01-21	ABT	Stock	88.86	90.04	88.61	89.73	7458100.0
2020-01-21	ABTC	Stock	272100.0	272100.0	235500.0	243000.0	3.76
2020-01-21	ABTS	Stock	31.5	32.1	31.2	31.665	287.0
2020-01-21	ABTX-DELISTED	Stock	37.24	37.32	36.94	36.99	42409.0

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

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