PREVIEW / stock_daily / 2020-07-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-23.parquet
  size:    223 KB
  rows:    6,747
  symbols: 2,406

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-07-23	AAPL	Stock	96.9975	97.0775	92.01	92.845	197004400.0
2020-07-23	MSFT	Stock	207.19	210.92	202.15	202.54	67457000.0
2020-07-23	NVDA	Stock	10.45	10.547	10.0312	10.1298	411660000.0
2020-07-23	AMZN	Stock	154.9135	154.9135	148.5	149.3275	113138000.0
2020-07-23	GOOGL	Stock	78.2965	78.5175	75.4295	75.8375	33909960.0
2020-07-23	META	Stock	239.63	242.42	231.75	232.6	21771800.0
2020-07-23	TSLA	Stock	111.93	112.6	98.718	100.8713	364927500.0
2020-07-23	TLT	Stock	168.92	169.88	168.48	169.75	10471802.0
2020-07-23	ES	Stock	89.35	90.7	89.28	90.03	1045800.0
2020-07-23	CL	Stock	74.89	75.18	74.16	74.23	3868000.0
2020-07-23	A	Stock	96.59	98.09	96.32	96.66	1386300.0
2020-07-23	AA	Stock	13.02	13.17	12.62	12.71	5685000.0
2020-07-23	AACG	Stock	1.2	1.39	1.2	1.25	19000.0
2020-07-23	AACQU-DELISTED	Stock	10.46	10.46	10.33	10.4155	79587.0
2020-07-23	AAIC-DELISTED	Stock	3.06	3.0729	3.015	3.03	162613.0
2020-07-23	AAIC.C-DELISTED	Stock	19.245	19.35	19.0	19.35	807.0
2020-07-23	AAL	Stock	11.27	12.41	11.01	11.77	115574800.0
2020-07-23	AAM.A-DELISTED	Stock	26.55	26.8103	26.5016	26.72	7876.0
2020-07-23	AAM.B-DELISTED	Stock	27.0	27.5	27.0	27.43	12061.0
2020-07-23	AAMC-DELISTED	Stock	4.225	4.6088	4.1176	4.1971	40321.0
2020-07-23	AAME	Stock	1.9	1.9	1.78	1.82	6200.0
2020-07-23	AAMI	Stock	12.49	12.64	12.24	12.34	528500.0
2020-07-23	AAOI	Stock	14.43	14.5	13.62	14.23	1056000.0
2020-07-23	AAON	Stock	38.9	40.0	38.68	38.9933	435150.0
2020-07-23	AAP	Stock	150.0	150.89	146.98	148.37	762500.0
2020-07-23	AAT	Stock	25.93	26.72	25.83	26.18	406900.0
2020-07-23	AAU-DELISTED	Stock	0.61	0.615	0.57	0.59	1171095.0
2020-07-23	AAUAF-DELISTED	Stock	0.61	0.615	0.57	0.59	1196550.0
2020-07-23	AAWW-DELISTED	Stock	49.1	49.4	47.85	48.82	261790.0
2020-07-23	AAXJ	Stock	74.86	75.145	74.03	74.42	695500.0
2020-07-23	AAXN-DELISTED	Stock	88.92	89.8887	86.56	87.53	473477.0
2020-07-23	AB	Stock	28.0	28.98	27.85	28.58	378300.0
2020-07-23	ABB-DELISTED	Stock	26.02	26.18	25.74	25.88	1784293.0
2020-07-23	ABBNY-DELISTED	Stock	26.02	26.18	25.74	25.88	1955085.0
2020-07-23	ABBV	Stock	98.24	98.92	97.45	98.03	5127200.0
2020-07-23	ABC-DELISTED	Stock	103.76	104.93	103.63	104.03	480130.0
2020-07-23	ABCB	Stock	22.36	23.57	22.33	23.42	555900.0
2020-07-23	ABEO	Stock	73.5	74.75	71.75	73.75	22620.0
2020-07-23	ABEV	Stock	2.89	2.9	2.78	2.79	21725400.0
2020-07-23	ABG	Stock	106.76	109.74	105.12	106.15	507800.0
2020-07-23	ABM	Stock	35.48	36.09	34.95	35.14	451800.0
2020-07-23	ABMD-DELISTED	Stock	299.53	301.105	293.26	294.58	132794.0
2020-07-23	ABR	Stock	9.0	9.1	8.74	8.84	799900.0
2020-07-23	ABR.A-DELISTED	Stock	24.85	24.85	24.7362	24.7362	2742.0
2020-07-23	ABR.B-DELISTED	Stock	23.65	23.7	23.5922	23.5922	1600.0
2020-07-23	ABR.C-DELISTED	Stock	24.77	24.85	24.77	24.8174	1914.0
2020-07-23	ABT	Stock	100.28	101.98	100.07	100.82	5905800.0
2020-07-23	ABTC	Stock	187500.0	203700.0	186300.0	186600.0	7.0
2020-07-23	ABTS	Stock	14.685	14.685	13.5	13.65	3267.0
2020-07-23	ABTX-DELISTED	Stock	23.38	24.28	23.38	24.18	29345.0

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

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