PREVIEW / stock_daily / 2010-09-02

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-02.parquet
  size:    189 KB
  rows:    5,929
  symbols: 3,476

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
2010-09-02	AAPL	Stock	8.9736	9.0061	8.8775	9.0061	415427600.0
2010-09-02	MSFT	Stock	23.88	23.95	23.71	23.94	48837100.0
2010-09-02	NVDA	Stock	0.2358	0.24	0.2335	0.2392	596292000.0
2010-09-02	AMZN	Stock	6.6085	6.7605	6.6025	6.7605	108148000.0
2010-09-02	TSLA	Stock	1.358	1.416	1.354	1.404	7306500.0
2010-09-02	TLT	Stock	105.2	105.3	104.4	104.88	8168089.0
2010-09-02	ES	Stock	29.69	29.83	29.2	29.21	2282900.0
2010-09-02	CL	Stock	37.44	37.55	37.255	37.415	5507000.0
2010-09-02	A	Stock	20.3648	20.9227	20.279	20.8941	3802979.0
2010-09-02	AABA-DELISTED	Stock	13.32	13.545	13.26	13.51	17296559.0
2010-09-02	AACC-DELISTED	Stock	3.95	3.96	3.8125	3.95	19944.0
2010-09-02	AACG	Stock	2.93	2.97	2.9	2.97	54800.0
2010-09-02	AAI-DELISTED	Stock	4.65	4.68	4.55	4.64	1091343.0
2010-09-02	AAIC-DELISTED	Stock	20.94	20.94	20.31	20.39	35183.0
2010-09-02	AAME	Stock	1.37	1.37	1.37	1.37	7000.0
2010-09-02	AAON	Stock	4.478	4.478	4.3457	4.4464	254644.0
2010-09-02	AAP	Stock	55.43	56.49	55.43	56.29	623900.0
2010-09-02	AATI-DELISTED	Stock	3.45	3.452	3.35	3.38	80534.0
2010-09-02	AAU-DELISTED	Stock	2.14	2.2	2.12	2.2	287242.0
2010-09-02	AAUAF-DELISTED	Stock	2.14	2.2	2.12	2.2	289842.0
2010-09-02	AAV-DELISTED	Stock	6.03	6.3	6.01	6.29	423317.0
2010-09-02	AAWW-DELISTED	Stock	45.27	47.61	44.82	47.38	305438.0
2010-09-02	AAXJ	Stock	55.82	56.0	55.57	55.96	249925.0
2010-09-02	AAXN-DELISTED	Stock	3.9	3.98	3.8699	3.97	412530.0
2010-09-02	AB	Stock	24.45	24.81	24.29	24.5	725700.0
2010-09-02	ABAC-DELISTED	Stock	3.8	3.87	3.8	3.82	5150.0
2010-09-02	ABAX-DELISTED	Stock	18.91	19.19	18.5701	19.09	52045.0
2010-09-02	ABB-DELISTED	Stock	20.15	20.36	20.09	20.35	1972841.0
2010-09-02	ABBC-DELISTED	Stock	10.11	10.16	10.05	10.14	135297.0
2010-09-02	ABBNY-DELISTED	Stock	20.15	20.37	20.09	20.37	2001526.0
2010-09-02	ABC-DELISTED	Stock	27.99	28.27	27.86	28.05	2680993.0
2010-09-02	ABCB	Stock	8.22	8.39	8.14	8.38	33400.0
2010-09-02	ABCD-DELISTED	Stock	3.01	3.14	3.01	3.07	22588.0
2010-09-02	ABCO-DELISTED	Stock	20.82	21.07	20.75	21.01	44517.0
2010-09-02	ABCW-DELISTED	Stock	0.64	0.65	0.62	0.63	74500.0
2010-09-02	ABD-DELISTED	Stock	6.1449	6.3051	6.0349	6.2951	201450.0
2010-09-02	ABE-DELISTED	Stock	17.27	17.35	17.21	17.3	8594.0
2010-09-02	ABEO	Stock	2562.5	2562.5	2412.5	2437.5	9.0
2010-09-02	ABFS-DELISTED	Stock	21.26	22.0	21.2	21.94	241485.0
2010-09-02	ABG	Stock	12.88	13.27	12.86	13.13	129500.0
2010-09-02	ABII-DELISTED	Stock	74.17	74.17	73.84	73.95	43336.0
2010-09-02	ABK-DELISTED	Stock	0.623	0.625	0.541	0.55	9032893.0
2010-09-02	ABM	Stock	20.61	21.16	20.61	21.09	236100.0
2010-09-02	ABMD-DELISTED	Stock	9.27	9.55	9.25	9.54	128963.0
2010-09-02	ABR	Stock	4.86	4.89	4.61	4.75	52400.0
2010-09-02	ABT	Stock	24.0908	24.2923	24.0908	24.2827	10352230.0
2010-09-02	ABTL-DELISTED	Stock	4.3519	4.5055	4.2495	4.25	7033.0
2010-09-02	ABV-DELISTED	Stock	112.44	114.15	112.25	113.21	556867.0
2010-09-02	ABVA-DELISTED	Stock	3.0	3.0	2.7	2.75	12540.0
2010-09-02	ABVT-DELISTED	Stock	53.85	53.85	53.06	53.24	82565.0

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

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