PREVIEW / stock_daily / 2008-07-09

all stock daily files

  file:    by_date/stock_daily/2008/2008-07-09.parquet
  size:    182 KB
  rows:    5,718
  symbols: 3,463

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-09	AAPL	Stock	6.4357	6.4611	6.2193	6.2232	895776000.0
2008-07-09	MSFT	Stock	25.79	25.85	25.18	25.23	54255800.0
2008-07-09	NVDA	Stock	0.3015	0.306	0.2955	0.2955	1413168000.0
2008-07-09	AMZN	Stock	3.728	3.745	3.524	3.5305	138242000.0
2008-07-09	TLT	Stock	92.94	93.64	92.92	93.64	1581965.0
2008-07-09	CL	Stock	35.035	35.475	34.795	35.155	4891200.0
2008-07-09	A	Stock	25.8298	25.8727	25.1001	25.1001	2905743.0
2008-07-09	AABA-DELISTED	Stock	24.74	24.8	23.83	23.84	21636360.0
2008-07-09	AACC-DELISTED	Stock	10.11	10.85	9.74	9.93	309764.0
2008-07-09	AACG	Stock	10.61	12.69	10.61	12.58	23000.0
2008-07-09	AAI-DELISTED	Stock	2.24	2.24	1.82	1.83	4699071.0
2008-07-09	AAIC-DELISTED	Stock	30.4	32.0	28.2	28.4	2045560.0
2008-07-09	AAME	Stock	1.66	1.7	1.65	1.7	4500.0
2008-07-09	AAON	Stock	3.5496	3.6346	3.4331	3.4331	565987.0
2008-07-09	AAP	Stock	38.4	38.52	37.38	37.53	1803500.0
2008-07-09	AATI-DELISTED	Stock	4.56	4.6	4.31	4.34	622936.0
2008-07-09	AAU-DELISTED	Stock	1.92	1.99	1.92	1.98	37340.0
2008-07-09	AAUAF-DELISTED	Stock	1.92	1.99	1.92	1.98	38220.0
2008-07-09	AAV-DELISTED	Stock	11.2	11.58	11.2	11.4	780124.0
2008-07-09	AAWW-DELISTED	Stock	46.11	46.17	44.87	45.06	256708.0
2008-07-09	AAXN-DELISTED	Stock	5.46	5.5	5.22	5.23	646802.0
2008-07-09	AB	Stock	52.83	53.4	49.34	49.89	721600.0
2008-07-09	ABAX-DELISTED	Stock	24.29	24.61	22.48	22.48	363476.0
2008-07-09	ABB-DELISTED	Stock	27.49	27.61	26.88	26.94	3126507.0
2008-07-09	ABBC-DELISTED	Stock	9.3	9.3	9.09	9.13	42762.0
2008-07-09	ABBNY-DELISTED	Stock	27.49	27.61	26.88	26.96	3140107.0
2008-07-09	ABC-DELISTED	Stock	19.62	20.01	19.45	19.46	2824092.0
2008-07-09	ABCB	Stock	9.211	9.3374	8.462	8.5009	51920.0
2008-07-09	ABCO-DELISTED	Stock	19.91	19.91	19.1	19.11	280704.0
2008-07-09	ABCW-DELISTED	Stock	7.254	7.254	6.396	6.4359	324660.0
2008-07-09	ABD-DELISTED	Stock	9.1	9.1	8.54	8.58	577410.0
2008-07-09	ABE-DELISTED	Stock	19.61	20.02	19.53	19.53	57335.0
2008-07-09	ABEO	Stock	3875.0	4000.0	3750.0	4000.0	19.0
2008-07-09	ABFS-DELISTED	Stock	37.45	37.97	36.75	37.4	1173090.0
2008-07-09	ABG	Stock	11.68	11.68	11.16	11.18	420000.0
2008-07-09	ABII-DELISTED	Stock	60.95	63.44	60.64	61.68	25027.0
2008-07-09	ABK-DELISTED	Stock	2.21	2.88	2.01	2.04	66354170.0
2008-07-09	ABM	Stock	22.26	22.4	21.58	21.64	213100.0
2008-07-09	ABMD-DELISTED	Stock	17.88	18.26	17.85	18.0	173986.0
2008-07-09	ABP-DELISTED	Stock	4.2	4.4	4.05	4.07	402053.0
2008-07-09	ABR	Stock	9.49	9.53	8.5	8.69	180800.0
2008-07-09	ABT	Stock	27.2766	27.79	27.1855	27.3054	17550438.0
2008-07-09	ABTL-DELISTED	Stock	6.1976	6.5532	6.096	6.35	20672.0
2008-07-09	ABV-DELISTED	Stock	59.36	59.71	57.55	58.17	678524.0
2008-07-09	ABVA-DELISTED	Stock	3.92	3.92	3.7	3.7	400.0
2008-07-09	ABVT-DELISTED	Stock	61.0	61.0	61.0	61.0	14346.0
2008-07-09	ABX-DELISTED	Stock	44.81	46.39	44.53	44.68	7172145.0
2008-07-09	ACAD	Stock	3.51	3.57	3.39	3.39	332500.0
2008-07-09	ACAP-DELISTED	Stock	45.26	45.41	44.04	44.38	82578.0
2008-07-09	ACAS-DELISTED	Stock	23.15	23.449	21.63	21.72	3262370.0

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

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