PREVIEW / stock_daily / 2007-10-30

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-30.parquet
  size:    179 KB
  rows:    5,543
  symbols: 3,353

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-30	AAPL	Stock	6.6493	6.7632	6.5975	6.6786	939414000.0
2007-10-30	MSFT	Stock	34.37	35.59	34.35	35.57	107297300.0
2007-10-30	NVDA	Stock	0.8465	0.8883	0.8325	0.8705	525212000.0
2007-10-30	AMZN	Stock	4.4835	4.5325	4.4025	4.412	108108000.0
2007-10-30	TLT	Stock	90.73	91.01	90.42	90.8	1439600.0
2007-10-30	CL	Stock	37.0	38.195	36.655	37.63	12118600.0
2007-10-30	A	Stock	25.6652	25.8798	25.372	25.6509	1676761.0
2007-10-30	AABA-DELISTED	Stock	31.55	31.64	30.12	30.84	52417261.0
2007-10-30	AACC-DELISTED	Stock	11.0	11.04	10.9	10.9	591396.0
2007-10-30	AAI-DELISTED	Stock	9.75	10.26	9.72	10.15	2985100.0
2007-10-30	AAIC-DELISTED	Stock	83.4	85.8	82.2	82.6	1174100.0
2007-10-30	AAME	Stock	2.45	2.45	2.05	2.19	10600.0
2007-10-30	AAON	Stock	3.52	3.52	3.4568	3.4904	347794.0
2007-10-30	AAP	Stock	34.0	34.55	33.81	34.26	1187400.0
2007-10-30	AATI-DELISTED	Stock	12.33	12.56	11.53	11.95	2519229.0
2007-10-30	AAU-DELISTED	Stock	3.08	3.09	3.0	3.05	65600.0
2007-10-30	AAUAF-DELISTED	Stock	3.08	3.09	3.0	3.05	65600.0
2007-10-30	AAV-DELISTED	Stock	12.54	12.55	12.35	12.41	650700.0
2007-10-30	AAWW-DELISTED	Stock	57.93	58.68	57.24	58.17	188049.0
2007-10-30	AAXN-DELISTED	Stock	16.25	16.4277	15.9	15.99	1750927.0
2007-10-30	AB	Stock	83.88	84.4	82.5	83.65	133800.0
2007-10-30	ABAX-DELISTED	Stock	29.29	29.5	28.01	28.13	305360.0
2007-10-30	ABB-DELISTED	Stock	29.99	30.13	29.87	29.89	3040700.0
2007-10-30	ABBC-DELISTED	Stock	9.41	9.57	9.32	9.34	45816.0
2007-10-30	ABBNY-DELISTED	Stock	29.99	30.13	29.87	29.9	3040700.0
2007-10-30	ABC-DELISTED	Stock	22.31	22.54	22.24	22.34	1355800.0
2007-10-30	ABCB	Stock	17.0115	17.0504	16.3307	16.4182	48014.0
2007-10-30	ABCO-DELISTED	Stock	30.97	31.87	30.97	31.55	258477.0
2007-10-30	ABCW-DELISTED	Stock	24.86	25.74	24.38	24.48	69270.0
2007-10-30	ABD-DELISTED	Stock	20.98	21.22	20.7	20.88	445350.0
2007-10-30	ABE-DELISTED	Stock	27.69	27.85	27.12	27.74	33500.0
2007-10-30	ABEO	Stock	4250.0	4312.5	3875.0	4250.0	10.0
2007-10-30	ABFS-DELISTED	Stock	28.3	28.53	26.84	27.0	1532609.0
2007-10-30	ABG	Stock	18.55	18.72	17.51	18.12	1207800.0
2007-10-30	ABK-DELISTED	Stock	41.35	42.66	39.39	39.96	5177300.0
2007-10-30	ABM	Stock	23.63	23.92	22.95	23.2	367300.0
2007-10-30	ABMD-DELISTED	Stock	13.68	13.73	13.36	13.53	136606.0
2007-10-30	ABP-DELISTED	Stock	4.53	4.54	4.4	4.41	142900.0
2007-10-30	ABR	Stock	18.75	18.78	18.16	18.26	221200.0
2007-10-30	ABT	Stock	26.0292	26.2595	25.9716	26.2211	13158608.0
2007-10-30	ABTL-DELISTED	Stock	12.798	13.405	12.748	12.95	10520.0
2007-10-30	ABV-DELISTED	Stock	80.32	81.87	80.25	81.0	673192.0
2007-10-30	ABVA-DELISTED	Stock	9.43	9.43	9.17	9.194	1950.0
2007-10-30	ABX-DELISTED	Stock	43.04	43.48	42.37	42.4	8033800.0
2007-10-30	ACAD	Stock	15.16	15.39	15.1	15.17	101300.0
2007-10-30	ACAP-DELISTED	Stock	42.29	44.88	42.29	43.65	112890.0
2007-10-30	ACAS-DELISTED	Stock	42.0	42.25	41.26	41.5	1295732.0
2007-10-30	ACAT-DELISTED	Stock	14.75	14.78	14.36	14.38	140922.0
2007-10-30	ACC-DELISTED	Stock	28.27	28.93	28.11	28.41	295500.0
2007-10-30	ACCL-DELISTED	Stock	7.65	7.75	7.41	7.63	114926.0

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

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