PREVIEW / stock_daily / 2021-04-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-05.parquet
  size:    254 KB
  rows:    7,737
  symbols: 2,919

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-05	AAPL	Stock	123.87	126.16	123.07	125.9	88651200.0
2021-04-05	MSFT	Stock	242.76	249.96	242.7	249.07	36910600.0
2021-04-05	NVDA	Stock	13.8675	14.014	13.733	13.9875	255672000.0
2021-04-05	AMZN	Stock	158.65	161.798	158.062	161.3365	66698000.0
2021-04-05	GOOGL	Stock	107.3575	111.4495	107.2602	110.948	48509600.0
2021-04-05	META	Stock	300.89	310.77	300.68	308.91	28237000.0
2021-04-05	TSLA	Stock	235.9033	236.0533	228.2333	230.35	125528400.0
2021-04-05	TLT	Stock	136.55	136.97	135.94	136.91	8242978.0
2021-04-05	ES	Stock	86.53	88.11	86.48	87.59	866800.0
2021-04-05	CL	Stock	78.73	79.91	78.61	79.53	4026900.0
2021-04-05	A	Stock	129.0	130.61	129.0	130.0	1096300.0
2021-04-05	AA	Stock	32.68	32.8	31.51	31.55	3933800.0
2021-04-05	AAC-DELISTED	Stock	9.82	9.88	9.81	9.85	206193.0
2021-04-05	AACG	Stock	4.15	4.29	4.07	4.2	132100.0
2021-04-05	AACQ-DELISTED	Stock	10.31	10.38	10.19	10.24	490503.0
2021-04-05	AACQU-DELISTED	Stock	10.8738	10.9281	10.822	10.8302	2800.0
2021-04-05	AACQW-DELISTED	Stock	1.85	1.96	1.78	1.925	147109.0
2021-04-05	AAIC-DELISTED	Stock	4.15	4.15	4.03	4.07	167640.0
2021-04-05	AAIC.C-DELISTED	Stock	23.6	23.6025	23.11	23.55	6767.0
2021-04-05	AAL	Stock	24.46	24.85	24.16	24.23	33657000.0
2021-04-05	AAM.A-DELISTED	Stock	26.1	26.1	25.95	26.0	50913.0
2021-04-05	AAM.B-DELISTED	Stock	26.98	26.98	26.8	26.8706	19088.0
2021-04-05	AAMC-DELISTED	Stock	6.1031	6.1031	5.5941	5.5941	13012.0
2021-04-05	AAME	Stock	4.14	4.17	3.92	4.02	252400.0
2021-04-05	AAMI	Stock	21.07	21.28	20.68	20.86	462000.0
2021-04-05	AAN-DELISTED	Stock	26.27	26.61	25.98	26.57	227500.0
2021-04-05	AAOI	Stock	8.92	8.93	8.42	8.69	1359000.0
2021-04-05	AAON	Stock	47.6667	48.2	46.9333	47.2267	168900.0
2021-04-05	AAP	Stock	187.5	187.8	182.28	183.23	998300.0
2021-04-05	AAT	Stock	33.37	33.37	32.19	32.5	206300.0
2021-04-05	AAU-DELISTED	Stock	0.5581	0.5583	0.5325	0.5429	1599585.0
2021-04-05	AAUAF-DELISTED	Stock	0.547	0.5583	0.5325	0.5429	1670525.0
2021-04-05	AAWW-DELISTED	Stock	61.6	62.67	60.8123	62.64	442233.0
2021-04-05	AAXJ	Stock	94.23	94.2628	93.74	93.97	686907.0
2021-04-05	AB	Stock	41.42	41.54	40.98	41.38	421200.0
2021-04-05	ABB-DELISTED	Stock	30.91	31.52	30.74	31.31	1218244.0
2021-04-05	ABBNY-DELISTED	Stock	30.91	31.52	30.74	31.32	1326888.0
2021-04-05	ABBV	Stock	109.08	109.08	105.4	106.14	10584400.0
2021-04-05	ABC-DELISTED	Stock	117.26	118.09	115.15	117.01	762215.0
2021-04-05	ABCB	Stock	53.83	54.3	52.82	53.28	376300.0
2021-04-05	ABCL	Stock	31.71	31.78	27.9	28.09	1648200.0
2021-04-05	ABCM-DELISTED	Stock	19.71	20.1	19.55	19.81	52916.0
2021-04-05	ABEO	Stock	46.25	46.75	44.0	46.25	45480.0
2021-04-05	ABEV	Stock	2.7	2.76	2.7	2.72	18797300.0
2021-04-05	ABG	Stock	199.66	199.66	195.45	197.37	110100.0
2021-04-05	ABGI-DELISTED	Stock	9.9	9.95	9.9	9.94	4632.0
2021-04-05	ABM	Stock	51.31	52.05	50.93	51.92	426900.0
2021-04-05	ABMD-DELISTED	Stock	315.63	322.285	311.48	321.5	161982.0
2021-04-05	ABNB	Stock	191.66	192.1	185.81	186.69	2591400.0
2021-04-05	ABR	Stock	16.2	16.23	15.93	15.93	1407700.0

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

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