PREVIEW / stock_daily / 2022-04-26

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-26.parquet
  size:    259 KB
  rows:    7,975
  symbols: 2,427

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-26	AAPL	Stock	162.25	162.34	156.72	156.8	95623200.0
2022-04-26	MSFT	Stock	277.5	278.36	270.0	270.22	46518400.0
2022-04-26	NVDA	Stock	19.718	19.788	18.67	18.788	653143000.0
2022-04-26	AMZN	Stock	144.8	144.856	138.9295	139.391	77530000.0
2022-04-26	GOOGL	Stock	122.2945	122.51	118.511	118.65	73054880.0
2022-04-26	META	Stock	186.63	187.19	179.5	180.95	31747400.0
2022-04-26	TSLA	Stock	331.81	333.3333	291.6667	292.14	136133700.0
2022-04-26	TLT	Stock	122.44	123.03	121.76	122.41	26931347.0
2022-04-26	ES	Stock	90.25	91.53	89.71	89.72	1202900.0
2022-04-26	CL	Stock	81.93	82.37	80.44	80.52	4716400.0
2022-04-26	A	Stock	121.0	121.28	117.24	117.94	2931900.0
2022-04-26	AA	Stock	67.15	69.03	64.67	66.97	7984900.0
2022-04-26	AAC-DELISTED	Stock	9.86	9.86	9.84	9.84	109232.0
2022-04-26	AACG	Stock	1.18	1.18	1.16	1.16	6900.0
2022-04-26	AACIU	Stock	9.98	9.98	9.9787	9.9787	600.0
2022-04-26	AACIW-DELISTED	Stock	0.2901	0.2902	0.2901	0.2901	4500.0
2022-04-26	AAIC-DELISTED	Stock	3.33	3.33	3.21	3.22	79087.0
2022-04-26	AAIC.C-DELISTED	Stock	24.65	24.65	24.58	24.58	7299.0
2022-04-26	AAL	Stock	19.84	19.98	18.76	18.77	33555800.0
2022-04-26	AAM.A-DELISTED	Stock	24.95	25.0391	24.86	24.86	9506.0
2022-04-26	AAM.B-DELISTED	Stock	25.1701	25.2506	25.08	25.09	9154.0
2022-04-26	AAMC-DELISTED	Stock	3.0824	3.1471	3.0	3.0	24337.0
2022-04-26	AAME	Stock	3.15	3.15	3.02	3.15	1900.0
2022-04-26	AAMI	Stock	21.35	21.37	20.76	20.76	606300.0
2022-04-26	AAN-DELISTED	Stock	20.64	21.63	19.11	19.73	322700.0
2022-04-26	AAOI	Stock	2.8	2.81	2.62	2.68	304000.0
2022-04-26	AAON	Stock	36.3333	36.4133	33.8333	33.9467	392100.0
2022-04-26	AAP	Stock	222.37	226.43	221.19	223.44	840600.0
2022-04-26	AAQC-DELISTED	Stock	9.77	9.7807	9.77	9.7807	126550.0
2022-04-26	AAT	Stock	36.16	36.75	35.85	35.85	303700.0
2022-04-26	AATC	Stock	6.98	6.9899	6.62	6.75	18461.0
2022-04-26	AAU-DELISTED	Stock	0.3141	0.32	0.2821	0.29	508097.0
2022-04-26	AAUAF-DELISTED	Stock	0.3141	0.32	0.2821	0.29	518710.0
2022-04-26	AAWW-DELISTED	Stock	69.17	69.51	67.74	67.775	299745.0
2022-04-26	AAXJ	Stock	69.53	69.65	68.5	68.5	2357533.0
2022-04-26	AB	Stock	40.48	40.67	39.03	39.18	721100.0
2022-04-26	ABB-DELISTED	Stock	31.04	31.06	29.81	29.81	3056892.0
2022-04-26	ABBNY-DELISTED	Stock	31.04	31.06	29.81	29.81	3332523.0
2022-04-26	ABBV	Stock	156.44	159.69	155.82	156.18	6787800.0
2022-04-26	ABC-DELISTED	Stock	157.92	161.685	157.09	157.17	1002466.0
2022-04-26	ABCB	Stock	40.61	40.9	39.67	39.72	601500.0
2022-04-26	ABCL	Stock	7.99	7.99	7.51	7.56	1166300.0
2022-04-26	ABCM-DELISTED	Stock	16.66	16.71	16.11	16.11	53719.0
2022-04-26	ABEO	Stock	6.0	6.25	5.5	5.5	34664.0
2022-04-26	ABEV	Stock	3.01	3.01	2.92	2.92	18109900.0
2022-04-26	ABG	Stock	163.67	164.07	159.55	159.71	222100.0
2022-04-26	ABM	Stock	49.38	49.43	47.5	47.91	707200.0
2022-04-26	ABMD-DELISTED	Stock	298.2	298.67	285.45	285.46	113330.0
2022-04-26	ABNB	Stock	158.4	159.2	152.8	153.04	4075000.0
2022-04-26	ABOS	Stock	4.22	4.265	3.98	4.0	192000.0

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

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