PREVIEW / stock_daily / 2023-02-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-15.parquet
  size:    248 KB
  rows:    7,676
  symbols: 1,856

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-15	AAPL	Stock	153.11	155.5	152.88	155.33	65573800.0
2023-02-15	MSFT	Stock	268.32	270.73	266.18	269.32	28922400.0
2023-02-15	NVDA	Stock	22.549	22.855	22.106	22.764	420575000.0
2023-02-15	AMZN	Stock	99.09	101.17	98.45	101.16	47957600.0
2023-02-15	GOOGL	Stock	94.49	97.12	94.15	96.94	50298481.0
2023-02-15	META	Stock	176.42	178.19	175.33	177.16	25308900.0
2023-02-15	TSLA	Stock	211.76	214.66	206.11	214.24	181006400.0
2023-02-15	TLT	Stock	103.55	103.95	102.495	103.05	15567607.0
2023-02-15	ES	Stock	78.51	80.17	78.4	79.88	1897200.0
2023-02-15	CL	Stock	72.87	72.99	72.29	72.7	4399200.0
2023-02-15	A	Stock	152.22	152.32	150.3	151.75	982400.0
2023-02-15	AA	Stock	47.51	48.59	47.28	48.41	3623800.0
2023-02-15	AAC-DELISTED	Stock	10.2	10.22	10.2	10.2	29381.0
2023-02-15	AACG	Stock	1.79	1.86	1.79	1.85	10800.0
2023-02-15	AACIW-DELISTED	Stock	0.124	0.124	0.124	0.124	300.0
2023-02-15	AAIC-DELISTED	Stock	2.99	3.04	2.98	3.04	99341.0
2023-02-15	AAIC.C-DELISTED	Stock	22.59	22.59	21.55	22.24	2756.0
2023-02-15	AAL	Stock	16.64	16.84	16.58	16.8	12457100.0
2023-02-15	AAM.A-DELISTED	Stock	24.73	24.885	24.29	24.565	22963.0
2023-02-15	AAM.B-DELISTED	Stock	24.54	24.8938	24.54	24.77	8242.0
2023-02-15	AAMC-DELISTED	Stock	11.55	12.3323	11.55	12.1265	60615.0
2023-02-15	AAME	Stock	2.35	2.37	2.23	2.27	8600.0
2023-02-15	AAMI	Stock	25.6	26.49	25.6	26.48	110200.0
2023-02-15	AAN-DELISTED	Stock	14.72	15.12	14.72	15.07	132500.0
2023-02-15	AAOI	Stock	2.69	2.91	2.69	2.83	233400.0
2023-02-15	AAON	Stock	52.0133	52.66	51.5733	52.64	250650.0
2023-02-15	AAP	Stock	150.23	151.66	150.23	151.29	1094200.0
2023-02-15	AAT	Stock	26.22	26.58	26.22	26.54	186100.0
2023-02-15	AATC	Stock	4.33	4.42	4.25	4.39	11555.0
2023-02-15	AAU-DELISTED	Stock	0.22	0.2259	0.22	0.2228	185724.0
2023-02-15	AAUAF-DELISTED	Stock	0.22	0.2259	0.22	0.2228	189074.0
2023-02-15	AAWW-DELISTED	Stock	102.2	102.23	102.08	102.17	191672.0
2023-02-15	AAXJ	Stock	68.29	68.66	68.15	68.62	533312.0
2023-02-15	AB	Stock	41.57	41.95	40.78	41.93	604300.0
2023-02-15	ABB-DELISTED	Stock	34.09	34.4799	33.965	34.43	1109442.0
2023-02-15	ABBNY-DELISTED	Stock	34.08	34.4799	33.965	34.42	1234185.0
2023-02-15	ABBV	Stock	152.62	153.49	150.83	151.06	5648100.0
2023-02-15	ABC-DELISTED	Stock	156.61	159.26	156.001	158.87	1107985.0
2023-02-15	ABCB	Stock	48.1	49.43	48.1	49.38	238100.0
2023-02-15	ABCL	Stock	9.9	10.21	9.62	9.98	2353100.0
2023-02-15	ABCM-DELISTED	Stock	15.08	15.5	14.85	14.89	1208230.0
2023-02-15	ABEO	Stock	2.4	2.44	2.35	2.38	216800.0
2023-02-15	ABEV	Stock	2.5	2.54	2.48	2.52	13009600.0
2023-02-15	ABG	Stock	228.67	234.41	227.57	234.12	256000.0
2023-02-15	ABGI-DELISTED	Stock	10.17	10.17	10.16	10.16	33576.0
2023-02-15	ABLV	Stock	10.27	10.27	10.25	10.26	52826.0
2023-02-15	ABM	Stock	48.38	49.0	48.38	48.8	256200.0
2023-02-15	ABNB	Stock	130.0	138.75	129.85	137.01	32481900.0
2023-02-15	ABOS	Stock	5.47	5.775	5.39	5.62	53500.0
2023-02-15	ABR	Stock	14.78	15.03	14.73	15.0	1312000.0

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

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