PREVIEW / stock_daily / 2008-09-02

all stock daily files

  file:    by_date/stock_daily/2008/2008-09-02.parquet
  size:    184 KB
  rows:    5,735
  symbols: 3,465

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-09-02	AAPL	Stock	6.1571	6.1964	5.8929	5.9354	780763200.0
2008-09-02	MSFT	Stock	27.67	27.76	27.06	27.1	66079200.0
2008-09-02	NVDA	Stock	0.3213	0.324	0.3038	0.308	693928000.0
2008-09-02	AMZN	Stock	4.158	4.225	4.0605	4.0705	120016000.0
2008-09-02	TLT	Stock	92.98	94.41	92.84	94.37	2915981.0
2008-09-02	CL	Stock	38.29	38.79	38.19	38.36	4082000.0
2008-09-02	A	Stock	25.1001	25.5365	24.5279	24.671	2876665.0
2008-09-02	AABA-DELISTED	Stock	19.63	19.77	18.74	18.75	16589766.0
2008-09-02	AACC-DELISTED	Stock	11.16	11.28	10.92	11.1	73608.0
2008-09-02	AACG	Stock	11.93	13.14	11.93	12.5	75100.0
2008-09-02	AAI-DELISTED	Stock	2.85	3.05	2.47	2.63	7080450.0
2008-09-02	AAIC-DELISTED	Stock	37.8	39.0	35.2	36.0	615266.0
2008-09-02	AAME	Stock	1.53	1.55	1.53	1.55	3300.0
2008-09-02	AAON	Stock	4.3121	4.32	4.1047	4.2054	418669.0
2008-09-02	AAP	Stock	43.58	45.52	43.47	44.01	1577500.0
2008-09-02	AATI-DELISTED	Stock	4.67	4.67	4.519	4.56	293750.0
2008-09-02	AAU-DELISTED	Stock	1.34	1.36	1.31	1.32	80370.0
2008-09-02	AAUAF-DELISTED	Stock	1.34	1.36	1.31	1.3201	86370.0
2008-09-02	AAV-DELISTED	Stock	10.85	11.2	10.6	10.88	536249.0
2008-09-02	AAWW-DELISTED	Stock	58.05	59.03	56.72	57.3	316821.0
2008-09-02	AAXJ	Stock	49.0	49.0	49.0	49.0	100.0
2008-09-02	AAXN-DELISTED	Stock	6.59	6.825	6.42	6.5	1061825.0
2008-09-02	AB	Stock	54.59	55.28	53.71	54.3	268600.0
2008-09-02	ABAX-DELISTED	Stock	20.11	20.29	19.44	19.5	253798.0
2008-09-02	ABB-DELISTED	Stock	25.25	25.26	24.35	24.45	5981069.0
2008-09-02	ABBC-DELISTED	Stock	10.05	10.05	9.91	9.97	18043.0
2008-09-02	ABBNY-DELISTED	Stock	25.25	25.26	24.35	24.46	6257169.0
2008-09-02	ABC-DELISTED	Stock	20.64	21.12	20.01	20.63	2747150.0
2008-09-02	ABCB	Stock	11.8468	11.9634	11.1659	11.9537	27965.0
2008-09-02	ABCO-DELISTED	Stock	15.622	15.892	15.248	15.318	552167.0
2008-09-02	ABCW-DELISTED	Stock	7.95	8.46	7.94	8.09	228170.0
2008-09-02	ABD-DELISTED	Stock	8.59	8.91	8.26	8.68	517930.0
2008-09-02	ABE-DELISTED	Stock	19.24	19.24	18.62	18.69	27747.0
2008-09-02	ABEO	Stock	4062.5	4062.5	3687.5	3750.0	96.0
2008-09-02	ABFS-DELISTED	Stock	35.38	36.7	34.45	35.08	670206.0
2008-09-02	ABG	Stock	12.58	13.1	12.35	12.64	311000.0
2008-09-02	ABII-DELISTED	Stock	73.49	74.5	69.0	72.13	60779.0
2008-09-02	ABK-DELISTED	Stock	7.55	7.61	6.89	7.05	37463701.0
2008-09-02	ABM	Stock	26.29	27.13	25.68	26.17	426300.0
2008-09-02	ABMD-DELISTED	Stock	18.25	18.37	17.6	17.89	273498.0
2008-09-02	ABR	Stock	9.23	9.3	8.85	8.9	198600.0
2008-09-02	ABT	Stock	27.886	28.4713	27.6125	28.313	16227386.0
2008-09-02	ABTL-DELISTED	Stock	5.8	5.95	5.7	5.8	5067.0
2008-09-02	ABV-DELISTED	Stock	60.48	61.59	60.48	60.9	488356.0
2008-09-02	ABVA-DELISTED	Stock	3.53	4.0	3.53	3.8565	8837.0
2008-09-02	ABX-DELISTED	Stock	32.98	33.33	32.02	32.88	12632342.0
2008-09-02	ACAD	Stock	2.57	2.7	2.3	2.36	79600.0
2008-09-02	ACAP-DELISTED	Stock	42.03	43.23	41.97	42.22	42396.0
2008-09-02	ACAS-DELISTED	Stock	22.3	22.38	21.45	21.83	2713716.0
2008-09-02	ACAT-DELISTED	Stock	10.45	11.35	10.45	11.0	104213.0

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

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