PREVIEW / stock_daily / 2021-04-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-07.parquet
  size:    254 KB
  rows:    7,750
  symbols: 2,926

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-07	AAPL	Stock	125.83	127.92	125.14	127.9	83466700.0
2021-04-07	MSFT	Stock	247.81	250.93	247.19	249.9	22719800.0
2021-04-07	NVDA	Stock	13.8808	14.2435	13.7115	14.1435	251284000.0
2021-04-07	AMZN	Stock	161.69	165.1805	161.1825	163.9695	66924000.0
2021-04-07	GOOGL	Stock	110.655	112.225	110.655	111.9515	24133920.0
2021-04-07	META	Stock	306.34	314.25	305.5	313.09	22855200.0
2021-04-07	TSLA	Stock	229.0	230.46	222.6133	223.6567	78928200.0
2021-04-07	TLT	Stock	137.45	138.1	136.88	136.88	11052827.0
2021-04-07	ES	Stock	87.81	88.23	87.09	87.6	912500.0
2021-04-07	CL	Stock	80.23	80.33	79.46	79.62	5027800.0
2021-04-07	A	Stock	130.25	130.57	128.53	129.34	954600.0
2021-04-07	AA	Stock	31.37	31.97	31.11	31.52	4193400.0
2021-04-07	AAC-DELISTED	Stock	9.87	9.87	9.77	9.81	243324.0
2021-04-07	AACG	Stock	3.99	4.0	3.8	3.99	172800.0
2021-04-07	AACQ-DELISTED	Stock	10.18	10.35	10.1628	10.29	850865.0
2021-04-07	AACQU-DELISTED	Stock	10.9	11.01	10.82	10.87	5748.0
2021-04-07	AACQW-DELISTED	Stock	2.03	2.05	1.92	1.99	125330.0
2021-04-07	AAIC-DELISTED	Stock	4.03	4.08	3.9987	4.02	197353.0
2021-04-07	AAIC.C-DELISTED	Stock	23.57	23.6	23.57	23.57	2424.0
2021-04-07	AAL	Stock	24.19	24.59	23.82	23.93	27792500.0
2021-04-07	AAM.A-DELISTED	Stock	26.0784	26.1	26.06	26.08	33700.0
2021-04-07	AAM.B-DELISTED	Stock	26.95	26.95	26.9032	26.92	11586.0
2021-04-07	AAMC-DELISTED	Stock	5.4824	5.6884	5.4412	5.4941	24007.0
2021-04-07	AAME	Stock	4.04	4.14	3.73	3.75	355900.0
2021-04-07	AAMI	Stock	20.45	20.64	20.33	20.37	498900.0
2021-04-07	AAN-DELISTED	Stock	26.1	26.71	25.11	25.16	332500.0
2021-04-07	AAOI	Stock	8.45	8.6	8.31	8.48	382800.0
2021-04-07	AAON	Stock	47.08	47.08	45.9333	45.9467	147750.0
2021-04-07	AAP	Stock	184.49	184.73	181.05	182.62	443900.0
2021-04-07	AAT	Stock	32.92	33.16	32.42	33.03	151200.0
2021-04-07	AAU-DELISTED	Stock	0.5584	0.5584	0.5372	0.5407	1081686.0
2021-04-07	AAUAF-DELISTED	Stock	0.5584	0.5584	0.5372	0.5407	1154522.0
2021-04-07	AAWW-DELISTED	Stock	63.66	63.88	61.14	61.73	474913.0
2021-04-07	AAXJ	Stock	93.11	93.26	92.68	92.98	769889.0
2021-04-07	AB	Stock	40.8	40.9	40.48	40.58	194500.0
2021-04-07	ABB-DELISTED	Stock	31.33	31.36	31.0839	31.21	1320957.0
2021-04-07	ABBNY-DELISTED	Stock	31.31	31.36	31.0839	31.21	1436268.0
2021-04-07	ABBV	Stock	105.53	106.13	104.17	105.21	8037300.0
2021-04-07	ABC-DELISTED	Stock	116.44	117.14	115.43	116.51	548727.0
2021-04-07	ABCB	Stock	52.38	52.67	51.61	51.93	534200.0
2021-04-07	ABCL	Stock	28.41	31.32	27.86	31.29	1443200.0
2021-04-07	ABCM-DELISTED	Stock	19.67	19.765	19.48	19.66	245959.0
2021-04-07	ABEO	Stock	42.5	43.25	40.5	40.5	53784.0
2021-04-07	ABEV	Stock	2.77	2.8	2.71	2.72	13536000.0
2021-04-07	ABG	Stock	195.8	197.64	191.54	193.24	140100.0
2021-04-07	ABGI-DELISTED	Stock	9.87	9.94	9.865	9.92	10353.0
2021-04-07	ABM	Stock	51.9	51.9	50.78	51.12	331400.0
2021-04-07	ABMD-DELISTED	Stock	325.23	325.3405	317.215	320.63	90135.0
2021-04-07	ABNB	Stock	189.38	190.62	179.47	179.94	6663500.0
2021-04-07	ABR	Stock	16.01	16.01	15.81	15.88	769700.0

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

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