PREVIEW / stock_daily / 2020-05-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-06.parquet
  size:    215 KB
  rows:    6,587
  symbols: 2,344

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-06	AAPL	Stock	75.115	75.81	74.7175	75.1575	142333600.0
2020-05-06	MSFT	Stock	182.08	184.2	181.63	182.54	32139300.0
2020-05-06	NVDA	Stock	7.4232	7.55	7.3853	7.4448	323464000.0
2020-05-06	AMZN	Stock	116.472	117.8725	116.0	117.563	62356000.0
2020-05-06	GOOGL	Stock	67.9	68.4345	67.2565	67.2715	31732580.0
2020-05-06	META	Stock	208.12	211.6	206.66	208.47	21857000.0
2020-05-06	TSLA	Stock	51.7667	52.6533	50.7407	52.172	166848000.0
2020-05-06	TLT	Stock	163.23	163.64	162.05	163.41	14721518.0
2020-05-06	ES	Stock	80.93	81.39	76.17	76.26	1907700.0
2020-05-06	CL	Stock	69.39	69.49	67.8	67.84	4551400.0
2020-05-06	A	Stock	76.69	78.83	76.65	77.87	2303600.0
2020-05-06	AA	Stock	7.89	7.94	7.585	7.71	6236800.0
2020-05-06	AACG	Stock	0.7	0.79	0.7	0.75	25300.0
2020-05-06	AAIC-DELISTED	Stock	2.65	2.76	2.55	2.56	266277.0
2020-05-06	AAIC.C-DELISTED	Stock	17.36	17.4	16.51	17.37	5597.0
2020-05-06	AAL	Stock	9.58	9.73	9.09	9.25	68991000.0
2020-05-06	AAM.A-DELISTED	Stock	25.67	25.814	25.45	25.78	132085.0
2020-05-06	AAM.B-DELISTED	Stock	25.63	25.71	25.55	25.55	14341.0
2020-05-06	AAMC-DELISTED	Stock	4.4124	4.9265	4.3324	4.55	12529.0
2020-05-06	AAME	Stock	1.8	1.8	1.79	1.79	500.0
2020-05-06	AAMI	Stock	7.27	7.37	7.09	7.23	526700.0
2020-05-06	AAOI	Stock	10.36	10.9	10.29	10.78	574600.0
2020-05-06	AAON	Stock	30.9267	31.5667	30.5933	31.28	303900.0
2020-05-06	AAP	Stock	121.81	122.94	119.57	121.16	683800.0
2020-05-06	AAT	Stock	27.13	27.55	26.55	26.77	404000.0
2020-05-06	AAU-DELISTED	Stock	0.44	0.44	0.41	0.41	111202.0
2020-05-06	AAUAF-DELISTED	Stock	0.44	0.44	0.41	0.41	126259.0
2020-05-06	AAWW-DELISTED	Stock	33.22	35.59	33.22	35.57	1061768.0
2020-05-06	AAXJ	Stock	63.35	63.39	62.73	62.81	2109757.0
2020-05-06	AAXN-DELISTED	Stock	66.901	68.23	65.64	66.28	392251.0
2020-05-06	AB	Stock	22.5	22.71	21.48	21.9	311000.0
2020-05-06	ABB-DELISTED	Stock	17.96	17.96	17.68	17.68	1129818.0
2020-05-06	ABBNY-DELISTED	Stock	17.96	17.96	17.67	17.67	1453433.0
2020-05-06	ABBV	Stock	86.28	88.15	85.25	85.42	17042600.0
2020-05-06	ABC-DELISTED	Stock	88.35	88.56	85.2	85.55	1006541.0
2020-05-06	ABCB	Stock	23.3	23.64	21.8	21.92	295900.0
2020-05-06	ABEO	Stock	63.75	64.25	60.25	60.75	21964.0
2020-05-06	ABEV	Stock	2.15	2.15	2.06	2.1	31829700.0
2020-05-06	ABG	Stock	68.55	69.04	63.48	64.89	339300.0
2020-05-06	ABM	Stock	32.04	32.71	30.98	31.06	294800.0
2020-05-06	ABMD-DELISTED	Stock	187.59	190.12	185.03	186.91	215212.0
2020-05-06	ABR	Stock	6.87	6.96	6.46	6.69	3012400.0
2020-05-06	ABR.A-DELISTED	Stock	22.7516	23.4	22.018	23.175	2898.0
2020-05-06	ABR.B-DELISTED	Stock	22.315	22.315	21.25	21.53	6263.0
2020-05-06	ABR.C-DELISTED	Stock	23.4321	24.225	23.4321	24.1191	2450.0
2020-05-06	ABT	Stock	93.15	93.43	91.03	91.08	4248400.0
2020-05-06	ABTC	Stock	215400.0	225600.0	214500.0	225000.0	2.1599999999999997
2020-05-06	ABTS	Stock	11.85	11.85	9.75	10.86	333.0
2020-05-06	ABTX-DELISTED	Stock	22.65	22.99	21.84	22.08	72545.0
2020-05-06	ABUS	Stock	1.3	1.48	1.25	1.42	1230100.0

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

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