PREVIEW / stock_daily / 2022-11-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-23.parquet
  size:    250 KB
  rows:    7,790
  symbols: 2,055

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-23	AAPL	Stock	149.45	151.83	149.34	151.07	58301400.0
2022-11-23	MSFT	Stock	245.11	248.28	244.27	247.58	19508500.0
2022-11-23	NVDA	Stock	16.098	16.527	16.048	16.519	427241000.0
2022-11-23	AMZN	Stock	93.24	94.58	92.83	94.13	59414700.0
2022-11-23	GOOGL	Stock	97.09	98.76	97.09	98.46	18868092.0
2022-11-23	META	Stock	111.72	112.67	110.73	112.24	21343100.0
2022-11-23	TSLA	Stock	173.57	183.62	172.5	183.2	109536700.0
2022-11-23	TLT	Stock	102.14	103.25	102.08	103.25	23234587.0
2022-11-23	ES	Stock	80.86	82.38	80.65	82.18	1666500.0
2022-11-23	CL	Stock	76.54	77.01	76.48	76.93	3861400.0
2022-11-23	A	Stock	156.67	157.28	154.35	155.35	1444100.0
2022-11-23	AA	Stock	48.51	48.97	47.88	48.51	3213600.0
2022-11-23	AAC-DELISTED	Stock	10.02	10.02	10.0	10.0	1911.0
2022-11-23	AACG	Stock	1.71	1.72	1.7	1.72	2300.0
2022-11-23	AACIU	Stock	9.95	9.95	9.95	9.95	500.0
2022-11-23	AAIC-DELISTED	Stock	3.04	3.1	3.015	3.1	119746.0
2022-11-23	AAL	Stock	13.98	14.43	13.88	14.42	23686400.0
2022-11-23	AAM.A-DELISTED	Stock	24.1	24.4194	24.1	24.28	2908.0
2022-11-23	AAM.B-DELISTED	Stock	23.8	24.285	23.8	24.19	6419.0
2022-11-23	AAMC-DELISTED	Stock	5.7882	5.9412	5.5882	5.9412	7477.0
2022-11-23	AAME	Stock	2.98	2.98	2.98	2.98	400.0
2022-11-23	AAMI	Stock	19.69	19.82	19.53	19.74	65500.0
2022-11-23	AAN-DELISTED	Stock	11.55	11.98	11.42	11.85	507200.0
2022-11-23	AAOI	Stock	2.268	2.38	2.17	2.18	159900.0
2022-11-23	AAON	Stock	53.0333	53.6	52.2867	52.4333	212400.0
2022-11-23	AAP	Stock	149.55	150.89	148.95	150.55	1841800.0
2022-11-23	AAQC-DELISTED	Stock	10.04	10.04	10.01	10.02	67053.0
2022-11-23	AAT	Stock	28.12	28.26	27.64	27.92	233500.0
2022-11-23	AATC	Stock	5.02	5.05	4.95	5.0266	16509.0
2022-11-23	AAU-DELISTED	Stock	0.24	0.25	0.2333	0.243	139698.0
2022-11-23	AAUAF-DELISTED	Stock	0.24	0.25	0.2333	0.2386	141708.0
2022-11-23	AAWW-DELISTED	Stock	100.7	100.97	100.7	100.86	129237.0
2022-11-23	AAXJ	Stock	63.03	63.495	63.01	63.44	431499.0
2022-11-23	AB	Stock	41.29	41.78	40.79	40.93	336000.0
2022-11-23	ABB-DELISTED	Stock	31.22	31.475	31.22	31.435	802094.0
2022-11-23	ABBNY-DELISTED	Stock	31.22	31.475	31.22	31.44	1030973.0
2022-11-23	ABBV	Stock	159.95	160.94	158.82	159.39	3221100.0
2022-11-23	ABC-DELISTED	Stock	164.93	166.25	164.16	165.57	576265.0
2022-11-23	ABCB	Stock	52.8	53.13	52.6	52.67	175700.0
2022-11-23	ABCL	Stock	14.03	14.15	13.768	14.0	1040800.0
2022-11-23	ABCM-DELISTED	Stock	15.78	16.255	15.78	16.04	146064.0
2022-11-23	ABEO	Stock	4.09	4.18	3.88	3.94	195900.0
2022-11-23	ABEV	Stock	2.86	2.93	2.85	2.92	19894300.0
2022-11-23	ABG	Stock	178.56	182.07	178.56	181.9	74000.0
2022-11-23	ABGI-DELISTED	Stock	10.01	10.01	10.01	10.01	130505.0
2022-11-23	ABLV	Stock	10.09	10.09	10.09	10.09	1491.0
2022-11-23	ABM	Stock	45.36	45.93	45.04	45.3	155200.0
2022-11-23	ABMD-DELISTED	Stock	378.0	378.36	377.63	378.01	573246.0
2022-11-23	ABNB	Stock	95.56	97.05	94.34	96.63	4337600.0
2022-11-23	ABOS	Stock	6.33	6.42	6.08	6.36	103300.0

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

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