PREVIEW / stock_daily / 2020-02-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-27.parquet
  size:    222 KB
  rows:    6,634
  symbols: 2,399

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-27	AAPL	Stock	70.275	71.5	68.24	68.38	320605600.0
2020-02-27	MSFT	Stock	163.32	167.03	157.98	158.18	93174900.0
2020-02-27	NVDA	Stock	6.3725	6.675	6.2222	6.315	906416000.0
2020-02-27	AMZN	Stock	96.719	98.75	94.138	94.215	162880000.0
2020-02-27	GOOGL	Stock	67.957	68.47	65.712	65.7475	62289520.0
2020-02-27	META	Stock	191.82	195.88	189.5	189.75	21682600.0
2020-02-27	TSLA	Stock	48.6667	49.318	44.6	45.2667	364158000.0
2020-02-27	TLT	Stock	152.7	153.08	150.83	151.88	30687929.0
2020-02-27	ES	Stock	93.41	93.93	89.46	89.52	2295200.0
2020-02-27	CL	Stock	73.06	73.72	70.13	70.15	6181100.0
2020-02-27	A	Stock	76.68	80.3	76.37	77.43	2879400.0
2020-02-27	AA	Stock	13.76	14.11	13.1	13.46	7007400.0
2020-02-27	AACG	Stock	1.13	1.13	1.05	1.06	35300.0
2020-02-27	AAIC-DELISTED	Stock	5.97	6.11	5.66	5.9	1220856.0
2020-02-27	AAIC.C-DELISTED	Stock	22.45	22.46	21.54	22.29	14882.0
2020-02-27	AAL	Stock	20.85	22.48	19.77	20.6	31897300.0
2020-02-27	AAM.A-DELISTED	Stock	26.261	26.38	26.03	26.11	16559.0
2020-02-27	AAM.B-DELISTED	Stock	26.27	26.515	26.17	26.17	47597.0
2020-02-27	AAMC-DELISTED	Stock	7.3529	7.4132	6.4275	7.0559	21865.0
2020-02-27	AAME	Stock	2.3	2.3	2.17	2.17	7700.0
2020-02-27	AAMI	Stock	9.27	9.5	8.98	9.3	404500.0
2020-02-27	AAOI	Stock	9.9	10.02	9.37	9.56	1027100.0
2020-02-27	AAON	Stock	34.9467	39.2333	34.9467	38.3933	697800.0
2020-02-27	AAP	Stock	133.16	138.11	129.63	134.13	997000.0
2020-02-27	AAT	Stock	42.76	43.66	41.75	41.82	416400.0
2020-02-27	AAU-DELISTED	Stock	0.41	0.41	0.35	0.375	702881.0
2020-02-27	AAUAF-DELISTED	Stock	0.41	0.41	0.35	0.375	710767.0
2020-02-27	AAWW-DELISTED	Stock	24.23	26.28	22.91	25.47	1144444.0
2020-02-27	AAXJ	Stock	69.0	69.45	68.19	68.28	1803450.0
2020-02-27	AAXN-DELISTED	Stock	78.06	80.82	74.21	77.14	776275.0
2020-02-27	AB	Stock	31.4	31.49	29.99	30.51	1014500.0
2020-02-27	ABB-DELISTED	Stock	22.1	22.545	21.88	21.94	3418534.0
2020-02-27	ABBNY-DELISTED	Stock	22.1	22.545	21.88	21.95	3876158.0
2020-02-27	ABBV	Stock	86.19	89.45	84.2	85.42	14184100.0
2020-02-27	ABC-DELISTED	Stock	92.05	92.94	86.56	86.57	1975289.0
2020-02-27	ABCB	Stock	35.97	36.74	34.91	35.24	547900.0
2020-02-27	ABEO	Stock	88.0	91.0	81.25	82.75	99556.0
2020-02-27	ABEV	Stock	3.17	3.34	3.17	3.25	110938200.0
2020-02-27	ABG	Stock	92.86	94.51	90.07	90.08	250100.0
2020-02-27	ABM	Stock	35.22	36.43	34.64	35.31	537000.0
2020-02-27	ABMD-DELISTED	Stock	150.1	159.18	149.07	154.0	610083.0
2020-02-27	ABR	Stock	13.3	13.31	12.04	12.66	4307600.0
2020-02-27	ABR.A-DELISTED	Stock	26.15	26.15	25.3	25.3	9265.0
2020-02-27	ABR.B-DELISTED	Stock	25.4	25.73	25.31	25.7178	12516.0
2020-02-27	ABR.C-DELISTED	Stock	25.85	25.85	25.08	25.42	23139.0
2020-02-27	ABT	Stock	80.4	82.03	79.16	79.19	8657200.0
2020-02-27	ABTC	Stock	236700.0	236700.0	213000.0	218100.0	3.36
2020-02-27	ABTS	Stock	22.62	23.1	21.6	21.6	147.0
2020-02-27	ABTX-DELISTED	Stock	34.74	35.44	33.98	33.98	59972.0
2020-02-27	ABUS	Stock	2.69	3.43	2.69	3.1	1150000.0

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

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