PREVIEW / stock_daily / 2020-07-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-22.parquet
  size:    222 KB
  rows:    6,739
  symbols: 2,396

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-07-22	AAPL	Stock	96.6925	97.975	96.6025	97.2725	89001600.0
2020-07-22	MSFT	Stock	209.2	212.3	208.39	211.75	49605700.0
2020-07-22	NVDA	Stock	10.3675	10.6025	10.2915	10.4388	367292000.0
2020-07-22	AMZN	Stock	156.25	157.5	153.263	154.9955	82084000.0
2020-07-22	GOOGL	Stock	77.7855	78.349	77.1615	78.2425	24482000.0
2020-07-22	META	Stock	240.26	241.9	238.12	239.87	15427900.0
2020-07-22	TSLA	Stock	106.6	108.428	104.1333	106.1553	212416500.0
2020-07-22	TLT	Stock	168.26	168.46	167.69	167.79	6592084.0
2020-07-22	ES	Stock	86.82	89.99	86.31	89.63	1343600.0
2020-07-22	CL	Stock	73.59	74.21	72.61	74.14	4239400.0
2020-07-22	A	Stock	96.36	96.88	95.81	96.35	1313200.0
2020-07-22	AA	Stock	13.05	13.385	13.0	13.07	4860900.0
2020-07-22	AACG	Stock	1.29	1.35	1.17	1.29	38100.0
2020-07-22	AACQU-DELISTED	Stock	10.41	10.45	10.38	10.4	682331.0
2020-07-22	AAIC-DELISTED	Stock	3.04	3.16	3.02	3.06	207337.0
2020-07-22	AAIC.C-DELISTED	Stock	18.17	19.3237	18.17	19.3	2989.0
2020-07-22	AAL	Stock	11.38	11.67	11.3	11.36	42461300.0
2020-07-22	AAM.A-DELISTED	Stock	26.43	26.56	26.38	26.5	10962.0
2020-07-22	AAM.B-DELISTED	Stock	27.0	27.17	26.86	27.06	19446.0
2020-07-22	AAMC-DELISTED	Stock	4.2338	4.2745	4.1206	4.167	33238.0
2020-07-22	AAME	Stock	1.81	1.87	1.8	1.83	3300.0
2020-07-22	AAMI	Stock	12.72	12.94	12.515	12.61	743400.0
2020-07-22	AAOI	Stock	13.93	15.13	13.33	14.39	2532600.0
2020-07-22	AAON	Stock	38.3533	39.4067	38.3533	38.74	220500.0
2020-07-22	AAP	Stock	146.9	150.07	146.9	149.4	493800.0
2020-07-22	AAT	Stock	25.73	26.4	25.41	26.19	179400.0
2020-07-22	AAU-DELISTED	Stock	0.6	0.6191	0.5723	0.5954	924911.0
2020-07-22	AAUAF-DELISTED	Stock	0.6	0.6191	0.5723	0.596	972278.0
2020-07-22	AAWW-DELISTED	Stock	50.0	50.31	49.07	49.16	195990.0
2020-07-22	AAXJ	Stock	75.17	75.19	74.442	74.76	635657.0
2020-07-22	AAXN-DELISTED	Stock	91.63	93.06	88.23	88.99	607269.0
2020-07-22	AB	Stock	28.9	29.3	28.81	28.96	259500.0
2020-07-22	ABB-DELISTED	Stock	25.58	26.48	25.53	26.2	4639102.0
2020-07-22	ABBNY-DELISTED	Stock	25.58	26.48	25.53	26.2	4934299.0
2020-07-22	ABBV	Stock	97.8	98.28	96.93	97.7	4441800.0
2020-07-22	ABC-DELISTED	Stock	103.85	104.3	102.62	103.81	559464.0
2020-07-22	ABCB	Stock	22.07	22.62	22.0	22.45	317200.0
2020-07-22	ABEO	Stock	75.0	75.25	72.75	73.75	15708.0
2020-07-22	ABEV	Stock	2.91	2.99	2.87	2.9	52349400.0
2020-07-22	ABG	Stock	100.29	106.23	100.29	106.04	245500.0
2020-07-22	ABM	Stock	35.57	35.98	35.15	35.59	344600.0
2020-07-22	ABMD-DELISTED	Stock	298.78	300.7784	293.585	297.3299	265712.0
2020-07-22	ABR	Stock	8.58	9.16	8.58	9.12	1192600.0
2020-07-22	ABR.A-DELISTED	Stock	24.665	24.95	24.5906	24.86	4730.0
2020-07-22	ABR.B-DELISTED	Stock	23.8999	23.8999	23.67	23.7	3231.0
2020-07-22	ABR.C-DELISTED	Stock	24.6535	24.8958	24.6174	24.8958	5255.0
2020-07-22	ABT	Stock	98.11	100.57	98.0	100.19	4662000.0
2020-07-22	ABTC	Stock	197700.0	202860.0	181500.0	189000.0	5.626666666666667
2020-07-22	ABTS	Stock	15.75	15.975	14.43	14.625	5180.0
2020-07-22	ABTX-DELISTED	Stock	23.7	23.91	23.0701	23.51	29267.0

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

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