PREVIEW / stock_daily / 2020-01-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-23.parquet
  size:    222 KB
  rows:    6,586
  symbols: 2,407

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-23	AAPL	Stock	79.48	79.89	78.9125	79.8075	104472000.0
2020-01-23	MSFT	Stock	166.19	166.8	165.27	166.72	19680800.0
2020-01-23	NVDA	Stock	6.293	6.33	6.2038	6.3215	244516000.0
2020-01-23	AMZN	Stock	94.2555	94.499	93.638	94.229	49692000.0
2020-01-23	GOOGL	Stock	74.3775	74.675	74.016	74.2345	26651240.0
2020-01-23	META	Stock	220.75	221.49	219.27	219.76	11195000.0
2020-01-23	TSLA	Stock	37.6167	38.8	37.04	38.1467	294765000.0
2020-01-23	TLT	Stock	140.845	141.38	140.78	140.94	9747418.0
2020-01-23	ES	Stock	90.02	91.27	89.92	91.24	1809800.0
2020-01-23	CL	Stock	70.07	71.07	70.0	70.61	2581600.0
2020-01-23	A	Stock	89.62	89.98	88.66	89.07	1228300.0
2020-01-23	AA	Stock	16.37	16.41	15.94	16.29	7362900.0
2020-01-23	AACG	Stock	1.48	1.48	1.41	1.44	3600.0
2020-01-23	AAIC-DELISTED	Stock	5.8	5.8499	5.78	5.79	406687.0
2020-01-23	AAIC.C-DELISTED	Stock	22.35	22.35	22.11	22.11	6990.0
2020-01-23	AAL	Stock	27.39	28.99	26.04	28.8	25611100.0
2020-01-23	AAM.A-DELISTED	Stock	27.0	27.0113	26.8601	27.0085	21354.0
2020-01-23	AAM.B-DELISTED	Stock	27.45	27.47	27.21	27.36	17126.0
2020-01-23	AAMC-DELISTED	Stock	3.9618	3.9618	3.9618	3.9618	1030.0
2020-01-23	AAME	Stock	1.85	1.95	1.85	1.86	2100.0
2020-01-23	AAMI	Stock	9.88	9.94	9.69	9.71	335400.0
2020-01-23	AAOI	Stock	14.22	14.574	13.911	14.23	518200.0
2020-01-23	AAON	Stock	35.1067	35.8867	34.7533	35.8667	245550.0
2020-01-23	AAP	Stock	146.07	150.13	145.97	149.73	1312600.0
2020-01-23	AAT	Stock	47.61	48.03	47.5	47.91	328600.0
2020-01-23	AAU-DELISTED	Stock	0.53	0.5486	0.49	0.5435	319397.0
2020-01-23	AAUAF-DELISTED	Stock	0.53	0.5486	0.49	0.5435	330297.0
2020-01-23	AAWW-DELISTED	Stock	26.02	26.02	25.2	25.61	331952.0
2020-01-23	AAXJ	Stock	73.4	73.91	73.025	73.79	3273321.0
2020-01-23	AAXN-DELISTED	Stock	79.07	80.6581	78.58	78.64	582661.0
2020-01-23	AB	Stock	33.36	33.74	32.91	33.73	279900.0
2020-01-23	ABB-DELISTED	Stock	23.69	23.825	23.595	23.825	1009863.0
2020-01-23	ABBNY-DELISTED	Stock	23.69	23.83	23.595	23.83	1104603.0
2020-01-23	ABBV	Stock	87.05	87.07	84.99	85.27	12266800.0
2020-01-23	ABC-DELISTED	Stock	92.19	92.19	90.67	91.17	1313403.0
2020-01-23	ABCB	Stock	42.89	42.93	42.36	42.83	397600.0
2020-01-23	ABDC-DELISTED	Stock	9.48	9.48	9.45	9.48	83656.0
2020-01-23	ABEO	Stock	71.75	73.25	69.5	70.5	51924.0
2020-01-23	ABEV	Stock	4.47	4.52	4.44	4.45	23412600.0
2020-01-23	ABG	Stock	100.59	102.78	99.64	102.3	195000.0
2020-01-23	ABM	Stock	39.59	39.59	38.99	39.3	317300.0
2020-01-23	ABMD-DELISTED	Stock	184.24	185.0	181.33	184.49	446091.0
2020-01-23	ABR	Stock	14.78	14.86	14.72	14.82	599600.0
2020-01-23	ABR.A-DELISTED	Stock	26.4	26.4	26.4	26.4	700.0
2020-01-23	ABR.C-DELISTED	Stock	26.64	26.64	26.5235	26.5235	850.0
2020-01-23	ABT	Stock	91.81	91.85	90.16	90.73	7418400.0
2020-01-23	ABTC	Stock	260100.0	295170.0	255510.0	280500.0	10.733333333333333
2020-01-23	ABTX-DELISTED	Stock	36.77	37.13	36.5	37.05	90780.0
2020-01-23	ABUS	Stock	3.22	3.22	3.05	3.12	363000.0
2020-01-23	ACA	Stock	45.29	45.81	44.451	45.62	268245.0

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

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