PREVIEW / stock_daily / 2020-08-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-03.parquet
  size:    224 KB
  rows:    6,792
  symbols: 2,413

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-08-03	AAPL	Stock	108.2	111.6375	107.8925	108.9375	308151200.0
2020-08-03	MSFT	Stock	211.52	217.64	210.44	216.54	78983000.0
2020-08-03	NVDA	Stock	10.7325	11.0988	10.7153	11.0103	412720000.0
2020-08-03	AMZN	Stock	159.0255	159.2	155.2	155.5945	101494000.0
2020-08-03	GOOGL	Stock	74.55	74.8865	73.586	74.138	45521700.0
2020-08-03	META	Stock	252.65	255.4	250.33	251.96	23124900.0
2020-08-03	TSLA	Stock	96.6133	100.654	96.292	99.0	132139500.0
2020-08-03	TLT	Stock	169.24	169.99	168.97	169.95	9067756.0
2020-08-03	ES	Stock	89.69	90.07	88.6	89.49	1019000.0
2020-08-03	CL	Stock	76.7	77.27	76.5	76.57	3127500.0
2020-08-03	A	Stock	96.94	99.36	96.94	99.09	1994300.0
2020-08-03	AA	Stock	13.08	13.78	12.92	13.68	5887100.0
2020-08-03	AACG	Stock	1.12	1.4	1.02	1.37	387300.0
2020-08-03	AACQU-DELISTED	Stock	10.39	10.39	10.0	10.04	163103.0
2020-08-03	AAIC-DELISTED	Stock	2.71	2.71	2.58	2.61	464296.0
2020-08-03	AAIC.C-DELISTED	Stock	19.35	19.4	19.1	19.1001	2835.0
2020-08-03	AAL	Stock	11.07	11.24	10.71	11.08	48264000.0
2020-08-03	AAM.A-DELISTED	Stock	26.89	26.98	26.85	26.85	15237.0
2020-08-03	AAM.B-DELISTED	Stock	27.51	27.56	27.3114	27.33	12205.0
2020-08-03	AAMC-DELISTED	Stock	4.1737	4.1737	4.1353	4.1434	6178.0
2020-08-03	AAME	Stock	1.85	1.93	1.85	1.88	3300.0
2020-08-03	AAMI	Stock	13.44	13.463	13.09	13.17	650200.0
2020-08-03	AAOI	Stock	14.41	16.75	14.21	16.06	3122400.0
2020-08-03	AAON	Stock	39.6467	40.7267	39.6467	40.2133	337050.0
2020-08-03	AAP	Stock	151.54	153.09	149.71	152.55	498300.0
2020-08-03	AAT	Stock	27.05	27.16	26.1	26.66	230000.0
2020-08-03	AAU-DELISTED	Stock	0.7245	0.75	0.7	0.7499	572080.0
2020-08-03	AAUAF-DELISTED	Stock	0.7245	0.75	0.7	0.75	596081.0
2020-08-03	AAWW-DELISTED	Stock	52.74	53.77	52.62	53.3	468915.0
2020-08-03	AAXJ	Stock	75.1	75.56	75.06	75.4	1681136.0
2020-08-03	AAXN-DELISTED	Stock	83.79	88.9	83.5	88.5	467595.0
2020-08-03	AB	Stock	28.21	28.38	27.81	28.23	378600.0
2020-08-03	ABB-DELISTED	Stock	25.64	25.875	25.55	25.76	1075751.0
2020-08-03	ABBNY-DELISTED	Stock	25.63	25.875	25.55	25.75	1198232.0
2020-08-03	ABBV	Stock	95.19	97.17	95.06	95.94	6919000.0
2020-08-03	ABC-DELISTED	Stock	100.81	104.86	100.81	104.5	965592.0
2020-08-03	ABCB	Stock	23.31	23.63	22.87	23.38	259900.0
2020-08-03	ABEO	Stock	71.5	74.25	71.0	73.75	20172.0
2020-08-03	ABEV	Stock	2.63	2.65	2.58	2.58	34823000.0
2020-08-03	ABG	Stock	100.37	101.89	98.71	100.79	251000.0
2020-08-03	ABM	Stock	36.32	36.77	35.75	35.81	367200.0
2020-08-03	ABMD-DELISTED	Stock	300.5	309.17	298.3	308.29	227074.0
2020-08-03	ABR	Stock	10.25	10.78	10.05	10.75	2620300.0
2020-08-03	ABR.A-DELISTED	Stock	25.0	25.59	24.96	25.42	5500.0
2020-08-03	ABR.B-DELISTED	Stock	24.22	24.78	24.1	24.61	8700.0
2020-08-03	ABR.C-DELISTED	Stock	25.61	25.9134	25.355	25.9134	2472.0
2020-08-03	ABT	Stock	101.08	101.55	100.21	100.68	3670900.0
2020-08-03	ABTC	Stock	195300.0	201300.0	194400.0	201000.0	1.3066666666666666
2020-08-03	ABTS	Stock	13.8	25.05	13.5	22.05	295467.0
2020-08-03	ABTX-DELISTED	Stock	24.55	24.55	22.9919	24.1	22631.0

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

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