PREVIEW / stock_daily / 2007-09-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-05.parquet
  size:    177 KB
  rows:    5,461
  symbols: 3,291

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-09-05	AAPL	Stock	5.1775	5.2086	4.8607	4.8843	2328222400.0
2007-09-05	MSFT	Stock	28.65	28.73	28.42	28.48	47669800.0
2007-09-05	NVDA	Stock	0.8752	0.9	0.8717	0.8723	656274000.0
2007-09-05	AMZN	Stock	4.112	4.2445	4.111	4.1875	181244000.0
2007-09-05	TLT	Stock	88.76	89.35	88.72	89.27	1271500.0
2007-09-05	CL	Stock	32.75	32.98	32.5	32.685	4182000.0
2007-09-05	A	Stock	25.8298	25.8941	25.6509	25.8655	2916927.0
2007-09-05	AABA-DELISTED	Stock	24.03	24.4	23.91	24.0899	20355869.0
2007-09-05	AACC-DELISTED	Stock	11.2	11.2	10.85	11.01	164090.0
2007-09-05	AAI-DELISTED	Stock	10.75	10.9	10.1	10.76	1375700.0
2007-09-05	AAIC-DELISTED	Stock	95.4	95.6	91.8	92.4	931600.0
2007-09-05	AAME	Stock	2.82	3.01	2.8	2.99	8200.0
2007-09-05	AAON	Stock	4.3852	4.3852	4.0099	4.0869	806962.0
2007-09-05	AAP	Stock	35.14	35.14	34.4	34.47	1180200.0
2007-09-05	AATI-DELISTED	Stock	9.23	9.44	9.164	9.35	161976.0
2007-09-05	AAU-DELISTED	Stock	2.14	2.14	2.1	2.11	33000.0
2007-09-05	AAUAF-DELISTED	Stock	2.14	2.14	2.1	2.11	32800.0
2007-09-05	AAV-DELISTED	Stock	11.46	11.5	11.36	11.48	494700.0
2007-09-05	AAWW-DELISTED	Stock	50.54	51.17	50.52	50.81	119205.0
2007-09-05	AAXN-DELISTED	Stock	14.64	14.85	14.5	14.67	1376397.0
2007-09-05	AB	Stock	81.6	83.52	81.23	83.13	216700.0
2007-09-05	ABAX-DELISTED	Stock	20.17	20.37	19.73	19.77	110367.0
2007-09-05	ABB-DELISTED	Stock	23.87	24.03	23.73	23.91	3404400.0
2007-09-05	ABBC-DELISTED	Stock	9.68	9.68	9.25	9.27	67576.0
2007-09-05	ABBNY-DELISTED	Stock	23.87	24.03	23.73	23.93	3518200.0
2007-09-05	ABC-DELISTED	Stock	23.7	23.93	23.25	23.48	2879400.0
2007-09-05	ABCB	Stock	19.589	19.6571	18.8596	19.0054	30844.0
2007-09-05	ABCO-DELISTED	Stock	28.59	28.69	28.08	28.46	325191.0
2007-09-05	ABCW-DELISTED	Stock	26.41	26.67	26.05	26.55	188790.0
2007-09-05	ABD-DELISTED	Stock	22.94	23.0	22.63	22.78	278500.0
2007-09-05	ABE-DELISTED	Stock	22.25	22.25	21.2	21.75	26300.0
2007-09-05	ABEO	Stock	4875.0	4937.5	4387.5	4812.5	2.0
2007-09-05	ABFS-DELISTED	Stock	36.06	36.09	35.11	35.27	523304.0
2007-09-05	ABG	Stock	21.84	21.91	21.52	21.65	441700.0
2007-09-05	ABK-DELISTED	Stock	63.82	63.88	62.35	62.68	2825700.0
2007-09-05	ABM	Stock	23.22	23.22	22.37	22.48	338300.0
2007-09-05	ABMD-DELISTED	Stock	12.9	12.97	12.29	12.38	129340.0
2007-09-05	ABP-DELISTED	Stock	3.61	3.7	3.58	3.61	88900.0
2007-09-05	ABR	Stock	20.36	20.42	19.6	19.64	251500.0
2007-09-05	ABT	Stock	24.5898	24.8776	24.5418	24.8153	8823468.0
2007-09-05	ABTL-DELISTED	Stock	15.275	15.275	14.776	14.975	13621.0
2007-09-05	ABV-DELISTED	Stock	68.02	68.38	66.61	67.61	832002.0
2007-09-05	ABVA-DELISTED	Stock	9.83	9.86	9.83	9.85	400.0
2007-09-05	ABVT-DELISTED	Stock	80.0	80.0	80.0	80.0	520.0
2007-09-05	ABX-DELISTED	Stock	33.13	33.89	32.93	33.31	5075000.0
2007-09-05	ACAD	Stock	15.23	15.34	15.0	15.08	199900.0
2007-09-05	ACAP-DELISTED	Stock	39.27	39.27	38.61	38.69	35448.0
2007-09-05	ACAS-DELISTED	Stock	41.0	41.04	39.21	40.17	2187569.0
2007-09-05	ACAT-DELISTED	Stock	16.14	16.61	16.09	16.35	115967.0
2007-09-05	ACC-DELISTED	Stock	28.04	28.04	27.28	27.84	130000.0

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

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