PREVIEW / stock_daily / 2007-08-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-24.parquet
  size:    176 KB
  rows:    5,460
  symbols: 3,286

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
2007-08-24	AAPL	Stock	4.6618	4.8346	4.6361	4.8321	911834000.0
2007-08-24	MSFT	Stock	28.21	28.84	28.07	28.81	45158900.0
2007-08-24	NVDA	Stock	0.7977	0.8057	0.7918	0.8042	361644000.0
2007-08-24	AMZN	Stock	3.84	3.97	3.8345	3.9625	113314000.0
2007-08-24	TLT	Stock	87.77	88.08	87.56	87.85	1614514.0
2007-08-24	CL	Stock	33.455	33.75	33.255	33.73	2298000.0
2007-08-24	A	Stock	24.814	25.2217	24.6924	25.1788	2320960.0
2007-08-24	AABA-DELISTED	Stock	23.03	23.73	23.03	23.59	10588932.0
2007-08-24	AACC-DELISTED	Stock	10.64	10.94	10.53	10.86	112384.0
2007-08-24	AAI-DELISTED	Stock	10.26	10.33	10.12	10.2	996600.0
2007-08-24	AAIC-DELISTED	Stock	88.0	94.08	87.0	93.4	1498400.0
2007-08-24	AAME	Stock	2.94	3.29	2.78	3.06	3900.0
2007-08-24	AAON	Stock	3.9704	4.077	3.9684	4.0573	306787.0
2007-08-24	AAP	Stock	34.22	35.09	34.0	34.96	2032700.0
2007-08-24	AATI-DELISTED	Stock	8.76	9.0	8.76	8.93	296513.0
2007-08-24	AAU-DELISTED	Stock	2.13	2.21	2.12	2.21	37900.0
2007-08-24	AAUAF-DELISTED	Stock	2.13	2.21	2.12	2.21	37400.0
2007-08-24	AAV-DELISTED	Stock	11.6	11.62	11.42	11.5	709900.0
2007-08-24	AAWW-DELISTED	Stock	50.8	51.44	50.73	51.2	84594.0
2007-08-24	AAXN-DELISTED	Stock	13.25	14.1	13.0	14.07	2794271.0
2007-08-24	AB	Stock	83.3	85.15	82.12	84.51	326400.0
2007-08-24	ABAX-DELISTED	Stock	20.15	21.0	20.09	20.93	84463.0
2007-08-24	ABB-DELISTED	Stock	23.32	23.88	23.28	23.87	1485700.0
2007-08-24	ABBC-DELISTED	Stock	9.55	9.59	9.53	9.59	17388.0
2007-08-24	ABBNY-DELISTED	Stock	23.32	23.88	23.28	23.84	1571300.0
2007-08-24	ABC-DELISTED	Stock	24.24	24.32	23.63	23.88	2787200.0
2007-08-24	ABCB	Stock	20.2796	20.5033	19.8516	20.2018	27759.0
2007-08-24	ABCO-DELISTED	Stock	28.28	28.82	28.06	28.63	283231.0
2007-08-24	ABCW-DELISTED	Stock	26.59	27.38	26.48	27.38	83760.0
2007-08-24	ABD-DELISTED	Stock	23.41	23.86	23.21	23.85	273990.0
2007-08-24	ABE-DELISTED	Stock	20.8201	21.75	20.8	21.636	26900.0
2007-08-24	ABEO	Stock	3987.5	4687.5	3750.0	4375.0	7.0
2007-08-24	ABFS-DELISTED	Stock	35.34	36.0	34.97	35.45	333652.0
2007-08-24	ABG	Stock	21.27	21.54	20.98	21.47	233100.0
2007-08-24	ABK-DELISTED	Stock	64.0	64.62	62.77	63.3	2339500.0
2007-08-24	ABM	Stock	23.45	23.74	23.22	23.52	130100.0
2007-08-24	ABMD-DELISTED	Stock	11.19	11.36	10.96	11.33	141255.0
2007-08-24	ABP-DELISTED	Stock	3.63	3.8	3.55	3.76	124000.0
2007-08-24	ABR	Stock	19.98	19.98	19.18	19.56	286200.0
2007-08-24	ABT	Stock	25.0696	25.2759	24.844	25.2039	8809504.0
2007-08-24	ABTL-DELISTED	Stock	16.0	16.3	16.0	16.15	19084.0
2007-08-24	ABV-DELISTED	Stock	64.58	66.83	63.33	66.69	502700.0
2007-08-24	ABVA-DELISTED	Stock	9.89	10.0	9.88	9.94	93583.0
2007-08-24	ABX-DELISTED	Stock	33.14	33.3	32.45	33.07	5303875.0
2007-08-24	ACAD	Stock	14.78	14.97	14.71	14.8	143600.0
2007-08-24	ACAP-DELISTED	Stock	39.5	40.24	39.04	40.19	71050.0
2007-08-24	ACAS-DELISTED	Stock	40.4	41.05	40.11	40.87	1131383.0
2007-08-24	ACAT-DELISTED	Stock	18.21	18.21	17.55	17.69	75578.0
2007-08-24	ACC-DELISTED	Stock	27.7	28.07	27.32	27.9	105815.0
2007-08-24	ACCL-DELISTED	Stock	6.42	6.42	6.25	6.31	29368.0

> showing 50 of 5,460 rows — these rows as CSV

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