PREVIEW / stock_daily / 2023-05-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-05.parquet
  size:    242 KB
  rows:    7,518
  symbols: 1,639

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-05	AAPL	Stock	170.98	174.3	170.76	173.57	113316400.0
2023-05-05	MSFT	Stock	305.72	311.97	304.27	310.65	28181200.0
2023-05-05	NVDA	Stock	27.826	28.755	27.731	28.68	361494000.0
2023-05-05	AMZN	Stock	104.27	105.76	103.55	105.66	56912900.0
2023-05-05	GOOGL	Stock	104.82	105.88	104.11	105.57	26639254.0
2023-05-05	META	Stock	232.24	234.68	229.85	232.78	26978900.0
2023-05-05	TSLA	Stock	163.97	170.79	163.51	170.06	107440900.0
2023-05-05	TLT	Stock	104.35	104.9	104.105	104.89	15096463.0
2023-05-05	ES	Stock	76.54	77.97	76.05	77.44	1336400.0
2023-05-05	CL	Stock	80.6	81.0	80.34	80.59	5359300.0
2023-05-05	A	Stock	135.3	135.41	131.91	133.3	1890100.0
2023-05-05	AA	Stock	35.24	36.35	34.87	36.15	3869400.0
2023-05-05	AAC-DELISTED	Stock	10.38	10.39	10.38	10.39	22816.0
2023-05-05	AACG	Stock	1.88	1.89	1.82	1.86	6100.0
2023-05-05	AACIW-DELISTED	Stock	0.1125	0.1125	0.1125	0.1125	100.0
2023-05-05	AAIC-DELISTED	Stock	2.56	2.6295	2.53	2.59	88720.0
2023-05-05	AAIC.C-DELISTED	Stock	21.0	21.0	20.55	20.55	444.0
2023-05-05	AAL	Stock	13.73	13.95	13.63	13.87	20608900.0
2023-05-05	AAM.A-DELISTED	Stock	24.4	24.55	24.0	24.39	11676.0
2023-05-05	AAM.B-DELISTED	Stock	24.735	24.735	23.8501	24.2499	8412.0
2023-05-05	AAMC-DELISTED	Stock	25.4118	26.5294	25.1118	25.1824	39396.0
2023-05-05	AAME	Stock	2.22	2.29	2.2	2.29	8800.0
2023-05-05	AAMI	Stock	22.61	22.685	21.84	22.59	108500.0
2023-05-05	AAN-DELISTED	Stock	12.16	12.44	12.14	12.34	268300.0
2023-05-05	AAOI	Stock	1.6	1.84	1.6	1.665	566000.0
2023-05-05	AAON	Stock	66.2667	69.5467	66.06	68.84	783750.0
2023-05-05	AAP	Stock	122.03	123.96	121.97	123.77	750200.0
2023-05-05	AAT	Stock	19.03	19.6	18.61	18.91	659100.0
2023-05-05	AATC	Stock	3.89	4.07	3.89	4.05	8043.0
2023-05-05	AAU-DELISTED	Stock	0.128	0.13	0.1215	0.1228	906741.0
2023-05-05	AAUAF-DELISTED	Stock	0.128	0.13	0.1215	0.13	909413.0
2023-05-05	AAXJ	Stock	66.57	67.1	66.41	67.07	340247.0
2023-05-05	AB	Stock	33.0	33.86	32.93	33.79	339400.0
2023-05-05	ABB-DELISTED	Stock	35.69	36.08	35.64	36.0	1112725.0
2023-05-05	ABBNY-DELISTED	Stock	35.69	36.08	35.64	35.99	1239795.0
2023-05-05	ABBV	Stock	148.54	149.38	147.14	148.03	4447700.0
2023-05-05	ABC-DELISTED	Stock	167.55	169.375	165.04	167.98	665441.0
2023-05-05	ABCB	Stock	31.09	31.26	30.0	30.53	606000.0
2023-05-05	ABCL	Stock	6.41	6.41	5.77	5.99	5067300.0
2023-05-05	ABCM-DELISTED	Stock	17.23	17.91	16.93	17.41	2601339.0
2023-05-05	ABEO	Stock	3.26	3.43	3.25	3.28	110200.0
2023-05-05	ABEV	Stock	2.88	2.93	2.85	2.89	14471600.0
2023-05-05	ABG	Stock	192.5	198.56	191.75	196.93	234200.0
2023-05-05	ABM	Stock	42.57	42.97	42.23	42.68	199300.0
2023-05-05	ABNB	Stock	120.01	120.3	116.93	119.9	6618800.0
2023-05-05	ABOS	Stock	4.07	5.34	4.07	5.29	1353400.0
2023-05-05	ABR	Stock	11.51	11.88	11.06	11.75	7361700.0
2023-05-05	ABR.D	Stock	17.57	17.7157	17.35	17.54	14842.0
2023-05-05	ABR.E	Stock	17.3201	17.55	17.32	17.42	2824.0
2023-05-05	ABR.F	Stock	17.7	18.01	17.36	17.66	36501.0

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

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