PREVIEW / stock_daily / 2007-10-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-24.parquet
  size:    179 KB
  rows:    5,546
  symbols: 3,354

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-10-24	AAPL	Stock	6.6361	6.6861	6.4014	6.6404	1288481600.0
2007-10-24	MSFT	Stock	30.85	31.3	30.5	31.25	77979200.0
2007-10-24	NVDA	Stock	0.9625	0.9625	0.9038	0.9505	565500000.0
2007-10-24	AMZN	Stock	4.5435	4.544	4.1635	4.4365	832348000.0
2007-10-24	TLT	Stock	90.71	91.39	90.56	91.02	2829300.0
2007-10-24	CL	Stock	36.34	36.905	36.315	36.865	6451800.0
2007-10-24	A	Stock	26.5165	26.6953	26.0515	26.3948	3712948.0
2007-10-24	AABA-DELISTED	Stock	30.67	30.98	30.0	30.68	33677950.0
2007-10-24	AACC-DELISTED	Stock	10.91	11.0	10.67	11.0	170082.0
2007-10-24	AAI-DELISTED	Stock	9.62	9.8	9.45	9.48	2003300.0
2007-10-24	AAIC-DELISTED	Stock	89.4	90.6	84.6	85.2	3167400.0
2007-10-24	AAME	Stock	2.45	2.45	2.35	2.44	2500.0
2007-10-24	AAON	Stock	3.358	3.3817	3.2691	3.362	322481.0
2007-10-24	AAP	Stock	31.68	33.65	31.53	33.58	1996100.0
2007-10-24	AATI-DELISTED	Stock	11.95	11.95	11.37	11.71	615961.0
2007-10-24	AAU-DELISTED	Stock	2.86	2.86	2.7	2.72	82100.0
2007-10-24	AAUAF-DELISTED	Stock	2.86	2.86	2.7	2.72	82100.0
2007-10-24	AAV-DELISTED	Stock	12.73	12.84	12.62	12.79	541800.0
2007-10-24	AAWW-DELISTED	Stock	57.08	57.8	56.3	57.53	154508.0
2007-10-24	AAXN-DELISTED	Stock	17.97	18.44	15.0	17.18	9312288.0
2007-10-24	AB	Stock	88.29	88.9	86.01	88.17	238500.0
2007-10-24	ABAX-DELISTED	Stock	24.55	24.65	23.851	24.19	208246.0
2007-10-24	ABB-DELISTED	Stock	27.8	28.0	27.31	28.0	3058700.0
2007-10-24	ABBC-DELISTED	Stock	9.36	9.5	9.23	9.31	35275.0
2007-10-24	ABBNY-DELISTED	Stock	27.8	28.0	27.31	28.0	3058700.0
2007-10-24	ABC-DELISTED	Stock	22.44	22.44	21.75	22.22	2652400.0
2007-10-24	ABCB	Stock	16.6322	17.0018	16.5349	16.7003	47294.0
2007-10-24	ABCO-DELISTED	Stock	30.53	30.95	30.36	30.92	178156.0
2007-10-24	ABCW-DELISTED	Stock	24.13	24.91	23.82	24.23	69490.0
2007-10-24	ABD-DELISTED	Stock	20.99	21.21	20.01	20.74	452980.0
2007-10-24	ABE-DELISTED	Stock	26.96	26.96	25.65	26.43	30500.0
2007-10-24	ABEO	Stock	4450.0	4812.5	4437.5	4812.5	5.0
2007-10-24	ABFS-DELISTED	Stock	31.42	31.98	30.64	31.21	545275.0
2007-10-24	ABG	Stock	19.35	19.85	18.75	19.34	444700.0
2007-10-24	ABK-DELISTED	Stock	54.99	55.01	49.05	51.03	10847900.0
2007-10-24	ABM	Stock	22.7	22.86	22.26	22.66	339600.0
2007-10-24	ABMD-DELISTED	Stock	12.9	12.91	12.35	12.77	142226.0
2007-10-24	ABP-DELISTED	Stock	4.24	4.25	4.08	4.21	121100.0
2007-10-24	ABR	Stock	18.58	18.7	18.0	18.24	205000.0
2007-10-24	ABT	Stock	24.9544	25.4054	24.6425	25.3622	17224885.0
2007-10-24	ABTL-DELISTED	Stock	14.229	14.637	12.75	12.75	29293.0
2007-10-24	ABV-DELISTED	Stock	78.25	79.63	77.22	78.54	707300.0
2007-10-24	ABVA-DELISTED	Stock	9.53	9.6	9.4	9.4	4584.0
2007-10-24	ABVT-DELISTED	Stock	82.5	85.0	82.5	84.95	8166.0
2007-10-24	ABX-DELISTED	Stock	41.67	42.1	40.61	41.88	5322400.0
2007-10-24	ACAD	Stock	15.01	15.38	14.93	15.38	153100.0
2007-10-24	ACAP-DELISTED	Stock	40.03	40.82	38.45	40.29	119569.0
2007-10-24	ACAS-DELISTED	Stock	42.3	42.4	40.54	41.44	1657736.0
2007-10-24	ACAT-DELISTED	Stock	15.14	16.4464	15.14	16.32	372463.0
2007-10-24	ACC-DELISTED	Stock	27.9	27.92	27.06	27.7	134721.0

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

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