PREVIEW / stock_daily / 2021-04-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-14.parquet
  size:    254 KB
  rows:    7,758
  symbols: 2,931

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-14	AAPL	Stock	134.94	135.0	131.66	132.03	87222800.0
2021-04-14	MSFT	Stock	257.48	258.83	255.16	255.59	23070900.0
2021-04-14	NVDA	Stock	15.625	15.7205	15.2275	15.277	385500000.0
2021-04-14	AMZN	Stock	170.202	170.2065	166.3	166.65	62904000.0
2021-04-14	GOOGL	Stock	113.3715	113.3715	111.8008	112.0955	21002860.0
2021-04-14	META	Stock	307.3	308.03	301.95	302.82	17421400.0
2021-04-14	TSLA	Stock	256.9	260.2633	242.6767	244.0767	147052200.0
2021-04-14	TLT	Stock	138.03	138.2351	137.57	138.04	7293169.0
2021-04-14	ES	Stock	87.03	88.2	86.83	88.16	1044500.0
2021-04-14	CL	Stock	79.79	79.81	79.0	79.4	4129600.0
2021-04-14	A	Stock	133.1	133.23	130.96	131.97	1499300.0
2021-04-14	AA	Stock	31.95	34.24	31.8	33.39	8200500.0
2021-04-14	AAC-DELISTED	Stock	9.91	9.93	9.89	9.9	454944.0
2021-04-14	AACG	Stock	3.35	3.45	3.29	3.37	94700.0
2021-04-14	AACQ-DELISTED	Stock	10.2	10.26	10.13	10.18	604089.0
2021-04-14	AACQU-DELISTED	Stock	10.76	10.8253	10.74	10.74	1700.0
2021-04-14	AACQW-DELISTED	Stock	1.79	1.96	1.7	1.76	194119.0
2021-04-14	AAIC-DELISTED	Stock	3.99	4.1	3.96	3.98	138340.0
2021-04-14	AAIC.C-DELISTED	Stock	23.85	23.8501	23.78	23.79	6562.0
2021-04-14	AAL	Stock	22.95	23.35	22.2	22.37	33969600.0
2021-04-14	AAM.A-DELISTED	Stock	26.09	26.11	26.05	26.07	21016.0
2021-04-14	AAM.B-DELISTED	Stock	26.66	26.75	26.66	26.75	9666.0
2021-04-14	AAMC-DELISTED	Stock	5.7559	5.7559	5.5588	5.6176	56202.0
2021-04-14	AAME	Stock	3.52	3.79	3.49	3.7	150500.0
2021-04-14	AAMI	Stock	23.25	23.9	23.25	23.43	556600.0
2021-04-14	AAN-DELISTED	Stock	24.18	25.2	24.18	24.86	227300.0
2021-04-14	AAOI	Stock	8.22	8.53	8.1	8.29	341800.0
2021-04-14	AAON	Stock	46.0333	46.6667	45.8933	45.8933	148800.0
2021-04-14	AAP	Stock	187.47	189.49	187.1	187.77	765900.0
2021-04-14	AAT	Stock	33.62	33.88	33.3	33.39	171200.0
2021-04-14	AAU-DELISTED	Stock	0.4838	0.5148	0.4825	0.498	1021507.0
2021-04-14	AAUAF-DELISTED	Stock	0.4838	0.5148	0.4825	0.4975	1096204.0
2021-04-14	AAWW-DELISTED	Stock	64.2	65.14	63.965	65.12	289277.0
2021-04-14	AAXJ	Stock	93.81	93.858	93.17	93.32	693492.0
2021-04-14	AB	Stock	40.33	40.81	40.08	40.35	389600.0
2021-04-14	ABB-DELISTED	Stock	31.67	31.8	31.56	31.59	864355.0
2021-04-14	ABBNY-DELISTED	Stock	31.67	31.8	31.56	31.59	940441.0
2021-04-14	ABBV	Stock	106.22	106.67	105.58	105.9	7766700.0
2021-04-14	ABC-DELISTED	Stock	116.94	118.3834	116.82	118.05	731304.0
2021-04-14	ABCB	Stock	49.99	51.45	49.99	50.64	388300.0
2021-04-14	ABCL	Stock	28.22	30.64	27.72	28.25	1170800.0
2021-04-14	ABCM-DELISTED	Stock	19.677	19.8792	19.51	19.56	125277.0
2021-04-14	ABEO	Stock	38.25	41.25	38.0	40.0	67468.0
2021-04-14	ABEV	Stock	2.78	2.83	2.77	2.82	24609500.0
2021-04-14	ABG	Stock	200.8	213.24	200.8	209.8	360800.0
2021-04-14	ABGI-DELISTED	Stock	9.9	10.02	9.84	9.95	35468.0
2021-04-14	ABM	Stock	52.65	53.9	52.65	53.4	390200.0
2021-04-14	ABMD-DELISTED	Stock	329.28	333.39	328.21	330.21	105384.0
2021-04-14	ABNB	Stock	179.5	181.467	175.31	176.43	2938600.0
2021-04-14	ABR	Stock	16.35	16.68	16.33	16.44	828400.0

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

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