PREVIEW / stock_daily / 2021-04-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-23.parquet
  size:    255 KB
  rows:    7,779
  symbols: 2,934

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
2021-04-23	AAPL	Stock	132.16	135.12	132.16	134.32	78657500.0
2021-04-23	MSFT	Stock	257.88	261.51	257.27	261.15	21462600.0
2021-04-23	NVDA	Stock	14.9342	15.335	14.9002	15.2653	227500000.0
2021-04-23	AMZN	Stock	165.955	168.75	165.425	167.044	63856000.0
2021-04-23	GOOGL	Stock	113.35	115.3059	113.0625	114.9965	29111080.0
2021-04-23	META	Stock	298.76	302.59	297.15	301.13	17536800.0
2021-04-23	TSLA	Stock	239.9333	245.7867	238.4867	243.1333	85110000.0
2021-04-23	TLT	Stock	140.38	140.47	139.49	140.06	12302248.0
2021-04-23	ES	Stock	88.4	88.7	87.82	88.17	1044800.0
2021-04-23	CL	Stock	80.41	80.63	79.48	79.79	3908400.0
2021-04-23	A	Stock	134.57	137.12	134.5	136.68	1495200.0
2021-04-23	AA	Stock	33.98	34.86	33.76	34.71	4817500.0
2021-04-23	AAC-DELISTED	Stock	9.8	9.81	9.79	9.81	192836.0
2021-04-23	AACG	Stock	2.75	2.88	2.7	2.84	277500.0
2021-04-23	AACQ-DELISTED	Stock	9.98	10.045	9.965	10.04	512899.0
2021-04-23	AACQU-DELISTED	Stock	10.55	10.7899	10.55	10.6717	500.0
2021-04-23	AACQW-DELISTED	Stock	1.53	1.69	1.53	1.61	144885.0
2021-04-23	AAIC-DELISTED	Stock	4.01	4.15	4.01	4.12	251817.0
2021-04-23	AAIC.C-DELISTED	Stock	23.82	23.89	23.82	23.89	3500.0
2021-04-23	AAL	Stock	20.27	21.2	20.18	21.11	47995300.0
2021-04-23	AAM.A-DELISTED	Stock	26.07	26.09	26.03	26.09	12834.0
2021-04-23	AAM.B-DELISTED	Stock	26.98	26.99	26.94	26.94	8478.0
2021-04-23	AAMC-DELISTED	Stock	5.1912	5.2474	5.1912	5.2474	5171.0
2021-04-23	AAME	Stock	4.05	4.15	3.89	4.0	372700.0
2021-04-23	AAMI	Stock	23.17	23.55	23.02	23.34	480800.0
2021-04-23	AAN-DELISTED	Stock	24.54	26.03	24.18	25.78	187300.0
2021-04-23	AAOI	Stock	8.08	8.31	7.99	8.27	487700.0
2021-04-23	AAON	Stock	46.4333	46.7	46.0733	46.5333	135750.0
2021-04-23	AAP	Stock	200.98	201.39	197.27	199.75	519700.0
2021-04-23	AAT	Stock	33.84	34.5	33.65	34.34	306900.0
2021-04-23	AAU-DELISTED	Stock	0.555	0.576	0.5502	0.5576	1404652.0
2021-04-23	AAUAF-DELISTED	Stock	0.555	0.576	0.5502	0.5696	1550304.0
2021-04-23	AAWW-DELISTED	Stock	66.56	67.9	65.81	67.76	194123.0
2021-04-23	AAXJ	Stock	94.22	94.73	94.21	94.66	1032807.0
2021-04-23	AB	Stock	41.7	42.34	41.61	42.21	306800.0
2021-04-23	ABB-DELISTED	Stock	32.46	32.85	32.435	32.77	918980.0
2021-04-23	ABBNY-DELISTED	Stock	32.46	32.85	32.435	32.77	1007910.0
2021-04-23	ABBV	Stock	109.71	111.77	109.55	111.38	4611000.0
2021-04-23	ABC-DELISTED	Stock	120.86	121.82	120.229	121.7	370119.0
2021-04-23	ABCB	Stock	47.97	51.62	47.55	50.81	491600.0
2021-04-23	ABCL	Stock	28.76	29.89	28.76	29.33	414400.0
2021-04-23	ABCM-DELISTED	Stock	20.25	20.73	20.17	20.64	44489.0
2021-04-23	ABEO	Stock	44.25	44.75	40.25	40.5	73984.0
2021-04-23	ABEV	Stock	2.95	2.97	2.9	2.92	17243800.0
2021-04-23	ABG	Stock	207.97	212.58	205.77	211.33	86000.0
2021-04-23	ABGI-DELISTED	Stock	9.9453	9.97	9.9453	9.97	1300.0
2021-04-23	ABM	Stock	53.05	53.87	53.0	53.52	352600.0
2021-04-23	ABMD-DELISTED	Stock	345.59	355.94	344.79	350.99	205980.0
2021-04-23	ABNB	Stock	172.919	178.25	172.0	174.25	3329900.0
2021-04-23	ABR	Stock	16.75	17.31	16.65	17.27	1279100.0

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

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