PREVIEW / stock_daily / 2022-09-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-14.parquet
  size:    252 KB
  rows:    7,841
  symbols: 2,195

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-14	AAPL	Stock	154.79	157.1	153.61	155.31	87965400.0
2022-09-14	MSFT	Stock	253.53	254.23	249.86	252.22	23913000.0
2022-09-14	NVDA	Stock	13.254	13.29	12.913	13.128	588507000.0
2022-09-14	AMZN	Stock	127.36	128.84	126.33	128.55	45316800.0
2022-09-14	GOOGL	Stock	104.57	105.275	103.66	105.0	26395134.0
2022-09-14	META	Stock	153.33	153.54	149.05	151.47	43064200.0
2022-09-14	TSLA	Stock	292.24	306.0	291.64	302.61	72628700.0
2022-09-14	TLT	Stock	107.34	108.21	107.115	108.04	13077844.0
2022-09-14	ES	Stock	89.76	91.3	89.61	90.69	1290200.0
2022-09-14	CL	Stock	75.8	77.37	75.47	76.06	8077500.0
2022-09-14	A	Stock	133.8	135.36	132.1	133.25	1577000.0
2022-09-14	AA	Stock	49.095	49.47	44.03	44.81	13376400.0
2022-09-14	AAC-DELISTED	Stock	9.92	9.93	9.92	9.92	28266.0
2022-09-14	AACG	Stock	2.01	2.01	1.92	1.98	50100.0
2022-09-14	AACIW-DELISTED	Stock	0.18	0.18	0.1037	0.1222	5726.0
2022-09-14	AAIC-DELISTED	Stock	3.1	3.19	3.1	3.16	71280.0
2022-09-14	AAIC.C-DELISTED	Stock	21.89	21.89	21.88	21.88	653.0
2022-09-14	AAL	Stock	13.62	14.04	13.27	14.03	30564000.0
2022-09-14	AAM.A-DELISTED	Stock	24.17	24.37	24.17	24.1938	6669.0
2022-09-14	AAM.B-DELISTED	Stock	24.08	24.34	23.84	24.34	4799.0
2022-09-14	AAMC-DELISTED	Stock	5.5559	5.7912	5.5559	5.5882	4570.0
2022-09-14	AAME	Stock	3.07	3.1	2.92	2.92	4500.0
2022-09-14	AAMI	Stock	17.28	17.425	16.825	17.06	248000.0
2022-09-14	AAN-DELISTED	Stock	12.07	12.07	11.61	11.9	427400.0
2022-09-14	AAOI	Stock	2.47	2.61	2.435	2.53	256300.0
2022-09-14	AAON	Stock	38.1667	38.1667	37.0	38.1333	280800.0
2022-09-14	AAP	Stock	173.51	174.05	168.08	170.04	988500.0
2022-09-14	AAQC-DELISTED	Stock	9.8	9.81	9.8	9.8	4600.0
2022-09-14	AAT	Stock	27.4	27.4	26.71	27.0	277900.0
2022-09-14	AATC	Stock	5.09	5.1584	5.09	5.1	3609.0
2022-09-14	AAU-DELISTED	Stock	0.2251	0.2276	0.22	0.223	173522.0
2022-09-14	AAUAF-DELISTED	Stock	0.2251	0.2276	0.22	0.223	177187.0
2022-09-14	AAWW-DELISTED	Stock	99.86	100.05	99.79	100.04	479106.0
2022-09-14	AAXJ	Stock	65.16	65.32	64.895	65.14	650556.0
2022-09-14	AB	Stock	42.4	43.24	41.73	42.42	349300.0
2022-09-14	ABB-DELISTED	Stock	27.77	28.1	27.63	27.97	1606017.0
2022-09-14	ABBNY-DELISTED	Stock	27.77	28.1	27.63	27.97	1738998.0
2022-09-14	ABBV	Stock	139.17	140.44	138.27	139.55	4673600.0
2022-09-14	ABC-DELISTED	Stock	140.96	141.87	139.025	140.13	663888.0
2022-09-14	ABCB	Stock	47.3	47.37	46.47	47.22	600500.0
2022-09-14	ABCL	Stock	10.76	10.885	10.55	10.84	1211800.0
2022-09-14	ABCM-DELISTED	Stock	15.88	16.3	15.82	16.16	216925.0
2022-09-14	ABEO	Stock	3.84	3.9	3.7	3.73	74800.0
2022-09-14	ABEV	Stock	2.94	2.96	2.9	2.92	14726200.0
2022-09-14	ABG	Stock	161.73	163.0	153.17	161.0	218500.0
2022-09-14	ABGI-DELISTED	Stock	9.88	9.88	9.88	9.88	1000.0
2022-09-14	ABLV	Stock	9.94	9.94	9.94	9.94	300092.0
2022-09-14	ABM	Stock	41.71	42.33	41.19	41.96	653600.0
2022-09-14	ABMD-DELISTED	Stock	266.39	266.88	262.65	264.23	213456.0
2022-09-14	ABNB	Stock	121.63	127.0	119.51	126.8	5690100.0

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

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