PREVIEW / stock_daily / 2020-01-31

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-31.parquet
  size:    221 KB
  rows:    6,575
  symbols: 2,389

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-01-31	AAPL	Stock	80.2325	80.67	77.0725	77.3775	199588400.0
2020-01-31	MSFT	Stock	172.21	172.4	169.58	170.23	36142700.0
2020-01-31	NVDA	Stock	6.0993	6.1112	5.8688	5.9108	370420000.0
2020-01-31	AMZN	Stock	102.5735	102.786	100.1135	100.436	311346000.0
2020-01-31	GOOGL	Stock	73.393	73.4835	71.353	71.639	43821500.0
2020-01-31	META	Stock	208.43	208.69	201.06	201.91	31359900.0
2020-01-31	TSLA	Stock	42.6667	43.5333	42.168	43.3713	235789500.0
2020-01-31	TLT	Stock	145.17	145.99	145.09	145.9	14538096.0
2020-01-31	ES	Stock	93.22	93.56	92.01	92.44	4749800.0
2020-01-31	CL	Stock	73.64	74.97	73.37	73.78	13592300.0
2020-01-31	A	Stock	84.03	84.34	82.34	82.56	2850400.0
2020-01-31	AA	Stock	14.01	14.24	13.62	13.95	9964100.0
2020-01-31	AACG	Stock	1.15	1.22	1.15	1.16	11600.0
2020-01-31	AAIC-DELISTED	Stock	5.71	5.72	5.65	5.68	352108.0
2020-01-31	AAIC.C-DELISTED	Stock	22.38	22.5	22.17	22.46	3292.0
2020-01-31	AAL	Stock	27.5	27.52	26.59	26.84	11027900.0
2020-01-31	AAM.A-DELISTED	Stock	26.89	26.98	26.83	26.98	42433.0
2020-01-31	AAM.B-DELISTED	Stock	27.35	27.39	27.18	27.19	15434.0
2020-01-31	AAMC-DELISTED	Stock	3.7246	3.9735	3.6618	3.9735	12124.0
2020-01-31	AAME	Stock	1.9	2.23	1.9	2.21	12100.0
2020-01-31	AAMI	Stock	9.35	9.42	9.16	9.21	351500.0
2020-01-31	AAOI	Stock	11.55	11.69	11.21	11.3	731500.0
2020-01-31	AAON	Stock	35.9933	36.3667	34.76	34.96	199500.0
2020-01-31	AAP	Stock	134.34	134.59	131.5	131.75	1280700.0
2020-01-31	AAT	Stock	46.39	46.7	45.34	45.56	442500.0
2020-01-31	AAU-DELISTED	Stock	0.5	0.5523	0.4999	0.5521	219971.0
2020-01-31	AAUAF-DELISTED	Stock	0.5	0.5523	0.4999	0.55	224228.0
2020-01-31	AAWW-DELISTED	Stock	22.77	22.86	22.02	22.38	380716.0
2020-01-31	AAXJ	Stock	69.29	69.3065	68.52	68.87	2805464.0
2020-01-31	AAXN-DELISTED	Stock	78.16	78.61	76.375	76.79	384726.0
2020-01-31	AB	Stock	33.47	33.47	32.7	32.75	185900.0
2020-01-31	ABB-DELISTED	Stock	23.45	23.45	23.08	23.18	1775997.0
2020-01-31	ABBNY-DELISTED	Stock	23.45	23.45	23.08	23.17	1859452.0
2020-01-31	ABBV	Stock	81.54	81.72	80.41	81.02	13870100.0
2020-01-31	ABC-DELISTED	Stock	89.25	89.29	85.27	85.49	943301.0
2020-01-31	ABCB	Stock	40.75	41.03	39.92	40.19	380000.0
2020-01-31	ABDC-DELISTED	Stock	9.23	9.23	8.7973	8.9	229090.0
2020-01-31	ABEO	Stock	59.5	59.5	53.75	54.25	73388.0
2020-01-31	ABEV	Stock	4.2	4.23	4.13	4.16	11719900.0
2020-01-31	ABG	Stock	99.21	99.62	96.09	96.45	212700.0
2020-01-31	ABM	Stock	38.64	38.9	37.96	38.14	1083200.0
2020-01-31	ABMD-DELISTED	Stock	186.34	188.83	183.4371	186.28	290739.0
2020-01-31	ABR	Stock	15.14	15.14	14.71	14.77	2456500.0
2020-01-31	ABR.A-DELISTED	Stock	26.45	26.5	26.45	26.5	500.0
2020-01-31	ABR.B-DELISTED	Stock	26.09	26.2	26.08	26.19	3276.0
2020-01-31	ABR.C-DELISTED	Stock	26.6137	26.6499	26.6	26.6	1992.0
2020-01-31	ABT	Stock	89.13	89.23	86.9	87.14	5914100.0
2020-01-31	ABTC	Stock	234000.0	244500.0	231000.0	243600.0	1.4133333333333333
2020-01-31	ABTX-DELISTED	Stock	37.71	37.71	37.13	37.17	83194.0
2020-01-31	ABUS	Stock	2.77	2.8	2.56	2.61	347600.0

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

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