PREVIEW / stock_daily / 2007-12-04

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-04.parquet
  size:    180 KB
  rows:    5,611
  symbols: 3,401

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-04	AAPL	Stock	6.3268	6.4607	6.3211	6.4218	773799600.0
2007-12-04	MSFT	Stock	32.74	33.24	32.63	32.77	54801500.0
2007-12-04	NVDA	Stock	0.8035	0.8062	0.7838	0.7992	371712000.0
2007-12-04	AMZN	Stock	4.502	4.728	4.502	4.7205	146758000.0
2007-12-04	TLT	Stock	94.9	95.06	94.15	94.74	1721173.0
2007-12-04	CL	Stock	39.865	40.065	39.345	39.52	9703400.0
2007-12-04	A	Stock	26.8956	27.2818	26.774	26.8097	4236639.0
2007-12-04	AABA-DELISTED	Stock	26.17	26.73	26.11	26.42	14686908.0
2007-12-04	AACC-DELISTED	Stock	11.49	11.49	11.0	11.46	229839.0
2007-12-04	AAI-DELISTED	Stock	8.28	8.31	7.99	8.07	2250800.0
2007-12-04	AAIC-DELISTED	Stock	54.4	56.0	49.8	54.8	2598302.0
2007-12-04	AAME	Stock	1.7	1.97	1.7	1.91	4500.0
2007-12-04	AAON	Stock	3.6622	3.7195	3.5852	3.603	593831.0
2007-12-04	AAP	Stock	36.1	37.49	36.1	36.97	1828000.0
2007-12-04	AATI-DELISTED	Stock	10.55	10.99	10.3	10.31	287278.0
2007-12-04	AAU-DELISTED	Stock	2.5	2.54	2.36	2.41	79256.0
2007-12-04	AAUAF-DELISTED	Stock	2.5	2.54	2.36	2.408	80812.0
2007-12-04	AAV-DELISTED	Stock	10.44	10.45	10.23	10.24	701300.0
2007-12-04	AAWW-DELISTED	Stock	52.28	52.91	52.04	52.63	70543.0
2007-12-04	AAXN-DELISTED	Stock	14.63	15.14	14.35	14.88	1607176.0
2007-12-04	AB	Stock	81.24	81.34	79.8	80.02	191500.0
2007-12-04	ABAX-DELISTED	Stock	33.57	33.57	31.84	31.93	224427.0
2007-12-04	ABB-DELISTED	Stock	28.41	28.95	28.34	28.72	3903370.0
2007-12-04	ABBC-DELISTED	Stock	8.78	8.94	8.52	8.74	96894.0
2007-12-04	ABBNY-DELISTED	Stock	28.41	28.95	28.34	28.72	3903370.0
2007-12-04	ABC-DELISTED	Stock	21.71	22.17	21.63	21.87	3623190.0
2007-12-04	ABCB	Stock	16.0292	16.2431	15.8443	16.0292	60145.0
2007-12-04	ABCO-DELISTED	Stock	31.52	32.86	31.42	31.52	240212.0
2007-12-04	ABCW-DELISTED	Stock	24.99	24.99	24.33	24.48	43850.0
2007-12-04	ABD-DELISTED	Stock	16.31	16.57	16.21	16.38	440510.0
2007-12-04	ABE-DELISTED	Stock	26.23	26.23	25.89	25.96	16700.0
2007-12-04	ABEO	Stock	3375.0	3637.5	3375.0	3375.0	3.0
2007-12-04	ABFS-DELISTED	Stock	22.2	22.2	21.69	22.1	441974.0
2007-12-04	ABG	Stock	16.6	16.61	16.16	16.42	357400.0
2007-12-04	ABII-DELISTED	Stock	59.95	60.5	59.52	60.15	25774.0
2007-12-04	ABK-DELISTED	Stock	25.87	26.39	25.25	25.85	3963195.0
2007-12-04	ABM	Stock	19.91	20.3	19.8	20.15	234000.0
2007-12-04	ABMD-DELISTED	Stock	12.53	12.91	12.34	12.79	94941.0
2007-12-04	ABP-DELISTED	Stock	3.26	3.49	3.25	3.45	151520.0
2007-12-04	ABR	Stock	17.22	17.5	16.9	16.9	239300.0
2007-12-04	ABT	Stock	27.1375	27.6893	27.1375	27.5885	12892038.0
2007-12-04	ABTL-DELISTED	Stock	15.275	15.425	14.975	14.975	30983.0
2007-12-04	ABV-DELISTED	Stock	75.59	75.8	73.69	74.78	693881.0
2007-12-04	ABVA-DELISTED	Stock	7.47	7.5	7.37	7.37	2693.0
2007-12-04	ABVT-DELISTED	Stock	75.75	76.25	75.75	76.25	15572.0
2007-12-04	ABX-DELISTED	Stock	41.26	41.26	40.32	40.46	4987542.0
2007-12-04	ACAD	Stock	11.41	11.66	11.16	11.52	339200.0
2007-12-04	ACAP-DELISTED	Stock	41.44	42.45	40.91	40.98	69035.0
2007-12-04	ACAS-DELISTED	Stock	37.63	37.84	36.96	36.97	2174629.0
2007-12-04	ACAT-DELISTED	Stock	10.94	11.05	10.67	10.73	131279.0

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

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