PREVIEW / stock_daily / 2020-05-26

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-26.parquet
  size:    217 KB
  rows:    6,609
  symbols: 2,342

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-05-26	AAPL	Stock	80.875	81.06	79.125	79.1825	125522000.0
2020-05-26	MSFT	Stock	186.34	186.5	181.1	181.57	36073600.0
2020-05-26	NVDA	Stock	9.1568	9.1817	8.672	8.7178	770780000.0
2020-05-26	AMZN	Stock	122.9	123.1	120.703	121.093	71364000.0
2020-05-26	GOOGL	Stock	72.098	72.2555	70.9698	71.0685	44589760.0
2020-05-26	META	Stock	239.77	240.9	231.67	232.2	33178300.0
2020-05-26	TSLA	Stock	55.6333	55.64	54.3807	54.5913	121345500.0
2020-05-26	TLT	Stock	163.71	163.79	162.975	163.33	8098939.0
2020-05-26	ES	Stock	79.79	79.83	77.76	78.01	1393000.0
2020-05-26	CL	Stock	71.34	71.48	69.1	69.43	6475600.0
2020-05-26	A	Stock	86.23	86.79	85.64	86.13	3173400.0
2020-05-26	AA	Stock	8.7	8.99	8.615	8.76	8563700.0
2020-05-26	AACG	Stock	0.88	0.9	0.88	0.9	8000.0
2020-05-26	AAIC-DELISTED	Stock	2.42	2.545	2.395	2.49	411156.0
2020-05-26	AAIC.C-DELISTED	Stock	16.5	16.95	16.3	16.9001	7660.0
2020-05-26	AAL	Stock	10.27	11.28	10.25	11.14	101717000.0
2020-05-26	AAM.A-DELISTED	Stock	26.18	26.4	26.18	26.19	23782.0
2020-05-26	AAM.B-DELISTED	Stock	26.18	26.4	26.12	26.3	39649.0
2020-05-26	AAMC-DELISTED	Stock	5.1118	5.4916	5.0029	5.0029	9027.0
2020-05-26	AAMI	Stock	8.71	8.965	8.565	8.78	524800.0
2020-05-26	AAOI	Stock	8.82	9.14	8.755	8.96	726000.0
2020-05-26	AAON	Stock	35.22	37.0333	35.22	36.52	309000.0
2020-05-26	AAP	Stock	137.62	138.67	134.59	135.58	813400.0
2020-05-26	AAT	Stock	26.36	27.22	25.87	27.0	502700.0
2020-05-26	AAU-DELISTED	Stock	0.46	0.47	0.43	0.4347	361881.0
2020-05-26	AAUAF-DELISTED	Stock	0.46	0.47	0.43	0.4347	384594.0
2020-05-26	AAWW-DELISTED	Stock	40.54	40.85	38.96	39.05	420176.0
2020-05-26	AAXJ	Stock	64.4	64.61	63.8	63.9	1188551.0
2020-05-26	AAXN-DELISTED	Stock	75.75	76.79	74.79	75.75	377823.0
2020-05-26	AB	Stock	24.93	25.99	24.88	24.93	522700.0
2020-05-26	ABB-DELISTED	Stock	19.55	19.6	19.38	19.42	2759263.0
2020-05-26	ABBNY-DELISTED	Stock	19.55	19.6	19.38	19.42	2903242.0
2020-05-26	ABBV	Stock	93.45	93.57	90.31	90.71	11869800.0
2020-05-26	ABC-DELISTED	Stock	95.0	95.0	90.59	90.78	733904.0
2020-05-26	ABCB	Stock	22.8	24.54	22.51	24.27	510600.0
2020-05-26	ABEO	Stock	83.5	83.5	75.5	76.25	29792.0
2020-05-26	ABEV	Stock	2.34	2.4	2.3	2.35	42690200.0
2020-05-26	ABG	Stock	76.08	78.26	75.67	77.39	198700.0
2020-05-26	ABM	Stock	33.73	34.57	33.65	34.16	343900.0
2020-05-26	ABMD-DELISTED	Stock	210.57	214.4	205.67	209.07	600024.0
2020-05-26	ABR	Stock	8.29	8.44	8.06	8.37	2332800.0
2020-05-26	ABR.A-DELISTED	Stock	24.0	24.25	23.65	23.67	7200.0
2020-05-26	ABR.B-DELISTED	Stock	23.63	24.3014	23.2	23.25	2983.0
2020-05-26	ABR.C-DELISTED	Stock	24.51	24.59	23.79	24.45	6646.0
2020-05-26	ABT	Stock	92.95	93.29	89.17	89.48	6243800.0
2020-05-26	ABTC	Stock	279000.0	319650.0	270480.0	301800.0	14.0
2020-05-26	ABTS	Stock	10.8	10.8	9.255	9.795	1707.0
2020-05-26	ABTX-DELISTED	Stock	26.04	26.67	25.805	26.45	52053.0
2020-05-26	ABUS	Stock	2.28	2.29	2.16	2.21	831300.0
2020-05-26	ACA	Stock	37.22	38.75	36.85	38.18	414912.0

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

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