PREVIEW / stock_daily / 2023-06-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-27.parquet
  size:    241 KB
  rows:    7,507
  symbols: 1,584

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-06-27	AAPL	Stock	185.89	188.39	185.67	188.06	50730800.0
2023-06-27	MSFT	Stock	331.86	336.15	329.3	334.57	24354100.0
2023-06-27	NVDA	Stock	40.799	41.94	40.448	41.876	462175000.0
2023-06-27	AMZN	Stock	128.63	130.09	127.55	129.18	46801000.0
2023-06-27	GOOGL	Stock	117.08	119.08	116.1	118.33	39535936.0
2023-06-27	META	Stock	282.01	289.35	280.65	287.05	26108300.0
2023-06-27	TSLA	Stock	243.24	250.39	240.85	250.21	164968200.0
2023-06-27	TLT	Stock	103.59	103.95	102.76	103.17	18105686.0
2023-06-27	ES	Stock	71.09	71.54	70.78	71.31	1902000.0
2023-06-27	CL	Stock	76.41	76.62	75.62	75.73	7488500.0
2023-06-27	A	Stock	118.47	118.96	116.73	117.04	2326100.0
2023-06-27	AA	Stock	33.49	34.525	33.03	34.43	4130400.0
2023-06-27	AAC-DELISTED	Stock	10.52	10.55	10.52	10.55	1777760.0
2023-06-27	AACG	Stock	1.35	1.4	1.35	1.39	4100.0
2023-06-27	AACIW-DELISTED	Stock	0.125	0.1251	0.125	0.1251	1380.0
2023-06-27	AACT	Stock	10.14	10.16	10.14	10.15	225168.0
2023-06-27	AAIC-DELISTED	Stock	4.4	4.49	4.38	4.48	180057.0
2023-06-27	AAIC.C-DELISTED	Stock	22.775	22.775	22.72	22.72	2091.0
2023-06-27	AAL	Stock	16.53	17.48	16.52	17.35	42031500.0
2023-06-27	AAM.A-DELISTED	Stock	22.87	23.19	22.87	22.92	7889.0
2023-06-27	AAM.B-DELISTED	Stock	22.85	22.95	22.51	22.6195	12176.0
2023-06-27	AAMC-DELISTED	Stock	16.5529	16.5529	15.7353	15.7794	33925.0
2023-06-27	AAME	Stock	2.01	2.01	1.95	1.98	13000.0
2023-06-27	AAMI	Stock	20.33	20.61	20.11	20.51	142900.0
2023-06-27	AAN-DELISTED	Stock	12.88	13.88	12.8	13.86	232300.0
2023-06-27	AAOI	Stock	4.72	4.99	4.6	4.85	1406300.0
2023-06-27	AAON	Stock	63.74	65.0667	63.74	64.26	495600.0
2023-06-27	AAP	Stock	67.62	68.75	66.5	68.32	1653900.0
2023-06-27	AAT	Stock	18.82	19.38	18.56	19.2	378400.0
2023-06-27	AATC	Stock	4.36	4.47	4.36	4.47	6425.0
2023-06-27	AAU-DELISTED	Stock	0.1317	0.1317	0.128	0.1281	237494.0
2023-06-27	AAUAF-DELISTED	Stock	0.1317	0.1317	0.128	0.1281	242173.0
2023-06-27	AAXJ	Stock	66.38	66.875	66.38	66.82	247477.0
2023-06-27	AB	Stock	32.02	32.17	31.67	31.78	222800.0
2023-06-27	ABBNY-DELISTED	Stock	38.61	39.19	38.54	39.0	242918.0
2023-06-27	ABBV	Stock	134.88	134.88	132.52	132.6	7839900.0
2023-06-27	ABC-DELISTED	Stock	185.04	189.1	183.672	188.76	870054.0
2023-06-27	ABCB	Stock	34.05	34.96	33.44	34.36	301000.0
2023-06-27	ABCL	Stock	6.89	6.89	6.35	6.35	4363800.0
2023-06-27	ABCM-DELISTED	Stock	23.21	24.06	22.98	23.62	2970980.0
2023-06-27	ABEO	Stock	4.7	4.79	4.52	4.67	130200.0
2023-06-27	ABEV	Stock	3.21	3.21	3.13	3.19	19716500.0
2023-06-27	ABG	Stock	229.0	238.14	228.67	235.9	112700.0
2023-06-27	ABLV	Stock	10.62	10.62	10.62	10.62	4400.0
2023-06-27	ABM	Stock	41.47	42.04	41.27	41.5	295900.0
2023-06-27	ABNB	Stock	124.41	128.17	123.32	127.89	4507700.0
2023-06-27	ABOS	Stock	4.95	4.95	4.57	4.77	82500.0
2023-06-27	ABR	Stock	14.07	14.44	13.94	14.3	3344400.0
2023-06-27	ABR.D	Stock	18.14	18.25	18.08	18.19	7824.0
2023-06-27	ABR.E	Stock	18.18	18.18	17.88	18.1	6006.0

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

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