PREVIEW / stock_daily / 2023-11-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-20.parquet
  size:    234 KB
  rows:    7,323
  symbols: 1,275

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-11-20	AAPL	Stock	189.89	191.91	189.88	191.45	46505100.0
2023-11-20	MSFT	Stock	371.22	378.87	371.0	377.44	52465100.0
2023-11-20	NVDA	Stock	49.312	50.548	49.181	50.409	414120000.0
2023-11-20	AMZN	Stock	145.13	146.63	144.73	146.13	41951200.0
2023-11-20	GOOGL	Stock	133.69	136.66	133.62	136.25	27850762.0
2023-11-20	META	Stock	334.89	341.87	334.19	339.97	16960500.0
2023-11-20	TSLA	Stock	234.04	237.1	231.02	235.6	116320100.0
2023-11-20	TLT	Stock	89.62	90.655	89.61	90.59	40517570.0
2023-11-20	ES	Stock	58.06	58.59	57.12	58.3	2658800.0
2023-11-20	CL	Stock	75.28	75.75	75.17	75.47	3150200.0
2023-11-20	A	Stock	113.25	114.5	112.39	113.98	3050000.0
2023-11-20	AA	Stock	26.32	26.7	25.97	26.47	4231300.0
2023-11-20	AACG	Stock	0.93	0.93	0.87	0.91	2800.0
2023-11-20	AACIW-DELISTED	Stock	0.0594	0.0594	0.0594	0.0594	103.0
2023-11-20	AACT	Stock	10.4	10.4	10.35	10.35	25400.0
2023-11-20	AAIC-DELISTED	Stock	4.62	4.68	4.57	4.66	114747.0
2023-11-20	AAIC.C-DELISTED	Stock	24.05	24.0873	24.0	24.0	2900.0
2023-11-20	AAL	Stock	12.23	12.45	12.17	12.4	23878800.0
2023-11-20	AAMC-DELISTED	Stock	2.713	2.77	2.7	2.75	23100.0
2023-11-20	AAME	Stock	1.89	1.89	1.89	1.89	600.0
2023-11-20	AAMI	Stock	17.19	17.55	17.12	17.47	181900.0
2023-11-20	AAN-DELISTED	Stock	8.85	9.17	8.79	9.04	366600.0
2023-11-20	AAOI	Stock	12.91	14.63	12.85	14.46	4643700.0
2023-11-20	AAON	Stock	62.75	63.36	62.18	63.22	225400.0
2023-11-20	AAP	Stock	50.7	53.4	49.9	53.02	2203100.0
2023-11-20	AAT	Stock	19.37	19.37	18.97	19.08	339900.0
2023-11-20	AATC	Stock	6.45	6.52	6.38	6.485	5545.0
2023-11-20	AAU-DELISTED	Stock	0.142	0.1429	0.14	0.14	386727.0
2023-11-20	AAUAF-DELISTED	Stock	0.142	0.1429	0.14	0.14	391689.0
2023-11-20	AAXJ	Stock	65.74	66.39	65.74	66.295	780385.0
2023-11-20	AB	Stock	28.03	28.87	27.95	28.54	329900.0
2023-11-20	ABAT	Stock	4.1	4.42	4.051	4.11	230938.0
2023-11-20	ABBNY-DELISTED	Stock	38.115	38.12	37.9	38.07	233919.0
2023-11-20	ABBV	Stock	137.53	138.69	137.14	138.31	4490000.0
2023-11-20	ABCB	Stock	43.39	43.96	40.71	43.15	249400.0
2023-11-20	ABCL	Stock	4.46	4.69	4.345	4.6	1989100.0
2023-11-20	ABCM-DELISTED	Stock	23.93	23.94	23.92	23.93	7788676.0
2023-11-20	ABEO	Stock	4.15	4.25	4.06	4.22	75000.0
2023-11-20	ABEV	Stock	2.77	2.8	2.77	2.78	5345300.0
2023-11-20	ABG	Stock	208.2	212.32	207.02	212.19	73700.0
2023-11-20	ABLLW	Stock	0.309	0.3299	0.309	0.31	7239.0
2023-11-20	ABLV	Stock	2.4	3.11	2.4	2.83	162200.0
2023-11-20	ABLVW	Stock	0.03	0.035	0.025	0.03	75903.0
2023-11-20	ABM	Stock	41.14	41.55	40.94	41.53	272700.0
2023-11-20	ABNB	Stock	127.4	130.95	127.01	129.7	4634600.0
2023-11-20	ABOS	Stock	2.28	2.415	2.19	2.36	461900.0
2023-11-20	ABR	Stock	12.4	12.56	12.25	12.4	3616200.0
2023-11-20	ABR.D	Stock	16.15	16.4	16.07	16.21	66559.0
2023-11-20	ABR.E	Stock	16.27	16.35	16.18	16.35	11748.0
2023-11-20	ABR.F	Stock	17.32	17.58	17.15	17.15	40473.0

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

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