PREVIEW / stock_daily / 2020-02-05

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-05.parquet
  size:    221 KB
  rows:    6,577
  symbols: 2,387

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-05	AAPL	Stock	80.88	81.19	79.7375	80.3625	118826800.0
2020-02-05	MSFT	Stock	184.03	184.2	178.41	179.9	39186300.0
2020-02-05	NVDA	Stock	6.2998	6.31	6.1852	6.269	208220000.0
2020-02-05	AMZN	Stock	103.551	103.551	101.6	101.9935	87524000.0
2020-02-05	GOOGL	Stock	73.1805	73.229	71.4838	72.3025	36375860.0
2020-02-05	META	Stock	212.51	212.73	208.71	210.11	12538200.0
2020-02-05	TSLA	Stock	54.884	56.3987	46.9407	48.98	726357000.0
2020-02-05	TLT	Stock	142.3	142.7	141.9	142.01	10782161.0
2020-02-05	ES	Stock	90.37	90.59	89.78	90.49	2132000.0
2020-02-05	CL	Stock	75.25	75.87	74.51	75.73	4282900.0
2020-02-05	A	Stock	84.53	85.5	84.39	84.93	2345100.0
2020-02-05	AA	Stock	15.31	15.89	15.175	15.81	8183000.0
2020-02-05	AACG	Stock	1.16	1.16	1.15	1.16	7100.0
2020-02-05	AAIC-DELISTED	Stock	5.68	5.76	5.67	5.74	512364.0
2020-02-05	AAIC.C-DELISTED	Stock	22.65	22.8	22.6	22.753	4670.0
2020-02-05	AAL	Stock	28.96	29.24	28.55	29.1	8959700.0
2020-02-05	AAM.A-DELISTED	Stock	26.99	26.995	26.89	26.9	14782.0
2020-02-05	AAM.B-DELISTED	Stock	27.24	27.49	27.24	27.46	27339.0
2020-02-05	AAME	Stock	2.23	2.23	2.19	2.23	600.0
2020-02-05	AAMI	Stock	10.11	10.55	10.09	10.13	604400.0
2020-02-05	AAOI	Stock	12.41	12.501	11.81	12.13	663800.0
2020-02-05	AAON	Stock	36.0333	36.5333	35.7467	36.0667	233250.0
2020-02-05	AAP	Stock	132.71	137.64	132.25	137.02	1199400.0
2020-02-05	AAT	Stock	46.54	46.88	46.36	46.54	167400.0
2020-02-05	AAU-DELISTED	Stock	0.4701	0.4798	0.45	0.4684	270762.0
2020-02-05	AAUAF-DELISTED	Stock	0.4701	0.4798	0.45	0.4684	281540.0
2020-02-05	AAWW-DELISTED	Stock	23.15	24.89	23.15	24.8	730869.0
2020-02-05	AAXJ	Stock	72.89	72.89	71.84	72.0	1459278.0
2020-02-05	AAXN-DELISTED	Stock	83.23	83.6277	79.77	81.81	484017.0
2020-02-05	AB	Stock	34.2	34.4	34.04	34.31	140200.0
2020-02-05	ABB-DELISTED	Stock	25.11	25.3	24.96	25.16	4197032.0
2020-02-05	ABBNY-DELISTED	Stock	25.11	25.3	24.96	25.16	4416128.0
2020-02-05	ABBV	Stock	85.06	87.14	84.88	86.63	10020600.0
2020-02-05	ABC-DELISTED	Stock	89.13	92.47	89.13	91.43	1295317.0
2020-02-05	ABCB	Stock	41.32	42.55	41.19	42.19	377700.0
2020-02-05	ABEO	Stock	62.0	69.0	61.5	66.0	81072.0
2020-02-05	ABEV	Stock	4.17	4.2	4.02	4.07	40597100.0
2020-02-05	ABG	Stock	96.57	97.65	94.96	96.33	285900.0
2020-02-05	ABM	Stock	40.05	40.71	40.05	40.55	222600.0
2020-02-05	ABMD-DELISTED	Stock	192.74	194.33	188.62	190.75	617766.0
2020-02-05	ABR	Stock	15.2	15.26	15.12	15.24	632300.0
2020-02-05	ABR.A-DELISTED	Stock	26.47	26.47	26.4527	26.47	2300.0
2020-02-05	ABR.B-DELISTED	Stock	26.08	26.159	25.9802	26.159	730.0
2020-02-05	ABR.C-DELISTED	Stock	26.675	26.7601	26.67	26.7601	610.0
2020-02-05	ABT	Stock	88.87	89.61	88.55	89.56	3565700.0
2020-02-05	ABTC	Stock	240600.0	241800.0	232500.0	235500.0	1.7066666666666668
2020-02-05	ABTS	Stock	31.5	37.05	30.15	32.85	5140.0
2020-02-05	ABTX-DELISTED	Stock	38.06	38.625	37.84	38.61	137421.0
2020-02-05	ABUS	Stock	3.25	3.31	3.1	3.24	1563800.0
2020-02-05	ACA	Stock	45.24	46.87	44.995	46.66	313143.0

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

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