PREVIEW / stock_daily / 2022-03-31

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-31.parquet
  size:    263 KB
  rows:    8,083
  symbols: 2,534

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-03-31	AAPL	Stock	177.84	178.03	174.4	174.61	103049300.0
2022-03-31	MSFT	Stock	313.9	315.14	307.89	308.31	33422100.0
2022-03-31	NVDA	Stock	27.782	28.248	27.27	27.286	523440000.0
2022-03-31	AMZN	Stock	166.445	166.495	162.9535	162.9975	59966000.0
2022-03-31	GOOGL	Stock	142.053	142.1078	139.0245	139.0675	37524720.0
2022-03-31	META	Stock	228.45	228.49	222.26	222.36	24192300.0
2022-03-31	TSLA	Stock	364.8567	367.7133	358.88	359.2	48992700.0
2022-03-31	TLT	Stock	131.98	132.67	131.66	132.08	19900953.0
2022-03-31	ES	Stock	88.63	89.21	88.14	88.19	1604600.0
2022-03-31	CL	Stock	76.2	76.38	75.38	75.83	7711400.0
2022-03-31	A	Stock	135.17	136.79	132.29	132.33	3046400.0
2022-03-31	AA	Stock	91.67	92.7	89.801	90.03	4567200.0
2022-03-31	AAC-DELISTED	Stock	9.76	9.81	9.76	9.81	70575.0
2022-03-31	AACG	Stock	1.39	1.6	1.39	1.48	46200.0
2022-03-31	AACIW-DELISTED	Stock	0.3099	0.3099	0.3035	0.3035	2150.0
2022-03-31	AAIC-DELISTED	Stock	3.47	3.5297	3.4632	3.47	47379.0
2022-03-31	AAIC.C-DELISTED	Stock	24.9399	24.9399	24.9399	24.9399	212.0
2022-03-31	AAL	Stock	18.16	18.45	17.98	18.25	33338200.0
2022-03-31	AAM.A-DELISTED	Stock	25.13	25.19	25.13	25.13	13690.0
2022-03-31	AAM.B-DELISTED	Stock	25.62	25.68	25.5	25.6	16260.0
2022-03-31	AAMC-DELISTED	Stock	4.1118	4.3	4.1118	4.1382	9918.0
2022-03-31	AAME	Stock	3.1	3.15	2.89	3.13	8000.0
2022-03-31	AAMI	Stock	24.35	24.68	24.21	24.25	578000.0
2022-03-31	AAN-DELISTED	Stock	20.83	20.95	19.84	20.08	345700.0
2022-03-31	AAOI	Stock	3.5	3.68	3.488	3.65	332200.0
2022-03-31	AAON	Stock	37.18	37.74	36.8733	37.1533	422550.0
2022-03-31	AAP	Stock	211.22	211.22	206.91	206.96	727800.0
2022-03-31	AAQC-DELISTED	Stock	9.72	9.76	9.72	9.76	38084.0
2022-03-31	AAT	Stock	38.33	38.65	37.84	37.89	343600.0
2022-03-31	AATC	Stock	6.27	6.38	6.27	6.38	4479.0
2022-03-31	AAU-DELISTED	Stock	0.361	0.3749	0.35	0.3645	398574.0
2022-03-31	AAUAF-DELISTED	Stock	0.361	0.3749	0.35	0.3584	403489.0
2022-03-31	AAWW-DELISTED	Stock	88.72	89.25	86.36	86.36	255657.0
2022-03-31	AAXJ	Stock	76.04	76.06	75.015	75.03	1084474.0
2022-03-31	AB	Stock	47.35	47.83	47.01	47.02	272700.0
2022-03-31	ABB-DELISTED	Stock	32.73	32.89	32.34	32.345	2507182.0
2022-03-31	ABBNY-DELISTED	Stock	32.73	32.89	32.34	32.34	2766849.0
2022-03-31	ABBV	Stock	162.93	164.66	162.1	162.11	8670100.0
2022-03-31	ABC-DELISTED	Stock	154.65	156.94	154.06	154.72	747578.0
2022-03-31	ABCB	Stock	45.0	45.43	43.68	43.88	455500.0
2022-03-31	ABCL	Stock	9.7	9.85	9.47	9.75	908000.0
2022-03-31	ABCM-DELISTED	Stock	18.25	18.4399	18.12	18.28	100274.0
2022-03-31	ABEO	Stock	7.25	8.25	6.75	8.0	313936.0
2022-03-31	ABEV	Stock	3.17	3.26	3.16	3.23	23582300.0
2022-03-31	ABG	Stock	163.7	167.63	159.29	160.2	595100.0
2022-03-31	ABGI-DELISTED	Stock	9.78	9.8	9.78	9.79	2146.0
2022-03-31	ABM	Stock	45.66	46.22	45.64	46.04	395500.0
2022-03-31	ABMD-DELISTED	Stock	330.0	342.38	328.665	330.97	276040.0
2022-03-31	ABNB	Stock	173.54	176.15	171.164	171.76	3232200.0
2022-03-31	ABOS	Stock	4.1	4.1	3.84	3.91	329400.0

> showing 50 of 8,083 rows — these rows as CSV

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