PREVIEW / stock_daily / 2023-02-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-06.parquet
  size:    248 KB
  rows:    7,668
  symbols: 1,862

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-06	AAPL	Stock	152.57	153.1	150.78	151.73	69858300.0
2023-02-06	MSFT	Stock	257.44	258.3	254.78	256.77	22518000.0
2023-02-06	NVDA	Stock	20.806	21.57	20.786	21.089	452197000.0
2023-02-06	AMZN	Stock	102.93	103.95	100.65	102.18	81945200.0
2023-02-06	GOOGL	Stock	102.4	104.36	101.88	102.9	31999562.0
2023-02-06	META	Stock	186.53	190.7	185.52	186.06	42483800.0
2023-02-06	TSLA	Stock	193.01	198.17	189.92	194.76	186188100.0
2023-02-06	TLT	Stock	105.75	106.305	105.68	105.91	15182444.0
2023-02-06	ES	Stock	80.15	81.36	79.75	81.31	1180400.0
2023-02-06	CL	Stock	74.2	74.41	73.28	73.85	4186900.0
2023-02-06	A	Stock	152.73	154.4	151.36	152.24	771500.0
2023-02-06	AA	Stock	55.14	55.4	50.86	52.02	5405100.0
2023-02-06	AAC-DELISTED	Stock	10.17	10.2	10.17	10.19	25697.0
2023-02-06	AACG	Stock	1.63	1.69	1.55	1.67	13200.0
2023-02-06	AAIC-DELISTED	Stock	3.02	3.02	3.0	3.01	48240.0
2023-02-06	AAIC.C-DELISTED	Stock	22.8	22.81	22.75	22.75	1275.0
2023-02-06	AAL	Stock	16.88	17.09	16.79	16.92	19340800.0
2023-02-06	AAM.A-DELISTED	Stock	25.1	25.3	24.575	24.575	12886.0
2023-02-06	AAM.B-DELISTED	Stock	24.98	25.28	24.6	24.73	11392.0
2023-02-06	AAMC-DELISTED	Stock	11.0676	11.2147	8.8235	9.9794	186245.0
2023-02-06	AAME	Stock	2.51	2.58	2.5	2.55	4600.0
2023-02-06	AAMI	Stock	25.82	25.975	25.41	25.51	171500.0
2023-02-06	AAN-DELISTED	Stock	15.34	15.625	14.96	14.99	200500.0
2023-02-06	AAOI	Stock	2.67	2.73	2.65	2.65	74600.0
2023-02-06	AAON	Stock	53.2133	54.4533	52.8067	53.04	189150.0
2023-02-06	AAP	Stock	151.0	151.74	150.16	151.67	827200.0
2023-02-06	AAT	Stock	28.67	28.67	28.17	28.3	160600.0
2023-02-06	AATC	Stock	4.1	4.235	4.1	4.215	31980.0
2023-02-06	AAU-DELISTED	Stock	0.2301	0.2331	0.22	0.2231	306451.0
2023-02-06	AAUAF-DELISTED	Stock	0.2301	0.233	0.22	0.2231	310010.0
2023-02-06	AAWW-DELISTED	Stock	102.1	102.24	102.1	102.2	187087.0
2023-02-06	AAXJ	Stock	69.28	69.36	68.76	69.22	1048117.0
2023-02-06	AB	Stock	39.01	39.43	38.57	38.71	157600.0
2023-02-06	ABB-DELISTED	Stock	33.85	33.95	33.66	33.87	1005100.0
2023-02-06	ABBNY-DELISTED	Stock	33.87	33.95	33.66	33.87	1124189.0
2023-02-06	ABBV	Stock	145.74	146.33	144.81	145.02	4297000.0
2023-02-06	ABC-DELISTED	Stock	157.22	157.585	154.17	154.52	1091861.0
2023-02-06	ABCB	Stock	49.93	50.31	48.8	48.93	405300.0
2023-02-06	ABCL	Stock	11.1	11.29	10.94	10.97	1138900.0
2023-02-06	ABCM-DELISTED	Stock	14.6	14.92	14.511	14.66	181287.0
2023-02-06	ABEO	Stock	2.77	2.84	2.68	2.68	109600.0
2023-02-06	ABEV	Stock	2.51	2.53	2.48	2.5	48072900.0
2023-02-06	ABG	Stock	242.95	244.16	234.61	236.0	298100.0
2023-02-06	ABLV	Stock	10.25	10.25	10.25	10.25	843.0
2023-02-06	ABM	Stock	47.71	47.88	46.97	47.59	242500.0
2023-02-06	ABNB	Stock	117.41	119.334	116.81	118.35	3204100.0
2023-02-06	ABOS	Stock	5.79	6.11	5.75	5.98	121700.0
2023-02-06	ABR	Stock	15.25	15.25	14.72	14.83	2069100.0
2023-02-06	ABR.D	Stock	20.9541	20.9541	20.735	20.735	6978.0
2023-02-06	ABR.E	Stock	21.05	21.1258	21.005	21.1199	2738.0

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

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