PREVIEW / stock_daily / 2020-07-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-24.parquet
  size:    222 KB
  rows:    6,705
  symbols: 2,391

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-24	AAPL	Stock	90.9875	92.97	89.145	92.615	185438800.0
2020-07-24	MSFT	Stock	200.42	202.86	197.51	201.3	39827000.0
2020-07-24	NVDA	Stock	9.875	10.3648	9.777	10.1945	473292000.0
2020-07-24	AMZN	Stock	146.5	151.579	144.4	150.4455	112648000.0
2020-07-24	GOOGL	Stock	74.9595	75.7714	74.3795	75.4105	29907620.0
2020-07-24	META	Stock	230.19	233.49	226.9	230.71	18325800.0
2020-07-24	TSLA	Stock	94.4007	97.6667	91.1027	94.4667	290949000.0
2020-07-24	TLT	Stock	169.01	169.92	168.8695	169.74	7520837.0
2020-07-24	ES	Stock	90.01	91.09	88.77	89.48	910300.0
2020-07-24	CL	Stock	74.73	75.24	73.97	74.32	2630700.0
2020-07-24	A	Stock	95.98	96.22	93.87	94.81	1142800.0
2020-07-24	AA	Stock	12.59	12.86	12.3	12.75	4173700.0
2020-07-24	AACG	Stock	1.24	1.24	1.08	1.16	28300.0
2020-07-24	AACQU-DELISTED	Stock	10.5	10.5	10.35	10.37	1295125.0
2020-07-24	AAIC-DELISTED	Stock	3.03	3.0439	2.91	2.91	239241.0
2020-07-24	AAIC.C-DELISTED	Stock	18.99	19.25	18.75	18.7575	3257.0
2020-07-24	AAL	Stock	11.67	11.82	11.34	11.39	53761400.0
2020-07-24	AAM.A-DELISTED	Stock	26.81	26.81	26.465	26.465	13545.0
2020-07-24	AAM.B-DELISTED	Stock	27.3	27.3991	27.14	27.14	11481.0
2020-07-24	AAMC-DELISTED	Stock	4.3529	4.3529	4.1382	4.3364	4080.0
2020-07-24	AAME	Stock	1.89	1.89	1.77	1.81	3200.0
2020-07-24	AAMI	Stock	12.34	12.36	11.97	11.98	422500.0
2020-07-24	AAOI	Stock	13.95	13.96	13.13	13.62	1090700.0
2020-07-24	AAON	Stock	38.9933	39.0533	38.22	38.4267	193350.0
2020-07-24	AAP	Stock	148.23	149.77	147.08	147.27	755800.0
2020-07-24	AAT	Stock	26.1	26.14	25.51	25.57	234300.0
2020-07-24	AAU-DELISTED	Stock	0.62	0.625	0.5568	0.567	790475.0
2020-07-24	AAUAF-DELISTED	Stock	0.62	0.625	0.5568	0.577	839306.0
2020-07-24	AAWW-DELISTED	Stock	48.36	48.64	47.5	47.84	196323.0
2020-07-24	AAXJ	Stock	73.48	74.18	73.41	74.18	1450299.0
2020-07-24	AAXN-DELISTED	Stock	86.57	87.47	83.66	85.6	463355.0
2020-07-24	AB	Stock	28.08	28.64	28.08	28.23	209200.0
2020-07-24	ABB-DELISTED	Stock	25.91	25.93	25.67	25.75	1233091.0
2020-07-24	ABBNY-DELISTED	Stock	25.91	25.93	25.67	25.74	1931789.0
2020-07-24	ABBV	Stock	98.05	98.19	96.46	97.11	5169400.0
2020-07-24	ABC-DELISTED	Stock	104.42	104.875	103.41	103.82	438997.0
2020-07-24	ABCB	Stock	23.27	23.75	23.08	23.18	354800.0
2020-07-24	ABEO	Stock	73.25	73.5	70.5	72.0	13680.0
2020-07-24	ABEV	Stock	2.8	2.88	2.75	2.87	31077900.0
2020-07-24	ABG	Stock	103.23	105.63	102.47	104.58	334600.0
2020-07-24	ABM	Stock	35.25	35.27	34.31	34.34	324500.0
2020-07-24	ABMD-DELISTED	Stock	293.2	294.87	286.85	292.94	114432.0
2020-07-24	ABR	Stock	8.88	9.14	8.76	8.86	1026000.0
2020-07-24	ABR.A-DELISTED	Stock	24.87	25.0	24.7905	24.9199	4942.0
2020-07-24	ABR.B-DELISTED	Stock	23.66	23.733	23.64	23.73	1645.0
2020-07-24	ABR.C-DELISTED	Stock	24.85	24.85	24.8499	24.8499	341.0
2020-07-24	ABT	Stock	100.21	100.21	98.36	98.95	4534400.0
2020-07-24	ABTC	Stock	184500.0	195600.0	181500.0	191700.0	1.5333333333333332
2020-07-24	ABTS	Stock	14.28	14.85	13.95	13.95	520.0
2020-07-24	ABTX-DELISTED	Stock	24.21	24.33	23.97	24.03	19657.0

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

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