PREVIEW / stock_daily / 2023-07-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-14.parquet
  size:    242 KB
  rows:    7,510
  symbols: 1,576

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-07-14	AAPL	Stock	190.23	191.18	189.63	190.69	41573900.0
2023-07-14	MSFT	Stock	347.59	351.43	344.31	345.24	28302200.0
2023-07-14	NVDA	Stock	46.583	48.088	45.06	45.469	772075000.0
2023-07-14	AMZN	Stock	134.06	136.65	134.06	134.68	54388100.0
2023-07-14	GOOGL	Stock	124.8	126.775	123.49	125.42	33283076.0
2023-07-14	META	Stock	311.79	314.88	307.36	308.87	22576000.0
2023-07-14	TSLA	Stock	277.01	285.3	276.31	281.38	119771100.0
2023-07-14	TLT	Stock	101.72	101.935	101.235	101.29	18568974.0
2023-07-14	ES	Stock	72.9	73.32	72.32	72.82	1545300.0
2023-07-14	CL	Stock	75.82	76.63	75.54	76.44	2978000.0
2023-07-14	A	Stock	119.54	120.39	118.25	119.75	1225400.0
2023-07-14	AA	Stock	35.5	35.52	34.05	34.52	8079500.0
2023-07-14	AAC-DELISTED	Stock	10.58	10.58	10.57	10.58	86698.0
2023-07-14	AACG	Stock	1.47	1.55	1.47	1.48	4100.0
2023-07-14	AACIW-DELISTED	Stock	0.064	0.067	0.064	0.067	1724.0
2023-07-14	AACT	Stock	10.17	10.17	10.166	10.166	1500.0
2023-07-14	AAIC-DELISTED	Stock	4.67	4.69	4.62	4.66	365877.0
2023-07-14	AAIC.C-DELISTED	Stock	23.26	23.3	23.06	23.06	3388.0
2023-07-14	AAL	Stock	18.44	18.56	17.96	18.14	23241100.0
2023-07-14	AAM.A-DELISTED	Stock	23.0	23.19	22.7427	22.884	14454.0
2023-07-14	AAM.B-DELISTED	Stock	22.98	23.07	22.71	23.07	15712.0
2023-07-14	AAMC-DELISTED	Stock	33.1118	35.1176	32.7118	33.1529	30770.0
2023-07-14	AAME	Stock	1.86	1.86	1.81	1.82	22600.0
2023-07-14	AAMI	Stock	21.92	21.97	21.25	21.46	256500.0
2023-07-14	AAN-DELISTED	Stock	14.85	15.075	14.55	14.79	181000.0
2023-07-14	AAOI	Stock	10.9	11.343	8.81	9.14	5508100.0
2023-07-14	AAON	Stock	65.0667	66.54	64.4533	66.3	346800.0
2023-07-14	AAP	Stock	70.59	71.03	69.05	70.64	2386200.0
2023-07-14	AAT	Stock	20.76	20.83	20.48	20.79	222400.0
2023-07-14	AATC	Stock	4.39	4.44	4.39	4.44	15039.0
2023-07-14	AAU-DELISTED	Stock	0.147	0.15	0.1411	0.1473	145741.0
2023-07-14	AAUAF-DELISTED	Stock	0.147	0.15	0.1411	0.1473	138039.0
2023-07-14	AAXJ	Stock	69.17	69.17	68.815	68.88	476371.0
2023-07-14	AB	Stock	34.7	34.7	33.27	33.62	384000.0
2023-07-14	ABBNY-DELISTED	Stock	39.54	39.61	39.42	39.43	142129.0
2023-07-14	ABBV	Stock	134.73	136.62	134.12	136.01	5543400.0
2023-07-14	ABC-DELISTED	Stock	191.95	192.51	191.02	191.44	534930.0
2023-07-14	ABCB	Stock	37.57	37.57	36.26	36.5	410500.0
2023-07-14	ABCL	Stock	7.4	8.0	7.04	7.16	2527100.0
2023-07-14	ABCM-DELISTED	Stock	23.86	24.03	23.78	23.89	1094631.0
2023-07-14	ABEO	Stock	4.0	4.06	3.85	3.88	154500.0
2023-07-14	ABEV	Stock	3.03	3.06	3.01	3.04	10734900.0
2023-07-14	ABG	Stock	247.65	247.8	240.93	243.26	192600.0
2023-07-14	ABLLW	Stock	0.3169	0.4125	0.3169	0.3874	54699.0
2023-07-14	ABLV	Stock	10.59	10.6001	10.59	10.6	42530.0
2023-07-14	ABM	Stock	42.39	42.61	41.91	42.46	407000.0
2023-07-14	ABNB	Stock	140.25	143.57	139.69	143.34	6496600.0
2023-07-14	ABOS	Stock	6.11	6.79	5.81	6.28	715500.0
2023-07-14	ABR	Stock	15.82	15.85	15.61	15.76	2551400.0
2023-07-14	ABR.D	Stock	18.73	18.75	18.36	18.58	25456.0

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

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