PREVIEW / stock_daily / 2007-07-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-24.parquet
  size:    178 KB
  rows:    5,468
  symbols: 3,293

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-07-24	AAPL	Stock	4.96	5.0357	4.7911	4.8175	1795292800.0
2007-07-24	MSFT	Stock	31.01	31.48	30.71	30.8	59729300.0
2007-07-24	NVDA	Stock	0.7562	0.7625	0.7345	0.7392	457560000.0
2007-07-24	AMZN	Stock	3.552	3.608	3.4425	3.4625	506846000.0
2007-07-24	TLT	Stock	86.01	86.16	85.72	86.14	1351575.0
2007-07-24	CL	Stock	34.175	34.68	33.985	34.125	7586600.0
2007-07-24	A	Stock	28.6123	28.9127	27.9328	28.0329	2915948.0
2007-07-24	AABA-DELISTED	Stock	24.8	25.34	24.73	24.87	27942753.0
2007-07-24	AACC-DELISTED	Stock	14.96	15.1099	14.38	14.39	183646.0
2007-07-24	AAI-DELISTED	Stock	10.21	10.45	10.17	10.2	1474221.0
2007-07-24	AAIC-DELISTED	Stock	97.2	98.6	92.6	92.8	3272503.0
2007-07-24	AAON	Stock	4.2851	4.297	4.1534	4.1626	499669.0
2007-07-24	AAP	Stock	38.54	38.71	38.33	38.52	912500.0
2007-07-24	AATI-DELISTED	Stock	9.8	9.98	9.4	9.47	397403.0
2007-07-24	AAU-DELISTED	Stock	2.75	2.75	2.7	2.71	77600.0
2007-07-24	AAUAF-DELISTED	Stock	2.75	2.75	2.7	2.71	81400.0
2007-07-24	AAV-DELISTED	Stock	13.28	13.41	12.68	12.75	1990100.0
2007-07-24	AAWW-DELISTED	Stock	58.31	58.82	57.16	58.02	126511.0
2007-07-24	AAXN-DELISTED	Stock	16.07	16.07	14.75	15.25	11047674.0
2007-07-24	AB	Stock	86.4	87.1	82.01	83.5	343100.0
2007-07-24	ABAX-DELISTED	Stock	18.5	18.92	18.5	18.87	330454.0
2007-07-24	ABB-DELISTED	Stock	23.9	24.01	23.45	23.54	2894300.0
2007-07-24	ABBC-DELISTED	Stock	9.57	9.65	9.31	9.35	66915.0
2007-07-24	ABBNY-DELISTED	Stock	23.9	24.01	23.45	23.54	2904500.0
2007-07-24	ABC-DELISTED	Stock	24.4	24.96	24.4	24.63	2712164.0
2007-07-24	ABCB	Stock	19.6473	19.7057	18.3343	18.6067	77624.0
2007-07-24	ABCO-DELISTED	Stock	27.36	27.54	26.96	27.01	352420.0
2007-07-24	ABCW-DELISTED	Stock	23.05	23.08	22.09	22.41	202360.0
2007-07-24	ABD-DELISTED	Stock	21.6	21.6	20.98	21.0	288400.0
2007-07-24	ABE-DELISTED	Stock	22.75	22.9	22.54	22.62	18900.0
2007-07-24	ABEO	Stock	5387.5	5625.0	5387.5	5625.0	12.0
2007-07-24	ABFS-DELISTED	Stock	38.0	38.04	36.44	36.61	1000388.0
2007-07-24	ABG	Stock	23.31	23.42	22.96	23.24	527700.0
2007-07-24	ABK-DELISTED	Stock	82.06	82.06	76.14	76.68	3592600.0
2007-07-24	ABM	Stock	23.98	24.09	22.96	23.02	356300.0
2007-07-24	ABMD-DELISTED	Stock	10.62	10.88	10.5	10.67	354236.0
2007-07-24	ABP-DELISTED	Stock	4.07	4.11	3.9	3.99	537400.0
2007-07-24	ABR	Stock	23.8	24.16	23.3	23.46	255800.0
2007-07-24	ABT	Stock	25.5254	26.0052	25.0456	25.1943	18363068.0
2007-07-24	ABTL-DELISTED	Stock	20.35	20.35	18.55	18.9	63039.0
2007-07-24	ABV-DELISTED	Stock	75.95	76.46	73.53	73.89	594800.0
2007-07-24	ABVA-DELISTED	Stock	12.43	12.51	12.37	12.49	3540.0
2007-07-24	ABVT-DELISTED	Stock	73.0	73.78	72.0	73.75	31100.0
2007-07-24	ABX-DELISTED	Stock	34.86	34.9	34.16	34.24	8062533.0
2007-07-24	ACAD	Stock	13.55	13.85	13.55	13.69	284400.0
2007-07-24	ACAP-DELISTED	Stock	38.06	38.32	37.55	37.88	98839.0
2007-07-24	ACAS-DELISTED	Stock	43.0	43.106	41.0701	41.27	4000496.0
2007-07-24	ACAT-DELISTED	Stock	19.41	19.54	18.27	18.42	180918.0
2007-07-24	ACC-DELISTED	Stock	26.76	27.1	26.32	26.53	187400.0
2007-07-24	ACCL-DELISTED	Stock	7.02	7.25	6.81	6.85	115751.0

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

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