PREVIEW / stock_daily / 2023-05-04

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-04.parquet
  size:    242 KB
  rows:    7,501
  symbols: 1,643

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
2023-05-04	AAPL	Stock	164.89	167.04	164.31	165.79	81235400.0
2023-05-04	MSFT	Stock	306.24	307.76	303.4	305.41	22519900.0
2023-05-04	NVDA	Stock	27.651	27.859	27.24	27.562	321850000.0
2023-05-04	AMZN	Stock	104.04	105.39	103.31	104.0	45345500.0
2023-05-04	GOOGL	Stock	105.485	105.6	103.97	104.69	23419506.0
2023-05-04	META	Stock	236.06	238.2	232.93	233.52	17889400.0
2023-05-04	TSLA	Stock	162.71	162.95	159.65	161.2	95108500.0
2023-05-04	TLT	Stock	105.22	106.45	105.15	105.24	25110469.0
2023-05-04	ES	Stock	76.55	77.13	75.62	76.72	2280500.0
2023-05-04	CL	Stock	81.53	81.76	80.46	80.79	7441500.0
2023-05-04	A	Stock	135.38	136.04	133.76	133.88	1103700.0
2023-05-04	AA	Stock	34.66	35.09	33.95	34.38	3615300.0
2023-05-04	AAC-DELISTED	Stock	10.37	10.39	10.37	10.39	38163.0
2023-05-04	AACG	Stock	1.89	1.94	1.85	1.89	7000.0
2023-05-04	AAIC-DELISTED	Stock	2.57	2.6	2.54	2.57	77078.0
2023-05-04	AAL	Stock	13.79	13.89	13.35	13.51	22983700.0
2023-05-04	AAM.A-DELISTED	Stock	23.74	23.87	23.0	23.57	24696.0
2023-05-04	AAM.B-DELISTED	Stock	24.09	24.23	22.64	23.19	16042.0
2023-05-04	AAMC-DELISTED	Stock	24.7029	25.5294	24.4118	25.1618	31008.0
2023-05-04	AAME	Stock	2.18	2.2	2.15	2.2	2600.0
2023-05-04	AAMI	Stock	22.09	22.509	21.015	22.11	199200.0
2023-05-04	AAN-DELISTED	Stock	12.03	12.24	11.84	11.89	305400.0
2023-05-04	AAOI	Stock	1.82	1.91	1.75	1.87	627200.0
2023-05-04	AAON	Stock	64.94	65.3133	63.8867	64.1867	446550.0
2023-05-04	AAP	Stock	123.34	123.68	120.22	120.24	1142800.0
2023-05-04	AAT	Stock	17.8	18.74	17.71	18.67	1040200.0
2023-05-04	AATC	Stock	3.89	3.9	3.77	3.9	6219.0
2023-05-04	AAU-DELISTED	Stock	0.135	0.1382	0.1232	0.1296	7658192.0
2023-05-04	AAUAF-DELISTED	Stock	0.135	0.1382	0.1232	0.1276	7702345.0
2023-05-04	AAXJ	Stock	66.25	66.57	66.1	66.3	3364217.0
2023-05-04	AB	Stock	33.63	33.98	32.58	33.19	317900.0
2023-05-04	ABB-DELISTED	Stock	35.7	35.895	35.57	35.72	1595426.0
2023-05-04	ABBNY-DELISTED	Stock	35.7	35.895	35.57	35.72	1738324.0
2023-05-04	ABBV	Stock	149.0	149.0	146.35	147.36	5694300.0
2023-05-04	ABC-DELISTED	Stock	166.83	167.8954	165.79	166.62	584753.0
2023-05-04	ABCB	Stock	29.65	30.21	28.33	29.65	597700.0
2023-05-04	ABCL	Stock	6.61	6.628	6.37	6.61	1398000.0
2023-05-04	ABCM-DELISTED	Stock	17.51	17.51	16.945	17.03	757174.0
2023-05-04	ABEO	Stock	3.07	3.29	3.04	3.26	97800.0
2023-05-04	ABEV	Stock	2.97	2.98	2.86	2.91	18169100.0
2023-05-04	ABG	Stock	189.98	191.23	186.72	189.41	228300.0
2023-05-04	ABM	Stock	41.65	42.24	41.27	41.91	198200.0
2023-05-04	ABNB	Stock	118.94	119.17	116.18	117.63	4939900.0
2023-05-04	ABOS	Stock	3.95	4.24	3.91	4.05	244300.0
2023-05-04	ABR	Stock	11.02	11.09	10.7	10.91	5085700.0
2023-05-04	ABR.D	Stock	17.32	17.38	17.1287	17.34	9474.0
2023-05-04	ABR.E	Stock	17.37	17.4763	17.34	17.34	6035.0
2023-05-04	ABR.F	Stock	17.87	17.87	17.49	17.49	23823.0
2023-05-04	ABSI	Stock	1.31	1.37	1.23	1.31	553700.0
2023-05-04	ABST-DELISTED	Stock	8.59	8.59	8.37	8.38	170388.0

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

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