PREVIEW / stock_daily / 2007-12-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-26.parquet
  size:    181 KB
  rows:    5,641
  symbols: 3,421

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-12-26	AAPL	Stock	7.1075	7.1771	7.0293	7.1054	703732400.0
2007-12-26	MSFT	Stock	36.41	36.64	36.26	36.61	30252400.0
2007-12-26	NVDA	Stock	0.8963	0.9065	0.8875	0.9065	215340000.0
2007-12-26	AMZN	Stock	4.574	4.697	4.525	4.6425	108844000.0
2007-12-26	TLT	Stock	91.02	91.63	90.28	90.44	674700.0
2007-12-26	CL	Stock	39.0	39.59	39.0	39.495	1757200.0
2007-12-26	A	Stock	26.3233	26.8312	26.3233	26.8026	1954124.0
2007-12-26	AABA-DELISTED	Stock	23.85	24.25	23.85	23.9799	9842184.0
2007-12-26	AACC-DELISTED	Stock	11.04	11.1	10.68	10.97	149365.0
2007-12-26	AAI-DELISTED	Stock	7.82	7.82	7.59	7.64	783280.0
2007-12-26	AAIC-DELISTED	Stock	68.6	71.8	63.4	63.4	1964251.0
2007-12-26	AAME	Stock	1.41	1.43	1.38	1.39	18900.0
2007-12-26	AAON	Stock	4.2943	4.3042	4.1422	4.1699	432337.0
2007-12-26	AAP	Stock	38.25	38.89	38.17	38.61	758800.0
2007-12-26	AATI-DELISTED	Stock	12.0	12.13	11.96	12.11	277657.0
2007-12-26	AAU-DELISTED	Stock	2.5	2.5	2.46	2.5	18935.0
2007-12-26	AAUAF-DELISTED	Stock	2.5	2.5	2.46	2.5	21435.0
2007-12-26	AAV-DELISTED	Stock	9.1	9.11	8.89	9.04	1446739.0
2007-12-26	AAWW-DELISTED	Stock	55.44	55.96	55.27	55.47	49463.0
2007-12-26	AAXN-DELISTED	Stock	15.2	15.27	14.82	15.27	862665.0
2007-12-26	AB	Stock	79.59	80.28	78.12	80.02	134000.0
2007-12-26	ABAX-DELISTED	Stock	39.85	40.0	37.9001	38.94	270158.0
2007-12-26	ABB-DELISTED	Stock	28.63	28.93	28.35	28.78	2670175.0
2007-12-26	ABBC-DELISTED	Stock	9.53	9.57	9.51	9.54	91414.0
2007-12-26	ABBNY-DELISTED	Stock	28.63	28.93	28.35	28.76	2670175.0
2007-12-26	ABC-DELISTED	Stock	22.88	22.9	22.52	22.68	1866652.0
2007-12-26	ABCB	Stock	18.0036	18.0717	17.2742	18.0036	75362.0
2007-12-26	ABCO-DELISTED	Stock	33.57	34.74	33.42	34.49	168408.0
2007-12-26	ABCW-DELISTED	Stock	25.18	25.47	24.85	25.44	93350.0
2007-12-26	ABD-DELISTED	Stock	16.335	16.525	15.994	16.475	242230.0
2007-12-26	ABE-DELISTED	Stock	27.71	27.71	27.4001	27.5	14060.0
2007-12-26	ABEO	Stock	4500.0	4500.0	4125.0	4500.0	7.0
2007-12-26	ABFS-DELISTED	Stock	23.18	23.34	22.6001	22.95	336812.0
2007-12-26	ABG	Stock	15.79	15.92	15.25	15.49	181600.0
2007-12-26	ABII-DELISTED	Stock	66.02	68.5	66.01	68.13	10071.0
2007-12-26	ABK-DELISTED	Stock	26.87	30.32	26.47	30.15	5094728.0
2007-12-26	ABM	Stock	20.85	21.12	20.17	20.87	184500.0
2007-12-26	ABMD-DELISTED	Stock	15.7	15.96	15.54	15.83	202649.0
2007-12-26	ABP-DELISTED	Stock	3.6	3.95	3.53	3.94	386110.0
2007-12-26	ABR	Stock	17.71	18.14	17.3	17.89	239700.0
2007-12-26	ABT	Stock	27.9004	28.1259	27.5981	27.7708	7275740.0
2007-12-26	ABTL-DELISTED	Stock	14.55	14.801	14.299	14.5	16674.0
2007-12-26	ABV-DELISTED	Stock	72.41	73.7	72.41	73.46	330000.0
2007-12-26	ABVA-DELISTED	Stock	7.24	7.24	7.0	7.08	8303.0
2007-12-26	ABVT-DELISTED	Stock	75.0	75.0	75.0	75.0	828.0
2007-12-26	ABX-DELISTED	Stock	39.98	40.37	39.56	39.94	4361287.0
2007-12-26	ACAD	Stock	12.28	12.33	12.09	12.27	199600.0
2007-12-26	ACAP-DELISTED	Stock	44.07	45.24	43.04	43.2	93644.0
2007-12-26	ACAS-DELISTED	Stock	34.65	34.73	33.86	34.25	1746614.0
2007-12-26	ACAT-DELISTED	Stock	12.74	12.9	12.67	12.72	146879.0

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

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