PREVIEW / stock_daily / 2022-10-03

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-03.parquet
  size:    254 KB
  rows:    7,972
  symbols: 2,279

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-10-03	AAPL	Stock	138.21	143.07	137.69	142.45	114311700.0
2022-10-03	MSFT	Stock	235.41	241.61	234.66	240.74	28880400.0
2022-10-03	NVDA	Stock	12.347	12.678	12.105	12.512	547478000.0
2022-10-03	AMZN	Stock	113.58	116.91	112.45	115.88	50941900.0
2022-10-03	GOOGL	Stock	96.76	99.2872	96.521	98.64	27982031.0
2022-10-03	META	Stock	137.14	139.62	136.1	138.61	27723100.0
2022-10-03	TSLA	Stock	254.5	255.16	241.01	242.4	98363500.0
2022-10-03	TLT	Stock	103.85	104.68	103.15	103.83	27192238.0
2022-10-03	ES	Stock	79.39	81.03	78.64	80.3	1598100.0
2022-10-03	CL	Stock	70.83	71.37	70.08	71.11	3840300.0
2022-10-03	A	Stock	122.73	127.3	121.68	126.38	1343200.0
2022-10-03	AA	Stock	34.35	37.94	34.0	37.39	9731400.0
2022-10-03	AAC-DELISTED	Stock	9.93	9.94	9.93	9.93	291993.0
2022-10-03	AACG	Stock	1.7	1.75	1.7	1.75	1600.0
2022-10-03	AACIU	Stock	9.97	10.05	9.95	10.035	48748.0
2022-10-03	AACIW-DELISTED	Stock	0.13	0.15	0.12	0.12	80981.0
2022-10-03	AAIC-DELISTED	Stock	2.75	2.93	2.75	2.8625	45325.0
2022-10-03	AAIC.C-DELISTED	Stock	17.95	18.5524	17.6454	18.27	4298.0
2022-10-03	AAL	Stock	12.02	12.23	11.65	11.92	41156700.0
2022-10-03	AAM.A-DELISTED	Stock	24.0	24.545	24.0	24.39	15459.0
2022-10-03	AAM.B-DELISTED	Stock	23.7	24.085	23.7	24.06	10289.0
2022-10-03	AAMC-DELISTED	Stock	4.65	4.9265	4.6294	4.7441	27197.0
2022-10-03	AAME	Stock	2.81	2.81	2.8	2.8	1100.0
2022-10-03	AAMI	Stock	15.07	15.27	14.73	15.15	334300.0
2022-10-03	AAN-DELISTED	Stock	10.05	10.24	9.75	9.89	515600.0
2022-10-03	AAOI	Stock	2.76	2.765	2.65	2.75	251000.0
2022-10-03	AAON	Stock	36.4333	37.3067	36.1667	36.8667	211500.0
2022-10-03	AAP	Stock	157.25	163.98	157.22	163.37	862400.0
2022-10-03	AAQC-DELISTED	Stock	9.81	9.84	9.81	9.82	457706.0
2022-10-03	AAT	Stock	26.08	26.08	25.5	25.67	313000.0
2022-10-03	AATC	Stock	4.55	4.6344	4.55	4.5693	3553.0
2022-10-03	AAU-DELISTED	Stock	0.2205	0.2325	0.2104	0.2289	317705.0
2022-10-03	AAUAF-DELISTED	Stock	0.2205	0.2325	0.2104	0.225	321488.0
2022-10-03	AAWW-DELISTED	Stock	95.67	97.67	95.65	97.18	437610.0
2022-10-03	AAXJ	Stock	58.72	59.26	58.41	59.09	833530.0
2022-10-03	AB	Stock	35.32	36.69	34.89	35.89	501000.0
2022-10-03	ABB-DELISTED	Stock	24.43	24.665	24.27	24.3	3314882.0
2022-10-03	ABBNY-DELISTED	Stock	24.41	24.665	24.27	24.3	3643312.0
2022-10-03	ABBV	Stock	135.88	138.8	135.31	138.32	7437500.0
2022-10-03	ABC-DELISTED	Stock	136.27	139.75	135.8053	139.18	652151.0
2022-10-03	ABCB	Stock	45.1	45.98	44.61	45.68	258400.0
2022-10-03	ABCL	Stock	10.08	10.32	9.68	10.25	2791800.0
2022-10-03	ABCM-DELISTED	Stock	15.32	15.76	15.21	15.68	251201.0
2022-10-03	ABEO	Stock	3.1	3.34	3.01	3.28	475700.0
2022-10-03	ABEV	Stock	2.93	3.11	2.91	3.11	31063500.0
2022-10-03	ABG	Stock	152.88	162.0	152.88	156.27	254100.0
2022-10-03	ABGI-DELISTED	Stock	9.93	9.93	9.9	9.91	6733.0
2022-10-03	ABM	Stock	38.73	39.63	38.49	39.32	333600.0
2022-10-03	ABMD-DELISTED	Stock	248.71	255.825	244.9927	255.16	319488.0
2022-10-03	ABNB	Stock	105.49	106.35	102.18	105.0	6208900.0

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

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