PREVIEW / stock_daily / 2008-07-16

all stock daily files

  file:    by_date/stock_daily/2008/2008-07-16.parquet
  size:    185 KB
  rows:    5,782
  symbols: 3,504

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
2008-07-16	AAPL	Stock	6.0786	6.1761	6.0214	6.1718	747790400.0
2008-07-16	MSFT	Stock	26.13	27.29	25.92	27.26	82060400.0
2008-07-16	NVDA	Stock	0.2825	0.2905	0.2748	0.283	1034392000.0
2008-07-16	AMZN	Stock	3.347	3.6375	3.342	3.592	240778000.0
2008-07-16	TLT	Stock	92.08	92.24	91.21	91.26	3435843.0
2008-07-16	CL	Stock	34.51	34.75	34.19	34.575	8726600.0
2008-07-16	A	Stock	24.8212	25.3505	24.7997	25.1216	4138779.0
2008-07-16	AABA-DELISTED	Stock	21.87	22.6	21.59	22.44	19918490.0
2008-07-16	AACC-DELISTED	Stock	9.71	10.3399	9.38	10.26	236154.0
2008-07-16	AACG	Stock	12.2	12.2	12.0	12.0	700.0
2008-07-16	AAI-DELISTED	Stock	1.63	1.84	1.48	1.72	4343875.0
2008-07-16	AAIC-DELISTED	Stock	31.0	35.6	30.6	35.4	1041413.0
2008-07-16	AAME	Stock	1.65	1.65	1.6	1.6	3700.0
2008-07-16	AAON	Stock	3.3501	3.4647	3.2988	3.4272	606487.0
2008-07-16	AAP	Stock	37.46	39.67	37.03	39.48	1302400.0
2008-07-16	AATI-DELISTED	Stock	4.3	4.55	4.3	4.5	444405.0
2008-07-16	AAU-DELISTED	Stock	2.23	2.29	2.11	2.15	34946.0
2008-07-16	AAUAF-DELISTED	Stock	2.23	2.29	2.11	2.15	36271.0
2008-07-16	AAV-DELISTED	Stock	12.14	12.35	11.65	11.88	812252.0
2008-07-16	AAWW-DELISTED	Stock	45.89	49.2	45.47	49.03	413241.0
2008-07-16	AAXN-DELISTED	Stock	5.45	5.96	5.43	5.9501	1465670.0
2008-07-16	AB	Stock	42.32	47.6	42.15	47.12	662000.0
2008-07-16	ABAX-DELISTED	Stock	22.49	23.54	22.42	23.002	449003.0
2008-07-16	ABB-DELISTED	Stock	27.08	27.96	26.9	27.86	5366409.0
2008-07-16	ABBC-DELISTED	Stock	8.77	9.18	8.77	9.13	83684.0
2008-07-16	ABBNY-DELISTED	Stock	27.08	27.96	26.9	27.83	5402884.0
2008-07-16	ABC-DELISTED	Stock	18.88	19.04	18.7	18.96	2113456.0
2008-07-16	ABCB	Stock	7.5477	8.7343	7.538	8.6176	122553.0
2008-07-16	ABCO-DELISTED	Stock	18.283	18.403	18.017	18.137	476602.0
2008-07-16	ABCW-DELISTED	Stock	6.28	6.96	5.61	6.83	398900.0
2008-07-16	ABD-DELISTED	Stock	7.8	7.99	7.58	7.95	746090.0
2008-07-16	ABE-DELISTED	Stock	19.6	20.1	19.24	20.08	17139.0
2008-07-16	ABEO	Stock	3437.5	3437.5	3125.0	3187.5	35.0
2008-07-16	ABFS-DELISTED	Stock	36.99	39.94	36.97	39.58	1584357.0
2008-07-16	ABG	Stock	10.4	11.2	10.25	11.07	581000.0
2008-07-16	ABII-DELISTED	Stock	67.63	67.98	65.66	67.98	9669.0
2008-07-16	ABK-DELISTED	Stock	1.87	2.09	1.81	2.07	22768359.0
2008-07-16	ABM	Stock	21.85	22.46	21.49	22.44	233000.0
2008-07-16	ABMD-DELISTED	Stock	18.17	18.91	17.967	18.61	226762.0
2008-07-16	ABP-DELISTED	Stock	4.51	4.51	4.19	4.43	323743.0
2008-07-16	ABR	Stock	8.31	8.94	8.28	8.62	169600.0
2008-07-16	ABT	Stock	27.9723	28.0683	27.1567	27.3342	25375782.0
2008-07-16	ABTL-DELISTED	Stock	5.45	5.5509	5.2986	5.45	23566.0
2008-07-16	ABV-DELISTED	Stock	60.91	62.54	60.0	61.87	1221499.0
2008-07-16	ABVA-DELISTED	Stock	3.68	3.75	3.68	3.68	800.0
2008-07-16	ABVT-DELISTED	Stock	59.75	59.75	59.4	59.4	1000.0
2008-07-16	ABX-DELISTED	Stock	49.78	50.43	47.84	48.37	9830909.0
2008-07-16	ACAD	Stock	3.39	3.51	3.27	3.42	237600.0
2008-07-16	ACAP-DELISTED	Stock	41.83	42.48	40.64	42.1	116329.0
2008-07-16	ACAS-DELISTED	Stock	17.62	20.55	16.78	20.33	7150378.0

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

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