PREVIEW / stock_daily / 2023-01-12

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-12.parquet
  size:    248 KB
  rows:    7,691
  symbols: 1,914

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-01-12	AAPL	Stock	133.88	134.26	131.44	133.41	71379600.0
2023-01-12	MSFT	Stock	235.26	239.9	233.56	238.51	27269500.0
2023-01-12	NVDA	Stock	16.1	16.637	15.492	16.511	551409000.0
2023-01-12	AMZN	Stock	96.93	97.19	93.5	95.27	85254800.0
2023-01-12	GOOGL	Stock	91.48	91.87	89.75	91.13	30258135.0
2023-01-12	META	Stock	133.44	137.68	131.76	136.71	30757700.0
2023-01-12	TSLA	Stock	122.56	124.13	117.0	123.56	169400900.0
2023-01-12	TLT	Stock	105.82	107.81	104.56	107.76	32029608.0
2023-01-12	ES	Stock	86.07	86.23	84.87	85.13	1327000.0
2023-01-12	CL	Stock	77.36	77.6	76.35	76.84	6059000.0
2023-01-12	A	Stock	158.16	158.6	155.58	156.49	809100.0
2023-01-12	AA	Stock	52.84	53.36	50.6	53.32	5733300.0
2023-01-12	AAC-DELISTED	Stock	10.13	10.14	10.125	10.13	864795.0
2023-01-12	AACG	Stock	1.38	1.42	1.35	1.35	4600.0
2023-01-12	AACIW-DELISTED	Stock	0.1001	0.11	0.0657	0.0715	17950.0
2023-01-12	AAIC-DELISTED	Stock	3.0	3.02	2.98	3.01	126213.0
2023-01-12	AAIC.C-DELISTED	Stock	21.38	21.4	21.29	21.4	1135.0
2023-01-12	AAL	Stock	16.03	16.9	15.88	16.83	96441800.0
2023-01-12	AAM.A-DELISTED	Stock	23.9654	24.2599	23.95	24.25	12285.0
2023-01-12	AAM.B-DELISTED	Stock	24.17	24.68	24.17	24.59	10071.0
2023-01-12	AAMC-DELISTED	Stock	7.3235	7.65	7.2059	7.5456	23385.0
2023-01-12	AAME	Stock	2.61	2.61	2.41	2.49	4600.0
2023-01-12	AAMI	Stock	21.34	21.771	20.955	21.15	226300.0
2023-01-12	AAN-DELISTED	Stock	14.31	14.59	14.2	14.31	318100.0
2023-01-12	AAOI	Stock	2.17	2.39	2.14	2.35	264300.0
2023-01-12	AAON	Stock	50.82	51.3067	46.8733	51.16	273300.0
2023-01-12	AAP	Stock	152.92	153.34	148.9	152.19	997500.0
2023-01-12	AAT	Stock	27.32	27.73	27.13	27.72	306800.0
2023-01-12	AATC	Stock	3.75	3.85	3.75	3.79	20873.0
2023-01-12	AAU-DELISTED	Stock	0.2599	0.2599	0.243	0.25	321392.0
2023-01-12	AAUAF-DELISTED	Stock	0.2599	0.2599	0.243	0.25	325130.0
2023-01-12	AAWW-DELISTED	Stock	101.55	102.03	101.55	101.78	578960.0
2023-01-12	AAXJ	Stock	70.06	70.29	69.34	70.23	1037299.0
2023-01-12	AB	Stock	39.0	39.48	38.18	39.0	231400.0
2023-01-12	ABB-DELISTED	Stock	33.49	33.66	33.23	33.52	1359971.0
2023-01-12	ABBNY-DELISTED	Stock	33.49	33.66	33.23	33.52	1508232.0
2023-01-12	ABBV	Stock	155.0	155.26	151.72	152.22	7665100.0
2023-01-12	ABC-DELISTED	Stock	165.26	165.965	164.12	164.9	737327.0
2023-01-12	ABCB	Stock	48.46	49.23	48.25	48.97	247000.0
2023-01-12	ABCL	Stock	9.7	10.215	9.405	10.2	1909300.0
2023-01-12	ABCM-DELISTED	Stock	16.5	16.59	15.1	15.65	615787.0
2023-01-12	ABEO	Stock	2.73	2.75	2.65	2.65	205300.0
2023-01-12	ABEV	Stock	2.71	2.77	2.66	2.74	34392200.0
2023-01-12	ABG	Stock	193.58	194.41	188.37	193.54	155700.0
2023-01-12	ABM	Stock	45.83	46.36	45.54	45.97	327500.0
2023-01-12	ABNB	Stock	95.31	98.95	94.02	98.49	7695200.0
2023-01-12	ABOS	Stock	5.66	6.0	5.5	6.0	24800.0
2023-01-12	ABR	Stock	14.22	14.24	14.05	14.13	1350200.0
2023-01-12	ABR.D	Stock	19.9	20.235	19.6561	19.88	38326.0
2023-01-12	ABR.E	Stock	18.57	18.77	18.4937	18.74	15545.0

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

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