PREVIEW / stock_daily / 2022-09-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-07.parquet
  size:    251 KB
  rows:    7,828
  symbols: 2,188

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-07	AAPL	Stock	154.82	156.67	153.61	155.96	87449600.0
2022-09-07	MSFT	Stock	254.7	258.83	253.22	258.09	24126700.0
2022-09-07	NVDA	Stock	13.563	13.838	13.346	13.714	512657000.0
2022-09-07	AMZN	Stock	126.12	129.82	125.4	129.48	47900300.0
2022-09-07	GOOGL	Stock	107.06	109.98	106.9	109.45	23166967.0
2022-09-07	META	Stock	157.76	160.96	156.81	160.39	16831200.0
2022-09-07	TSLA	Stock	273.1	283.84	272.27	283.7	50028900.0
2022-09-07	TLT	Stock	108.32	109.48	108.21	109.19	17050131.0
2022-09-07	ES	Stock	89.93	92.03	89.74	91.82	1843300.0
2022-09-07	CL	Stock	78.09	78.66	77.91	78.55	4264500.0
2022-09-07	A	Stock	128.97	131.82	128.61	131.43	1254600.0
2022-09-07	AA	Stock	47.02	48.07	46.12	47.66	5242800.0
2022-09-07	AAC-DELISTED	Stock	9.91	9.915	9.91	9.91	124243.0
2022-09-07	AACG	Stock	2.13	2.19	2.13	2.16	14300.0
2022-09-07	AAIC-DELISTED	Stock	3.16	3.1892	3.11	3.18	63512.0
2022-09-07	AAIC.C-DELISTED	Stock	21.505	21.74	21.4	21.4	2195.0
2022-09-07	AAL	Stock	13.27	13.93	13.22	13.89	32867600.0
2022-09-07	AAM.A-DELISTED	Stock	23.7131	24.15	23.7131	24.12	11198.0
2022-09-07	AAM.B-DELISTED	Stock	23.7	23.96	23.7	23.86	11527.0
2022-09-07	AAMC-DELISTED	Stock	5.8824	5.8824	5.5882	5.7794	9425.0
2022-09-07	AAME	Stock	2.82	3.04	2.82	2.99	3900.0
2022-09-07	AAMI	Stock	17.21	17.75	16.965	17.73	326600.0
2022-09-07	AAN-DELISTED	Stock	11.61	11.93	11.32	11.82	366800.0
2022-09-07	AAOI	Stock	2.14	2.32	2.14	2.31	114000.0
2022-09-07	AAON	Stock	36.98	38.78	36.8733	38.4733	363450.0
2022-09-07	AAP	Stock	173.91	178.73	173.61	178.3	622800.0
2022-09-07	AAQC-DELISTED	Stock	9.81	9.82	9.8	9.81	25451.0
2022-09-07	AAT	Stock	27.05	27.65	26.98	27.65	208800.0
2022-09-07	AATC	Stock	5.069	5.12	5.05	5.07	11432.0
2022-09-07	AAU-DELISTED	Stock	0.2226	0.2326	0.2226	0.2324	367786.0
2022-09-07	AAUAF-DELISTED	Stock	0.2226	0.2326	0.2226	0.2324	377962.0
2022-09-07	AAWW-DELISTED	Stock	99.9	100.04	99.885	99.93	575457.0
2022-09-07	AAXJ	Stock	64.5	65.49	64.5	65.43	1059513.0
2022-09-07	AB	Stock	42.3	42.7	42.13	42.55	224100.0
2022-09-07	ABB-DELISTED	Stock	27.27	27.815	27.185	27.77	1369778.0
2022-09-07	ABBNY-DELISTED	Stock	27.27	27.815	27.185	27.76	1484785.0
2022-09-07	ABBV	Stock	137.55	139.04	135.34	138.71	4141700.0
2022-09-07	ABC-DELISTED	Stock	145.9	148.22	144.97	147.88	376441.0
2022-09-07	ABCB	Stock	44.89	45.95	44.57	45.89	337700.0
2022-09-07	ABCL	Stock	10.49	10.94	10.4	10.86	1205300.0
2022-09-07	ABCM-DELISTED	Stock	13.89	14.31	13.85	14.26	98294.0
2022-09-07	ABEO	Stock	3.73	3.85	3.65	3.76	38600.0
2022-09-07	ABEV	Stock	2.92	2.98	2.92	2.98	14799400.0
2022-09-07	ABG	Stock	165.03	170.74	162.65	170.03	136200.0
2022-09-07	ABM	Stock	44.98	45.78	44.87	45.74	203400.0
2022-09-07	ABMD-DELISTED	Stock	264.37	268.79	261.19	268.31	143780.0
2022-09-07	ABNB	Stock	112.85	116.44	112.71	116.07	4619300.0
2022-09-07	ABOS	Stock	6.11	6.55	5.905	6.53	25400.0
2022-09-07	ABR	Stock	14.56	14.8	14.43	14.8	1462100.0
2022-09-07	ABR.D	Stock	20.31	20.705	20.31	20.33	2805.0

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

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