PREVIEW / stock_daily / 2022-09-15

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-15.parquet
  size:    251 KB
  rows:    7,854
  symbols: 2,204

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-15	AAPL	Stock	154.65	155.24	151.38	152.37	90481100.0
2022-09-15	MSFT	Stock	249.77	251.4	244.02	245.38	31530900.0
2022-09-15	NVDA	Stock	13.015	13.233	12.79	12.929	523625000.0
2022-09-15	AMZN	Stock	127.38	130.37	125.5	126.28	52887200.0
2022-09-15	GOOGL	Stock	104.03	105.27	102.35	102.91	34188284.0
2022-09-15	META	Stock	149.8	154.2	148.7	149.55	34606300.0
2022-09-15	TSLA	Stock	301.83	309.12	300.72	303.75	64795500.0
2022-09-15	TLT	Stock	107.85	108.19	107.58	107.97	10260164.0
2022-09-15	ES	Stock	89.92	89.93	88.09	88.19	1460800.0
2022-09-15	CL	Stock	76.22	76.27	74.53	75.23	4982400.0
2022-09-15	A	Stock	133.81	135.51	132.66	133.16	1446500.0
2022-09-15	AA	Stock	44.57	45.54	43.013	43.14	8631700.0
2022-09-15	AAC-DELISTED	Stock	9.91	9.94	9.91	9.93	182518.0
2022-09-15	AACG	Stock	1.89	1.9	1.76	1.85	46100.0
2022-09-15	AACIW-DELISTED	Stock	0.1797	0.1797	0.1797	0.1797	300.0
2022-09-15	AAIC-DELISTED	Stock	3.1	3.1673	3.1	3.14	21077.0
2022-09-15	AAL	Stock	13.91	14.56	13.9	14.27	28334700.0
2022-09-15	AAM.A-DELISTED	Stock	24.24	24.36	24.16	24.18	12374.0
2022-09-15	AAM.B-DELISTED	Stock	24.4	24.6	24.3	24.3	7853.0
2022-09-15	AAMC-DELISTED	Stock	5.6235	5.6235	5.5735	5.6176	4376.0
2022-09-15	AAME	Stock	2.95	3.04	2.92	3.02	8000.0
2022-09-15	AAMI	Stock	16.97	17.3	16.74	16.76	256000.0
2022-09-15	AAN-DELISTED	Stock	11.81	12.45	11.8	12.18	670200.0
2022-09-15	AAOI	Stock	2.53	2.63	2.46	2.5	2386000.0
2022-09-15	AAON	Stock	38.5	39.22	38.24	38.66	209700.0
2022-09-15	AAP	Stock	169.3	170.58	166.62	167.62	1053400.0
2022-09-15	AAQC-DELISTED	Stock	9.8	9.81	9.8	9.81	1617.0
2022-09-15	AAT	Stock	27.02	27.41	26.78	27.0	421200.0
2022-09-15	AATC	Stock	5.1	5.2292	5.1	5.1	14788.0
2022-09-15	AAU-DELISTED	Stock	0.2203	0.2272	0.2203	0.2226	176270.0
2022-09-15	AAUAF-DELISTED	Stock	0.2203	0.2272	0.2203	0.2226	178118.0
2022-09-15	AAWW-DELISTED	Stock	99.91	100.05	99.79	99.95	412273.0
2022-09-15	AAXJ	Stock	64.83	65.11	64.39	64.51	651387.0
2022-09-15	AB	Stock	42.37	43.28	42.35	42.52	198300.0
2022-09-15	ABB-DELISTED	Stock	28.07	28.29	27.8223	27.895	1222324.0
2022-09-15	ABBNY-DELISTED	Stock	28.06	28.29	27.8223	27.88	1355138.0
2022-09-15	ABBV	Stock	139.99	143.9	139.39	142.51	6416900.0
2022-09-15	ABC-DELISTED	Stock	140.9	140.93	139.37	139.81	550923.0
2022-09-15	ABCB	Stock	47.15	48.07	46.39	47.61	627500.0
2022-09-15	ABCL	Stock	10.78	11.12	10.77	10.88	1370400.0
2022-09-15	ABCM-DELISTED	Stock	16.03	16.57	16.0	16.47	162440.0
2022-09-15	ABEO	Stock	4.1	4.23	3.8	4.07	141200.0
2022-09-15	ABEV	Stock	2.92	2.92	2.86	2.87	16732500.0
2022-09-15	ABG	Stock	159.02	163.48	157.68	159.19	158500.0
2022-09-15	ABGI-DELISTED	Stock	9.88	9.88	9.88	9.88	829.0
2022-09-15	ABM	Stock	41.45	42.51	41.12	41.17	305200.0
2022-09-15	ABMD-DELISTED	Stock	263.71	269.99	262.52	263.81	145947.0
2022-09-15	ABNB	Stock	125.29	129.38	124.28	125.04	6606100.0
2022-09-15	ABOS	Stock	6.0	6.41	5.975	6.18	59800.0
2022-09-15	ABR	Stock	15.09	15.14	14.72	14.76	2003200.0

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

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