PREVIEW / stock_daily / 2020-02-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-28.parquet
  size:    221 KB
  rows:    6,671
  symbols: 2,419

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-28	AAPL	Stock	64.315	69.6025	64.0925	68.34	426510000.0
2020-02-28	MSFT	Stock	152.41	163.71	152.0	162.01	97012700.0
2020-02-28	NVDA	Stock	6.0615	6.8115	6.0448	6.7518	1133252000.0
2020-02-28	AMZN	Stock	90.7315	94.488	90.5565	94.1875	189620000.0
2020-02-28	GOOGL	Stock	63.7155	67.1225	63.4105	66.9625	80218000.0
2020-02-28	META	Stock	182.7	192.74	181.82	192.47	32568900.0
2020-02-28	TSLA	Stock	41.98	46.0347	40.768	44.5327	363343500.0
2020-02-28	TLT	Stock	154.45	155.9799	154.16	155.31	45010774.0
2020-02-28	ES	Stock	88.0	88.0	84.48	86.46	3405900.0
2020-02-28	CL	Stock	68.99	69.36	66.32	67.57	11130900.0
2020-02-28	A	Stock	74.97	77.07	74.17	77.07	3755600.0
2020-02-28	AA	Stock	12.84	13.91	12.83	13.87	6812900.0
2020-02-28	AACG	Stock	1.02	1.07	0.95	1.03	45900.0
2020-02-28	AAIC-DELISTED	Stock	5.8	5.8	5.59	5.66	883834.0
2020-02-28	AAIC.C-DELISTED	Stock	21.67	22.18	21.6659	22.18	5550.0
2020-02-28	AAL	Stock	19.8	20.35	18.77	19.05	37093200.0
2020-02-28	AAM.A-DELISTED	Stock	25.63	25.8	25.39	25.42	80374.0
2020-02-28	AAM.B-DELISTED	Stock	26.0	26.05	25.41	25.93	48815.0
2020-02-28	AAMC-DELISTED	Stock	6.5588	6.5588	5.4118	6.2785	18737.0
2020-02-28	AAME	Stock	2.29	2.54	2.12	2.47	1900.0
2020-02-28	AAMI	Stock	9.0	9.37	8.81	9.35	958000.0
2020-02-28	AAOI	Stock	8.95	9.73	8.54	8.93	1480600.0
2020-02-28	AAON	Stock	37.4933	38.4733	35.7467	36.6733	824550.0
2020-02-28	AAP	Stock	131.29	132.98	127.85	132.98	1909200.0
2020-02-28	AAT	Stock	40.97	41.72	39.85	41.45	609000.0
2020-02-28	AAU-DELISTED	Stock	0.345	0.3646	0.28	0.3525	900170.0
2020-02-28	AAUAF-DELISTED	Stock	0.345	0.3646	0.28	0.3537	938574.0
2020-02-28	AAWW-DELISTED	Stock	24.77	26.85	24.77	26.72	1044440.0
2020-02-28	AAXJ	Stock	66.53	68.34	66.07	68.34	5505076.0
2020-02-28	AAXN-DELISTED	Stock	72.0	78.11	71.0	77.58	1456563.0
2020-02-28	AB	Stock	29.65	30.54	28.4	30.41	1561000.0
2020-02-28	ABB-DELISTED	Stock	21.37	21.785	21.17	21.64	5716053.0
2020-02-28	ABBNY-DELISTED	Stock	21.37	21.785	21.17	21.64	5913077.0
2020-02-28	ABBV	Stock	82.79	85.71	81.58	85.71	18450000.0
2020-02-28	ABC-DELISTED	Stock	83.55	85.0	81.47	84.32	2995495.0
2020-02-28	ABCB	Stock	34.51	35.14	33.6	34.18	658200.0
2020-02-28	ABEO	Stock	80.25	85.5	76.25	77.0	93404.0
2020-02-28	ABEV	Stock	3.11	3.23	3.1	3.21	42324700.0
2020-02-28	ABG	Stock	87.29	89.08	85.51	88.64	299100.0
2020-02-28	ABM	Stock	34.24	34.94	32.38	32.92	585600.0
2020-02-28	ABMD-DELISTED	Stock	150.0	153.39	147.28	150.53	767791.0
2020-02-28	ABR	Stock	11.91	12.42	11.5	12.14	4450400.0
2020-02-28	ABR.A-DELISTED	Stock	25.25	25.75	25.25	25.75	4536.0
2020-02-28	ABR.B-DELISTED	Stock	25.04	25.294	25.0	25.13	7142.0
2020-02-28	ABR.C-DELISTED	Stock	25.15	25.5	25.12	25.5	3756.0
2020-02-28	ABT	Stock	77.12	78.16	74.02	77.03	16671900.0
2020-02-28	ABTC	Stock	210300.0	229350.0	198000.0	227700.0	3.5199999999999996
2020-02-28	ABTS	Stock	24.45	25.2	21.6	24.0	787.0
2020-02-28	ABTX-DELISTED	Stock	33.22	33.82	29.88	33.3	126507.0
2020-02-28	ABUS	Stock	3.09	3.1	2.6	2.92	691600.0

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

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