PREVIEW / stock_daily / 2020-02-26

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-26.parquet
  size:    223 KB
  rows:    6,619
  symbols: 2,393

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-02-26	AAPL	Stock	71.6325	74.47	71.625	73.1625	198054800.0
2020-02-26	MSFT	Stock	169.71	173.26	168.21	170.17	56206100.0
2020-02-26	NVDA	Stock	6.5515	6.8862	6.55	6.6912	747732000.0
2020-02-26	AMZN	Stock	98.514	100.7335	98.0225	98.9795	104492000.0
2020-02-26	GOOGL	Stock	69.749	70.6835	68.8275	69.5235	49803560.0
2020-02-26	META	Stock	197.19	201.21	195.49	197.2	16524500.0
2020-02-26	TSLA	Stock	52.1667	54.2207	51.7407	51.92	211282500.0
2020-02-26	TLT	Stock	149.95	151.72	149.58	150.25	22599515.0
2020-02-26	ES	Stock	93.44	94.72	93.04	93.46	2277500.0
2020-02-26	CL	Stock	74.0	74.47	72.9	72.92	4188700.0
2020-02-26	A	Stock	78.66	80.27	78.09	78.11	2526000.0
2020-02-26	AA	Stock	14.64	14.84	14.11	14.12	4796200.0
2020-02-26	AACG	Stock	1.18	1.18	1.05	1.13	24600.0
2020-02-26	AAIC-DELISTED	Stock	6.24	6.38	6.22	6.28	710294.0
2020-02-26	AAIC.C-DELISTED	Stock	23.1	23.3	22.8593	22.98	15191.0
2020-02-26	AAL	Stock	23.57	23.75	22.11	22.31	19610300.0
2020-02-26	AAM.A-DELISTED	Stock	26.58	26.8295	26.58	26.7275	29289.0
2020-02-26	AAM.B-DELISTED	Stock	27.193	27.193	26.846	26.86	18662.0
2020-02-26	AAMC-DELISTED	Stock	9.0824	9.4824	6.9441	7.4	79060.0
2020-02-26	AAME	Stock	2.4	2.5	2.4	2.5	600.0
2020-02-26	AAMI	Stock	10.29	10.34	9.455	9.56	557600.0
2020-02-26	AAOI	Stock	10.27	10.47	10.02	10.18	713200.0
2020-02-26	AAON	Stock	35.5067	36.3533	35.3867	35.4133	337350.0
2020-02-26	AAP	Stock	138.95	138.95	134.08	134.54	1164800.0
2020-02-26	AAT	Stock	44.14	44.32	43.53	43.55	225500.0
2020-02-26	AAU-DELISTED	Stock	0.42	0.43	0.4	0.4106	292013.0
2020-02-26	AAUAF-DELISTED	Stock	0.42	0.43	0.4	0.4106	295761.0
2020-02-26	AAWW-DELISTED	Stock	26.49	26.81	24.28	24.4	721677.0
2020-02-26	AAXJ	Stock	69.64	70.13	69.31	69.35	1562570.0
2020-02-26	AAXN-DELISTED	Stock	79.6	82.862	79.4907	80.2	507770.0
2020-02-26	AB	Stock	32.35	32.64	31.93	32.05	451700.0
2020-02-26	ABB-DELISTED	Stock	22.66	22.85	22.375	22.42	2431481.0
2020-02-26	ABBNY-DELISTED	Stock	22.66	22.85	22.375	22.42	2665370.0
2020-02-26	ABBV	Stock	88.62	91.18	88.19	88.41	9786900.0
2020-02-26	ABC-DELISTED	Stock	93.8	95.0051	93.1439	93.72	1588930.0
2020-02-26	ABCB	Stock	38.25	38.25	36.64	36.7	727700.0
2020-02-26	ABEO	Stock	98.0	101.0	89.0	92.25	64372.0
2020-02-26	ABEV	Stock	3.58	3.67	3.54	3.57	66486300.0
2020-02-26	ABG	Stock	97.48	97.66	94.08	94.81	295000.0
2020-02-26	ABM	Stock	35.92	36.49	35.34	35.84	330500.0
2020-02-26	ABMD-DELISTED	Stock	159.58	161.27	154.01	154.06	583844.0
2020-02-26	ABR	Stock	13.82	14.17	13.7	13.7	1904200.0
2020-02-26	ABR.A-DELISTED	Stock	25.8	26.05	25.55	26.05	6283.0
2020-02-26	ABR.B-DELISTED	Stock	25.43	25.43	25.35	25.4	5784.0
2020-02-26	ABR.C-DELISTED	Stock	26.3	26.4	26.01	26.0566	4711.0
2020-02-26	ABT	Stock	82.13	82.88	81.11	81.36	7380100.0
2020-02-26	ABTC	Stock	229500.0	239700.0	226500.0	236700.0	2.746666666666667
2020-02-26	ABTS	Stock	25.5	25.995	25.5	25.995	147.0
2020-02-26	ABTX-DELISTED	Stock	36.03	36.33	35.19	35.39	75864.0
2020-02-26	ABUS	Stock	3.01	3.01	2.66	2.8	2004900.0

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

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