PREVIEW / stock_daily / 2021-11-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-23.parquet
  size:    262 KB
  rows:    8,031
  symbols: 2,681

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
2021-11-23	AAPL	Stock	161.12	161.8	159.06	161.41	96041900.0
2021-11-23	MSFT	Stock	337.05	339.45	333.56	337.68	30427600.0
2021-11-23	NVDA	Stock	31.535	32.36	30.88	31.746	532163000.0
2021-11-23	AMZN	Stock	179.252	181.0525	176.3855	179.002	73804000.0
2021-11-23	GOOGL	Stock	146.153	146.66	144.115	145.782	27231160.0
2021-11-23	META	Stock	338.93	341.4	333.5	337.25	17225000.0
2021-11-23	TSLA	Stock	389.17	393.5	354.2333	369.6767	108515100.0
2021-11-23	TLT	Stock	145.93	146.11	144.5	144.5	15321246.0
2021-11-23	ES	Stock	84.74	85.54	84.19	85.2	860800.0
2021-11-23	CL	Stock	77.69	78.18	77.24	77.93	2941800.0
2021-11-23	A	Stock	155.89	159.32	151.77	154.78	3140600.0
2021-11-23	AA	Stock	49.16	50.21	48.45	49.02	4875500.0
2021-11-23	AAC-DELISTED	Stock	9.84	9.84	9.79	9.83	379759.0
2021-11-23	AACG	Stock	1.76	1.8	1.73	1.73	16900.0
2021-11-23	AACIU	Stock	9.9855	9.9855	9.9855	9.9855	1021.0
2021-11-23	AACIW-DELISTED	Stock	0.528	0.528	0.5	0.5175	46158.0
2021-11-23	AAIC-DELISTED	Stock	3.67	3.73	3.67	3.68	128109.0
2021-11-23	AAIC.C-DELISTED	Stock	25.93	25.93	25.93	25.93	100.0
2021-11-23	AAL	Stock	19.75	20.14	19.32	19.47	30427300.0
2021-11-23	AAM.A-DELISTED	Stock	25.6	25.67	25.6	25.65	27715.0
2021-11-23	AAM.B-DELISTED	Stock	26.6	26.71	26.5949	26.65	5082.0
2021-11-23	AAMC-DELISTED	Stock	6.4706	6.5559	6.4676	6.4706	4566.0
2021-11-23	AAME	Stock	4.15	4.19	3.94	4.0	12600.0
2021-11-23	AAMI	Stock	30.26	30.62	30.23	30.4	1456200.0
2021-11-23	AAN-DELISTED	Stock	25.19	26.12	25.09	25.16	162800.0
2021-11-23	AAOI	Stock	5.94	6.01	5.75	5.92	624300.0
2021-11-23	AAON	Stock	52.1533	52.4933	51.3867	52.2733	302850.0
2021-11-23	AAP	Stock	232.51	235.99	230.31	235.77	405300.0
2021-11-23	AAQC-DELISTED	Stock	9.76	9.76	9.71	9.74	119555.0
2021-11-23	AAT	Stock	37.8	38.41	37.8	38.0	198800.0
2021-11-23	AATC	Stock	6.9999	6.9999	6.84	6.85	10062.0
2021-11-23	AAU-DELISTED	Stock	0.3521	0.3559	0.324	0.34	807819.0
2021-11-23	AAUAF-DELISTED	Stock	0.3521	0.3559	0.324	0.34	818608.0
2021-11-23	AAWW-DELISTED	Stock	93.01	95.0	92.4425	94.92	430174.0
2021-11-23	AAXJ	Stock	86.27	86.555	85.76	86.02	803327.0
2021-11-23	AB	Stock	54.48	55.12	53.9	54.93	245600.0
2021-11-23	ABB-DELISTED	Stock	35.59	35.78	35.365	35.56	960945.0
2021-11-23	ABBNY-DELISTED	Stock	35.59	35.78	35.365	35.56	1103604.0
2021-11-23	ABBV	Stock	116.56	119.33	116.15	118.88	8948300.0
2021-11-23	ABC-DELISTED	Stock	121.27	124.24	120.99	123.64	968251.0
2021-11-23	ABCB	Stock	53.2	53.78	52.83	53.45	227100.0
2021-11-23	ABCL	Stock	14.33	14.39	13.47	13.96	1809500.0
2021-11-23	ABCM-DELISTED	Stock	21.88	22.42	21.88	22.3	28070.0
2021-11-23	ABEO	Stock	19.25	20.75	18.5	18.75	42628.0
2021-11-23	ABEV	Stock	3.04	3.06	2.99	3.05	37596500.0
2021-11-23	ABG	Stock	167.51	168.29	160.84	166.64	621100.0
2021-11-23	ABGI-DELISTED	Stock	9.7601	9.79	9.76	9.78	1067.0
2021-11-23	ABM	Stock	48.51	49.1	48.5	48.83	243700.0
2021-11-23	ABMD-DELISTED	Stock	332.81	339.7639	324.67	328.04	132522.0
2021-11-23	ABNB	Stock	181.143	183.73	175.25	178.27	6451900.0

> showing 50 of 8,031 rows — these rows as CSV

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