PREVIEW / stock_daily / 2023-12-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-06.parquet
  size:    235 KB
  rows:    7,320
  symbols: 1,256

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-06	AAPL	Stock	194.45	194.76	192.11	192.32	41089700.0
2023-12-06	MSFT	Stock	373.54	374.18	368.03	368.8	21182100.0
2023-12-06	NVDA	Stock	47.215	47.387	45.412	45.503	380590000.0
2023-12-06	AMZN	Stock	147.58	147.85	144.28	144.52	39679000.0
2023-12-06	GOOGL	Stock	131.44	131.84	129.875	130.02	23576176.0
2023-12-06	META	Stock	321.93	322.25	317.04	317.45	11294300.0
2023-12-06	TSLA	Stock	242.92	246.57	239.17	239.37	126436200.0
2023-12-06	TLT	Stock	95.08	96.05	94.87	95.87	61606082.0
2023-12-06	ES	Stock	60.66	60.94	60.1	60.6	2653100.0
2023-12-06	CL	Stock	77.65	77.85	77.13	77.47	3595400.0
2023-12-06	A	Stock	128.5	129.76	127.92	128.91	1816800.0
2023-12-06	AA	Stock	25.6	25.96	25.04	25.12	4055000.0
2023-12-06	AACG	Stock	0.81	0.96	0.81	0.95	19200.0
2023-12-06	AACT	Stock	10.38	10.38	10.37	10.37	15200.0
2023-12-06	AAIC-DELISTED	Stock	4.67	4.72	4.59	4.62	184018.0
2023-12-06	AAIC.C-DELISTED	Stock	24.35	24.45	24.35	24.45	3200.0
2023-12-06	AAL	Stock	13.36	13.74	13.34	13.48	51354300.0
2023-12-06	AAMC-DELISTED	Stock	3.33	3.4	3.25	3.37	56500.0
2023-12-06	AAME	Stock	1.88	1.91	1.88	1.89	1200.0
2023-12-06	AAMI	Stock	18.07	18.46	18.01	18.1	98900.0
2023-12-06	AAN-DELISTED	Stock	10.03	10.28	9.99	10.16	455500.0
2023-12-06	AAOI	Stock	16.52	18.66	16.41	17.22	5106000.0
2023-12-06	AAON	Stock	64.0	64.78	63.72	63.94	408500.0
2023-12-06	AAP	Stock	53.9	55.43	53.4	55.16	1685100.0
2023-12-06	AAT	Stock	21.29	21.5	21.01	21.18	487300.0
2023-12-06	AATC	Stock	7.08	7.36	6.96	7.25	25168.0
2023-12-06	AAU-DELISTED	Stock	0.145	0.1494	0.141	0.145	145496.0
2023-12-06	AAUAF-DELISTED	Stock	0.145	0.1494	0.141	0.145	147732.0
2023-12-06	AAXJ	Stock	64.66	64.805	64.29	64.33	487654.0
2023-12-06	AB	Stock	28.43	29.02	28.34	28.42	511100.0
2023-12-06	ABAT	Stock	4.1	4.25	3.95	3.98	589035.0
2023-12-06	ABBNY-DELISTED	Stock	40.65	40.83	40.37	40.37	153735.0
2023-12-06	ABBV	Stock	144.79	147.07	144.73	146.38	4978800.0
2023-12-06	ABCB	Stock	46.36	47.62	45.84	45.85	255100.0
2023-12-06	ABCL	Stock	4.51	4.94	4.49	4.85	1655900.0
2023-12-06	ABEO	Stock	4.52	4.61	4.46	4.55	108800.0
2023-12-06	ABEV	Stock	2.85	2.86	2.82	2.83	6098500.0
2023-12-06	ABG	Stock	219.87	223.75	214.48	214.62	92700.0
2023-12-06	ABLLW	Stock	0.37	0.37	0.33	0.35	57200.0
2023-12-06	ABLV	Stock	2.7	2.77	2.63	2.64	13200.0
2023-12-06	ABM	Stock	42.61	43.28	42.61	42.87	365400.0
2023-12-06	ABNB	Stock	135.59	138.48	135.14	135.31	4932000.0
2023-12-06	ABOS	Stock	2.68	2.96	2.66	2.84	662400.0
2023-12-06	ABR	Stock	13.8	14.05	13.07	13.15	4500500.0
2023-12-06	ABR.D	Stock	17.18	17.295	17.1	17.1	35142.0
2023-12-06	ABR.E	Stock	17.11	17.3136	17.11	17.21	15389.0
2023-12-06	ABR.F	Stock	19.3045	19.36	19.21	19.21	19724.0
2023-12-06	ABSI	Stock	2.18	2.455	2.051	2.24	1237000.0
2023-12-06	ABT	Stock	104.63	105.26	103.88	104.94	4296000.0
2023-12-06	ABTC	Stock	528.0	540.0	495.0	508.5	137.8

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

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