PREVIEW / stock_daily / 2023-08-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-14.parquet
  size:    239 KB
  rows:    7,456
  symbols: 1,513

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-08-14	AAPL	Stock	177.97	179.69	177.31	179.46	43675600.0
2023-08-14	MSFT	Stock	321.39	324.06	320.08	324.04	18836100.0
2023-08-14	NVDA	Stock	40.486	43.8	40.311	43.753	690286000.0
2023-08-14	AMZN	Stock	138.3	140.59	137.75	140.57	47148700.0
2023-08-14	GOOGL	Stock	129.39	131.37	128.96	131.33	24695608.0
2023-08-14	META	Stock	300.98	306.21	298.25	306.19	15641900.0
2023-08-14	TSLA	Stock	235.7	240.66	233.75	239.76	98595300.0
2023-08-14	TLT	Stock	95.21	95.93	94.9	95.16	19071967.0
2023-08-14	ES	Stock	67.0	67.0	65.94	66.34	1702400.0
2023-08-14	CL	Stock	77.1	77.16	75.58	75.72	4249000.0
2023-08-14	A	Stock	125.43	128.0	125.19	126.65	1582400.0
2023-08-14	AA	Stock	31.56	31.86	30.6	31.73	7337100.0
2023-08-14	AAC-DELISTED	Stock	10.65	10.65	10.63	10.64	29266.0
2023-08-14	AACG	Stock	1.3	1.31	1.22	1.29	6300.0
2023-08-14	AACIW-DELISTED	Stock	0.08005	0.08005	0.08005	0.08005	220.0
2023-08-14	AACT	Stock	10.2	10.2	10.2	10.2	400.0
2023-08-14	AAIC-DELISTED	Stock	4.48	4.53	4.48	4.49	32487.0
2023-08-14	AAIC.C-DELISTED	Stock	23.9	24.9	23.8	23.95	9799.0
2023-08-14	AAL	Stock	15.57	15.88	15.46	15.88	23646600.0
2023-08-14	AAM.A-DELISTED	Stock	24.4	24.9067	24.325	24.9	69882.0
2023-08-14	AAM.B-DELISTED	Stock	24.32	25.025	24.02	24.89	78833.0
2023-08-14	AAMC-DELISTED	Stock	21.2765	21.9824	17.3882	19.3176	728790.0
2023-08-14	AAME	Stock	1.79	1.99	1.79	1.97	9400.0
2023-08-14	AAMI	Stock	19.85	19.97	19.52	19.94	108500.0
2023-08-14	AAN-DELISTED	Stock	12.88	12.88	12.47	12.55	205900.0
2023-08-14	AAOI	Stock	12.25	15.0	12.1	14.84	4503500.0
2023-08-14	AAON	Stock	63.0667	64.2067	62.1933	64.16	304200.0
2023-08-14	AAP	Stock	71.6	72.0	69.8	71.11	3057200.0
2023-08-14	AAT	Stock	22.14	22.18	21.83	21.93	225500.0
2023-08-14	AATC	Stock	5.27	5.45	5.19	5.36	12907.0
2023-08-14	AAU-DELISTED	Stock	0.13	0.1354	0.125	0.128	267684.0
2023-08-14	AAUAF-DELISTED	Stock	0.13	0.1354	0.125	0.128	265500.0
2023-08-14	AAXJ	Stock	65.67	66.1	65.43	66.02	576463.0
2023-08-14	AB	Stock	30.0	30.15	29.48	29.95	360200.0
2023-08-14	ABBNY-DELISTED	Stock	38.23	38.69	38.19	38.61	136867.0
2023-08-14	ABBV	Stock	153.02	153.14	151.57	152.27	2570900.0
2023-08-14	ABC-DELISTED	Stock	188.08	188.81	186.99	187.64	1451725.0
2023-08-14	ABCB	Stock	43.58	43.58	42.71	43.15	249000.0
2023-08-14	ABCL	Stock	5.75	5.75	5.56	5.59	2142400.0
2023-08-14	ABCM-DELISTED	Stock	23.2	23.2	22.56	22.97	961955.0
2023-08-14	ABEO	Stock	2.99	3.12	2.88	3.12	70200.0
2023-08-14	ABEV	Stock	2.87	2.89	2.83	2.86	8667800.0
2023-08-14	ABG	Stock	224.06	229.52	222.44	229.3	140900.0
2023-08-14	ABLLW	Stock	0.2475	0.3027	0.2475	0.252	52725.0
2023-08-14	ABLV	Stock	7.82	8.68	7.8	8.66	14661.0
2023-08-14	ABM	Stock	46.0	46.02	45.47	45.82	317400.0
2023-08-14	ABNB	Stock	133.56	133.79	131.74	133.24	3373800.0
2023-08-14	ABOS	Stock	7.12	7.26	6.84	7.22	742200.0
2023-08-14	ABR	Stock	16.12	16.22	15.77	16.08	2702600.0
2023-08-14	ABR.D	Stock	18.56	18.75	18.53	18.74	10372.0

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

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