PREVIEW / stock_daily / 2020-02-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-03.parquet
  size:    222 KB
  rows:    6,593
  symbols: 2,388

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-03	AAPL	Stock	76.075	78.3725	75.555	77.165	173788400.0
2020-02-03	MSFT	Stock	170.43	174.5	170.4	174.38	30107000.0
2020-02-03	NVDA	Stock	5.8925	6.0278	5.8863	6.0082	255564000.0
2020-02-03	AMZN	Stock	100.53	102.425	100.0125	100.21	117834000.0
2020-02-03	GOOGL	Stock	73.0825	74.315	72.8305	74.13	72175200.0
2020-02-03	META	Stock	203.44	205.14	202.5	204.19	15495600.0
2020-02-03	TSLA	Stock	44.9127	52.4093	44.9013	52.0	705975000.0
2020-02-03	TLT	Stock	144.945	145.755	144.12	145.54	15310744.0
2020-02-03	ES	Stock	92.64	92.77	91.85	92.41	1399200.0
2020-02-03	CL	Stock	74.06	75.46	74.06	74.93	7725400.0
2020-02-03	A	Stock	83.29	83.69	82.11	82.15	1919800.0
2020-02-03	AA	Stock	14.01	14.42	13.91	14.24	7226500.0
2020-02-03	AACG	Stock	1.16	1.19	1.15	1.16	12700.0
2020-02-03	AAIC-DELISTED	Stock	5.7	5.73	5.6	5.65	381169.0
2020-02-03	AAIC.C-DELISTED	Stock	22.32	22.348	22.32	22.348	1460.0
2020-02-03	AAL	Stock	26.93	27.67	26.74	27.16	7630400.0
2020-02-03	AAM.A-DELISTED	Stock	26.98	26.98	26.93	26.966	9692.0
2020-02-03	AAM.B-DELISTED	Stock	27.39	27.39	27.21	27.22	12696.0
2020-02-03	AAMC-DELISTED	Stock	3.9735	3.9735	3.9735	3.9735	1166.0
2020-02-03	AAME	Stock	2.0	2.23	1.93	1.93	900.0
2020-02-03	AAMI	Stock	9.24	9.52	9.2	9.39	435700.0
2020-02-03	AAOI	Stock	11.43	11.96	11.155	11.62	770000.0
2020-02-03	AAON	Stock	35.2667	35.84	35.2667	35.3867	223650.0
2020-02-03	AAP	Stock	132.78	134.41	132.34	132.65	1014200.0
2020-02-03	AAT	Stock	45.72	46.38	45.72	46.16	338500.0
2020-02-03	AAU-DELISTED	Stock	0.5	0.504	0.47	0.47	835092.0
2020-02-03	AAUAF-DELISTED	Stock	0.49	0.504	0.47	0.4701	893094.0
2020-02-03	AAWW-DELISTED	Stock	22.65	22.81	21.79	21.92	258408.0
2020-02-03	AAXJ	Stock	69.21	69.87	69.17	69.67	948876.0
2020-02-03	AAXN-DELISTED	Stock	77.37	78.29	76.5	77.59	367856.0
2020-02-03	AB	Stock	32.71	33.48	32.68	33.24	260000.0
2020-02-03	ABB-DELISTED	Stock	23.31	23.5	23.24	23.245	1501471.0
2020-02-03	ABBNY-DELISTED	Stock	23.31	23.5	23.24	23.25	1591244.0
2020-02-03	ABBV	Stock	81.31	82.6	80.92	82.3	10143700.0
2020-02-03	ABC-DELISTED	Stock	85.94	86.92	85.24	85.66	775898.0
2020-02-03	ABCB	Stock	40.53	40.85	40.3	40.47	273900.0
2020-02-03	ABEO	Stock	55.0	56.5	54.0	54.75	47268.0
2020-02-03	ABEV	Stock	4.2	4.27	4.12	4.13	32328200.0
2020-02-03	ABG	Stock	100.76	103.6	98.36	99.26	408300.0
2020-02-03	ABM	Stock	38.34	38.89	38.18	38.73	419400.0
2020-02-03	ABMD-DELISTED	Stock	186.45	190.09	184.845	185.96	364845.0
2020-02-03	ABR	Stock	14.84	15.08	14.81	14.9	817400.0
2020-02-03	ABR.A-DELISTED	Stock	26.3879	26.5	26.3302	26.3302	620.0
2020-02-03	ABR.B-DELISTED	Stock	26.05	26.05	25.91	25.98	3436.0
2020-02-03	ABR.C-DELISTED	Stock	26.65	26.6918	26.6	26.6258	1072.0
2020-02-03	ABT	Stock	87.78	88.4	86.75	87.06	4675900.0
2020-02-03	ABTC	Stock	243600.0	251700.0	232920.0	233700.0	2.2266666666666666
2020-02-03	ABTX-DELISTED	Stock	37.45	37.975	37.16	37.9	107752.0
2020-02-03	ABUS	Stock	2.65	2.65	2.54	2.59	253300.0
2020-02-03	ACA	Stock	43.93	44.53	43.72	43.88	265905.0

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

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