PREVIEW / stock_daily / 2022-04-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-29.parquet
  size:    259 KB
  rows:    8,047
  symbols: 2,467

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-04-29	AAPL	Stock	161.84	166.2	157.25	157.65	131747600.0
2022-04-29	MSFT	Stock	288.61	289.88	276.5	277.52	37073900.0
2022-04-29	NVDA	Stock	19.402	20.128	18.517	18.547	500435000.0
2022-04-29	AMZN	Stock	129.849	130.761	121.625	124.2815	272662000.0
2022-04-29	GOOGL	Stock	116.7345	117.9198	113.8145	114.1095	42676000.0
2022-04-29	META	Stock	204.46	212.48	199.9	200.47	49193400.0
2022-04-29	TSLA	Stock	300.75	311.4667	290.0	290.2533	88133100.0
2022-04-29	TLT	Stock	119.31	120.97	119.105	119.45	26153421.0
2022-04-29	ES	Stock	89.83	89.87	87.22	87.4	2291800.0
2022-04-29	CL	Stock	77.74	77.95	76.18	77.05	14943400.0
2022-04-29	A	Stock	120.71	123.89	119.05	119.27	2269200.0
2022-04-29	AA	Stock	71.06	72.68	67.225	67.8	6093800.0
2022-04-29	AAC-DELISTED	Stock	9.84	9.86	9.83	9.84	144275.0
2022-04-29	AACG	Stock	1.17	1.2	1.16	1.18	7200.0
2022-04-29	AACIW-DELISTED	Stock	0.3	0.3	0.2896	0.2896	11975.0
2022-04-29	AAIC-DELISTED	Stock	3.22	3.26	3.05	3.05	125966.0
2022-04-29	AAIC.C-DELISTED	Stock	24.54	24.54	24.5	24.51	13844.0
2022-04-29	AAL	Stock	19.15	19.51	18.72	18.77	24044900.0
2022-04-29	AAM.A-DELISTED	Stock	24.51	24.89	24.345	24.72	63350.0
2022-04-29	AAM.B-DELISTED	Stock	25.15	25.55	24.9777	25.55	57028.0
2022-04-29	AAMC-DELISTED	Stock	2.8912	2.9941	2.6765	2.6765	35180.0
2022-04-29	AAME	Stock	2.97	3.13	2.97	3.05	4200.0
2022-04-29	AAMI	Stock	20.45	20.83	19.97	20.04	624900.0
2022-04-29	AAN-DELISTED	Stock	20.37	21.14	20.37	20.53	255400.0
2022-04-29	AAOI	Stock	2.53	2.72	2.53	2.57	97400.0
2022-04-29	AAON	Stock	33.2533	33.7533	32.4	32.4933	239700.0
2022-04-29	AAP	Stock	208.57	209.8	198.82	199.63	894800.0
2022-04-29	AAQC-DELISTED	Stock	9.785	9.785	9.78	9.78	10500.0
2022-04-29	AAT	Stock	37.82	37.93	36.54	36.6	497000.0
2022-04-29	AATC	Stock	6.5429	6.725	6.5429	6.72	2643.0
2022-04-29	AAU-DELISTED	Stock	0.3	0.32	0.3	0.305	587433.0
2022-04-29	AAUAF-DELISTED	Stock	0.3	0.32	0.2962	0.2962	593967.0
2022-04-29	AAWW-DELISTED	Stock	69.37	70.49	68.77	68.97	284031.0
2022-04-29	AAXJ	Stock	71.88	72.195	70.81	70.92	2022750.0
2022-04-29	AB	Stock	39.95	41.8	39.79	39.81	455000.0
2022-04-29	ABB-DELISTED	Stock	30.46	30.775	29.82	29.87	2164627.0
2022-04-29	ABBNY-DELISTED	Stock	30.46	30.775	29.82	29.87	2363296.0
2022-04-29	ABBV	Stock	149.56	149.86	139.93	146.88	25155900.0
2022-04-29	ABC-DELISTED	Stock	156.96	157.205	150.71	151.26	1240081.0
2022-04-29	ABCB	Stock	42.31	42.83	41.5	41.7	559000.0
2022-04-29	ABCL	Stock	7.94	7.985	7.64	7.67	812000.0
2022-04-29	ABCM-DELISTED	Stock	15.6	15.83	15.465	15.5	56714.0
2022-04-29	ABEO	Stock	5.75	5.75	5.25	5.25	78696.0
2022-04-29	ABEV	Stock	2.98	3.02	2.9	2.91	30378300.0
2022-04-29	ABG	Stock	173.55	189.99	173.55	183.71	508100.0
2022-04-29	ABM	Stock	48.1	49.23	47.39	48.27	2698100.0
2022-04-29	ABMD-DELISTED	Stock	284.97	292.09	280.47	286.37	224921.0
2022-04-29	ABNB	Stock	158.88	163.24	153.0	153.21	4033100.0
2022-04-29	ABOS	Stock	3.87	3.96	3.71	3.86	182600.0
2022-04-29	ABR	Stock	17.56	17.61	17.03	17.1	1466500.0

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

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