PREVIEW / stock_daily / 2020-12-22

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-22.parquet
  size:    240 KB
  rows:    7,261
  symbols: 2,639

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-22	AAPL	Stock	131.61	134.41	129.65	131.88	168904800.0
2020-12-22	MSFT	Stock	222.69	225.63	221.85	223.94	22612200.0
2020-12-22	NVDA	Stock	13.3192	13.3372	13.054	13.2782	185580000.0
2020-12-22	AMZN	Stock	160.142	161.1	159.004	160.326	47388000.0
2020-12-22	GOOGL	Stock	86.4665	86.6306	85.289	86.011	20376580.0
2020-12-22	META	Stock	271.5	271.5	264.63	267.09	17312900.0
2020-12-22	TSLA	Stock	216.0	216.6267	204.7433	213.4467	155148000.0
2020-12-22	TLT	Stock	157.5634	157.83	157.08	157.76	7378508.0
2020-12-22	ES	Stock	83.92	84.21	83.18	83.57	1905700.0
2020-12-22	CL	Stock	85.2	85.42	84.27	84.4	2341500.0
2020-12-22	A	Stock	118.0	118.43	116.85	117.37	1670400.0
2020-12-22	AA	Stock	22.17	22.22	21.5	21.61	4196900.0
2020-12-22	AACG	Stock	1.2	1.23	1.16	1.18	12400.0
2020-12-22	AACQ-DELISTED	Stock	10.5	10.51	10.29	10.45	1642445.0
2020-12-22	AACQU-DELISTED	Stock	11.0	11.1199	10.92	11.05	366094.0
2020-12-22	AACQW-DELISTED	Stock	2.07	2.0998	1.89	2.03	621037.0
2020-12-22	AAIC-DELISTED	Stock	3.8	3.8245	3.71	3.8	277951.0
2020-12-22	AAIC.C-DELISTED	Stock	21.0	21.0	20.76	20.875	2214.0
2020-12-22	AAL	Stock	16.34	16.38	15.45	15.48	74627300.0
2020-12-22	AAM.A-DELISTED	Stock	26.59	26.6114	26.31	26.41	7640.0
2020-12-22	AAM.B-DELISTED	Stock	27.33	27.33	26.96	27.13	18015.0
2020-12-22	AAMC-DELISTED	Stock	6.5574	6.5574	6.5574	6.5574	1105.0
2020-12-22	AAME	Stock	2.1	2.18	2.03	2.1	17600.0
2020-12-22	AAMI	Stock	18.81	18.93	18.535	18.89	525700.0
2020-12-22	AAN-DELISTED	Stock	18.06	18.06	17.1	17.13	768000.0
2020-12-22	AAOI	Stock	8.38	9.115	8.26	8.89	1000300.0
2020-12-22	AAON	Stock	42.7933	43.3	42.22	42.88	183450.0
2020-12-22	AAP	Stock	160.42	161.18	158.68	159.4	780400.0
2020-12-22	AAT	Stock	27.92	28.2	27.61	28.1	203700.0
2020-12-22	AAU-DELISTED	Stock	0.5	0.5001	0.48	0.4863	4889703.0
2020-12-22	AAUAF-DELISTED	Stock	0.5	0.5001	0.48	0.4861	5405290.0
2020-12-22	AAWW-DELISTED	Stock	55.54	56.46	55.3	56.08	187990.0
2020-12-22	AAXJ	Stock	86.64	86.7	86.02	86.24	1103069.0
2020-12-22	AAXN-DELISTED	Stock	127.58	131.63	126.38	128.46	735669.0
2020-12-22	AB	Stock	33.42	33.66	33.14	33.37	250000.0
2020-12-22	ABB-DELISTED	Stock	27.25	27.25	26.975	27.08	1723283.0
2020-12-22	ABBNY-DELISTED	Stock	27.25	27.25	26.975	27.08	1838499.0
2020-12-22	ABBV	Stock	103.41	103.5	102.01	102.8	4002900.0
2020-12-22	ABC-DELISTED	Stock	97.62	98.38	96.46	96.72	693976.0
2020-12-22	ABCB	Stock	36.95	37.87	35.92	35.96	252900.0
2020-12-22	ABCL	Stock	47.62	47.99	42.565	47.12	965500.0
2020-12-22	ABCM-DELISTED	Stock	19.62	20.09	19.48	20.0	91433.0
2020-12-22	ABEO	Stock	39.75	40.75	38.0	40.0	109740.0
2020-12-22	ABEV	Stock	3.03	3.09	3.02	3.03	15175600.0
2020-12-22	ABG	Stock	141.22	142.82	136.41	137.61	213700.0
2020-12-22	ABM	Stock	38.65	39.34	38.26	38.44	332800.0
2020-12-22	ABMD-DELISTED	Stock	295.84	304.36	292.53	302.35	158664.0
2020-12-22	ABNB	Stock	170.0	174.97	161.05	163.19	9872600.0
2020-12-22	ABR	Stock	13.81	14.06	13.75	13.94	736200.0
2020-12-22	ABR.A-DELISTED	Stock	25.56	25.56	25.4	25.52	1187.0

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

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