PREVIEW / stock_daily / 2008-04-09

all stock daily files

  file:    by_date/stock_daily/2008/2008-04-09.parquet
  size:    181 KB
  rows:    5,685
  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-09	AAPL	Stock	5.4754	5.4961	5.3736	5.4086	873398400.0
2008-04-09	MSFT	Stock	28.72	29.04	28.54	28.89	45839300.0
2008-04-09	NVDA	Stock	0.4835	0.4925	0.479	0.4875	675232000.0
2008-04-09	AMZN	Stock	3.828	3.8335	3.683	3.7195	133206000.0
2008-04-09	TLT	Stock	94.56	95.64	94.55	95.35	2883511.0
2008-04-09	CL	Stock	39.25	39.475	39.05	39.32	3697000.0
2008-04-09	A	Stock	22.5036	22.5966	21.9886	22.2175	2126638.0
2008-04-09	AABA-DELISTED	Stock	27.8	27.95	27.13	27.79	30705588.0
2008-04-09	AACC-DELISTED	Stock	11.17	11.25	10.96	11.08	206959.0
2008-04-09	AACG	Stock	10.0	10.0	9.75	10.0	28400.0
2008-04-09	AAI-DELISTED	Stock	6.53	6.57	6.1	6.16	2233309.0
2008-04-09	AAIC-DELISTED	Stock	33.8	34.8	31.4	31.6	626300.0
2008-04-09	AAME	Stock	1.55	1.58	1.55	1.58	3600.0
2008-04-09	AAON	Stock	3.8143	3.8281	3.6425	3.6642	514350.0
2008-04-09	AAP	Stock	35.71	35.74	34.34	34.37	586300.0
2008-04-09	AATI-DELISTED	Stock	6.19	6.42	6.16	6.36	1016231.0
2008-04-09	AAU-DELISTED	Stock	2.41	2.45	2.35	2.36	33800.0
2008-04-09	AAUAF-DELISTED	Stock	2.41	2.45	2.35	2.36	34000.0
2008-04-09	AAV-DELISTED	Stock	11.45	11.49	11.3	11.43	435625.0
2008-04-09	AAWW-DELISTED	Stock	59.4	59.64	57.82	58.03	139642.0
2008-04-09	AAXN-DELISTED	Stock	9.73	9.87	9.3	9.44	1817669.0
2008-04-09	AB	Stock	64.16	64.16	60.35	60.64	684900.0
2008-04-09	ABAX-DELISTED	Stock	24.84	25.06	23.87	24.21	201677.0
2008-04-09	ABB-DELISTED	Stock	27.5	27.54	27.06	27.09	3399597.0
2008-04-09	ABBC-DELISTED	Stock	10.27	10.32	10.2	10.3	22505.0
2008-04-09	ABBNY-DELISTED	Stock	27.5	27.545	27.0575	27.13	3503097.0
2008-04-09	ABC-DELISTED	Stock	20.14	20.26	20.07	20.14	1511660.0
2008-04-09	ABCB	Stock	15.4164	15.4553	14.6383	14.6383	70838.0
2008-04-09	ABCO-DELISTED	Stock	26.16	26.44	25.59	25.67	213192.0
2008-04-09	ABCW-DELISTED	Stock	17.54	17.54	16.67	16.74	161340.0
2008-04-09	ABD-DELISTED	Stock	13.92	13.97	13.299	13.48	291700.0
2008-04-09	ABE-DELISTED	Stock	23.81	23.81	22.76	23.08	11400.0
2008-04-09	ABEO	Stock	2625.0	3000.0	2562.5	3000.0	5.0
2008-04-09	ABFS-DELISTED	Stock	34.16	34.17	32.09	32.33	867327.0
2008-04-09	ABG	Stock	14.77	14.88	14.25	14.26	232300.0
2008-04-09	ABII-DELISTED	Stock	59.41	60.55	59.41	60.39	12185.0
2008-04-09	ABK-DELISTED	Stock	6.09	6.11	5.52	5.67	8048061.0
2008-04-09	ABM	Stock	21.55	21.75	21.0	21.03	257900.0
2008-04-09	ABMD-DELISTED	Stock	14.16	14.5	14.02	14.08	203373.0
2008-04-09	ABP-DELISTED	Stock	3.36	3.36	3.29	3.29	324150.0
2008-04-09	ABR	Stock	17.85	18.1	16.55	16.63	190500.0
2008-04-09	ABT	Stock	25.8708	26.0723	25.6789	25.8468	17835348.0
2008-04-09	ABTL-DELISTED	Stock	9.3	9.45	9.15	9.2	16120.0
2008-04-09	ABV-DELISTED	Stock	78.56	79.33	77.63	78.4	330016.0
2008-04-09	ABVA-DELISTED	Stock	5.1	5.25	5.1	5.1	5000.0
2008-04-09	ABVT-DELISTED	Stock	62.0	62.0	62.0	62.0	100.0
2008-04-09	ABX-DELISTED	Stock	43.2	44.37	43.05	44.06	7921552.0
2008-04-09	ACAD	Stock	9.04	9.05	8.43	8.54	191200.0
2008-04-09	ACAP-DELISTED	Stock	46.19	47.5	46.19	47.1	55561.0
2008-04-09	ACAS-DELISTED	Stock	34.21	34.54	33.99	34.21	1791334.0

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

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