PREVIEW / stock_daily / 2020-01-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-29.parquet
  size:    221 KB
  rows:    6,567
  symbols: 2,383

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-29	AAPL	Stock	81.1125	81.9625	80.345	81.085	216229200.0
2020-01-29	MSFT	Stock	167.84	168.75	165.69	168.04	34754500.0
2020-01-29	NVDA	Stock	6.1848	6.221	6.0985	6.1385	258848000.0
2020-01-29	AMZN	Stock	93.2	93.7375	92.751	92.9	41760000.0
2020-01-29	GOOGL	Stock	72.923	73.207	72.2692	72.835	21639280.0
2020-01-29	META	Stock	221.44	224.2	218.45	223.23	33181300.0
2020-01-29	TSLA	Stock	38.3793	39.32	37.8287	38.7327	267022500.0
2020-01-29	TLT	Stock	143.44	144.7	143.43	144.56	9567654.0
2020-01-29	ES	Stock	91.87	92.52	91.41	92.39	1376200.0
2020-01-29	CL	Stock	69.75	69.89	68.81	68.83	3233400.0
2020-01-29	A	Stock	87.55	88.36	87.15	87.24	1131500.0
2020-01-29	AA	Stock	14.83	14.874	14.35	14.5	5280600.0
2020-01-29	AACG	Stock	1.21	1.26	1.14	1.16	18100.0
2020-01-29	AAIC-DELISTED	Stock	5.76	5.81	5.73	5.76	238425.0
2020-01-29	AAIC.C-DELISTED	Stock	22.4	22.92	22.4	22.57	13166.0
2020-01-29	AAL	Stock	26.88	27.49	26.74	26.8	9088700.0
2020-01-29	AAM.A-DELISTED	Stock	26.93	26.93	26.86	26.86	14836.0
2020-01-29	AAM.B-DELISTED	Stock	27.32	27.33	27.22	27.32	17533.0
2020-01-29	AAMC-DELISTED	Stock	3.9235	3.9235	3.9206	3.9206	911.0
2020-01-29	AAME	Stock	2.22	2.23	1.82	2.02	4900.0
2020-01-29	AAMI	Stock	9.26	9.54	9.26	9.45	383300.0
2020-01-29	AAOI	Stock	12.89	12.985	11.9	11.93	1142000.0
2020-01-29	AAON	Stock	35.94	36.1133	35.5267	35.74	118650.0
2020-01-29	AAP	Stock	139.05	140.43	138.1	138.55	913400.0
2020-01-29	AAT	Stock	47.32	47.43	47.07	47.13	306000.0
2020-01-29	AAU-DELISTED	Stock	0.5034	0.5099	0.49	0.5041	230249.0
2020-01-29	AAUAF-DELISTED	Stock	0.5034	0.5099	0.49	0.5041	236866.0
2020-01-29	AAWW-DELISTED	Stock	23.67	24.02	23.12	23.36	338227.0
2020-01-29	AAXJ	Stock	71.71	71.78	71.355	71.53	945552.0
2020-01-29	AAXN-DELISTED	Stock	79.77	80.79	78.75	79.89	356715.0
2020-01-29	AB	Stock	33.92	34.09	33.76	33.78	201000.0
2020-01-29	ABB-DELISTED	Stock	23.56	23.685	23.46	23.53	1718461.0
2020-01-29	ABBNY-DELISTED	Stock	23.56	23.685	23.46	23.54	1802749.0
2020-01-29	ABBV	Stock	83.8	84.0	83.13	83.2	5703200.0
2020-01-29	ABC-DELISTED	Stock	89.49	90.85	89.2	89.88	1448262.0
2020-01-29	ABCB	Stock	41.15	41.23	40.51	40.61	371900.0
2020-01-29	ABDC-DELISTED	Stock	9.27	9.48	9.27	9.48	18511.0
2020-01-29	ABEO	Stock	62.0	63.25	59.25	59.5	31216.0
2020-01-29	ABEV	Stock	4.43	4.44	4.27	4.27	12211300.0
2020-01-29	ABG	Stock	100.76	101.7	99.4	99.56	126200.0
2020-01-29	ABM	Stock	39.18	39.43	38.88	39.02	265700.0
2020-01-29	ABMD-DELISTED	Stock	186.0	192.63	185.34	188.67	514905.0
2020-01-29	ABR	Stock	15.0	15.15	14.92	15.1	982200.0
2020-01-29	ABR.A-DELISTED	Stock	26.45	26.5	26.4	26.5	1400.0
2020-01-29	ABR.B-DELISTED	Stock	26.25	26.25	26.25	26.25	400.0
2020-01-29	ABR.C-DELISTED	Stock	26.5501	26.5501	26.55	26.55	440.0
2020-01-29	ABT	Stock	89.61	90.23	89.07	89.14	3914300.0
2020-01-29	ABTC	Stock	263400.0	263400.0	246300.0	250800.0	1.5599999999999998
2020-01-29	ABTX-DELISTED	Stock	37.0	37.98	37.0	37.76	179911.0
2020-01-29	ABUS	Stock	2.74	2.9	2.71	2.86	274700.0

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

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