PREVIEW / stock_daily / 2008-03-07

all stock daily files

  file:    by_date/stock_daily/2008/2008-03-07.parquet
  size:    179 KB
  rows:    5,649
  symbols: 3,420

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-03-07	AAPL	Stock	4.3004	4.3921	4.2518	4.3661	1230462800.0
2008-03-07	MSFT	Stock	27.34	28.07	27.32	27.87	77597600.0
2008-03-07	NVDA	Stock	0.487	0.508	0.475	0.4888	767500000.0
2008-03-07	AMZN	Stock	3.11	3.2435	3.1005	3.2045	208762000.0
2008-03-07	TLT	Stock	93.29	93.35	91.74	92.23	3601277.0
2008-03-07	CL	Stock	37.725	37.89	37.28	37.445	5497800.0
2008-03-07	A	Stock	21.4306	21.9242	21.3305	21.5093	4018831.0
2008-03-07	AABA-DELISTED	Stock	28.57	29.18	28.5	29.02	28417214.0
2008-03-07	AACC-DELISTED	Stock	8.4	8.75	8.08	8.57	275828.0
2008-03-07	AACG	Stock	10.2	10.87	10.2	10.84	10300.0
2008-03-07	AAI-DELISTED	Stock	6.6	6.86	6.52	6.62	1138706.0
2008-03-07	AAIC-DELISTED	Stock	37.8	42.0	36.6	38.0	1795589.0
2008-03-07	AAME	Stock	1.5	1.52	1.48	1.48	5000.0
2008-03-07	AAON	Stock	3.3798	3.5812	3.358	3.4607	521944.0
2008-03-07	AAP	Stock	32.52	33.47	32.4	32.83	690400.0
2008-03-07	AATI-DELISTED	Stock	5.9	6.11	5.84	6.0	940882.0
2008-03-07	AAU-DELISTED	Stock	2.55	2.55	2.42	2.45	47645.0
2008-03-07	AAUAF-DELISTED	Stock	2.55	2.55	2.42	2.45	47745.0
2008-03-07	AAV-DELISTED	Stock	11.01	11.2	10.9	10.98	634549.0
2008-03-07	AAWW-DELISTED	Stock	49.86	51.47	49.86	50.9	88382.0
2008-03-07	AAXN-DELISTED	Stock	10.75	11.1	10.67	10.8	1138649.0
2008-03-07	AB	Stock	56.99	58.99	55.2	58.44	743400.0
2008-03-07	ABAX-DELISTED	Stock	27.32	28.2	26.65	26.85	331112.0
2008-03-07	ABB-DELISTED	Stock	25.25	25.87	25.07	25.35	5413576.0
2008-03-07	ABBC-DELISTED	Stock	9.84	10.0	9.84	9.84	48713.0
2008-03-07	ABBNY-DELISTED	Stock	25.25	25.87	25.07	25.41	5413576.0
2008-03-07	ABC-DELISTED	Stock	20.05	20.9	19.9	20.54	3612918.0
2008-03-07	ABCB	Stock	12.158	13.189	12.158	12.8	30844.0
2008-03-07	ABCO-DELISTED	Stock	27.11	28.13	26.96	27.24	274618.0
2008-03-07	ABCW-DELISTED	Stock	17.6	18.26	17.26	17.63	125850.0
2008-03-07	ABD-DELISTED	Stock	13.05	13.56	12.83	13.08	339800.0
2008-03-07	ABE-DELISTED	Stock	21.6	22.39	21.6	21.83	27860.0
2008-03-07	ABEO	Stock	2500.0	2500.0	2375.0	2375.0	1.0
2008-03-07	ABFS-DELISTED	Stock	28.1	29.19	28.0	28.52	520233.0
2008-03-07	ABG	Stock	13.92	14.42	13.92	14.05	190600.0
2008-03-07	ABII-DELISTED	Stock	59.47	60.0	58.06	59.5	13566.0
2008-03-07	ABK-DELISTED	Stock	6.56	7.56	6.5	7.38	86473242.0
2008-03-07	ABM	Stock	20.55	21.14	20.54	20.65	208800.0
2008-03-07	ABMD-DELISTED	Stock	12.77	13.1	12.77	12.9	114006.0
2008-03-07	ABP-DELISTED	Stock	3.51	3.53	3.38	3.4	249935.0
2008-03-07	ABR	Stock	13.85	14.95	13.75	13.78	381400.0
2008-03-07	ABT	Stock	25.0312	25.0312	24.4074	24.489	14591288.0
2008-03-07	ABTL-DELISTED	Stock	12.907	12.907	11.794	12.3	19396.0
2008-03-07	ABV-DELISTED	Stock	78.6	80.0	77.28	77.62	640156.0
2008-03-07	ABVA-DELISTED	Stock	5.48	5.49	5.27	5.31	6102.0
2008-03-07	ABVT-DELISTED	Stock	73.0	73.0	73.0	73.0	305.0
2008-03-07	ABX-DELISTED	Stock	51.5	51.56	50.31	50.34	6571359.0
2008-03-07	ACAD	Stock	8.65	8.68	8.2	8.32	700000.0
2008-03-07	ACAP-DELISTED	Stock	42.97	43.94	42.74	43.08	51631.0
2008-03-07	ACAS-DELISTED	Stock	32.58	34.28	31.55	33.58	2622155.0

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

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