PREVIEW / stock_daily / 2020-02-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-11.parquet
  size:    220 KB
  rows:    6,571
  symbols: 2,376

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-02-11	AAPL	Stock	80.9	80.975	79.6775	79.9025	94323200.0
2020-02-11	MSFT	Stock	190.65	190.7	183.5	184.44	53159900.0
2020-02-11	NVDA	Stock	6.683	6.8125	6.6208	6.6972	638556000.0
2020-02-11	AMZN	Stock	107.545	109.2975	106.8	107.54	114920000.0
2020-02-11	GOOGL	Stock	75.6635	76.494	75.2725	75.503	34852940.0
2020-02-11	META	Stock	210.19	210.86	206.51	207.19	25030800.0
2020-02-11	TSLA	Stock	51.2527	52.234	50.5333	51.6253	175462500.0
2020-02-11	TLT	Stock	144.59	144.72	143.94	144.1	7784102.0
2020-02-11	ES	Stock	91.43	91.75	91.09	91.18	940800.0
2020-02-11	CL	Stock	77.24	77.29	76.1	76.11	3992600.0
2020-02-11	A	Stock	85.03	85.67	84.84	85.09	1543200.0
2020-02-11	AA	Stock	15.57	16.21	15.54	15.74	4580400.0
2020-02-11	AACG	Stock	1.11	1.11	1.04	1.08	10700.0
2020-02-11	AAIC-DELISTED	Stock	5.73	5.89	5.73	5.86	798351.0
2020-02-11	AAIC.C-DELISTED	Stock	22.49	22.6	22.45	22.5276	11261.0
2020-02-11	AAL	Stock	29.06	29.94	28.97	29.84	8977700.0
2020-02-11	AAM.A-DELISTED	Stock	27.13	27.13	26.924	27.06	18474.0
2020-02-11	AAM.B-DELISTED	Stock	27.8	27.88	27.56	27.83	38565.0
2020-02-11	AAMC-DELISTED	Stock	3.8206	3.8206	3.6853	3.6853	5392.0
2020-02-11	AAME	Stock	2.2	2.2	2.07	2.08	4800.0
2020-02-11	AAMI	Stock	10.16	10.46	10.08	10.36	231400.0
2020-02-11	AAOI	Stock	11.4	11.66	11.11	11.51	649200.0
2020-02-11	AAON	Stock	36.64	37.46	36.48	36.74	136650.0
2020-02-11	AAP	Stock	130.96	132.84	130.79	132.11	558100.0
2020-02-11	AAT	Stock	46.29	46.57	45.93	46.06	393900.0
2020-02-11	AAU-DELISTED	Stock	0.43	0.45	0.43	0.4352	347062.0
2020-02-11	AAUAF-DELISTED	Stock	0.43	0.45	0.43	0.4352	376913.0
2020-02-11	AAWW-DELISTED	Stock	27.27	27.7	26.91	27.07	281199.0
2020-02-11	AAXJ	Stock	72.88	73.28	72.81	72.94	1775564.0
2020-02-11	AAXN-DELISTED	Stock	86.04	87.51	84.89	87.16	373401.0
2020-02-11	AB	Stock	34.92	35.43	34.58	34.87	321900.0
2020-02-11	ABB-DELISTED	Stock	24.56	24.7485	24.5131	24.655	1551526.0
2020-02-11	ABBNY-DELISTED	Stock	24.56	24.7485	24.5131	24.64	1696421.0
2020-02-11	ABBV	Stock	95.26	97.08	95.01	96.0	10682800.0
2020-02-11	ABC-DELISTED	Stock	94.33	94.61	92.72	94.57	898507.0
2020-02-11	ABCB	Stock	41.61	42.19	41.14	41.39	149900.0
2020-02-11	ABEO	Stock	74.75	84.5	73.25	79.0	124836.0
2020-02-11	ABEV	Stock	3.88	3.89	3.8	3.81	21732300.0
2020-02-11	ABG	Stock	96.75	100.5	96.75	100.0	366400.0
2020-02-11	ABM	Stock	38.74	39.19	38.74	38.98	158500.0
2020-02-11	ABMD-DELISTED	Stock	175.5	179.25	172.7	175.75	588172.0
2020-02-11	ABR	Stock	15.02	15.09	14.88	14.89	726800.0
2020-02-11	ABR.A-DELISTED	Stock	26.48	26.55	26.45	26.55	6171.0
2020-02-11	ABR.B-DELISTED	Stock	26.27	26.298	26.2208	26.298	1355.0
2020-02-11	ABR.C-DELISTED	Stock	27.15	27.15	27.15	27.15	399.0
2020-02-11	ABT	Stock	88.64	89.41	88.53	89.17	2661900.0
2020-02-11	ABTC	Stock	236400.0	241500.0	230400.0	236400.0	1.4933333333333332
2020-02-11	ABTS	Stock	28.815	30.0	28.815	30.0	80.0
2020-02-11	ABTX-DELISTED	Stock	38.45	38.71	38.22	38.26	93842.0
2020-02-11	ABUS	Stock	3.15	3.19	3.04	3.07	1516500.0

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

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