PREVIEW / stock_daily / 2022-09-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-02.parquet
  size:    253 KB
  rows:    7,867
  symbols: 2,199

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-02	AAPL	Stock	159.75	160.36	154.97	155.81	76957800.0
2022-09-02	MSFT	Stock	261.7	264.74	254.47	256.06	22855400.0
2022-09-02	NVDA	Stock	14.1	14.171	13.591	13.647	743157000.0
2022-09-02	AMZN	Stock	129.5	131.38	126.39	127.51	57429800.0
2022-09-02	GOOGL	Stock	110.59	110.74	107.26	107.85	24160711.0
2022-09-02	META	Stock	167.45	167.93	159.22	160.32	22634200.0
2022-09-02	TSLA	Stock	281.07	282.35	269.08	270.21	50890100.0
2022-09-02	TLT	Stock	109.68	110.56	109.47	110.22	13024448.0
2022-09-02	ES	Stock	91.05	91.94	89.31	89.55	1156800.0
2022-09-02	CL	Stock	80.14	80.42	77.91	78.17	3111700.0
2022-09-02	A	Stock	129.79	130.27	127.12	128.01	1695900.0
2022-09-02	AA	Stock	49.28	50.35	48.93	49.25	3963100.0
2022-09-02	AAC-DELISTED	Stock	9.89	9.9	9.89	9.89	12978.0
2022-09-02	AACG	Stock	2.48	2.48	2.12	2.19	67300.0
2022-09-02	AAIC-DELISTED	Stock	3.2	3.22	3.18	3.2	19255.0
2022-09-02	AAL	Stock	13.15	13.35	12.87	12.99	26922500.0
2022-09-02	AAM.A-DELISTED	Stock	24.1264	24.29	23.93	23.93	4679.0
2022-09-02	AAM.B-DELISTED	Stock	24.08	24.22	23.78	23.915	15556.0
2022-09-02	AAMC-DELISTED	Stock	5.7697	5.9794	5.7432	5.8529	12417.0
2022-09-02	AAME	Stock	2.88	2.99	2.88	2.97	2600.0
2022-09-02	AAMI	Stock	17.6	17.6	16.99	17.3	307300.0
2022-09-02	AAN-DELISTED	Stock	12.26	12.26	11.75	11.87	388500.0
2022-09-02	AAOI	Stock	2.19	2.318	2.11	2.27	241500.0
2022-09-02	AAON	Stock	39.0467	39.2067	37.8067	38.0067	138750.0
2022-09-02	AAP	Stock	174.03	175.08	170.73	171.73	579200.0
2022-09-02	AAQC-DELISTED	Stock	9.82	9.82	9.81	9.81	2900.0
2022-09-02	AAT	Stock	27.95	27.95	27.29	27.41	226700.0
2022-09-02	AATC	Stock	5.13	5.2299	4.9799	5.0349	24106.0
2022-09-02	AAU-DELISTED	Stock	0.2264	0.23	0.2238	0.2295	114489.0
2022-09-02	AAUAF-DELISTED	Stock	0.2264	0.23	0.2238	0.2295	117288.0
2022-09-02	AAWW-DELISTED	Stock	99.88	100.1	99.72	99.95	504183.0
2022-09-02	AAXJ	Stock	66.05	66.35	65.485	65.59	796670.0
2022-09-02	AB	Stock	43.0	43.96	42.6	42.99	273400.0
2022-09-02	ABB-DELISTED	Stock	27.59	27.995	27.225	27.33	1820299.0
2022-09-02	ABBNY-DELISTED	Stock	27.59	27.995	27.225	27.33	2146334.0
2022-09-02	ABBV	Stock	138.66	139.4	135.81	136.28	3601600.0
2022-09-02	ABC-DELISTED	Stock	148.05	150.38	147.11	147.75	423573.0
2022-09-02	ABCB	Stock	46.73	47.22	45.87	46.06	209900.0
2022-09-02	ABCL	Stock	11.18	11.2	10.69	10.84	1024900.0
2022-09-02	ABCM-DELISTED	Stock	14.28	14.35	14.04	14.19	192696.0
2022-09-02	ABEO	Stock	3.52	3.73	3.44	3.57	96200.0
2022-09-02	ABEV	Stock	2.93	3.0	2.92	2.93	21163500.0
2022-09-02	ABG	Stock	175.58	179.97	170.02	171.1	109100.0
2022-09-02	ABGI-DELISTED	Stock	9.98	9.98	9.885	9.9	3427.0
2022-09-02	ABM	Stock	45.76	46.18	44.63	44.97	231600.0
2022-09-02	ABMD-DELISTED	Stock	265.2	266.04	257.78	261.29	163433.0
2022-09-02	ABNB	Stock	114.32	116.46	112.33	113.64	4121700.0
2022-09-02	ABOS	Stock	6.22	6.389	5.6	5.77	24400.0
2022-09-02	ABR	Stock	14.75	14.84	14.47	14.54	1590300.0
2022-09-02	ABR.D	Stock	20.5224	20.7257	20.52	20.6145	5857.0

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

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