PREVIEW / stock_daily / 2007-11-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-26.parquet
  size:    180 KB
  rows:    5,615
  symbols: 3,408

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-11-26	AAPL	Stock	6.1996	6.3311	6.1554	6.1621	1305754800.0
2007-11-26	MSFT	Stock	34.09	34.37	32.93	32.97	80335000.0
2007-11-26	NVDA	Stock	0.755	0.7705	0.7365	0.738	385896000.0
2007-11-26	AMZN	Stock	4.115	4.2245	4.057	4.065	172210000.0
2007-11-26	TLT	Stock	94.22	96.36	94.12	95.58	4426981.0
2007-11-26	CL	Stock	39.5	39.86	39.11	39.11	5513000.0
2007-11-26	A	Stock	26.3519	26.8741	26.1373	26.1373	3260416.0
2007-11-26	AABA-DELISTED	Stock	26.13	26.25	25.2	25.25	24178024.0
2007-11-26	AACC-DELISTED	Stock	11.04	11.27	10.98	11.17	221689.0
2007-11-26	AAI-DELISTED	Stock	8.52	8.54	8.17	8.18	1494700.0
2007-11-26	AAIC-DELISTED	Stock	59.2	60.4	52.4	54.6	2480824.0
2007-11-26	AAME	Stock	1.79	1.85	1.67	1.72	11900.0
2007-11-26	AAON	Stock	3.7057	3.8025	3.5042	3.5101	633825.0
2007-11-26	AAP	Stock	34.16	34.3	33.3	33.37	836300.0
2007-11-26	AATI-DELISTED	Stock	10.48	10.7	9.99	10.09	530902.0
2007-11-26	AAU-DELISTED	Stock	2.9	2.9	2.53	2.56	117500.0
2007-11-26	AAUAF-DELISTED	Stock	2.9	2.9	2.53	2.56	121500.0
2007-11-26	AAV-DELISTED	Stock	10.93	11.14	10.93	10.98	720851.0
2007-11-26	AAWW-DELISTED	Stock	53.99	54.06	52.05	52.31	130500.0
2007-11-26	AAXN-DELISTED	Stock	12.78	13.25	12.6058	12.67	2227375.0
2007-11-26	AB	Stock	77.49	79.32	76.8	77.05	804200.0
2007-11-26	ABAX-DELISTED	Stock	32.04	32.5	30.7	30.81	353834.0
2007-11-26	ABB-DELISTED	Stock	27.88	28.0	27.0	27.04	4241790.0
2007-11-26	ABBC-DELISTED	Stock	9.23	9.24	8.98	8.98	37426.0
2007-11-26	ABBNY-DELISTED	Stock	27.88	28.0	27.0	27.07	4241690.0
2007-11-26	ABC-DELISTED	Stock	21.8	22.08	21.78	21.78	2796800.0
2007-11-26	ABCB	Stock	14.2492	14.5118	13.6559	13.7629	48014.0
2007-11-26	ABCO-DELISTED	Stock	32.26	32.26	31.27	31.27	166135.0
2007-11-26	ABCW-DELISTED	Stock	24.62	24.74	23.89	24.09	148650.0
2007-11-26	ABD-DELISTED	Stock	18.386	18.616	16.894	16.924	409280.0
2007-11-26	ABE-DELISTED	Stock	24.2	25.58	24.0801	24.0801	28120.0
2007-11-26	ABEO	Stock	3437.5	3625.0	3437.5	3500.0	11.0
2007-11-26	ABFS-DELISTED	Stock	22.38	22.82	21.9	21.9	475631.0
2007-11-26	ABG	Stock	17.48	17.54	16.26	16.43	769300.0
2007-11-26	ABII-DELISTED	Stock	55.77	57.0	55.77	56.9	58981.0
2007-11-26	ABK-DELISTED	Stock	25.89	25.89	23.72	23.96	4574134.0
2007-11-26	ABM	Stock	19.89	20.11	19.35	19.4	166800.0
2007-11-26	ABMD-DELISTED	Stock	12.37	12.38	11.83	11.93	159156.0
2007-11-26	ABP-DELISTED	Stock	3.55	3.67	3.41	3.41	135850.0
2007-11-26	ABR	Stock	17.41	17.5	16.61	16.82	205000.0
2007-11-26	ABT	Stock	26.5713	26.6433	25.962	26.0292	9097957.0
2007-11-26	ABTL-DELISTED	Stock	14.744	15.859	14.744	15.2	12293.0
2007-11-26	ABV-DELISTED	Stock	69.0	69.5	65.66	65.84	857000.0
2007-11-26	ABVA-DELISTED	Stock	7.81	7.82	7.81	7.82	1900.0
2007-11-26	ABVT-DELISTED	Stock	80.0	82.0	75.0	79.52	16659.0
2007-11-26	ABX-DELISTED	Stock	43.31	43.46	41.6	41.67	6543927.0
2007-11-26	ACAD	Stock	10.26	10.44	9.95	9.99	252700.0
2007-11-26	ACAP-DELISTED	Stock	42.1	42.84	40.63	41.14	72626.0
2007-11-26	ACAS-DELISTED	Stock	38.14	38.14	35.35	35.35	3895923.0
2007-11-26	ACAT-DELISTED	Stock	12.21	12.35	11.45	11.45	93843.0

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

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