PREVIEW / stock_daily / 2007-10-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-26.parquet
  size:    179 KB
  rows:    5,548
  symbols: 3,355

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-26	AAPL	Stock	6.6175	6.6204	6.5314	6.5964	706876800.0
2007-10-26	MSFT	Stock	36.01	36.03	34.56	35.03	288121200.0
2007-10-26	NVDA	Stock	0.895	0.901	0.8475	0.86	616580000.0
2007-10-26	AMZN	Stock	4.45	4.544	4.385	4.5	176524000.0
2007-10-26	TLT	Stock	90.37	91.0	90.34	90.5	1366471.0
2007-10-26	CL	Stock	37.135	37.215	36.645	36.975	3752600.0
2007-10-26	A	Stock	26.1874	26.4664	25.3505	25.7725	1818379.0
2007-10-26	AABA-DELISTED	Stock	32.43	33.99	31.61	33.66	66166427.0
2007-10-26	AACC-DELISTED	Stock	10.02	10.84	9.45	10.81	835309.0
2007-10-26	AAI-DELISTED	Stock	9.39	9.64	9.06	9.64	1894700.0
2007-10-26	AAIC-DELISTED	Stock	83.7	86.6	81.0	86.2	3069100.0
2007-10-26	AAME	Stock	2.56	2.57	2.36	2.41	12000.0
2007-10-26	AAON	Stock	3.358	3.5635	3.3244	3.5141	506756.0
2007-10-26	AAP	Stock	34.5	34.73	33.82	34.03	823700.0
2007-10-26	AATI-DELISTED	Stock	11.2	11.44	10.95	11.23	527983.0
2007-10-26	AAU-DELISTED	Stock	2.86	2.95	2.84	2.88	105600.0
2007-10-26	AAUAF-DELISTED	Stock	2.86	2.95	2.84	2.88	105600.0
2007-10-26	AAV-DELISTED	Stock	12.68	12.85	12.55	12.85	737500.0
2007-10-26	AAWW-DELISTED	Stock	57.91	58.33	57.16	58.14	194007.0
2007-10-26	AAXN-DELISTED	Stock	16.93	17.0	16.21	16.61	2126102.0
2007-10-26	AB	Stock	84.35	84.35	80.55	83.92	444500.0
2007-10-26	ABAX-DELISTED	Stock	29.84	30.0	29.01	29.68	942525.0
2007-10-26	ABB-DELISTED	Stock	29.94	29.97	29.5	29.67	3443200.0
2007-10-26	ABBC-DELISTED	Stock	9.48	9.57	9.31	9.48	21416.0
2007-10-26	ABBNY-DELISTED	Stock	29.94	29.97	29.5	29.67	3443200.0
2007-10-26	ABC-DELISTED	Stock	22.6	22.66	22.06	22.27	1555200.0
2007-10-26	ABCB	Stock	16.7392	17.2547	16.6127	17.1671	26834.0
2007-10-26	ABCO-DELISTED	Stock	30.48	31.02	30.08	31.02	308130.0
2007-10-26	ABCW-DELISTED	Stock	24.51	25.34	24.39	25.34	63400.0
2007-10-26	ABD-DELISTED	Stock	21.0	21.27	20.7	21.17	700550.0
2007-10-26	ABE-DELISTED	Stock	27.89	27.89	27.01	27.27	71100.0
2007-10-26	ABEO	Stock	4562.5	4750.0	4562.5	4750.0	4.0
2007-10-26	ABFS-DELISTED	Stock	29.92	31.68	29.77	30.88	817493.0
2007-10-26	ABG	Stock	19.31	19.45	18.97	19.27	214400.0
2007-10-26	ABK-DELISTED	Stock	46.53	47.63	36.34	44.3	14593306.0
2007-10-26	ABM	Stock	22.88	23.37	22.8	23.34	263000.0
2007-10-26	ABMD-DELISTED	Stock	13.46	13.5	13.1	13.48	138925.0
2007-10-26	ABP-DELISTED	Stock	4.26	4.4	4.26	4.4	145700.0
2007-10-26	ABR	Stock	18.8	19.05	18.5	18.73	243900.0
2007-10-26	ABT	Stock	26.0387	26.0771	25.8564	25.9428	11847020.0
2007-10-26	ABTL-DELISTED	Stock	12.237	12.563	12.162	12.513	27423.0
2007-10-26	ABV-DELISTED	Stock	78.1	79.35	77.75	78.96	536600.0
2007-10-26	ABVA-DELISTED	Stock	10.23	10.23	9.52	9.72	2227.0
2007-10-26	ABVT-DELISTED	Stock	85.0	86.0	84.95	85.0	40120.0
2007-10-26	ABX-DELISTED	Stock	42.98	43.32	42.66	43.02	5736800.0
2007-10-26	ACAD	Stock	15.29	15.54	15.05	15.54	147600.0
2007-10-26	ACAP-DELISTED	Stock	42.33	44.9	41.61	44.43	114269.0
2007-10-26	ACAS-DELISTED	Stock	41.43	42.07	41.17	41.99	1260669.0
2007-10-26	ACAT-DELISTED	Stock	15.84	15.98	15.02	15.07	208073.0
2007-10-26	ACC-DELISTED	Stock	28.27	28.68	27.76	28.58	143002.0

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

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