PREVIEW / stock_daily / 2008-04-23

all stock daily files

  file:    by_date/stock_daily/2008/2008-04-23.parquet
  size:    182 KB
  rows:    5,700
  symbols: 3,443

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-04-23	AAPL	Stock	5.8589	5.8871	5.7529	5.8175	1504190800.0
2008-04-23	MSFT	Stock	30.45	31.46	30.3	31.45	98351500.0
2008-04-23	NVDA	Stock	0.4942	0.5165	0.4878	0.511	1020496000.0
2008-04-23	AMZN	Stock	4.015	4.132	3.937	4.05	385008000.0
2008-04-23	TLT	Stock	93.09	93.63	92.53	93.15	1221004.0
2008-04-23	CL	Stock	38.49	38.49	37.98	38.205	4497400.0
2008-04-23	A	Stock	21.5594	22.3104	21.5522	22.2031	3240284.0
2008-04-23	AABA-DELISTED	Stock	28.23	28.35	27.71	28.08	30311054.0
2008-04-23	AACC-DELISTED	Stock	11.16	11.27	10.96	11.15	114873.0
2008-04-23	AACG	Stock	10.98	11.0	10.52	10.62	12400.0
2008-04-23	AAI-DELISTED	Stock	3.69	3.77	3.18	3.21	6516621.0
2008-04-23	AAIC-DELISTED	Stock	29.6	37.2	29.4	32.8	3115139.0
2008-04-23	AAME	Stock	2.0	2.02	2.0	2.02	2500.0
2008-04-23	AAON	Stock	3.6622	3.6622	3.5575	3.6306	355387.0
2008-04-23	AAP	Stock	34.04	34.16	33.08	33.57	1003000.0
2008-04-23	AATI-DELISTED	Stock	6.25	7.01	6.21	7.01	1269565.0
2008-04-23	AAU-DELISTED	Stock	2.3	2.34	2.26	2.28	42495.0
2008-04-23	AAUAF-DELISTED	Stock	2.3	2.34	2.26	2.28	44795.0
2008-04-23	AAV-DELISTED	Stock	12.66	12.66	12.15	12.51	668237.0
2008-04-23	AAWW-DELISTED	Stock	57.56	59.27	56.55	58.45	88229.0
2008-04-23	AAXN-DELISTED	Stock	9.52	9.67	9.23	9.43	2486176.0
2008-04-23	AB	Stock	58.6	58.6	57.61	57.93	332600.0
2008-04-23	ABAX-DELISTED	Stock	23.75	24.25	23.43	23.75	317149.0
2008-04-23	ABB-DELISTED	Stock	28.29	28.96	28.24	28.39	5066365.0
2008-04-23	ABBC-DELISTED	Stock	10.31	10.47	10.31	10.4	39970.0
2008-04-23	ABBNY-DELISTED	Stock	28.29	28.96	28.24	28.45	5087565.0
2008-04-23	ABC-DELISTED	Stock	21.22	21.22	19.58	19.73	5925362.0
2008-04-23	ABCB	Stock	13.938	14.1423	13.7142	13.8796	31358.0
2008-04-23	ABCO-DELISTED	Stock	22.11	22.45	21.46	21.58	1327904.0
2008-04-23	ABCW-DELISTED	Stock	16.41	16.41	15.629	15.69	166450.0
2008-04-23	ABD-DELISTED	Stock	13.15	13.24	12.97	13.07	387940.0
2008-04-23	ABE-DELISTED	Stock	23.5	23.689	23.42	23.671	15877.0
2008-04-23	ABEO	Stock	2975.0	2975.0	2875.0	2875.0	2.0
2008-04-23	ABFS-DELISTED	Stock	35.79	36.9	34.65	36.6	2882988.0
2008-04-23	ABG	Stock	13.95	14.22	13.87	14.05	382200.0
2008-04-23	ABII-DELISTED	Stock	59.69	60.6	59.3	60.09	18190.0
2008-04-23	ABK-DELISTED	Stock	4.91	4.95	3.08	3.53	70181113.0
2008-04-23	ABM	Stock	20.22	20.48	19.92	20.18	245500.0
2008-04-23	ABMD-DELISTED	Stock	14.13	14.59	14.13	14.59	65872.0
2008-04-23	ABP-DELISTED	Stock	4.29	4.34	4.14	4.28	280913.0
2008-04-23	ABR	Stock	16.75	17.42	16.73	17.15	80800.0
2008-04-23	ABT	Stock	24.3786	24.4218	24.2107	24.2587	24663610.0
2008-04-23	ABTL-DELISTED	Stock	7.55	8.5	7.25	8.45	41196.0
2008-04-23	ABV-DELISTED	Stock	75.42	75.63	73.25	73.79	512551.0
2008-04-23	ABVA-DELISTED	Stock	5.05	5.08	5.0	5.0	9244.0
2008-04-23	ABVT-DELISTED	Stock	56.75	56.75	56.75	56.75	254.0
2008-04-23	ABX-DELISTED	Stock	42.02	42.02	40.52	40.78	11554556.0
2008-04-23	ACAD	Stock	8.04	8.04	7.71	7.78	160100.0
2008-04-23	ACAP-DELISTED	Stock	45.86	46.3146	45.08	46.12	30525.0
2008-04-23	ACAS-DELISTED	Stock	31.03	31.13	30.23	30.38	2730698.0

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

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