PREVIEW / stock_daily / 2023-12-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-20.parquet
  size:    236 KB
  rows:    7,334
  symbols: 1,227

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-12-20	AAPL	Stock	196.9	197.68	194.83	194.83	52242800.0
2023-12-20	MSFT	Stock	375.0	376.03	370.53	370.62	26316700.0
2023-12-20	NVDA	Stock	49.655	49.999	48.098	48.111	397894000.0
2023-12-20	AMZN	Stock	152.9	155.63	151.56	152.12	50322100.0
2023-12-20	GOOGL	Stock	138.97	141.695	138.065	138.34	49107179.0
2023-12-20	META	Stock	348.65	354.96	347.79	349.28	16369900.0
2023-12-20	TSLA	Stock	256.41	259.84	247.0	247.14	125097000.0
2023-12-20	TLT	Stock	99.11	99.69	98.58	99.56	51229377.0
2023-12-20	ES	Stock	61.7	62.01	60.47	60.53	2264800.0
2023-12-20	CL	Stock	77.74	78.33	77.34	77.35	5326800.0
2023-12-20	A	Stock	139.79	141.24	138.14	138.18	2120900.0
2023-12-20	AA	Stock	32.01	32.475	30.56	30.65	7516900.0
2023-12-20	AACG	Stock	0.85	0.85	0.83	0.83	20500.0
2023-12-20	AACT	Stock	10.5	10.537	10.42	10.42	11700.0
2023-12-20	AAGR-DELISTED	Stock	0.6962	1.15	0.65	0.9927	6273859.0
2023-12-20	AAGRW-DELISTED	Stock	0.041	0.041	0.036	0.036	3064.0
2023-12-20	AAL	Stock	14.2	14.39	13.95	13.98	26557500.0
2023-12-20	AAMC-DELISTED	Stock	4.68	4.68	4.31	4.32	14500.0
2023-12-20	AAME	Stock	2.03	2.03	1.94	2.0	3900.0
2023-12-20	AAMI	Stock	19.66	20.05	19.4	19.41	257500.0
2023-12-20	AAN-DELISTED	Stock	11.16	11.38	10.87	10.89	301800.0
2023-12-20	AAOI	Stock	22.7	22.767	20.6	20.62	2869400.0
2023-12-20	AAON	Stock	72.5	73.64	71.6	71.78	524700.0
2023-12-20	AAP	Stock	60.6	61.35	59.44	59.45	1646000.0
2023-12-20	AAT	Stock	22.61	23.34	22.59	22.63	385400.0
2023-12-20	AATC	Stock	7.05	7.2	6.95	6.95	2465.0
2023-12-20	AAU-DELISTED	Stock	0.145	0.1494	0.145	0.1459	95673.0
2023-12-20	AAUAF-DELISTED	Stock	0.145	0.1494	0.145	0.1459	98364.0
2023-12-20	AAXJ	Stock	64.73	64.855	63.92	63.95	695125.0
2023-12-20	AB	Stock	32.75	32.92	31.55	31.62	663800.0
2023-12-20	ABAT	Stock	6.41	6.45	5.2801	5.31	978674.0
2023-12-20	ABBNY-DELISTED	Stock	43.55	43.65	43.0	43.0	217492.0
2023-12-20	ABBV	Stock	153.99	154.21	151.54	151.69	4716400.0
2023-12-20	ABCB	Stock	52.51	53.64	51.49	51.49	775600.0
2023-12-20	ABCL	Stock	5.63	5.795	5.41	5.43	1506100.0
2023-12-20	ABEO	Stock	4.75	4.75	4.68	4.73	70500.0
2023-12-20	ABEV	Stock	2.96	2.97	2.9	2.9	8283500.0
2023-12-20	ABG	Stock	225.66	227.83	220.62	221.79	195400.0
2023-12-20	ABLLW	Stock	0.56	0.62	0.56	0.6	191201.0
2023-12-20	ABLVW	Stock	0.0399	0.0399	0.0399	0.0399	196.0
2023-12-20	ABM	Stock	46.32	47.0	45.38	45.4	1118500.0
2023-12-20	ABNB	Stock	146.5	146.5	140.65	141.07	5718000.0
2023-12-20	ABOS	Stock	3.15	3.339	3.07	3.08	504800.0
2023-12-20	ABR	Stock	15.9	16.16	15.48	15.49	5210000.0
2023-12-20	ABR.D	Stock	18.2	18.39	17.92	17.92	28533.0
2023-12-20	ABR.E	Stock	18.6222	18.6222	18.0101	18.11	10638.0
2023-12-20	ABR.F	Stock	18.71	18.88	18.45	18.47	54283.0
2023-12-20	ABSI	Stock	3.11	3.619	3.01	3.06	2023200.0
2023-12-20	ABT	Stock	107.85	108.82	107.3	107.4	5666200.0
2023-12-20	ABTC	Stock	450.0	465.0	414.0	441.0	189.13333333333333

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

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