PREVIEW / stock_daily / 2020-03-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-24.parquet
  size:    215 KB
  rows:    6,675
  symbols: 2,404

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-03-24	AAPL	Stock	59.09	61.9225	58.575	61.72	287531200.0
2020-03-24	MSFT	Stock	143.75	149.6	141.27	148.34	82516700.0
2020-03-24	NVDA	Stock	5.725	6.3165	5.7013	6.2295	1101644000.0
2020-03-24	AMZN	Stock	97.575	97.75	95.017	97.005	142942000.0
2020-03-24	GOOGL	Stock	55.199	56.6665	54.3215	56.5005	72468700.0
2020-03-24	META	Stock	155.21	161.31	152.57	160.98	30440400.0
2020-03-24	TSLA	Stock	31.82	34.246	31.6	33.6667	343428000.0
2020-03-24	TLT	Stock	161.25	165.45	160.41	162.91	11948557.0
2020-03-24	ES	Stock	64.7	72.46	61.96	71.44	2697800.0
2020-03-24	CL	Stock	61.11	65.88	59.61	61.18	9887200.0
2020-03-24	A	Stock	65.53	68.18	64.6	67.0	2868900.0
2020-03-24	AA	Stock	6.24	7.48	6.2	7.27	15143000.0
2020-03-24	AACG	Stock	0.86	1.06	0.75	0.86	6500.0
2020-03-24	AAIC-DELISTED	Stock	2.12	2.19	1.97	2.02	486092.0
2020-03-24	AAIC.C-DELISTED	Stock	9.75	9.75	8.0	8.0	26656.0
2020-03-24	AAL	Stock	11.96	14.81	11.54	13.92	101553100.0
2020-03-24	AAM.A-DELISTED	Stock	18.3	20.2299	18.3	19.98	70709.0
2020-03-24	AAM.B-DELISTED	Stock	18.65	20.0	18.6	19.98	54230.0
2020-03-24	AAMC-DELISTED	Stock	3.1542	3.3088	3.103	3.2118	35697.0
2020-03-24	AAME	Stock	2.45	2.45	2.4	2.4	400.0
2020-03-24	AAMI	Stock	4.96	5.31	4.94	5.14	709200.0
2020-03-24	AAOI	Stock	7.33	7.7	7.05	7.7	842800.0
2020-03-24	AAON	Stock	33.1733	34.58	29.6867	30.3267	532200.0
2020-03-24	AAP	Stock	82.71	87.61	81.42	86.38	1668300.0
2020-03-24	AAT	Stock	23.05	24.33	22.5	23.87	404300.0
2020-03-24	AAU-DELISTED	Stock	0.26	0.2939	0.245	0.29	552554.0
2020-03-24	AAUAF-DELISTED	Stock	0.26	0.2939	0.245	0.29	599992.0
2020-03-24	AAWW-DELISTED	Stock	25.0	26.87	22.98	23.68	944275.0
2020-03-24	AAXJ	Stock	56.83	57.58	56.7	57.55	1122192.0
2020-03-24	AAXN-DELISTED	Stock	66.66	70.96	66.5	69.82	619203.0
2020-03-24	AB	Stock	16.0	19.24	15.99	16.91	1465200.0
2020-03-24	ABB-DELISTED	Stock	16.27	16.88	16.11	16.84	2779174.0
2020-03-24	ABBNY-DELISTED	Stock	16.27	16.88	16.11	16.83	3177090.0
2020-03-24	ABBV	Stock	68.16	71.82	67.09	67.49	18376300.0
2020-03-24	ABC-DELISTED	Stock	77.71	80.62	76.1625	79.84	1588574.0
2020-03-24	ABCB	Stock	20.13	22.1	19.88	21.75	655400.0
2020-03-24	ABEO	Stock	51.75	53.5	50.0	51.75	37008.0
2020-03-24	ABEV	Stock	2.39	2.5	2.24	2.25	29126700.0
2020-03-24	ABG	Stock	48.44	53.94	47.46	53.53	403900.0
2020-03-24	ABM	Stock	21.7	22.71	19.79	21.02	1118400.0
2020-03-24	ABMD-DELISTED	Stock	136.39	146.67	134.44	143.5324	532688.0
2020-03-24	ABR	Stock	4.55	5.0	4.26	4.27	3181500.0
2020-03-24	ABR.A-DELISTED	Stock	13.1953	14.33	11.325	11.86	22509.0
2020-03-24	ABR.B-DELISTED	Stock	13.91	14.4099	10.767	11.31	16833.0
2020-03-24	ABR.C-DELISTED	Stock	15.99	15.99	12.0006	12.76	8151.0
2020-03-24	ABT	Stock	64.91	69.97	64.5	69.69	10903700.0
2020-03-24	ABTC	Stock	130200.0	139200.0	124500.0	127800.0	4.466666666666667
2020-03-24	ABTS	Stock	15.6	15.75	12.6	13.275	347.0
2020-03-24	ABTX-DELISTED	Stock	23.69	25.09	22.98	24.76	88073.0
2020-03-24	ABUS	Stock	1.67	1.98	1.65	1.95	297100.0

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

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