PREVIEW / stock_daily / 2022-09-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-01.parquet
  size:    252 KB
  rows:    7,862
  symbols: 2,223

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
2022-09-01	AAPL	Stock	156.64	158.42	154.67	157.96	74229900.0
2022-09-01	MSFT	Stock	258.87	260.89	255.41	260.4	23263400.0
2022-09-01	NVDA	Stock	14.209	14.38	13.27	13.937	1178865000.0
2022-09-01	AMZN	Stock	126.0	128.02	123.66	127.82	56636100.0
2022-09-01	GOOGL	Stock	108.28	110.445	107.36	109.74	28360926.0
2022-09-01	META	Stock	163.58	167.36	160.35	165.36	30145700.0
2022-09-01	TSLA	Stock	272.58	277.58	266.15	277.16	54287000.0
2022-09-01	TLT	Stock	109.87	110.25	108.94	109.6	22490448.0
2022-09-01	ES	Stock	89.83	91.34	89.48	90.87	1237900.0
2022-09-01	CL	Stock	78.13	79.8	77.77	79.8	5924100.0
2022-09-01	A	Stock	127.63	129.11	126.21	128.93	1282000.0
2022-09-01	AA	Stock	47.695	48.41	46.1	48.08	5971400.0
2022-09-01	AAC-DELISTED	Stock	9.89	9.9091	9.89	9.89	82218.0
2022-09-01	AACG	Stock	2.5	2.5	2.36	2.46	15200.0
2022-09-01	AACIW-DELISTED	Stock	0.1446	0.1798	0.1446	0.1449	663.0
2022-09-01	AAIC-DELISTED	Stock	3.3	3.3	3.19	3.2	20505.0
2022-09-01	AAIC.C-DELISTED	Stock	21.8	21.85	21.0101	21.6	5461.0
2022-09-01	AAL	Stock	12.87	12.95	12.5	12.93	29871200.0
2022-09-01	AAM.A-DELISTED	Stock	24.21	24.335	23.74	23.83	20765.0
2022-09-01	AAM.B-DELISTED	Stock	24.1	24.2971	23.92	23.97	10549.0
2022-09-01	AAMC-DELISTED	Stock	5.5843	6.3235	5.5843	5.9147	44693.0
2022-09-01	AAME	Stock	3.05	3.05	2.86	2.97	5100.0
2022-09-01	AAMI	Stock	17.0	17.27	16.82	17.23	255900.0
2022-09-01	AAN-DELISTED	Stock	11.9	12.0	11.39	11.97	337400.0
2022-09-01	AAOI	Stock	2.37	2.37	2.16	2.18	150500.0
2022-09-01	AAON	Stock	38.1867	38.8333	37.7933	38.6267	173700.0
2022-09-01	AAP	Stock	168.0	172.54	167.57	172.15	919600.0
2022-09-01	AAQC-DELISTED	Stock	9.81	9.82	9.81	9.81	1556.0
2022-09-01	AAT	Stock	27.64	27.67	27.14	27.66	200300.0
2022-09-01	AATC	Stock	5.1	5.6	5.05	5.11	5172.0
2022-09-01	AAU-DELISTED	Stock	0.2251	0.2301	0.2202	0.2238	56839.0
2022-09-01	AAUAF-DELISTED	Stock	0.2251	0.2301	0.2202	0.2238	60832.0
2022-09-01	AAWW-DELISTED	Stock	99.91	99.98	99.75	99.79	709113.0
2022-09-01	AAXJ	Stock	66.22	66.475	65.81	66.4	936490.0
2022-09-01	AB	Stock	42.75	43.0	41.64	43.0	269400.0
2022-09-01	ABB-DELISTED	Stock	27.14	27.25	26.83	27.24	1804875.0
2022-09-01	ABBNY-DELISTED	Stock	27.14	27.25	26.83	27.25	2169295.0
2022-09-01	ABBV	Stock	134.64	138.59	134.1	138.45	4521000.0
2022-09-01	ABC-DELISTED	Stock	146.56	147.71	145.36	147.66	407662.0
2022-09-01	ABCB	Stock	46.62	46.68	45.36	46.2	427300.0
2022-09-01	ABCL	Stock	10.54	11.09	10.47	11.07	1415700.0
2022-09-01	ABCM-DELISTED	Stock	14.54	14.54	13.98	14.14	108314.0
2022-09-01	ABEO	Stock	3.68	3.68	3.35	3.48	138500.0
2022-09-01	ABEV	Stock	2.9	2.92	2.85	2.88	34612200.0
2022-09-01	ABG	Stock	171.67	173.84	167.62	173.61	180700.0
2022-09-01	ABGI-DELISTED	Stock	9.88	9.88	9.875	9.88	9272.0
2022-09-01	ABM	Stock	46.24	46.24	44.83	45.12	214800.0
2022-09-01	ABMD-DELISTED	Stock	256.73	259.67	249.7346	259.61	140947.0
2022-09-01	ABNB	Stock	111.1	114.08	108.17	113.4	5661500.0
2022-09-01	ABOS	Stock	5.62	6.27	5.58	6.09	28700.0

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

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