PREVIEW / stock_daily / 2022-09-20

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-20.parquet
  size:    253 KB
  rows:    7,904
  symbols: 2,221

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-20	AAPL	Stock	153.4	158.08	153.08	156.9	107689800.0
2022-09-20	MSFT	Stock	242.07	243.51	239.64	242.45	26660300.0
2022-09-20	NVDA	Stock	13.215	13.483	13.057	13.176	524818000.0
2022-09-20	AMZN	Stock	123.35	124.4	121.14	122.19	47698400.0
2022-09-20	GOOGL	Stock	102.08	102.37	100.52	101.14	26517123.0
2022-09-20	META	Stock	145.78	148.84	145.22	146.09	23217400.0
2022-09-20	TSLA	Stock	306.91	313.33	305.58	308.73	61642800.0
2022-09-20	TLT	Stock	105.69	106.84	105.4	106.25	20133840.0
2022-09-20	ES	Stock	88.97	89.13	87.82	88.61	1248600.0
2022-09-20	CL	Stock	75.7	75.88	74.8	75.16	2738600.0
2022-09-20	A	Stock	129.1	129.6	126.82	128.14	1274700.0
2022-09-20	AA	Stock	43.58	43.8	42.7	43.53	5023600.0
2022-09-20	AAC-DELISTED	Stock	9.93	9.94	9.925	9.93	220776.0
2022-09-20	AACG	Stock	1.96	1.99	1.92	1.98	14000.0
2022-09-20	AAIC-DELISTED	Stock	3.09	3.1196	3.07	3.1	29572.0
2022-09-20	AAIC.C-DELISTED	Stock	20.1	20.1	20.05	20.05	1581.0
2022-09-20	AAL	Stock	14.2	14.33	13.69	13.97	31083400.0
2022-09-20	AAM.A-DELISTED	Stock	23.56	23.7	23.475	23.52	22334.0
2022-09-20	AAM.B-DELISTED	Stock	23.68	23.9	23.58	23.89	5233.0
2022-09-20	AAMC-DELISTED	Stock	5.4324	5.5471	5.3235	5.4382	21213.0
2022-09-20	AAME	Stock	3.12	3.15	2.88	3.09	15200.0
2022-09-20	AAMI	Stock	17.11	17.159	16.41	16.6	190800.0
2022-09-20	AAN-DELISTED	Stock	11.96	11.96	11.45	11.51	441600.0
2022-09-20	AAOI	Stock	3.72	4.0	3.05	3.18	3467500.0
2022-09-20	AAON	Stock	38.7333	38.76	37.88	38.38	107700.0
2022-09-20	AAP	Stock	166.24	167.1	164.24	165.87	708500.0
2022-09-20	AAQC-DELISTED	Stock	9.81	9.82	9.8	9.81	47300.0
2022-09-20	AAT	Stock	26.81	27.22	26.57	27.12	481600.0
2022-09-20	AATC	Stock	5.07	5.0815	5.05	5.05	4931.0
2022-09-20	AAU-DELISTED	Stock	0.22	0.2201	0.2045	0.2151	202394.0
2022-09-20	AAUAF-DELISTED	Stock	0.22	0.2201	0.2045	0.2151	204890.0
2022-09-20	AAWW-DELISTED	Stock	99.1	99.73	98.86	99.2	697390.0
2022-09-20	AAXJ	Stock	63.87	64.01	63.53	63.69	457923.0
2022-09-20	AB	Stock	41.84	42.02	40.95	41.4	262300.0
2022-09-20	ABB-DELISTED	Stock	26.82	26.96	26.665	26.835	1306286.0
2022-09-20	ABBNY-DELISTED	Stock	26.82	26.96	26.665	26.83	1429608.0
2022-09-20	ABBV	Stock	141.82	142.49	140.37	141.77	4532900.0
2022-09-20	ABC-DELISTED	Stock	139.68	140.225	138.15	138.91	555111.0
2022-09-20	ABCB	Stock	48.28	48.98	48.19	48.48	505500.0
2022-09-20	ABCL	Stock	10.24	10.455	10.13	10.29	914200.0
2022-09-20	ABCM-DELISTED	Stock	16.24	16.5	16.08	16.125	153285.0
2022-09-20	ABEO	Stock	3.78	3.85	3.62	3.72	92600.0
2022-09-20	ABEV	Stock	2.94	3.02	2.91	3.0	41027000.0
2022-09-20	ABG	Stock	156.16	156.16	150.24	153.1	155300.0
2022-09-20	ABGI-DELISTED	Stock	9.895	9.9	9.895	9.9	14568.0
2022-09-20	ABM	Stock	40.59	40.59	39.88	40.26	221100.0
2022-09-20	ABMD-DELISTED	Stock	255.52	261.03	251.475	258.98	231105.0
2022-09-20	ABNB	Stock	117.93	121.66	116.62	116.71	5610900.0
2022-09-20	ABOS	Stock	4.81	5.24	4.81	4.94	29600.0
2022-09-20	ABR	Stock	14.63	14.69	14.33	14.36	1372000.0

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

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