PREVIEW / stock_daily / 2020-07-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-02.parquet
  size:    222 KB
  rows:    6,718
  symbols: 2,394

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-02	AAPL	Stock	91.9625	92.6175	90.91	91.0275	114041600.0
2020-07-02	MSFT	Stock	205.68	208.02	205.0	206.26	29315800.0
2020-07-02	NVDA	Stock	9.639	9.7375	9.5782	9.6123	364056000.0
2020-07-02	AMZN	Stock	145.6005	147.778	143.555	144.515	131868000.0
2020-07-02	GOOGL	Stock	72.592	74.426	72.5532	73.4965	57218300.0
2020-07-02	META	Stock	239.0	240.0	232.61	233.42	30633600.0
2020-07-02	TSLA	Stock	81.432	81.8667	79.04	80.5773	258751500.0
2020-07-02	TLT	Stock	162.7	163.74	162.24	163.59	7599940.0
2020-07-02	ES	Stock	85.61	85.93	84.42	84.67	1192400.0
2020-07-02	CL	Stock	73.64	73.87	73.07	73.28	2658600.0
2020-07-02	A	Stock	88.83	89.49	88.55	88.68	1507700.0
2020-07-02	AA	Stock	11.26	11.68	10.86	10.97	7515400.0
2020-07-02	AACG	Stock	1.3	1.39	1.3	1.31	46800.0
2020-07-02	AAIC-DELISTED	Stock	2.99	2.99	2.93	2.95	391477.0
2020-07-02	AAIC.C-DELISTED	Stock	19.575	19.575	19.575	19.575	1064.0
2020-07-02	AAL	Stock	13.35	13.42	12.42	12.5	86439500.0
2020-07-02	AAM.A-DELISTED	Stock	25.9473	25.9473	25.83	25.84	8994.0
2020-07-02	AAM.B-DELISTED	Stock	25.99	26.1699	25.99	26.05	8809.0
2020-07-02	AAMC-DELISTED	Stock	5.0221	5.2574	5.0221	5.1176	10020.0
2020-07-02	AAME	Stock	1.62	1.73	1.58	1.7	19800.0
2020-07-02	AAMI	Stock	12.73	13.04	12.46	12.75	1564600.0
2020-07-02	AAOI	Stock	10.48	11.03	10.39	10.79	881000.0
2020-07-02	AAON	Stock	35.6467	36.1867	35.2	35.82	255450.0
2020-07-02	AAP	Stock	144.24	145.61	140.3	141.84	467000.0
2020-07-02	AAT	Stock	28.88	29.04	28.02	28.09	275900.0
2020-07-02	AAU-DELISTED	Stock	0.5	0.5169	0.49	0.4925	364873.0
2020-07-02	AAUAF-DELISTED	Stock	0.5	0.5169	0.49	0.495	374886.0
2020-07-02	AAWW-DELISTED	Stock	44.61	45.24	44.22	44.49	234224.0
2020-07-02	AAXJ	Stock	71.45	71.96	71.38	71.71	1491266.0
2020-07-02	AAXN-DELISTED	Stock	100.23	101.8383	99.4	100.34	531318.0
2020-07-02	AB	Stock	27.0	27.48	26.63	26.67	218100.0
2020-07-02	ABB-DELISTED	Stock	23.58	23.65	23.4	23.435	2022839.0
2020-07-02	ABBNY-DELISTED	Stock	23.58	23.65	23.4	23.43	2105836.0
2020-07-02	ABBV	Stock	99.45	99.99	97.86	98.88	6158800.0
2020-07-02	ABC-DELISTED	Stock	100.2	101.62	99.72	100.1	554526.0
2020-07-02	ABCB	Stock	23.13	23.5	22.01	22.14	244600.0
2020-07-02	ABEO	Stock	72.0	72.25	70.25	71.25	18452.0
2020-07-02	ABEV	Stock	2.77	2.8	2.63	2.66	22932900.0
2020-07-02	ABG	Stock	77.56	79.01	76.23	76.59	102000.0
2020-07-02	ABM	Stock	36.5	36.7	35.26	35.39	370700.0
2020-07-02	ABMD-DELISTED	Stock	256.11	266.35	255.43	264.15	326073.0
2020-07-02	ABR	Stock	9.22	9.26	8.85	8.86	1296600.0
2020-07-02	ABR.A-DELISTED	Stock	24.81	25.0	24.81	25.0	2791.0
2020-07-02	ABR.B-DELISTED	Stock	24.0649	24.37	23.645	23.67	3021.0
2020-07-02	ABR.C-DELISTED	Stock	25.0999	25.0999	24.955	24.955	500.0
2020-07-02	ABT	Stock	92.5	93.06	91.93	92.23	3845300.0
2020-07-02	ABTC	Stock	255900.0	257400.0	237600.0	246300.0	3.973333333333333
2020-07-02	ABTS	Stock	11.655	12.15	11.265	11.7	1580.0
2020-07-02	ABTX-DELISTED	Stock	24.65	24.95	23.66	23.77	27591.0
2020-07-02	ABUS	Stock	1.83	1.94	1.81	1.88	687300.0

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

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