PREVIEW / stock_daily / 2022-10-24

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-24.parquet
  size:    249 KB
  rows:    7,800
  symbols: 2,123

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
2022-10-24	AAPL	Stock	147.19	150.23	146.0	149.45	75981900.0
2022-10-24	MSFT	Stock	243.76	247.84	241.3	247.25	24911200.0
2022-10-24	NVDA	Stock	12.508	12.71	12.064	12.599	517457000.0
2022-10-24	AMZN	Stock	119.98	120.39	116.57	119.82	49531500.0
2022-10-24	GOOGL	Stock	101.8	102.75	99.98	102.52	27176417.0
2022-10-24	META	Stock	127.25	133.48	124.57	129.72	63563400.0
2022-10-24	TSLA	Stock	205.82	213.5	198.59	211.25	100446800.0
2022-10-24	TLT	Stock	92.82	93.55	91.85	92.4	31332597.0
2022-10-24	ES	Stock	72.57	73.64	72.02	72.77	1845300.0
2022-10-24	CL	Stock	72.04	72.59	71.22	72.02	3500900.0
2022-10-24	A	Stock	131.13	133.13	129.81	132.3	1045300.0
2022-10-24	AA	Stock	40.05	40.15	38.6	39.17	7822400.0
2022-10-24	AAC-DELISTED	Stock	9.96	9.965	9.96	9.96	15401.0
2022-10-24	AACG	Stock	1.82	1.82	1.75	1.8	5400.0
2022-10-24	AAIC-DELISTED	Stock	2.7876	2.89	2.77	2.89	12387.0
2022-10-24	AAL	Stock	13.75	14.12	13.59	14.1	32811000.0
2022-10-24	AAM.A-DELISTED	Stock	21.41	21.91	21.0501	21.385	14701.0
2022-10-24	AAM.B-DELISTED	Stock	21.28	21.59	21.28	21.32	5795.0
2022-10-24	AAMC-DELISTED	Stock	4.1176	4.1176	4.0515	4.0515	4022.0
2022-10-24	AAME	Stock	2.72	2.85	2.72	2.85	9700.0
2022-10-24	AAMI	Stock	17.4	17.83	17.36	17.52	234600.0
2022-10-24	AAN-DELISTED	Stock	8.0	8.13	7.645	8.1	968900.0
2022-10-24	AAOI	Stock	2.74	2.8	2.63	2.71	283600.0
2022-10-24	AAON	Stock	37.8	39.3467	37.6667	39.1667	289800.0
2022-10-24	AAP	Stock	173.5	176.67	173.05	176.62	799900.0
2022-10-24	AAQC-DELISTED	Stock	9.8801	9.8801	9.87	9.875	9301.0
2022-10-24	AAT	Stock	26.49	26.88	26.25	26.73	279500.0
2022-10-24	AATC	Stock	4.39	4.4	4.35	4.35	2730.0
2022-10-24	AAU-DELISTED	Stock	0.229	0.235	0.211	0.2122	251237.0
2022-10-24	AAUAF-DELISTED	Stock	0.229	0.235	0.211	0.2122	275285.0
2022-10-24	AAWW-DELISTED	Stock	100.46	101.01	100.42	100.45	208870.0
2022-10-24	AAXJ	Stock	55.26	55.28	54.39	55.19	1055118.0
2022-10-24	AB	Stock	35.12	35.26	34.53	34.86	235100.0
2022-10-24	ABB-DELISTED	Stock	27.18	27.66	27.155	27.48	2071101.0
2022-10-24	ABBNY-DELISTED	Stock	27.18	27.66	27.155	27.48	2229378.0
2022-10-24	ABBV	Stock	148.71	151.53	148.7	150.89	5139700.0
2022-10-24	ABC-DELISTED	Stock	149.19	150.73	148.11	150.17	865361.0
2022-10-24	ABCB	Stock	49.25	49.81	48.84	49.74	191900.0
2022-10-24	ABCL	Stock	10.13	10.275	9.83	10.25	1231300.0
2022-10-24	ABCM-DELISTED	Stock	14.06	14.69	14.01	14.6	265171.0
2022-10-24	ABEO	Stock	3.55	3.86	3.35	3.82	348800.0
2022-10-24	ABEV	Stock	2.86	2.88	2.8	2.83	31494800.0
2022-10-24	ABG	Stock	143.59	148.93	143.2	148.24	219300.0
2022-10-24	ABGI-DELISTED	Stock	9.94	9.94	9.94	9.94	134995.0
2022-10-24	ABM	Stock	42.09	42.61	41.63	42.22	212800.0
2022-10-24	ABMD-DELISTED	Stock	260.7	261.04	256.36	260.33	120264.0
2022-10-24	ABNB	Stock	118.33	119.07	112.824	116.39	4452800.0
2022-10-24	ABOS	Stock	7.75	8.036	7.3	7.6	272000.0
2022-10-24	ABR	Stock	12.41	12.54	12.2	12.46	1445500.0
2022-10-24	ABR.D	Stock	16.2	16.2	16.0	16.14	39394.0

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

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