PREVIEW / stock_daily / 2020-02-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-07.parquet
  size:    222 KB
  rows:    6,582
  symbols: 2,385

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-07	AAPL	Stock	80.5925	80.85	79.5	80.0075	117684000.0
2020-02-07	MSFT	Stock	182.85	185.63	182.48	183.89	33529100.0
2020-02-07	NVDA	Stock	6.316	6.3383	6.2643	6.2898	189752000.0
2020-02-07	AMZN	Stock	102.0995	104.9265	101.905	103.964	101906000.0
2020-02-07	GOOGL	Stock	73.3693	74.2622	73.2705	73.9555	28360980.0
2020-02-07	META	Stock	210.3	212.82	209.93	212.33	12242500.0
2020-02-07	TSLA	Stock	48.7033	51.3167	48.6667	49.8713	255952500.0
2020-02-07	TLT	Stock	144.22	144.74	143.87	144.43	11374834.0
2020-02-07	ES	Stock	91.11	91.23	90.42	90.58	1243900.0
2020-02-07	CL	Stock	76.4	76.52	75.9	76.03	3222700.0
2020-02-07	A	Stock	84.61	84.79	82.92	83.17	1447600.0
2020-02-07	AA	Stock	15.63	15.7	15.36	15.55	5058700.0
2020-02-07	AACG	Stock	1.13	1.14	1.03	1.03	11900.0
2020-02-07	AAIC-DELISTED	Stock	5.77	5.79	5.75	5.76	343959.0
2020-02-07	AAIC.C-DELISTED	Stock	22.63	22.63	22.55	22.6	2200.0
2020-02-07	AAL	Stock	28.06	28.55	27.78	28.38	6231800.0
2020-02-07	AAM.A-DELISTED	Stock	27.0	27.06	26.9665	27.02	36718.0
2020-02-07	AAM.B-DELISTED	Stock	27.55	27.812	27.55	27.79	21204.0
2020-02-07	AAMC-DELISTED	Stock	3.8244	3.8244	3.7929	3.808	3403.0
2020-02-07	AAME	Stock	2.19	2.19	2.19	2.19	800.0
2020-02-07	AAMI	Stock	10.34	10.46	9.88	9.95	273400.0
2020-02-07	AAOI	Stock	11.6	11.6	11.24	11.27	594900.0
2020-02-07	AAON	Stock	36.1133	36.4533	35.9267	36.3333	99600.0
2020-02-07	AAP	Stock	134.0	134.38	131.13	132.93	895500.0
2020-02-07	AAT	Stock	46.88	46.94	46.06	46.07	150100.0
2020-02-07	AAU-DELISTED	Stock	0.4606	0.464	0.45	0.45	236239.0
2020-02-07	AAUAF-DELISTED	Stock	0.4606	0.464	0.45	0.45	241590.0
2020-02-07	AAWW-DELISTED	Stock	24.9	27.7143	24.85	27.23	961255.0
2020-02-07	AAXJ	Stock	71.7	71.785	71.28	71.4	508516.0
2020-02-07	AAXN-DELISTED	Stock	83.36	83.85	81.67	82.88	225875.0
2020-02-07	AB	Stock	34.36	34.47	34.06	34.3	215300.0
2020-02-07	ABB-DELISTED	Stock	24.48	24.48	24.25	24.275	1626347.0
2020-02-07	ABBNY-DELISTED	Stock	24.48	24.48	24.25	24.27	1734329.0
2020-02-07	ABBV	Stock	89.74	92.98	88.88	92.29	19090300.0
2020-02-07	ABC-DELISTED	Stock	93.9	94.72	91.76	91.94	1225089.0
2020-02-07	ABCB	Stock	41.47	41.62	40.85	41.12	277400.0
2020-02-07	ABEO	Stock	65.5	66.0	62.75	62.75	24036.0
2020-02-07	ABEV	Stock	3.92	3.95	3.86	3.9	76469800.0
2020-02-07	ABG	Stock	93.89	94.4	92.25	93.67	178000.0
2020-02-07	ABM	Stock	39.38	39.4	38.39	38.42	162500.0
2020-02-07	ABMD-DELISTED	Stock	193.92	194.0	184.0	186.93	794026.0
2020-02-07	ABR	Stock	15.19	15.27	15.17	15.21	707900.0
2020-02-07	ABR.A-DELISTED	Stock	26.4	26.47	26.34	26.385	3971.0
2020-02-07	ABR.B-DELISTED	Stock	26.13	26.26	26.07	26.18	2080.0
2020-02-07	ABR.C-DELISTED	Stock	26.78	26.86	26.6792	26.86	3207.0
2020-02-07	ABT	Stock	89.23	89.51	87.68	87.87	4472300.0
2020-02-07	ABTC	Stock	221700.0	236310.0	219000.0	229500.0	1.9066666666666667
2020-02-07	ABTS	Stock	27.075	29.4	27.075	29.4	153.0
2020-02-07	ABTX-DELISTED	Stock	38.48	38.48	38.0	38.28	64447.0
2020-02-07	ABUS	Stock	3.2	3.27	3.09	3.25	323500.0

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

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