PREVIEW / stock_daily / 2020-01-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-22.parquet
  size:    222 KB
  rows:    6,598
  symbols: 2,411

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-22	AAPL	Stock	79.645	79.9975	79.3275	79.425	101832400.0
2020-01-22	MSFT	Stock	167.4	167.49	165.68	165.7	24138800.0
2020-01-22	NVDA	Stock	6.244	6.3398	6.225	6.2528	239240000.0
2020-01-22	AMZN	Stock	94.8045	95.125	94.167	94.373	64326000.0
2020-01-22	GOOGL	Stock	74.4865	75.0291	74.1331	74.2085	28458920.0
2020-01-22	META	Stock	222.31	222.75	221.28	221.32	12212800.0
2020-01-22	TSLA	Stock	38.126	39.6333	37.2733	37.9707	470535000.0
2020-01-22	TLT	Stock	139.72	140.14	139.59	139.96	6317029.0
2020-01-22	ES	Stock	89.37	90.26	88.65	89.95	1521400.0
2020-01-22	CL	Stock	70.88	71.08	70.51	70.53	2890800.0
2020-01-22	A	Stock	89.94	90.64	89.84	90.13	1665800.0
2020-01-22	AA	Stock	17.07	17.12	16.5	16.59	12843100.0
2020-01-22	AACG	Stock	1.49	1.55	1.44	1.53	26200.0
2020-01-22	AAIC-DELISTED	Stock	5.75	5.84	5.75	5.83	697191.0
2020-01-22	AAIC.C-DELISTED	Stock	22.264	22.264	22.16	22.16	1154.0
2020-01-22	AAL	Stock	27.51	27.91	27.3	27.32	9852600.0
2020-01-22	AAM.A-DELISTED	Stock	26.87	27.0	26.87	27.0	25253.0
2020-01-22	AAM.B-DELISTED	Stock	27.15	27.37	27.15	27.37	7579.0
2020-01-22	AAMC-DELISTED	Stock	4.0741	4.1471	3.9157	3.9176	12804.0
2020-01-22	AAME	Stock	1.85	2.0	1.85	1.9	4500.0
2020-01-22	AAMI	Stock	10.03	10.12	9.9	10.0	328500.0
2020-01-22	AAOI	Stock	13.75	14.42	13.47	14.25	792200.0
2020-01-22	AAON	Stock	35.3467	35.5667	34.9533	35.3	175200.0
2020-01-22	AAP	Stock	148.87	149.98	146.81	147.65	1204300.0
2020-01-22	AAT	Stock	47.56	47.74	47.34	47.62	297600.0
2020-01-22	AAU-DELISTED	Stock	0.52	0.5358	0.52	0.5275	117909.0
2020-01-22	AAUAF-DELISTED	Stock	0.52	0.5358	0.52	0.525	136470.0
2020-01-22	AAWW-DELISTED	Stock	27.36	27.36	25.98	26.35	275748.0
2020-01-22	AAXJ	Stock	74.9	74.925	74.41	74.55	1057062.0
2020-01-22	AAXN-DELISTED	Stock	75.6	79.45	75.6	79.08	1439399.0
2020-01-22	AB	Stock	33.1	33.5	33.05	33.24	515500.0
2020-01-22	ABB-DELISTED	Stock	24.0	24.0	23.87	23.87	1433945.0
2020-01-22	ABBNY-DELISTED	Stock	24.0	24.0	23.87	23.87	1525888.0
2020-01-22	ABBV	Stock	88.03	88.17	87.15	87.21	6438900.0
2020-01-22	ABC-DELISTED	Stock	91.57	92.42	91.17	92.06	1226138.0
2020-01-22	ABCB	Stock	43.03	43.13	42.42	42.91	200400.0
2020-01-22	ABDC-DELISTED	Stock	9.37	9.5	9.37	9.5	23098.0
2020-01-22	ABEO	Stock	70.75	72.0	68.75	71.5	48092.0
2020-01-22	ABEV	Stock	4.48	4.53	4.48	4.53	14388200.0
2020-01-22	ABG	Stock	102.95	103.17	100.31	100.99	247700.0
2020-01-22	ABM	Stock	39.77	40.06	39.68	39.76	246300.0
2020-01-22	ABMD-DELISTED	Stock	189.38	191.79	183.9311	184.42	592863.0
2020-01-22	ABR	Stock	14.84	14.85	14.75	14.78	882400.0
2020-01-22	ABR.A-DELISTED	Stock	26.5	26.5	26.4248	26.4417	4030.0
2020-01-22	ABR.B-DELISTED	Stock	26.175	26.26	26.175	26.26	1306.0
2020-01-22	ABT	Stock	90.78	92.45	90.03	91.86	9841200.0
2020-01-22	ABTC	Stock	243000.0	260700.0	240630.0	255600.0	3.0933333333333333
2020-01-22	ABTS	Stock	28.35	28.35	28.35	28.35	153.0
2020-01-22	ABTX-DELISTED	Stock	37.02	37.11	36.84	37.01	42806.0
2020-01-22	ABUS	Stock	3.1	3.31	3.09	3.21	441800.0

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

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