PREVIEW / stock_daily / 2022-09-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-06.parquet
  size:    251 KB
  rows:    7,824
  symbols: 2,179

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-09-06	AAPL	Stock	156.47	157.09	153.69	154.53	73714800.0
2022-09-06	MSFT	Stock	256.2	257.83	251.94	253.25	21328200.0
2022-09-06	NVDA	Stock	13.731	13.779	13.351	13.465	535751000.0
2022-09-06	AMZN	Stock	127.92	128.62	124.74	126.11	43888600.0
2022-09-06	GOOGL	Stock	107.3	108.03	105.78	106.81	25068280.0
2022-09-06	META	Stock	160.1	161.69	157.69	158.54	19339800.0
2022-09-06	TSLA	Stock	272.68	275.99	265.74	274.42	55860000.0
2022-09-06	TLT	Stock	108.9	108.97	107.42	107.49	24648520.0
2022-09-06	ES	Stock	89.66	90.86	88.89	89.15	1239000.0
2022-09-06	CL	Stock	77.68	79.11	77.56	77.77	4137000.0
2022-09-06	A	Stock	129.38	130.57	127.72	129.3	1533500.0
2022-09-06	AA	Stock	49.66	50.52	47.45	47.91	6800900.0
2022-09-06	AAC-DELISTED	Stock	9.9	9.91	9.9	9.905	77295.0
2022-09-06	AACG	Stock	2.19	2.34	2.15	2.22	170300.0
2022-09-06	AACIW-DELISTED	Stock	0.1799	0.19	0.1798	0.19	1021.0
2022-09-06	AAIC-DELISTED	Stock	3.18	3.1837	3.13	3.18	46638.0
2022-09-06	AAIC.C-DELISTED	Stock	21.9	21.9	21.9	21.9	200.0
2022-09-06	AAL	Stock	13.19	13.26	12.74	13.22	27966400.0
2022-09-06	AAM.A-DELISTED	Stock	24.05	24.05	23.56	23.75	17136.0
2022-09-06	AAM.B-DELISTED	Stock	23.86	23.86	23.54	23.7	15174.0
2022-09-06	AAMC-DELISTED	Stock	5.75	6.0	5.5471	5.6029	26591.0
2022-09-06	AAME	Stock	3.03	3.04	2.92	2.98	3500.0
2022-09-06	AAMI	Stock	17.45	17.45	16.84	17.16	231000.0
2022-09-06	AAN-DELISTED	Stock	11.8	11.9	11.27	11.54	447800.0
2022-09-06	AAOI	Stock	2.24	2.29	2.15	2.15	86000.0
2022-09-06	AAON	Stock	37.9133	37.9533	36.36	36.7467	246150.0
2022-09-06	AAP	Stock	172.29	174.78	170.69	173.34	866400.0
2022-09-06	AAQC-DELISTED	Stock	9.81	9.81	9.8	9.81	8300.0
2022-09-06	AAT	Stock	27.51	27.62	27.09	27.61	228400.0
2022-09-06	AATC	Stock	5.05	5.05	4.9492	5.0233	4624.0
2022-09-06	AAU-DELISTED	Stock	0.22	0.2289	0.22	0.2255	59858.0
2022-09-06	AAUAF-DELISTED	Stock	0.22	0.2289	0.22	0.2255	62126.0
2022-09-06	AAWW-DELISTED	Stock	99.865	100.07	99.75	99.95	742489.0
2022-09-06	AAXJ	Stock	65.28	65.38	64.73	64.86	865976.0
2022-09-06	AB	Stock	42.99	43.37	42.11	42.65	224400.0
2022-09-06	ABB-DELISTED	Stock	27.51	27.64	27.2021	27.325	1863249.0
2022-09-06	ABBNY-DELISTED	Stock	27.51	27.64	27.2021	27.32	1997796.0
2022-09-06	ABBV	Stock	137.3	139.35	136.24	137.59	4810600.0
2022-09-06	ABC-DELISTED	Stock	148.04	149.02	145.5001	146.14	532251.0
2022-09-06	ABCB	Stock	46.17	46.67	44.52	45.1	637300.0
2022-09-06	ABCL	Stock	10.94	10.94	10.43	10.46	1265300.0
2022-09-06	ABCM-DELISTED	Stock	14.13	14.23	14.035	14.14	172927.0
2022-09-06	ABEO	Stock	3.65	3.87	3.55	3.73	151200.0
2022-09-06	ABEV	Stock	2.95	2.96	2.9	2.93	25041100.0
2022-09-06	ABG	Stock	172.37	172.37	164.55	165.09	150200.0
2022-09-06	ABGI-DELISTED	Stock	9.885	9.885	9.885	9.885	360.0
2022-09-06	ABM	Stock	45.31	45.46	44.29	44.86	246500.0
2022-09-06	ABMD-DELISTED	Stock	262.15	265.32	259.27	263.89	163504.0
2022-09-06	ABNB	Stock	114.09	114.52	110.5	113.7	4067100.0
2022-09-06	ABOS	Stock	5.75	6.23	5.75	6.08	48700.0

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

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