PREVIEW / stock_daily / 2020-01-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-02.parquet
  size:    222 KB
  rows:    6,588
  symbols: 2,426

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-02	AAPL	Stock	74.06	75.15	73.7975	75.0875	135480400.0
2020-01-02	MSFT	Stock	158.78	160.73	158.33	160.62	22622100.0
2020-01-02	NVDA	Stock	5.9688	5.9978	5.918	5.9978	237536000.0
2020-01-02	AMZN	Stock	93.75	94.9005	93.2075	94.9005	80580000.0
2020-01-02	GOOGL	Stock	67.4205	68.434	67.3245	68.434	27285300.0
2020-01-02	META	Stock	206.75	209.79	206.27	209.78	12077100.0
2020-01-02	TSLA	Stock	28.3	28.7133	28.114	28.684	142981500.0
2020-01-02	TLT	Stock	136.79	137.53	136.665	137.015	11034459.0
2020-01-02	ES	Stock	85.03	85.03	83.08	83.23	3278200.0
2020-01-02	CL	Stock	68.84	68.94	67.89	68.12	3441800.0
2020-01-02	A	Stock	85.9	86.35	85.2	85.95	1410500.0
2020-01-02	AA	Stock	21.86	21.86	21.315	21.42	3062500.0
2020-01-02	AACG	Stock	1.35	1.38	1.35	1.35	4300.0
2020-01-02	AAIC-DELISTED	Stock	5.58	5.61	5.53	5.54	595319.0
2020-01-02	AAIC.C-DELISTED	Stock	21.5715	21.73	21.5459	21.64	4071.0
2020-01-02	AAL	Stock	28.98	29.3	28.65	29.09	6451100.0
2020-01-02	AAM.A-DELISTED	Stock	26.61	26.68	26.51	26.664	47779.0
2020-01-02	AAM.B-DELISTED	Stock	27.07	27.3	27.07	27.27	22649.0
2020-01-02	AAMC-DELISTED	Stock	3.6211	3.8735	3.6211	3.8735	6236.0
2020-01-02	AAME	Stock	1.99	2.1	1.99	1.99	2400.0
2020-01-02	AAMI	Stock	9.8	10.0	9.71	9.86	686000.0
2020-01-02	AAOI	Stock	12.13	12.53	11.8	12.5	885000.0
2020-01-02	AAON	Stock	33.22	33.2667	32.3467	33.26	287100.0
2020-01-02	AAP	Stock	160.47	160.95	157.53	159.41	944900.0
2020-01-02	AAT	Stock	46.15	46.23	44.76	44.98	196900.0
2020-01-02	AAU-DELISTED	Stock	0.5982	0.5999	0.5513	0.572	233820.0
2020-01-02	AAUAF-DELISTED	Stock	0.5982	0.5999	0.5513	0.572	237946.0
2020-01-02	AAWW-DELISTED	Stock	27.87	28.3	27.05	27.75	168097.0
2020-01-02	AAXJ	Stock	74.3	74.96	74.3	74.91	840918.0
2020-01-02	AAXN-DELISTED	Stock	74.02	76.62	73.34	76.58	685352.0
2020-01-02	AB	Stock	30.25	30.36	30.16	30.23	281200.0
2020-01-02	ABB-DELISTED	Stock	24.32	24.38	24.26	24.37	1305811.0
2020-01-02	ABBNY-DELISTED	Stock	24.32	24.38	24.26	24.37	1367507.0
2020-01-02	ABBV	Stock	89.08	89.57	88.51	89.55	5639200.0
2020-01-02	ABC-DELISTED	Stock	85.64	85.8	84.335	85.09	599410.0
2020-01-02	ABCB	Stock	42.93	43.0	41.94	42.74	266700.0
2020-01-02	ABDC-DELISTED	Stock	9.1	9.16	9.01	9.04	8459.0
2020-01-02	ABEO	Stock	89.75	90.0	79.25	80.25	75380.0
2020-01-02	ABEV	Stock	4.67	4.73	4.67	4.73	10162700.0
2020-01-02	ABG	Stock	112.69	112.69	110.32	111.33	163300.0
2020-01-02	ABM	Stock	37.89	38.48	37.84	38.42	358600.0
2020-01-02	ABMD-DELISTED	Stock	172.51	173.86	167.14	168.81	541329.0
2020-01-02	ABR	Stock	14.38	14.42	14.0	14.13	1821700.0
2020-01-02	ABR.A-DELISTED	Stock	26.08	26.11	26.08	26.11	498.0
2020-01-02	ABR.B-DELISTED	Stock	25.7	25.96	25.7	25.886	4691.0
2020-01-02	ABR.C-DELISTED	Stock	26.5	26.5	26.5	26.5	101.0
2020-01-02	ABT	Stock	86.06	86.96	85.8	86.95	4969000.0
2020-01-02	ABTC	Stock	255900.0	265800.0	244560.0	254100.0	5.906666666666666
2020-01-02	ABTS	Stock	31.5	32.55	31.5	32.55	53.3
2020-01-02	ABTX-DELISTED	Stock	38.02	38.02	37.25	37.5	60335.0

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

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