PREVIEW / stock_daily / 2007-11-02

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-02.parquet
  size:    179 KB
  rows:    5,542
  symbols: 3,350

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-02	AAPL	Stock	6.7575	6.7657	6.5532	6.7096	1002114400.0
2007-11-02	MSFT	Stock	37.22	37.5	36.42	37.06	96389800.0
2007-11-02	NVDA	Stock	0.8968	0.925	0.8842	0.9185	491844000.0
2007-11-02	AMZN	Stock	4.3985	4.406	4.175	4.299	204610000.0
2007-11-02	TLT	Stock	90.45	91.54	90.21	91.0	1927700.0
2007-11-02	CL	Stock	37.925	38.06	36.925	37.36	6282800.0
2007-11-02	A	Stock	26.0014	26.2804	25.6223	25.7654	1835714.0
2007-11-02	AABA-DELISTED	Stock	30.53	31.21	29.64	31.12	34092296.0
2007-11-02	AACC-DELISTED	Stock	10.56	10.65	10.32	10.34	305307.0
2007-11-02	AAI-DELISTED	Stock	10.17	10.2	9.83	9.88	1047200.0
2007-11-02	AAIC-DELISTED	Stock	80.2	82.0	76.2	77.6	2033200.0
2007-11-02	AAME	Stock	2.29	2.29	2.16	2.23	3200.0
2007-11-02	AAON	Stock	3.3837	3.4212	3.3047	3.4114	499162.0
2007-11-02	AAP	Stock	35.55	35.65	34.35	34.78	2572600.0
2007-11-02	AATI-DELISTED	Stock	11.5	11.8	11.28	11.73	932174.0
2007-11-02	AAU-DELISTED	Stock	3.05	3.25	3.05	3.25	131600.0
2007-11-02	AAUAF-DELISTED	Stock	3.05	3.25	3.05	3.25	131600.0
2007-11-02	AAV-DELISTED	Stock	12.55	12.69	12.47	12.54	663180.0
2007-11-02	AAWW-DELISTED	Stock	57.64	57.85	56.66	57.56	106032.0
2007-11-02	AAXN-DELISTED	Stock	16.23	16.25	15.75	15.97	1756376.0
2007-11-02	AB	Stock	82.0	82.5	79.73	80.49	238200.0
2007-11-02	ABAX-DELISTED	Stock	29.33	29.67	28.51	29.5	324604.0
2007-11-02	ABB-DELISTED	Stock	30.24	30.76	30.0	30.7	3992960.0
2007-11-02	ABBC-DELISTED	Stock	9.08	9.11	8.71	8.91	91289.0
2007-11-02	ABBNY-DELISTED	Stock	30.24	30.77	30.0	30.77	3992960.0
2007-11-02	ABC-DELISTED	Stock	22.72	22.72	21.74	21.96	3875200.0
2007-11-02	ABCB	Stock	15.3288	15.5525	14.8717	15.1635	48116.0
2007-11-02	ABCO-DELISTED	Stock	31.5	32.0	30.28	31.88	312674.0
2007-11-02	ABCW-DELISTED	Stock	23.58	23.94	22.6	22.94	125480.0
2007-11-02	ABD-DELISTED	Stock	20.38	20.47	19.96	20.27	273900.0
2007-11-02	ABE-DELISTED	Stock	27.38	27.38	26.02	27.1	25600.0
2007-11-02	ABEO	Stock	3875.0	3875.0	3250.0	3875.0	28.0
2007-11-02	ABFS-DELISTED	Stock	26.04	26.09	25.4	25.84	624808.0
2007-11-02	ABG	Stock	17.85	18.24	17.18	17.94	720600.0
2007-11-02	ABK-DELISTED	Stock	28.0	28.3	21.62	23.52	29935165.0
2007-11-02	ABM	Stock	23.16	23.35	22.34	22.74	416900.0
2007-11-02	ABMD-DELISTED	Stock	13.07	13.37	12.8	13.18	165025.0
2007-11-02	ABP-DELISTED	Stock	4.43	4.65	4.41	4.64	233100.0
2007-11-02	ABR	Stock	18.3	18.35	16.54	16.58	664200.0
2007-11-02	ABT	Stock	26.7057	26.7249	25.7173	25.9332	11051480.0
2007-11-02	ABTL-DELISTED	Stock	11.675	11.871	10.976	11.225	15428.0
2007-11-02	ABV-DELISTED	Stock	81.92	82.49	80.0	82.32	519000.0
2007-11-02	ABVA-DELISTED	Stock	8.76	8.76	8.59	8.59	5150.0
2007-11-02	ABVT-DELISTED	Stock	87.5	91.0	87.0	90.0	157338.0
2007-11-02	ABX-DELISTED	Stock	43.44	45.67	42.96	45.59	9948466.0
2007-11-02	ACAD	Stock	15.09	15.3	14.9	15.23	181400.0
2007-11-02	ACAP-DELISTED	Stock	43.68	43.68	42.08	42.62	68929.0
2007-11-02	ACAS-DELISTED	Stock	41.99	41.99	40.25	41.41	2797890.0
2007-11-02	ACAT-DELISTED	Stock	13.9	14.5	13.43	13.74	162083.0
2007-11-02	ACC-DELISTED	Stock	27.44	27.81	26.22	26.42	348100.0

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

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