PREVIEW / stock_daily / 2021-09-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-03.parquet
  size:    257 KB
  rows:    7,821
  symbols: 2,673

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-09-03	AAPL	Stock	153.76	154.63	153.09	154.3	57808700.0
2021-09-03	MSFT	Stock	300.99	302.6	300.26	301.14	14747900.0
2021-09-03	NVDA	Stock	22.325	22.986	22.2	22.843	280532000.0
2021-09-03	AMZN	Stock	172.6	174.1335	171.822	173.9025	51514000.0
2021-09-03	GOOGL	Stock	143.0805	144.155	142.4005	143.7395	19854360.0
2021-09-03	META	Stock	374.75	377.16	373.11	376.26	7509600.0
2021-09-03	TSLA	Stock	244.0833	244.6667	241.4	244.5233	45738300.0
2021-09-03	TLT	Stock	148.27	148.51	147.94	148.18	12928250.0
2021-09-03	ES	Stock	92.36	92.6	91.65	91.99	926800.0
2021-09-03	CL	Stock	78.4	78.45	77.77	77.91	3030200.0
2021-09-03	A	Stock	177.67	179.57	177.03	179.28	971800.0
2021-09-03	AA	Stock	46.955	47.72	46.04	47.21	5201900.0
2021-09-03	AAC-DELISTED	Stock	9.71	9.73	9.71	9.72	126962.0
2021-09-03	AACG	Stock	2.76	2.79	2.76	2.77	10400.0
2021-09-03	AAIC-DELISTED	Stock	3.79	3.86	3.78	3.85	108180.0
2021-09-03	AAIC.C-DELISTED	Stock	25.39	25.39	25.29	25.29	720.0
2021-09-03	AAL	Stock	19.68	19.93	19.32	19.37	20311900.0
2021-09-03	AAM.A-DELISTED	Stock	26.18	26.1859	26.09	26.14	7215.0
2021-09-03	AAM.B-DELISTED	Stock	26.94	26.94	26.89	26.91	5504.0
2021-09-03	AAMC-DELISTED	Stock	7.7206	9.0176	7.5441	8.1706	559613.0
2021-09-03	AAME	Stock	4.12	4.16	3.99	3.99	54400.0
2021-09-03	AAMI	Stock	27.26	27.53	27.06	27.4	352000.0
2021-09-03	AAN-DELISTED	Stock	26.76	26.87	26.31	26.85	184300.0
2021-09-03	AAOI	Stock	7.77	7.92	7.65	7.72	330800.0
2021-09-03	AAON	Stock	45.26	45.6267	44.6667	44.8067	146400.0
2021-09-03	AAP	Stock	199.68	201.35	197.7	199.44	699400.0
2021-09-03	AAQC-DELISTED	Stock	9.6712	9.68	9.67	9.68	3507.0
2021-09-03	AAT	Stock	39.57	39.82	39.31	39.79	139400.0
2021-09-03	AATC	Stock	7.94	8.2499	7.94	8.11	21161.0
2021-09-03	AAU-DELISTED	Stock	0.4116	0.4285	0.41	0.4218	803706.0
2021-09-03	AAUAF-DELISTED	Stock	0.4116	0.4285	0.41	0.4218	814641.0
2021-09-03	AAWW-DELISTED	Stock	73.67	74.29	73.01	73.53	181743.0
2021-09-03	AAXJ	Stock	89.83	90.14	89.735	90.01	1011463.0
2021-09-03	AB	Stock	51.75	52.04	51.03	51.46	238500.0
2021-09-03	ABB-DELISTED	Stock	37.56	37.84	37.43	37.67	798438.0
2021-09-03	ABBNY-DELISTED	Stock	37.56	37.84	37.43	37.67	901962.0
2021-09-03	ABBV	Stock	111.18	112.07	111.02	111.62	5364800.0
2021-09-03	ABC-DELISTED	Stock	125.01	125.56	124.905	125.09	339970.0
2021-09-03	ABCB	Stock	48.55	49.64	47.86	48.03	246100.0
2021-09-03	ABCL	Stock	17.661	19.12	17.44	18.74	3003400.0
2021-09-03	ABCM-DELISTED	Stock	21.4	21.51	21.12	21.47	37504.0
2021-09-03	ABEO	Stock	34.0	34.0	32.5	33.75	8988.0
2021-09-03	ABEV	Stock	3.17	3.19	3.13	3.14	27226700.0
2021-09-03	ABG	Stock	180.0	180.33	175.2	179.44	147400.0
2021-09-03	ABM	Stock	48.7	49.03	48.42	48.86	389300.0
2021-09-03	ABMD-DELISTED	Stock	368.27	373.11	363.4101	373.09	88542.0
2021-09-03	ABNB	Stock	158.05	160.64	157.2	158.0	4456400.0
2021-09-03	ABOS	Stock	15.3	15.9	15.045	15.59	152700.0
2021-09-03	ABR	Stock	18.36	18.37	18.17	18.29	716400.0
2021-09-03	ABR.D	Stock	25.52	25.55	25.5	25.53	28982.0

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

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