PREVIEW / stock_daily / 2020-02-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-04.parquet
  size:    223 KB
  rows:    6,603
  symbols: 2,400

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-04	AAPL	Stock	78.8275	79.91	78.4075	79.7125	136616400.0
2020-02-04	MSFT	Stock	177.14	180.64	176.31	180.12	36433300.0
2020-02-04	NVDA	Stock	6.1508	6.1975	6.1005	6.1782	271544000.0
2020-02-04	AMZN	Stock	101.494	102.99	100.7685	102.4835	105786000.0
2020-02-04	GOOGL	Stock	72.7245	73.3668	71.1015	72.2705	95879340.0
2020-02-04	META	Stock	206.62	210.6	205.2	209.83	19628900.0
2020-02-04	TSLA	Stock	58.864	64.5993	55.592	59.1373	914082000.0
2020-02-04	TLT	Stock	143.99	144.14	143.06	143.58	11388275.0
2020-02-04	ES	Stock	92.02	92.28	90.44	90.6	2599000.0
2020-02-04	CL	Stock	75.28	76.2	75.19	75.4	4671800.0
2020-02-04	A	Stock	82.85	83.9	82.78	83.52	1676000.0
2020-02-04	AA	Stock	14.46	14.945	14.24	14.7	7443200.0
2020-02-04	AACG	Stock	1.16	1.17	1.15	1.15	3700.0
2020-02-04	AAIC-DELISTED	Stock	5.66	5.69	5.65	5.68	306259.0
2020-02-04	AAIC.C-DELISTED	Stock	22.376	22.65	22.376	22.65	6646.0
2020-02-04	AAL	Stock	27.68	28.61	27.55	28.43	10832900.0
2020-02-04	AAM.A-DELISTED	Stock	27.0	27.05	26.94	26.95	15693.0
2020-02-04	AAM.B-DELISTED	Stock	27.39	27.48	27.29	27.39	28064.0
2020-02-04	AAMC-DELISTED	Stock	3.8676	3.9265	3.815	3.815	10220.0
2020-02-04	AAME	Stock	2.22	2.22	2.18	2.21	1700.0
2020-02-04	AAMI	Stock	9.55	10.04	9.55	9.94	460300.0
2020-02-04	AAOI	Stock	11.86	12.41	11.64	12.4	953900.0
2020-02-04	AAON	Stock	35.9533	36.0933	35.4333	35.6	313650.0
2020-02-04	AAP	Stock	134.09	134.63	131.54	131.56	822300.0
2020-02-04	AAT	Stock	46.42	46.62	46.24	46.38	207600.0
2020-02-04	AAU-DELISTED	Stock	0.46	0.48	0.45	0.452	589987.0
2020-02-04	AAUAF-DELISTED	Stock	0.46	0.48	0.45	0.452	647641.0
2020-02-04	AAWW-DELISTED	Stock	22.48	22.72	21.78	22.71	343006.0
2020-02-04	AAXJ	Stock	71.53	72.0	71.52	71.72	974788.0
2020-02-04	AAXN-DELISTED	Stock	78.99	82.49	78.6949	81.8	600447.0
2020-02-04	AB	Stock	33.5	34.06	33.27	33.93	200500.0
2020-02-04	ABB-DELISTED	Stock	23.81	24.13	23.81	24.1	2871311.0
2020-02-04	ABBNY-DELISTED	Stock	23.81	24.13	23.81	24.1	3037816.0
2020-02-04	ABBV	Stock	83.59	84.71	83.59	84.36	8251500.0
2020-02-04	ABC-DELISTED	Stock	87.15	89.14	87.01	88.09	1189212.0
2020-02-04	ABCB	Stock	41.13	41.21	40.54	40.8	189800.0
2020-02-04	ABEO	Stock	56.0	61.0	55.25	60.5	47888.0
2020-02-04	ABEV	Stock	4.18	4.2	4.08	4.09	28185000.0
2020-02-04	ABG	Stock	99.09	100.29	95.23	95.66	251800.0
2020-02-04	ABM	Stock	39.4	40.18	39.38	39.85	258600.0
2020-02-04	ABMD-DELISTED	Stock	187.81	192.72	186.25	190.9	358117.0
2020-02-04	ABR	Stock	15.04	15.3	14.93	15.17	1133100.0
2020-02-04	ABR.A-DELISTED	Stock	26.3	26.3	26.3	26.3	300.0
2020-02-04	ABR.B-DELISTED	Stock	26.18	26.18	26.18	26.18	300.0
2020-02-04	ABR.C-DELISTED	Stock	26.61	26.74	26.61	26.74	3368.0
2020-02-04	ABT	Stock	88.15	89.25	88.15	88.23	3904600.0
2020-02-04	ABTC	Stock	234000.0	240360.0	228000.0	232500.0	2.466666666666667
2020-02-04	ABTS	Stock	31.95	41.85	27.015	27.015	4280.0
2020-02-04	ABTX-DELISTED	Stock	38.0	38.15	37.53	37.88	136319.0
2020-02-04	ABUS	Stock	2.6	2.84	2.6	2.81	134100.0

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

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