PREVIEW / stock_daily / 2020-03-12

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-12.parquet
  size:    216 KB
  rows:    6,715
  symbols: 2,439

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-03-12	AAPL	Stock	63.985	67.5	62.0	62.0575	418474000.0
2020-03-12	MSFT	Stock	145.3	153.47	138.58	139.06	93226400.0
2020-03-12	NVDA	Stock	5.6365	5.903	5.395	5.4078	816540000.0
2020-03-12	AMZN	Stock	86.099	88.25	83.75	83.8305	226924000.0
2020-03-12	GOOGL	Stock	56.131	59.4375	55.4235	55.5775	94325860.0
2020-03-12	META	Stock	159.54	166.6	154.34	154.47	43266300.0
2020-03-12	TSLA	Stock	38.726	39.6333	36.4167	37.37	283636500.0
2020-03-12	TLT	Stock	163.51	166.36	155.66	157.5	24361836.0
2020-03-12	ES	Stock	83.72	84.45	73.9	82.62	3492200.0
2020-03-12	CL	Stock	64.93	67.45	63.2	63.89	9772200.0
2020-03-12	A	Stock	64.0	67.14	62.16	63.42	5055000.0
2020-03-12	AA	Stock	8.35	8.35	7.24	7.51	12676900.0
2020-03-12	AACG	Stock	0.96	1.0	0.9	0.9	35900.0
2020-03-12	AAIC-DELISTED	Stock	3.85	3.86	3.12	3.16	888646.0
2020-03-12	AAIC.C-DELISTED	Stock	18.06	18.418	16.2183	17.2737	11274.0
2020-03-12	AAL	Stock	14.05	15.75	13.33	13.45	53968500.0
2020-03-12	AAM.A-DELISTED	Stock	24.69	24.69	20.98	21.9	101489.0
2020-03-12	AAM.B-DELISTED	Stock	24.0	24.105	21.34	22.305	97509.0
2020-03-12	AAMC-DELISTED	Stock	5.2824	5.2824	4.4118	5.1412	22012.0
2020-03-12	AAME	Stock	2.31	2.6	2.31	2.52	1600.0
2020-03-12	AAMI	Stock	6.1	6.24	5.86	5.97	777800.0
2020-03-12	AAOI	Stock	6.31	6.5	5.665	5.68	1065200.0
2020-03-12	AAON	Stock	27.6667	31.4333	26.9867	27.5133	1192650.0
2020-03-12	AAP	Stock	118.4	120.33	109.02	109.17	1721300.0
2020-03-12	AAT	Stock	33.53	33.72	30.41	30.42	473900.0
2020-03-12	AAU-DELISTED	Stock	0.29	0.2989	0.2561	0.2897	611329.0
2020-03-12	AAUAF-DELISTED	Stock	0.29	0.2989	0.2561	0.2899	649105.0
2020-03-12	AAWW-DELISTED	Stock	17.27	17.4	15.37	16.42	1281463.0
2020-03-12	AAXJ	Stock	59.48	60.0	57.51	58.83	4046698.0
2020-03-12	AAXN-DELISTED	Stock	54.19	59.98	51.86	56.73	964153.0
2020-03-12	AB	Stock	24.3	24.39	19.12	22.56	1867400.0
2020-03-12	ABB-DELISTED	Stock	17.24	17.5	16.4	16.83	3726450.0
2020-03-12	ABBNY-DELISTED	Stock	17.24	17.5	16.4	16.83	3998001.0
2020-03-12	ABBV	Stock	78.85	81.29	77.06	78.61	19935700.0
2020-03-12	ABC-DELISTED	Stock	80.46	84.28	79.0861	80.49	4965826.0
2020-03-12	ABCB	Stock	24.0	25.91	23.16	24.09	802900.0
2020-03-12	ABEO	Stock	49.5	49.75	41.75	43.25	80748.0
2020-03-12	ABEV	Stock	2.04	2.73	2.04	2.61	44605500.0
2020-03-12	ABG	Stock	65.16	66.85	58.69	58.7	298100.0
2020-03-12	ABM	Stock	27.0	27.0	24.16	24.17	608400.0
2020-03-12	ABMD-DELISTED	Stock	143.07	149.43	135.77	137.04	757510.0
2020-03-12	ABR	Stock	8.12	8.93	7.78	8.37	3412800.0
2020-03-12	ABR.A-DELISTED	Stock	23.6	24.2	22.96	23.0745	42615.0
2020-03-12	ABR.B-DELISTED	Stock	22.73	23.75	21.4	22.7	28132.0
2020-03-12	ABR.C-DELISTED	Stock	24.82	24.82	20.5	22.66	32092.0
2020-03-12	ABT	Stock	73.28	78.15	72.01	74.74	13876300.0
2020-03-12	ABTC	Stock	174000.0	177900.0	151800.0	152400.0	3.1199999999999997
2020-03-12	ABTS	Stock	21.15	22.2	16.2	17.025	4553.0
2020-03-12	ABTX-DELISTED	Stock	24.43	26.14	23.39	24.42	105321.0
2020-03-12	ABUS	Stock	2.41	2.46	2.17	2.31	637900.0

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

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