PREVIEW / stock_daily / 2020-12-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-08.parquet
  size:    238 KB
  rows:    7,199
  symbols: 2,611

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-12-08	AAPL	Stock	124.37	124.98	123.09	124.38	82225500.0
2020-12-08	MSFT	Stock	213.97	216.95	212.89	216.01	23284100.0
2020-12-08	NVDA	Stock	13.585	13.5988	13.2815	13.35	271920000.0
2020-12-08	AMZN	Stock	157.945	159.2065	156.001	158.8645	65726000.0
2020-12-08	GOOGL	Stock	90.426	90.7985	89.564	90.5665	19935360.0
2020-12-08	META	Stock	286.01	286.43	281.55	283.4	10747700.0
2020-12-08	TSLA	Stock	208.5033	217.0933	206.1667	216.6267	192795000.0
2020-12-08	TLT	Stock	157.57	158.07	157.2	157.34	7397240.0
2020-12-08	ES	Stock	86.1	86.87	85.56	86.38	850100.0
2020-12-08	CL	Stock	84.47	85.44	84.19	85.17	2664500.0
2020-12-08	A	Stock	114.34	117.34	114.33	117.01	1320600.0
2020-12-08	AA	Stock	23.07	23.68	22.9	23.29	5735000.0
2020-12-08	AACG	Stock	1.23	1.23	1.19	1.19	27300.0
2020-12-08	AACQ-DELISTED	Stock	10.44	10.44	10.2	10.3	2816520.0
2020-12-08	AACQU-DELISTED	Stock	11.25	11.25	10.85	10.92	213306.0
2020-12-08	AACQW-DELISTED	Stock	2.2	2.2	1.85	1.91	563197.0
2020-12-08	AAIC-DELISTED	Stock	3.76	3.8	3.67	3.8	369457.0
2020-12-08	AAIC.C-DELISTED	Stock	21.825	21.95	21.4	21.8	2223.0
2020-12-08	AAL	Stock	17.47	17.92	17.16	17.63	95855400.0
2020-12-08	AAM.A-DELISTED	Stock	26.35	26.3884	26.29	26.35	13890.0
2020-12-08	AAM.B-DELISTED	Stock	27.14	27.14	27.03	27.04	9767.0
2020-12-08	AAMC-DELISTED	Stock	6.7882	6.7882	6.7647	6.7647	1085.0
2020-12-08	AAME	Stock	2.22	2.22	2.13	2.13	2100.0
2020-12-08	AAMI	Stock	19.31	19.67	19.03	19.52	444900.0
2020-12-08	AAN-DELISTED	Stock	17.75	18.03	16.58	17.23	3246400.0
2020-12-08	AAOI	Stock	8.39	8.53	8.26	8.4	700800.0
2020-12-08	AAON	Stock	41.1933	41.74	40.8667	41.4867	355200.0
2020-12-08	AAP	Stock	152.69	153.06	148.96	152.78	1135300.0
2020-12-08	AAT	Stock	29.63	30.39	29.56	29.58	250100.0
2020-12-08	AAU-DELISTED	Stock	0.741	0.7449	0.681	0.716	1523538.0
2020-12-08	AAUAF-DELISTED	Stock	0.741	0.7449	0.681	0.72	1605408.0
2020-12-08	AAWW-DELISTED	Stock	55.38	55.38	53.94	54.98	319336.0
2020-12-08	AAXJ	Stock	87.74	87.95	87.45	87.94	1016417.0
2020-12-08	AAXN-DELISTED	Stock	122.37	125.74	122.36	125.5	324865.0
2020-12-08	AB	Stock	32.49	33.69	32.31	33.13	338900.0
2020-12-08	ABB-DELISTED	Stock	26.93	27.1	26.92	27.09	744300.0
2020-12-08	ABBNY-DELISTED	Stock	26.93	27.1	26.92	27.08	882755.0
2020-12-08	ABBV	Stock	105.7	108.35	105.6	107.69	6688200.0
2020-12-08	ABC-DELISTED	Stock	99.02	100.99	98.37	100.4	656594.0
2020-12-08	ABCB	Stock	36.6	37.47	35.39	37.08	503000.0
2020-12-08	ABCM-DELISTED	Stock	18.8	19.07	18.72	19.01	25979.0
2020-12-08	ABEO	Stock	38.75	39.0	37.5	38.25	83220.0
2020-12-08	ABEV	Stock	2.96	3.02	2.94	2.96	21872900.0
2020-12-08	ABG	Stock	141.58	141.94	137.66	139.61	211000.0
2020-12-08	ABM	Stock	39.0	40.61	39.0	40.54	458900.0
2020-12-08	ABMD-DELISTED	Stock	272.0	275.47	270.08	273.35	116890.0
2020-12-08	ABR	Stock	13.7	14.44	13.69	14.3	2192400.0
2020-12-08	ABR.A-DELISTED	Stock	25.46	25.54	25.45	25.53	3356.0
2020-12-08	ABR.B-DELISTED	Stock	25.26	25.3842	25.26	25.3842	638.0
2020-12-08	ABR.C-DELISTED	Stock	25.6388	25.9	25.6388	25.77	2200.0

> showing 50 of 7,199 rows — these rows as CSV

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