PREVIEW / stock_daily / 2022-11-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-18.parquet
  size:    251 KB
  rows:    7,826
  symbols: 2,083

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-11-18	AAPL	Stock	152.31	152.7	149.97	151.29	74829600.0
2022-11-18	MSFT	Stock	243.51	243.74	239.03	241.22	27613500.0
2022-11-18	NVDA	Stock	15.966	16.002	15.12	15.409	492072000.0
2022-11-18	AMZN	Stock	95.95	95.99	92.48	94.14	72428200.0
2022-11-18	GOOGL	Stock	98.77	98.9	96.37	97.43	28342297.0
2022-11-18	META	Stock	113.8	114.32	110.62	112.05	33357700.0
2022-11-18	TSLA	Stock	185.05	185.19	176.55	180.19	76048900.0
2022-11-18	TLT	Stock	100.6	100.885	99.545	99.64	14941277.0
2022-11-18	ES	Stock	79.08	79.7	78.86	79.65	2031800.0
2022-11-18	CL	Stock	76.07	76.68	75.72	76.46	4060900.0
2022-11-18	A	Stock	146.68	147.96	144.15	146.19	1283400.0
2022-11-18	AA	Stock	48.18	48.57	46.72	47.31	3967400.0
2022-11-18	AAC-DELISTED	Stock	9.99	10.0	9.99	9.995	8425.0
2022-11-18	AACG	Stock	1.68	1.86	1.68	1.78	20100.0
2022-11-18	AACIW-DELISTED	Stock	0.0335	0.0335	0.0335	0.0335	6693.0
2022-11-18	AAIC-DELISTED	Stock	3.05	3.23	3.0	3.05	70690.0
2022-11-18	AAIC.C-DELISTED	Stock	21.4	21.4	21.26	21.26	400.0
2022-11-18	AAL	Stock	14.26	14.58	13.92	14.05	25968300.0
2022-11-18	AAM.A-DELISTED	Stock	24.89	24.89	24.32	24.7	7852.0
2022-11-18	AAM.B-DELISTED	Stock	24.82	25.0	24.58	24.71	7483.0
2022-11-18	AAMC-DELISTED	Stock	5.8235	5.8235	5.5618	5.6971	3924.0
2022-11-18	AAME	Stock	3.07	3.07	3.01	3.02	2300.0
2022-11-18	AAMI	Stock	19.88	19.99	19.29	19.51	132900.0
2022-11-18	AAN-DELISTED	Stock	10.67	11.06	10.5	11.05	422000.0
2022-11-18	AAOI	Stock	2.18	2.205	2.12	2.13	64200.0
2022-11-18	AAON	Stock	53.9267	53.9267	52.3133	52.5067	277500.0
2022-11-18	AAP	Stock	149.68	150.27	145.59	147.5	1707900.0
2022-11-18	AAQC-DELISTED	Stock	10.015	10.02	10.01	10.02	19853.0
2022-11-18	AAT	Stock	28.55	28.88	28.15	28.82	372200.0
2022-11-18	AATC	Stock	4.41	4.9499	4.41	4.68	41498.0
2022-11-18	AAU-DELISTED	Stock	0.255	0.255	0.2335	0.2453	239146.0
2022-11-18	AAUAF-DELISTED	Stock	0.255	0.255	0.2335	0.2445	246111.0
2022-11-18	AAWW-DELISTED	Stock	100.78	100.81	100.07	100.66	200654.0
2022-11-18	AAXJ	Stock	64.02	64.02	63.5	63.75	307046.0
2022-11-18	AB	Stock	39.9	40.09	39.28	39.4	228900.0
2022-11-18	ABB-DELISTED	Stock	30.69	30.87	30.55	30.715	1474994.0
2022-11-18	ABBNY-DELISTED	Stock	30.69	30.87	30.55	30.72	1599562.0
2022-11-18	ABBV	Stock	153.67	155.64	153.67	154.98	5691100.0
2022-11-18	ABC-DELISTED	Stock	160.0	162.0	159.11	161.95	990606.0
2022-11-18	ABCB	Stock	52.37	52.37	51.48	52.02	293100.0
2022-11-18	ABCL	Stock	14.4	14.42	14.01	14.16	1377900.0
2022-11-18	ABCM-DELISTED	Stock	16.63	16.7275	16.32	16.37	232101.0
2022-11-18	ABEO	Stock	3.98	4.19	3.9	4.04	371100.0
2022-11-18	ABEV	Stock	2.89	2.93	2.86	2.87	34901200.0
2022-11-18	ABG	Stock	182.77	182.77	172.35	178.36	167000.0
2022-11-18	ABLV	Stock	10.08	10.08	10.08	10.08	2200.0
2022-11-18	ABM	Stock	45.62	45.76	45.0	45.47	262500.0
2022-11-18	ABMD-DELISTED	Stock	376.98	377.78	376.26	377.17	1242270.0
2022-11-18	ABNB	Stock	100.84	100.84	96.6	97.77	5913100.0
2022-11-18	ABOS	Stock	6.67	6.67	5.96	6.08	61100.0

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

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