PREVIEW / stock_daily / 2020-10-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-02.parquet
  size:    226 KB
  rows:    6,914
  symbols: 2,465

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-10-02	AAPL	Stock	112.89	115.37	112.22	113.02	144712000.0
2020-10-02	MSFT	Stock	208.0	210.99	205.54	206.19	33154800.0
2020-10-02	NVDA	Stock	13.225	13.5195	13.051	13.0622	552496000.0
2020-10-02	AMZN	Stock	157.6815	159.79	156.15	156.25	112262000.0
2020-10-02	GOOGL	Stock	72.9815	73.9515	72.3675	72.78	31222640.0
2020-10-02	META	Stock	261.21	265.15	259.18	259.94	16367600.0
2020-10-02	TSLA	Stock	140.4633	146.3767	138.3333	138.3633	214290000.0
2020-10-02	TLT	Stock	163.61	163.67	162.18	162.75	8829140.0
2020-10-02	ES	Stock	84.93	87.63	84.64	87.05	1717300.0
2020-10-02	CL	Stock	76.59	77.96	76.46	77.4	3540200.0
2020-10-02	A	Stock	100.21	101.28	99.81	100.01	712200.0
2020-10-02	AA	Stock	11.02	11.95	10.98	11.82	5600900.0
2020-10-02	AACG	Stock	1.1	1.14	1.09	1.1	17200.0
2020-10-02	AACQ-DELISTED	Stock	9.89	9.95	9.88	9.93	74362.0
2020-10-02	AACQU-DELISTED	Stock	10.29	10.48	10.29	10.4	31447.0
2020-10-02	AACQW-DELISTED	Stock	1.46	1.6098	1.46	1.49	165851.0
2020-10-02	AAIC-DELISTED	Stock	2.79	2.85	2.79	2.85	142576.0
2020-10-02	AAIC.C-DELISTED	Stock	18.77	18.95	18.77	18.95	211.0
2020-10-02	AAL	Stock	12.05	13.35	12.0	13.0	111883300.0
2020-10-02	AAM.A-DELISTED	Stock	25.93	26.08	25.9	26.08	25642.0
2020-10-02	AAM.B-DELISTED	Stock	27.04	27.1	26.9	27.09	21769.0
2020-10-02	AAMC-DELISTED	Stock	6.1618	6.1618	6.1618	6.1618	1846.0
2020-10-02	AAME	Stock	1.94	2.01	1.94	1.96	2600.0
2020-10-02	AAMI	Stock	12.58	13.33	12.58	13.24	524100.0
2020-10-02	AAOI	Stock	10.77	11.36	10.55	11.33	347100.0
2020-10-02	AAON	Stock	39.7267	40.7933	39.6467	40.62	209400.0
2020-10-02	AAP	Stock	152.24	156.35	151.66	155.5	487300.0
2020-10-02	AAT	Stock	24.36	25.51	24.3	25.45	181000.0
2020-10-02	AAU-DELISTED	Stock	0.81	0.82	0.781	0.8003	246415.0
2020-10-02	AAUAF-DELISTED	Stock	0.81	0.82	0.781	0.8114	260841.0
2020-10-02	AAWW-DELISTED	Stock	61.02	64.2	60.03	63.89	221181.0
2020-10-02	AAXJ	Stock	76.84	77.82	76.84	77.19	787207.0
2020-10-02	AAXN-DELISTED	Stock	93.5	94.49	90.87	91.58	338387.0
2020-10-02	AB	Stock	26.5	27.25	26.5	26.96	269600.0
2020-10-02	ABB-DELISTED	Stock	25.39	26.0	25.37	25.89	3857414.0
2020-10-02	ABBNY-DELISTED	Stock	25.39	26.0	25.37	25.89	4269678.0
2020-10-02	ABBV	Stock	86.5	87.35	86.05	86.12	5554300.0
2020-10-02	ABC-DELISTED	Stock	94.05	96.55	93.96	95.38	491129.0
2020-10-02	ABCB	Stock	22.61	23.92	22.61	23.82	314900.0
2020-10-02	ABEO	Stock	25.75	28.0	25.5	26.25	224028.0
2020-10-02	ABEV	Stock	2.25	2.3	2.22	2.24	19271200.0
2020-10-02	ABG	Stock	97.95	105.31	97.95	103.73	209400.0
2020-10-02	ABM	Stock	36.08	37.04	36.08	36.7	349100.0
2020-10-02	ABMD-DELISTED	Stock	256.48	265.41	255.405	262.12	287921.0
2020-10-02	ABR	Stock	11.32	11.95	11.02	11.85	990000.0
2020-10-02	ABR.A-DELISTED	Stock	25.4276	25.4276	25.4276	25.4276	200.0
2020-10-02	ABR.B-DELISTED	Stock	25.19	25.19	25.06	25.06	448.0
2020-10-02	ABR.C-DELISTED	Stock	25.77	25.99	25.3	25.43	17146.0
2020-10-02	ABT	Stock	107.68	108.66	106.33	106.5	5590500.0
2020-10-02	ABTC	Stock	118500.0	120300.0	115500.0	118800.0	6.426666666666667

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

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