PREVIEW / stock_daily / 2022-08-24

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-24.parquet
  size:    253 KB
  rows:    7,885
  symbols: 2,253

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-08-24	AAPL	Stock	167.32	168.11	166.25	167.53	53841500.0
2022-08-24	MSFT	Stock	275.41	277.23	275.11	275.79	18137000.0
2022-08-24	NVDA	Stock	17.012	17.406	16.895	17.222	522661000.0
2022-08-24	AMZN	Stock	132.75	135.47	132.1	133.8	38627000.0
2022-08-24	GOOGL	Stock	113.5	114.78	112.8701	113.69	17734624.0
2022-08-24	META	Stock	160.6	165.46	159.77	163.26	20891500.0
2022-08-24	TSLA	Stock	297.5633	303.6467	296.5	297.0967	57259800.0
2022-08-24	TLT	Stock	111.485	111.87	110.86	111.22	13971626.0
2022-08-24	ES	Stock	91.94	92.21	91.35	92.03	772600.0
2022-08-24	CL	Stock	81.19	81.19	80.46	81.0	2390900.0
2022-08-24	A	Stock	133.02	134.54	132.65	133.67	1020500.0
2022-08-24	AA	Stock	52.11	54.46	51.77	54.43	4943600.0
2022-08-24	AAC-DELISTED	Stock	9.87	9.885	9.87	9.88	628181.0
2022-08-24	AACG	Stock	2.51	2.61	2.45	2.6	41400.0
2022-08-24	AACIU	Stock	9.87	9.91	9.87	9.91	600.0
2022-08-24	AAIC-DELISTED	Stock	3.3	3.38	3.2989	3.36	97312.0
2022-08-24	AAIC.C-DELISTED	Stock	20.82	20.82	20.82	20.82	100.0
2022-08-24	AAL	Stock	13.84	14.05	13.77	13.99	17825100.0
2022-08-24	AAM.A-DELISTED	Stock	24.9	25.06	24.79	25.04	8663.0
2022-08-24	AAM.B-DELISTED	Stock	24.72	25.19	24.72	25.15	17006.0
2022-08-24	AAMC-DELISTED	Stock	5.8824	6.0588	5.7941	5.8882	16432.0
2022-08-24	AAME	Stock	2.97	3.05	2.95	2.98	10400.0
2022-08-24	AAMI	Stock	18.66	18.79	18.57	18.65	141200.0
2022-08-24	AAN-DELISTED	Stock	13.79	13.96	13.51	13.58	148400.0
2022-08-24	AAOI	Stock	2.48	2.76	2.4	2.76	274600.0
2022-08-24	AAON	Stock	39.6333	39.8133	39.1533	39.6733	90750.0
2022-08-24	AAP	Stock	182.79	185.0	176.75	179.91	3623600.0
2022-08-24	AAQC-DELISTED	Stock	9.82	9.82	9.81	9.82	571945.0
2022-08-24	AAT	Stock	28.44	28.63	28.35	28.55	158100.0
2022-08-24	AATC	Stock	5.38	5.38	5.13	5.16	13964.0
2022-08-24	AAU-DELISTED	Stock	0.2322	0.2351	0.2264	0.232	96048.0
2022-08-24	AAUAF-DELISTED	Stock	0.2322	0.2351	0.2264	0.232	102532.0
2022-08-24	AAWW-DELISTED	Stock	99.87	100.01	99.825	99.86	336858.0
2022-08-24	AAXJ	Stock	66.34	67.33	66.32	66.98	1412170.0
2022-08-24	AB	Stock	43.91	44.3	43.66	44.13	152900.0
2022-08-24	ABB-DELISTED	Stock	28.49	28.695	28.4399	28.51	1022303.0
2022-08-24	ABBNY-DELISTED	Stock	28.49	28.695	28.4399	28.49	1119255.0
2022-08-24	ABBV	Stock	139.05	139.46	137.7	137.91	5018900.0
2022-08-24	ABC-DELISTED	Stock	148.38	148.74	147.13	148.23	272640.0
2022-08-24	ABCB	Stock	48.1	48.63	47.66	48.51	179100.0
2022-08-24	ABCL	Stock	11.53	11.97	11.38	11.85	1196200.0
2022-08-24	ABCM-DELISTED	Stock	14.76	15.12	14.68	15.05	50368.0
2022-08-24	ABEO	Stock	4.23	4.38	4.05	4.36	129900.0
2022-08-24	ABEV	Stock	3.02	3.08	3.0	3.04	30903500.0
2022-08-24	ABG	Stock	181.39	183.8	178.66	182.3	86800.0
2022-08-24	ABGI-DELISTED	Stock	9.87	9.87	9.87	9.87	65267.0
2022-08-24	ABM	Stock	47.15	47.49	46.9	47.32	151500.0
2022-08-24	ABMD-DELISTED	Stock	262.93	269.8	262.93	268.07	115661.0
2022-08-24	ABNB	Stock	110.93	115.57	110.84	114.51	3634000.0
2022-08-24	ABOS	Stock	5.13	5.57	5.12	5.47	31000.0

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

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