PREVIEW / stock_daily / 2007-09-04

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-04.parquet
  size:    176 KB
  rows:    5,473
  symbols: 3,297

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-04	AAPL	Stock	4.9979	5.2046	4.9943	5.1486	1316842800.0
2007-09-04	MSFT	Stock	28.5	29.1	28.48	28.81	45689600.0
2007-09-04	NVDA	Stock	0.8565	0.8827	0.8432	0.879	683268000.0
2007-09-04	AMZN	Stock	3.995	4.1765	3.9865	4.135	165320000.0
2007-09-04	TLT	Stock	88.83	89.13	88.2	89.13	930971.0
2007-09-04	CL	Stock	33.125	33.195	32.725	32.945	3528600.0
2007-09-04	A	Stock	26.1731	26.2375	25.7582	26.0801	2215411.0
2007-09-04	AABA-DELISTED	Stock	23.3	24.5	23.26	23.97	38030064.0
2007-09-04	AACC-DELISTED	Stock	11.54	12.0	11.2	11.21	187045.0
2007-09-04	AAI-DELISTED	Stock	10.51	10.88	10.48	10.76	1243800.0
2007-09-04	AAIC-DELISTED	Stock	93.0	97.0	92.8	96.2	2037800.0
2007-09-04	AAME	Stock	2.89	3.03	2.76	2.82	6900.0
2007-09-04	AAON	Stock	4.1402	4.4148	4.1146	4.4109	458156.0
2007-09-04	AAP	Stock	35.55	35.63	35.09	35.38	778200.0
2007-09-04	AATI-DELISTED	Stock	9.05	9.5	9.05	9.29	364058.0
2007-09-04	AAU-DELISTED	Stock	2.1	2.16	2.1	2.16	129000.0
2007-09-04	AAUAF-DELISTED	Stock	2.1	2.16	2.1	2.16	129000.0
2007-09-04	AAV-DELISTED	Stock	11.4	11.5	11.27	11.44	505600.0
2007-09-04	AAWW-DELISTED	Stock	50.46	51.2	50.03	50.96	132418.0
2007-09-04	AAXN-DELISTED	Stock	14.25	14.95	14.0	14.86	2465106.0
2007-09-04	AB	Stock	81.87	84.0	81.8	83.07	226900.0
2007-09-04	ABAX-DELISTED	Stock	19.4	20.57	19.4	20.29	98721.0
2007-09-04	ABB-DELISTED	Stock	24.17	24.85	24.11	24.75	3473686.0
2007-09-04	ABBC-DELISTED	Stock	9.57	9.69	9.55	9.69	28561.0
2007-09-04	ABBNY-DELISTED	Stock	24.17	24.85	24.11	24.73	3636786.0
2007-09-04	ABC-DELISTED	Stock	24.0	24.05	23.63	23.79	1467400.0
2007-09-04	ABCB	Stock	19.1416	19.8225	18.8693	19.6765	22722.0
2007-09-04	ABCO-DELISTED	Stock	28.73	28.94	28.49	28.7	198015.0
2007-09-04	ABCW-DELISTED	Stock	26.2	27.01	26.2	26.63	161140.0
2007-09-04	ABD-DELISTED	Stock	22.62	23.4	22.5	23.13	291950.0
2007-09-04	ABE-DELISTED	Stock	21.99	22.46	21.87	22.3	23800.0
2007-09-04	ABEO	Stock	4300.0	4750.0	3875.0	4750.0	9.0
2007-09-04	ABFS-DELISTED	Stock	35.9	36.52	35.7	36.41	402177.0
2007-09-04	ABG	Stock	21.57	22.11	21.51	21.95	281600.0
2007-09-04	ABK-DELISTED	Stock	62.37	65.32	60.7	64.89	2874500.0
2007-09-04	ABM	Stock	23.3	23.59	23.09	23.34	197900.0
2007-09-04	ABMD-DELISTED	Stock	12.28	12.99	12.28	12.86	210124.0
2007-09-04	ABP-DELISTED	Stock	3.58	3.75	3.56	3.66	176400.0
2007-09-04	ABR	Stock	20.11	20.69	19.95	20.38	167900.0
2007-09-04	ABT	Stock	24.8632	24.892	24.5562	24.7481	10141309.0
2007-09-04	ABTL-DELISTED	Stock	16.1	16.15	15.35	15.45	23331.0
2007-09-04	ABV-DELISTED	Stock	69.5	70.89	68.91	69.53	629098.0
2007-09-04	ABVA-DELISTED	Stock	9.9221	10.0	9.9221	9.95	19915.0
2007-09-04	ABVT-DELISTED	Stock	79.5	81.5	79.5	80.0	43574.0
2007-09-04	ABX-DELISTED	Stock	32.89	33.73	32.52	33.43	4706900.0
2007-09-04	ACAD	Stock	14.42	15.54	14.42	15.27	406800.0
2007-09-04	ACAP-DELISTED	Stock	39.63	40.09	38.82	39.6	85438.0
2007-09-04	ACAS-DELISTED	Stock	41.37	42.18	40.65	41.8	2520135.0
2007-09-04	ACAT-DELISTED	Stock	16.83	16.83	16.32	16.32	96837.0
2007-09-04	ACC-DELISTED	Stock	28.3	28.51	28.01	28.24	101633.0

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

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