PREVIEW / stock_daily / 2022-10-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-28.parquet
  size:    251 KB
  rows:    7,825
  symbols: 2,103

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-28	AAPL	Stock	148.2	157.5	147.82	155.74	164762400.0
2022-10-28	MSFT	Stock	226.24	236.6	226.05	235.87	40647700.0
2022-10-28	NVDA	Stock	13.104	13.85	13.061	13.834	521040000.0
2022-10-28	AMZN	Stock	97.91	103.96	97.66	103.41	223133400.0
2022-10-28	GOOGL	Stock	92.27	96.55	92.13	96.29	43697286.0
2022-10-28	META	Stock	99.58	100.85	97.51	99.2	95928300.0
2022-10-28	TSLA	Stock	225.4	228.86	216.35	228.52	69152400.0
2022-10-28	TLT	Stock	96.86	97.625	96.41	96.8	22244089.0
2022-10-28	ES	Stock	74.75	77.0	74.75	76.77	2071400.0
2022-10-28	CL	Stock	71.64	74.68	71.29	74.64	5613100.0
2022-10-28	A	Stock	136.38	139.12	135.02	138.77	901900.0
2022-10-28	AA	Stock	40.78	40.785	38.46	39.49	6566400.0
2022-10-28	AAC-DELISTED	Stock	9.97	9.975	9.97	9.97	35900.0
2022-10-28	AACG	Stock	1.78	1.81	1.76	1.78	6300.0
2022-10-28	AACIW-DELISTED	Stock	0.04	0.045	0.04	0.04	20510.0
2022-10-28	AAIC-DELISTED	Stock	2.95	3.055	2.95	3.02	34449.0
2022-10-28	AAL	Stock	14.0	14.1	13.79	14.0	26410600.0
2022-10-28	AAM.A-DELISTED	Stock	21.9423	22.25	21.9	22.05	9174.0
2022-10-28	AAM.B-DELISTED	Stock	22.63	22.85	22.27	22.42	6025.0
2022-10-28	AAMC-DELISTED	Stock	4.2353	4.4118	3.9735	4.3706	4376.0
2022-10-28	AAME	Stock	3.06	3.06	2.95	2.99	2400.0
2022-10-28	AAMI	Stock	18.44	18.67	18.2	18.6	371800.0
2022-10-28	AAN-DELISTED	Stock	10.46	10.77	10.3	10.33	625800.0
2022-10-28	AAOI	Stock	2.83	2.85	2.755	2.8	168000.0
2022-10-28	AAON	Stock	42.02	43.8067	41.9867	43.4333	175500.0
2022-10-28	AAP	Stock	188.19	190.99	186.74	190.67	500500.0
2022-10-28	AAQC-DELISTED	Stock	9.913	9.94	9.913	9.94	42700.0
2022-10-28	AAT	Stock	27.17	27.44	26.95	27.44	706700.0
2022-10-28	AATC	Stock	4.35	4.39	4.23	4.385	23923.0
2022-10-28	AAU-DELISTED	Stock	0.2284	0.2388	0.2213	0.238	530595.0
2022-10-28	AAUAF-DELISTED	Stock	0.2284	0.2388	0.2213	0.238	534567.0
2022-10-28	AAWW-DELISTED	Stock	100.98	101.0	100.78	100.89	241999.0
2022-10-28	AAXJ	Stock	55.37	55.895	55.26	55.89	535058.0
2022-10-28	AB	Stock	35.51	37.41	35.42	37.25	362500.0
2022-10-28	ABB-DELISTED	Stock	27.63	28.03	27.6	28.01	1673933.0
2022-10-28	ABBNY-DELISTED	Stock	27.64	28.03	27.6	28.02	1847586.0
2022-10-28	ABBV	Stock	145.93	148.98	142.34	147.61	10812200.0
2022-10-28	ABC-DELISTED	Stock	156.31	159.4	156.07	159.31	532638.0
2022-10-28	ABCB	Stock	52.21	53.37	50.95	51.79	758700.0
2022-10-28	ABCL	Stock	10.8	11.765	10.68	11.71	3019300.0
2022-10-28	ABCM-DELISTED	Stock	15.53	15.975	15.46	15.95	190540.0
2022-10-28	ABEO	Stock	4.34	4.45	4.2	4.4	270900.0
2022-10-28	ABEV	Stock	2.87	2.94	2.86	2.93	30866900.0
2022-10-28	ABG	Stock	158.3	160.79	149.38	156.93	269600.0
2022-10-28	ABM	Stock	44.41	45.12	44.32	44.8	256200.0
2022-10-28	ABMD-DELISTED	Stock	260.0	267.3	255.92	257.96	313524.0
2022-10-28	ABNB	Stock	111.19	115.25	110.39	115.21	4757300.0
2022-10-28	ABOS	Stock	7.15	7.455	7.01	7.16	247400.0
2022-10-28	ABR	Stock	13.4	13.93	13.37	13.83	1648100.0
2022-10-28	ABR.D	Stock	16.9228	17.8967	16.9228	17.8	11904.0

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

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