PREVIEW / stock_daily / 2022-07-05

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-05.parquet
  size:    254 KB
  rows:    7,971
  symbols: 2,363

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-07-05	AAPL	Stock	137.77	141.61	136.93	141.56	73353800.0
2022-07-05	MSFT	Stock	256.16	262.98	254.74	262.85	22941000.0
2022-07-05	NVDA	Stock	14.175	14.971	14.055	14.964	651397000.0
2022-07-05	AMZN	Stock	107.6	114.08	106.32	113.5	76583700.0
2022-07-05	GOOGL	Stock	107.1005	113.3768	105.7315	113.263	39399640.0
2022-07-05	META	Stock	158.14	168.25	157.02	168.19	28618600.0
2022-07-05	TSLA	Stock	223.0	233.1467	216.1667	233.0667	84581100.0
2022-07-05	TLT	Stock	116.89	117.75	116.17	116.73	16689670.0
2022-07-05	ES	Stock	86.89	86.97	81.89	83.37	1820600.0
2022-07-05	CL	Stock	81.33	81.85	80.09	81.0	3068500.0
2022-07-05	A	Stock	117.75	120.68	116.49	120.56	1484900.0
2022-07-05	AA	Stock	42.83	43.26	41.37	42.09	7442800.0
2022-07-05	AAC-DELISTED	Stock	9.85	9.85	9.82	9.84	289467.0
2022-07-05	AACG	Stock	1.07	1.07	1.06	1.06	8300.0
2022-07-05	AACIU	Stock	9.97	9.97	9.97	9.97	301.0
2022-07-05	AACIW-DELISTED	Stock	0.1901	0.2	0.1901	0.2	10107.0
2022-07-05	AAIC-DELISTED	Stock	3.1	3.19	3.1	3.16	33475.0
2022-07-05	AAL	Stock	12.81	13.88	12.55	13.88	43922100.0
2022-07-05	AAM.A-DELISTED	Stock	24.36	24.39	23.85	24.205	22464.0
2022-07-05	AAM.B-DELISTED	Stock	25.04	25.43	24.87	25.08	10314.0
2022-07-05	AAMC-DELISTED	Stock	2.9118	2.9559	2.9118	2.9382	62138.0
2022-07-05	AAME	Stock	2.64	2.66	2.5	2.57	3000.0
2022-07-05	AAMI	Stock	17.81	18.1	17.62	18.05	365700.0
2022-07-05	AAN-DELISTED	Stock	14.58	15.37	14.26	15.37	413100.0
2022-07-05	AAOI	Stock	1.55	1.56	1.49	1.53	308400.0
2022-07-05	AAON	Stock	36.6533	37.9	36.16	37.8533	359400.0
2022-07-05	AAP	Stock	172.35	182.43	172.09	182.31	1107200.0
2022-07-05	AAQC-DELISTED	Stock	9.76	9.76	9.76	9.76	119.0
2022-07-05	AAT	Stock	30.0	30.51	29.38	30.46	342300.0
2022-07-05	AATC	Stock	5.32	5.434	5.29	5.3	3036.0
2022-07-05	AAU-DELISTED	Stock	0.2173	0.2235	0.215	0.2176	220624.0
2022-07-05	AAUAF-DELISTED	Stock	0.2173	0.2235	0.215	0.2176	225657.0
2022-07-05	AAWW-DELISTED	Stock	60.18	61.7	59.64	61.61	165425.0
2022-07-05	AAXJ	Stock	67.32	68.37	67.0893	68.37	1738612.0
2022-07-05	AB	Stock	41.65	42.1	40.37	41.82	330900.0
2022-07-05	ABB-DELISTED	Stock	25.97	26.4	25.85	26.4	2004382.0
2022-07-05	ABBNY-DELISTED	Stock	25.97	26.4	25.85	26.39	2165901.0
2022-07-05	ABBV	Stock	151.9	154.05	149.66	153.93	5478800.0
2022-07-05	ABC-DELISTED	Stock	142.25	142.58	138.24	140.73	711283.0
2022-07-05	ABCB	Stock	40.08	41.26	39.55	41.23	510600.0
2022-07-05	ABCL	Stock	10.33	10.55	10.06	10.38	2619800.0
2022-07-05	ABCM-DELISTED	Stock	14.36	15.23	14.33	15.21	116999.0
2022-07-05	ABEO	Stock	3.76	4.55	3.7	4.08	474800.0
2022-07-05	ABEV	Stock	2.52	2.58	2.5	2.56	38927600.0
2022-07-05	ABG	Stock	169.0	178.34	167.9	177.79	156800.0
2022-07-05	ABGI-DELISTED	Stock	9.8	9.8	9.8	9.8	24749.0
2022-07-05	ABM	Stock	42.32	42.74	41.52	42.73	393400.0
2022-07-05	ABMD-DELISTED	Stock	251.09	256.74	247.3035	256.74	94580.0
2022-07-05	ABNB	Stock	88.88	96.01	86.75	95.94	7648500.0
2022-07-05	ABOS	Stock	4.65	4.933	4.55	4.75	128200.0

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

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