PREVIEW / stock_daily / 2020-05-05

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-05.parquet
  size:    216 KB
  rows:    6,562
  symbols: 2,327

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-05	AAPL	Stock	73.765	75.25	73.615	74.39	147751200.0
2020-05-05	MSFT	Stock	180.62	183.65	179.9	180.76	36839200.0
2020-05-05	NVDA	Stock	7.3868	7.5068	7.2823	7.3435	368896000.0
2020-05-05	AMZN	Stock	117.0	117.55	115.3565	115.89	64850000.0
2020-05-05	GOOGL	Stock	66.875	68.5505	66.7515	67.451	39666360.0
2020-05-05	META	Stock	207.02	210.38	206.5	207.07	21071200.0
2020-05-05	TSLA	Stock	52.6527	53.2613	50.812	51.214	254875500.0
2020-05-05	TLT	Stock	165.57	166.27	165.27	166.09	7831916.0
2020-05-05	ES	Stock	80.77	82.55	80.76	80.99	1849700.0
2020-05-05	CL	Stock	69.5	70.13	69.02	69.52	2458000.0
2020-05-05	A	Stock	74.91	77.58	74.83	76.37	1476100.0
2020-05-05	AA	Stock	8.02	8.27	7.72	7.81	8138900.0
2020-05-05	AACG	Stock	0.7	0.74	0.65	0.72	9700.0
2020-05-05	AAIC-DELISTED	Stock	2.73	2.83	2.65	2.65	292625.0
2020-05-05	AAIC.C-DELISTED	Stock	16.85	17.41	16.85	17.36	1593.0
2020-05-05	AAL	Stock	10.26	10.38	9.5	9.51	86943900.0
2020-05-05	AAM.A-DELISTED	Stock	25.84	25.85	25.66	25.67	14317.0
2020-05-05	AAM.B-DELISTED	Stock	25.84	25.85	25.6168	25.65	37517.0
2020-05-05	AAMC-DELISTED	Stock	4.7794	5.1735	4.6412	4.6559	17214.0
2020-05-05	AAME	Stock	1.65	1.8	1.65	1.8	800.0
2020-05-05	AAMI	Stock	7.75	7.9	7.23	7.24	480800.0
2020-05-05	AAOI	Stock	10.62	10.85	10.2	10.34	472600.0
2020-05-05	AAON	Stock	30.86	31.32	30.5333	30.7533	397950.0
2020-05-05	AAP	Stock	121.89	123.59	121.0	121.19	440100.0
2020-05-05	AAT	Stock	27.95	28.32	27.02	27.09	301800.0
2020-05-05	AAU-DELISTED	Stock	0.429	0.4378	0.42	0.4338	465591.0
2020-05-05	AAUAF-DELISTED	Stock	0.429	0.4378	0.42	0.4338	494712.0
2020-05-05	AAWW-DELISTED	Stock	33.45	34.14	32.16	33.45	742498.0
2020-05-05	AAXJ	Stock	63.0	63.26	62.74	62.75	2014933.0
2020-05-05	AAXN-DELISTED	Stock	68.09	68.81	65.77	65.85	482952.0
2020-05-05	AB	Stock	23.37	23.44	22.18	22.26	355900.0
2020-05-05	ABB-DELISTED	Stock	18.25	18.28	17.94	17.96	1670580.0
2020-05-05	ABBNY-DELISTED	Stock	18.25	18.28	17.94	17.96	1791777.0
2020-05-05	ABBV	Stock	82.95	86.48	82.6	85.37	10927000.0
2020-05-05	ABC-DELISTED	Stock	87.5	89.45	85.61	87.94	1040500.0
2020-05-05	ABCB	Stock	24.8	24.97	23.05	23.17	266000.0
2020-05-05	ABEO	Stock	61.25	62.75	59.5	62.75	38536.0
2020-05-05	ABEV	Stock	2.18	2.21	2.14	2.15	23055300.0
2020-05-05	ABG	Stock	69.09	71.77	66.46	67.45	367400.0
2020-05-05	ABM	Stock	33.09	33.27	32.19	32.21	329600.0
2020-05-05	ABMD-DELISTED	Stock	182.84	189.62	182.525	186.22	243546.0
2020-05-05	ABR	Stock	6.9	7.18	6.77	6.78	2166000.0
2020-05-05	ABR.A-DELISTED	Stock	22.5	23.5	22.5	23.16	2850.0
2020-05-05	ABR.B-DELISTED	Stock	21.95	22.4	21.7623	22.22	44192.0
2020-05-05	ABR.C-DELISTED	Stock	23.7	23.7	23.21	23.7	4901.0
2020-05-05	ABT	Stock	90.95	93.66	90.39	93.03	6747900.0
2020-05-05	ABTC	Stock	221100.0	222000.0	213300.0	216000.0	2.146666666666667
2020-05-05	ABTS	Stock	10.8	11.7	10.125	11.355	2213.0
2020-05-05	ABTX-DELISTED	Stock	24.12	24.63	22.49	22.61	80230.0
2020-05-05	ABUS	Stock	1.23	1.38	1.18	1.27	1384100.0

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

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