PREVIEW / stock_daily / 2021-04-06

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-06.parquet
  size:    254 KB
  rows:    7,742
  symbols: 2,922

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-06	AAPL	Stock	126.5	127.13	125.65	126.21	80171300.0
2021-04-06	MSFT	Stock	247.61	249.4	246.88	247.86	22931900.0
2021-04-06	NVDA	Stock	13.9998	14.0542	13.7735	13.8615	191744000.0
2021-04-06	AMZN	Stock	161.1875	162.3655	160.852	161.191	50756000.0
2021-04-06	GOOGL	Stock	110.546	111.4	110.0895	110.463	35240780.0
2021-04-06	META	Stock	308.84	311.35	305.25	306.26	17335200.0
2021-04-06	TSLA	Stock	230.1	232.1833	227.1233	230.54	84815400.0
2021-04-06	TLT	Stock	137.16	137.98	137.01	137.84	9282395.0
2021-04-06	ES	Stock	87.11	87.96	86.55	87.68	693200.0
2021-04-06	CL	Stock	79.25	80.14	79.21	79.86	3814800.0
2021-04-06	A	Stock	130.57	131.86	129.87	131.04	1623200.0
2021-04-06	AA	Stock	31.66	33.07	31.1	31.31	6204500.0
2021-04-06	AAC-DELISTED	Stock	9.86	9.87	9.8	9.85	236001.0
2021-04-06	AACG	Stock	4.14	4.25	3.96	3.99	247100.0
2021-04-06	AACQ-DELISTED	Stock	10.22	10.335	10.135	10.19	717381.0
2021-04-06	AACQU-DELISTED	Stock	10.93	10.94	10.7567	10.7567	1819.0
2021-04-06	AACQW-DELISTED	Stock	1.98	2.05	1.8512	1.91	185770.0
2021-04-06	AAIC-DELISTED	Stock	4.05	4.13	4.05	4.06	117379.0
2021-04-06	AAIC.C-DELISTED	Stock	23.5524	23.7	23.525	23.59	15550.0
2021-04-06	AAL	Stock	24.2	24.5	23.91	24.06	31099400.0
2021-04-06	AAM.A-DELISTED	Stock	25.99	26.08	25.99	26.07	23297.0
2021-04-06	AAM.B-DELISTED	Stock	26.9	26.95	26.82	26.94	12865.0
2021-04-06	AAMC-DELISTED	Stock	5.5882	5.772	5.4824	5.7029	9017.0
2021-04-06	AAME	Stock	4.1	4.18	3.95	4.03	283700.0
2021-04-06	AAMI	Stock	20.84	20.93	20.4	20.44	584600.0
2021-04-06	AAN-DELISTED	Stock	26.53	27.18	25.89	26.01	239000.0
2021-04-06	AAOI	Stock	8.64	8.74	8.45	8.47	444900.0
2021-04-06	AAON	Stock	47.3133	47.36	46.6867	47.0333	167700.0
2021-04-06	AAP	Stock	181.26	184.47	180.68	183.65	901400.0
2021-04-06	AAT	Stock	32.49	33.18	32.49	33.02	257500.0
2021-04-06	AAU-DELISTED	Stock	0.55	0.5583	0.541	0.555	1220136.0
2021-04-06	AAUAF-DELISTED	Stock	0.55	0.5583	0.541	0.555	1267579.0
2021-04-06	AAWW-DELISTED	Stock	63.31	64.34	62.35	64.21	548446.0
2021-04-06	AAXJ	Stock	94.01	94.9769	93.81	94.56	1054639.0
2021-04-06	AB	Stock	40.98	41.38	40.45	40.75	396600.0
2021-04-06	ABB-DELISTED	Stock	31.24	31.42	31.14	31.16	1222695.0
2021-04-06	ABBNY-DELISTED	Stock	31.24	31.42	31.14	31.16	1780514.0
2021-04-06	ABBV	Stock	105.85	106.28	104.88	105.38	8522500.0
2021-04-06	ABC-DELISTED	Stock	117.01	117.93	115.77	115.99	584784.0
2021-04-06	ABCB	Stock	53.15	53.92	52.6	52.87	370000.0
2021-04-06	ABCL	Stock	28.0	29.14	26.77	29.0	1432100.0
2021-04-06	ABCM-DELISTED	Stock	19.36	19.83	19.095	19.7	179835.0
2021-04-06	ABEO	Stock	45.5	45.75	42.5	42.5	54816.0
2021-04-06	ABEV	Stock	2.72	2.8	2.72	2.76	12201800.0
2021-04-06	ABG	Stock	196.77	199.77	195.0	196.39	75100.0
2021-04-06	ABGI-DELISTED	Stock	9.94	9.95	9.81	9.94	4400.0
2021-04-06	ABM	Stock	52.0	52.7	51.51	51.88	281300.0
2021-04-06	ABMD-DELISTED	Stock	321.42	329.02	317.45	323.87	152178.0
2021-04-06	ABNB	Stock	188.7	194.48	187.52	190.03	3565600.0
2021-04-06	ABR	Stock	15.94	16.09	15.87	15.87	1193600.0

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

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