PREVIEW / stock_daily / 2023-02-10

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-10.parquet
  size:    248 KB
  rows:    7,671
  symbols: 1,843

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
2023-02-10	AAPL	Stock	149.46	151.34	149.22	151.01	57450700.0
2023-02-10	MSFT	Stock	261.53	264.09	260.66	263.1	25818500.0
2023-02-10	NVDA	Stock	21.69	22.078	20.811	21.265	550737000.0
2023-02-10	AMZN	Stock	97.56	98.82	96.23	97.61	52740100.0
2023-02-10	GOOGL	Stock	95.45	96.75	94.25	94.57	54980696.0
2023-02-10	META	Stock	176.35	178.89	173.35	174.15	33433600.0
2023-02-10	TSLA	Stock	202.23	206.2	192.89	196.89	204754100.0
2023-02-10	TLT	Stock	104.4	104.44	103.115	103.39	16598349.0
2023-02-10	ES	Stock	78.48	80.12	78.06	80.07	1442700.0
2023-02-10	CL	Stock	72.93	73.73	72.73	73.55	3524300.0
2023-02-10	A	Stock	151.8	152.99	151.07	152.55	934800.0
2023-02-10	AA	Stock	49.28	49.49	48.19	48.69	4612600.0
2023-02-10	AAC-DELISTED	Stock	10.2	10.21	10.19	10.21	132141.0
2023-02-10	AACG	Stock	1.7	1.8	1.65	1.74	11400.0
2023-02-10	AACIW-DELISTED	Stock	0.1121	0.1249	0.082	0.1249	2850.0
2023-02-10	AAIC-DELISTED	Stock	3.0	3.01	2.99	2.99	16937.0
2023-02-10	AAL	Stock	16.41	16.43	16.14	16.28	14210100.0
2023-02-10	AAM.A-DELISTED	Stock	24.72	24.72	24.2668	24.635	8113.0
2023-02-10	AAM.B-DELISTED	Stock	24.45	24.78	24.13	24.7176	11338.0
2023-02-10	AAMC-DELISTED	Stock	10.6324	11.5676	10.55	11.4118	52635.0
2023-02-10	AAMI	Stock	25.38	26.2	25.22	26.18	148900.0
2023-02-10	AAN-DELISTED	Stock	14.77	14.85	14.42	14.64	152900.0
2023-02-10	AAOI	Stock	2.64	2.7	2.59	2.65	75800.0
2023-02-10	AAON	Stock	50.4333	50.94	49.9733	50.1467	325800.0
2023-02-10	AAP	Stock	151.79	155.01	151.14	151.8	1115200.0
2023-02-10	AAT	Stock	26.42	26.68	26.1	26.43	999200.0
2023-02-10	AATC	Stock	4.37	4.4	4.35	4.39	8544.0
2023-02-10	AAU-DELISTED	Stock	0.2201	0.2268	0.2167	0.22	128710.0
2023-02-10	AAUAF-DELISTED	Stock	0.2201	0.2268	0.2167	0.22	131824.0
2023-02-10	AAWW-DELISTED	Stock	102.24	102.24	102.12	102.21	267053.0
2023-02-10	AAXJ	Stock	69.62	69.62	69.035	69.26	674733.0
2023-02-10	AB	Stock	39.09	40.15	38.26	39.38	427400.0
2023-02-10	ABB-DELISTED	Stock	33.34	33.64	33.24	33.63	967953.0
2023-02-10	ABBNY-DELISTED	Stock	33.34	33.64	33.24	33.63	1282727.0
2023-02-10	ABBV	Stock	149.69	153.18	148.77	152.05	8956700.0
2023-02-10	ABC-DELISTED	Stock	155.73	159.19	155.445	159.17	975028.0
2023-02-10	ABCB	Stock	48.3	48.75	47.98	48.46	289800.0
2023-02-10	ABCL	Stock	9.76	10.0	9.57	9.83	1918900.0
2023-02-10	ABCM-DELISTED	Stock	14.35	15.2	14.35	14.92	343616.0
2023-02-10	ABEO	Stock	2.51	2.55	2.48	2.48	162100.0
2023-02-10	ABEV	Stock	2.43	2.45	2.4	2.44	21535700.0
2023-02-10	ABG	Stock	228.99	233.18	227.22	231.51	187200.0
2023-02-10	ABGI-DELISTED	Stock	10.15	10.16	10.15	10.15	30895.0
2023-02-10	ABM	Stock	46.29	47.99	46.29	47.99	345400.0
2023-02-10	ABNB	Stock	112.25	113.36	106.538	108.87	6463500.0
2023-02-10	ABOS	Stock	5.81	5.97	5.66	5.7	103000.0
2023-02-10	ABR	Stock	14.46	14.65	14.37	14.65	2154300.0
2023-02-10	ABR.D	Stock	20.14	20.44	20.14	20.38	6056.0
2023-02-10	ABR.E	Stock	20.85	20.9866	20.8001	20.98	1454.0
2023-02-10	ABR.F	Stock	20.75	20.795	20.55	20.66	8386.0

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

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