PREVIEW / stock_daily / 2022-08-25

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-25.parquet
  size:    254 KB
  rows:    7,887
  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-25	AAPL	Stock	168.78	170.14	168.35	170.03	51218200.0
2022-08-25	MSFT	Stock	277.33	279.02	274.52	278.85	16583400.0
2022-08-25	NVDA	Stock	16.844	17.947	16.833	17.913	770691000.0
2022-08-25	AMZN	Stock	135.26	137.42	134.28	137.28	37496300.0
2022-08-25	GOOGL	Stock	114.235	116.72	114.11	116.65	16956794.0
2022-08-25	META	Stock	165.18	168.88	164.02	168.78	15550500.0
2022-08-25	TSLA	Stock	302.36	302.96	291.6	296.07	53230000.0
2022-08-25	TLT	Stock	111.32	113.09	110.99	112.77	21429692.0
2022-08-25	ES	Stock	92.21	92.91	91.76	92.84	739500.0
2022-08-25	CL	Stock	80.77	81.05	80.46	80.92	2660000.0
2022-08-25	A	Stock	135.3	136.08	133.99	136.01	969100.0
2022-08-25	AA	Stock	55.19	57.0	54.4	56.92	4968500.0
2022-08-25	AAC-DELISTED	Stock	9.89	9.9	9.88	9.9	219779.0
2022-08-25	AACG	Stock	2.52	2.64	2.51	2.52	72500.0
2022-08-25	AACIU	Stock	9.91	9.91	9.91	9.91	300.0
2022-08-25	AACIW-DELISTED	Stock	0.2399	0.2399	0.21	0.21	227.0
2022-08-25	AAIC-DELISTED	Stock	3.34	3.39	3.31	3.385	52542.0
2022-08-25	AAIC.C-DELISTED	Stock	21.1	21.4	21.1	21.4	840.0
2022-08-25	AAL	Stock	14.17	14.46	14.09	14.42	22167800.0
2022-08-25	AAM.A-DELISTED	Stock	25.02	25.2698	25.02	25.2698	3346.0
2022-08-25	AAM.B-DELISTED	Stock	25.24	26.0	25.15	25.75	14058.0
2022-08-25	AAMC-DELISTED	Stock	5.9088	6.3823	5.4446	5.7588	15229.0
2022-08-25	AAME	Stock	2.94	3.06	2.94	3.06	2400.0
2022-08-25	AAMI	Stock	18.57	19.03	18.54	19.0	148700.0
2022-08-25	AAN-DELISTED	Stock	13.56	14.15	13.48	13.82	150100.0
2022-08-25	AAOI	Stock	2.8	2.86	2.69	2.76	222700.0
2022-08-25	AAON	Stock	39.8067	40.7933	39.6933	40.66	167700.0
2022-08-25	AAP	Stock	179.85	181.34	177.59	180.99	1007000.0
2022-08-25	AAQC-DELISTED	Stock	9.82	9.85	9.81	9.82	107389.0
2022-08-25	AAT	Stock	28.66	29.05	28.56	28.98	303200.0
2022-08-25	AATC	Stock	5.32	5.32	5.12	5.15	13390.0
2022-08-25	AAU-DELISTED	Stock	0.232	0.234	0.2283	0.232	88281.0
2022-08-25	AAUAF-DELISTED	Stock	0.232	0.234	0.2283	0.232	96236.0
2022-08-25	AAWW-DELISTED	Stock	99.95	100.33	99.83	99.93	507450.0
2022-08-25	AAXJ	Stock	67.7	68.55	67.62	68.55	465196.0
2022-08-25	AB	Stock	44.25	45.18	44.24	44.77	260200.0
2022-08-25	ABB-DELISTED	Stock	28.63	29.075	28.61	29.075	958647.0
2022-08-25	ABBNY-DELISTED	Stock	28.64	29.075	28.61	29.07	1080500.0
2022-08-25	ABBV	Stock	138.77	139.56	137.67	139.33	3301200.0
2022-08-25	ABC-DELISTED	Stock	148.27	150.52	147.8	150.51	373179.0
2022-08-25	ABCB	Stock	48.53	49.57	48.3	49.35	198900.0
2022-08-25	ABCL	Stock	12.0	12.2	11.65	12.18	1137100.0
2022-08-25	ABCM-DELISTED	Stock	15.29	15.5	15.15	15.5	49685.0
2022-08-25	ABEO	Stock	4.37	4.67	4.3	4.51	149200.0
2022-08-25	ABEV	Stock	3.04	3.08	3.02	3.04	16495000.0
2022-08-25	ABG	Stock	181.85	189.19	181.85	188.66	98800.0
2022-08-25	ABGI-DELISTED	Stock	9.87	9.88	9.87	9.88	4118.0
2022-08-25	ABM	Stock	47.51	48.7	47.51	48.57	175300.0
2022-08-25	ABMD-DELISTED	Stock	270.34	274.74	268.59	274.39	90322.0
2022-08-25	ABNB	Stock	115.89	117.95	115.42	117.03	4021600.0

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

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