PREVIEW / stock_daily / 2007-07-11

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-11.parquet
  size:    178 KB
  rows:    5,458
  symbols: 3,281

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-11	AAPL	Stock	4.7168	4.775	4.6896	4.7282	821772000.0
2007-07-11	MSFT	Stock	29.24	29.65	29.21	29.49	48017000.0
2007-07-11	NVDA	Stock	0.7578	0.763	0.7442	0.7547	582612000.0
2007-07-11	AMZN	Stock	3.529	3.5825	3.5075	3.5365	131872000.0
2007-07-11	TLT	Stock	84.95	85.09	84.32	84.32	1191300.0
2007-07-11	CL	Stock	32.75	33.495	32.75	33.445	4498600.0
2007-07-11	A	Stock	28.2546	28.5408	28.2546	28.5336	2538488.0
2007-07-11	AABA-DELISTED	Stock	27.03	27.05	26.55	26.68	21201558.0
2007-07-11	AACC-DELISTED	Stock	17.26	17.53	17.25	17.32	176680.0
2007-07-11	AAI-DELISTED	Stock	10.76	10.78	10.57	10.64	1687400.0
2007-07-11	AAIC-DELISTED	Stock	104.0	104.4	100.6	101.8	2189100.0
2007-07-11	AAME	Stock	4.05	4.09	4.02	4.09	9600.0
2007-07-11	AAON	Stock	4.1297	4.1508	4.0823	4.1508	207309.0
2007-07-11	AAP	Stock	40.35	40.67	39.95	40.0	929400.0
2007-07-11	AATI-DELISTED	Stock	9.61	9.72	9.42	9.5	326749.0
2007-07-11	AAU-DELISTED	Stock	2.8	2.8	2.66	2.68	66100.0
2007-07-11	AAUAF-DELISTED	Stock	2.8	2.8	2.66	2.68	66100.0
2007-07-11	AAV-DELISTED	Stock	13.95	13.95	13.74	13.82	919400.0
2007-07-11	AAWW-DELISTED	Stock	59.11	59.58	58.8	59.42	73087.0
2007-07-11	AAXN-DELISTED	Stock	16.36	16.65	16.05	16.16	4258153.0
2007-07-11	AB	Stock	86.86	89.69	86.5	89.35	394700.0
2007-07-11	ABAX-DELISTED	Stock	20.21	20.42	19.98	19.98	137175.0
2007-07-11	ABB-DELISTED	Stock	23.85	24.4	23.85	24.31	3443500.0
2007-07-11	ABBC-DELISTED	Stock	9.745	9.775	9.635	9.735	54242.0
2007-07-11	ABBNY-DELISTED	Stock	23.85	24.4	23.85	24.31	4210100.0
2007-07-11	ABC-DELISTED	Stock	24.35	24.48	24.29	24.45	2494600.0
2007-07-11	ABCB	Stock	21.8163	22.0887	21.6802	21.7191	61379.0
2007-07-11	ABCO-DELISTED	Stock	27.92	28.15	27.86	28.02	103666.0
2007-07-11	ABCW-DELISTED	Stock	24.86	25.0	24.68	24.74	171090.0
2007-07-11	ABD-DELISTED	Stock	23.0	23.07	22.7	22.83	435130.0
2007-07-11	ABE-DELISTED	Stock	21.65	21.84	21.65	21.81	5400.0
2007-07-11	ABEO	Stock	6362.5	6412.5	6125.0	6412.5	2.0
2007-07-11	ABFS-DELISTED	Stock	39.45	39.92	39.25	39.71	194705.0
2007-07-11	ABG	Stock	24.2	24.39	24.07	24.23	243500.0
2007-07-11	ABK-DELISTED	Stock	82.5	84.09	81.93	83.9	2272100.0
2007-07-11	ABM	Stock	25.44	25.59	25.24	25.47	176100.0
2007-07-11	ABMD-DELISTED	Stock	10.38	10.44	9.95	10.15	216359.0
2007-07-11	ABP-DELISTED	Stock	4.48	4.5	4.4	4.48	299500.0
2007-07-11	ABR	Stock	25.2	25.31	24.8	24.95	105800.0
2007-07-11	ABT	Stock	25.367	25.5781	25.2039	25.5302	16503126.0
2007-07-11	ABTL-DELISTED	Stock	21.67	21.93	21.62	21.78	18750.0
2007-07-11	ABV-DELISTED	Stock	72.05	73.66	72.05	73.4	398700.0
2007-07-11	ABVA-DELISTED	Stock	12.49	12.98	12.49	12.72	60400.0
2007-07-11	ABVT-DELISTED	Stock	64.0	66.25	64.0	66.25	39324.0
2007-07-11	ABX-DELISTED	Stock	31.23	31.36	30.77	31.01	5971000.0
2007-07-11	ACAD	Stock	13.5	13.57	13.3	13.53	317000.0
2007-07-11	ACAP-DELISTED	Stock	39.06	39.39	38.12	38.55	49997.0
2007-07-11	ACAS-DELISTED	Stock	45.09	45.14	44.45	44.94	3029804.0
2007-07-11	ACAT-DELISTED	Stock	20.43	20.63	20.28	20.34	58973.0
2007-07-11	ACC-DELISTED	Stock	28.83	28.95	28.37	28.46	133581.0

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

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