PREVIEW / stock_daily / 2010-11-02

all stock daily files

  file:    by_date/stock_daily/2010/2010-11-02.parquet
  size:    194 KB
  rows:    6,010
  symbols: 3,523

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-11-02	AAPL	Stock	10.9643	11.0782	10.9643	11.0486	433930000.0
2010-11-02	MSFT	Stock	27.06	27.42	27.02	27.39	54402100.0
2010-11-02	NVDA	Stock	0.3022	0.3123	0.3005	0.3073	581036000.0
2010-11-02	AMZN	Stock	8.1875	8.297	8.168	8.2305	85200000.0
2010-11-02	TSLA	Stock	1.4453	1.4587	1.4033	1.4167	4837500.0
2010-11-02	TLT	Stock	100.46	101.09	100.42	100.98	6537348.0
2010-11-02	ES	Stock	31.68	31.88	31.59	31.88	1221300.0
2010-11-02	CL	Stock	38.685	39.125	38.685	39.025	6532200.0
2010-11-02	A	Stock	25.0215	25.1717	24.8784	25.0787	2930068.0
2010-11-02	AABA-DELISTED	Stock	16.31	16.4	16.18	16.2	9735351.0
2010-11-02	AACC-DELISTED	Stock	5.54	5.85	5.54	5.83	17789.0
2010-11-02	AACG	Stock	3.45	3.61	3.45	3.57	2300.0
2010-11-02	AAI-DELISTED	Stock	7.43	7.445	7.36	7.43	6016493.0
2010-11-02	AAIC-DELISTED	Stock	23.11	23.99	22.89	23.75	49768.0
2010-11-02	AAME	Stock	1.75	1.75	1.7	1.7	5200.0
2010-11-02	AAON	Stock	4.9244	4.9383	4.8474	4.9165	139725.0
2010-11-02	AAP	Stock	65.11	65.19	64.48	64.57	472000.0
2010-11-02	AATI-DELISTED	Stock	3.79	3.79	3.68	3.73	223757.0
2010-11-02	AAU-DELISTED	Stock	2.89	2.9	2.79	2.8	215091.0
2010-11-02	AAUAF-DELISTED	Stock	2.89	2.9	2.79	2.8	215591.0
2010-11-02	AAV-DELISTED	Stock	6.33	6.44	6.27	6.44	295517.0
2010-11-02	AAWW-DELISTED	Stock	56.15	59.03	55.81	58.87	445092.0
2010-11-02	AAXJ	Stock	63.52	63.68	63.36	63.59	700673.0
2010-11-02	AAXN-DELISTED	Stock	3.94	3.99	3.9	3.91	325497.0
2010-11-02	AB	Stock	24.11	24.39	24.11	24.28	610200.0
2010-11-02	ABAC-DELISTED	Stock	6.15	7.44	6.1	6.96	1236428.0
2010-11-02	ABAX-DELISTED	Stock	23.83	24.8	23.83	24.76	81106.0
2010-11-02	ABB-DELISTED	Stock	20.9	21.03	20.85	21.0	1502231.0
2010-11-02	ABBC-DELISTED	Stock	10.78	11.06	10.68	11.06	81035.0
2010-11-02	ABBNY-DELISTED	Stock	20.9	21.03	20.85	21.0	1507859.0
2010-11-02	ABC-DELISTED	Stock	33.03	33.23	31.1	31.95	7449565.0
2010-11-02	ABCB	Stock	9.17	9.3	9.05	9.08	69200.0
2010-11-02	ABCD-DELISTED	Stock	3.06	3.18	3.05	3.12	27644.0
2010-11-02	ABCO-DELISTED	Stock	23.37	24.29	23.37	24.08	95458.0
2010-11-02	ABCW-DELISTED	Stock	0.65	0.67	0.53	0.59	111890.0
2010-11-02	ABD-DELISTED	Stock	6.145	6.2251	6.0449	6.115	223540.0
2010-11-02	ABE-DELISTED	Stock	19.07	19.111	18.96	19.026	86810.0
2010-11-02	ABEO	Stock	3662.5	3775.0	3662.5	3775.0	34.0
2010-11-02	ABFS-DELISTED	Stock	26.59	26.82	26.17	26.49	411834.0
2010-11-02	ABG	Stock	14.84	15.12	14.7	14.9	181200.0
2010-11-02	ABK-DELISTED	Stock	0.4226	0.5188	0.4226	0.4849	37308333.0
2010-11-02	ABM	Stock	22.72	23.15	22.58	23.15	205600.0
2010-11-02	ABMD-DELISTED	Stock	10.54	10.72	10.34	10.71	145401.0
2010-11-02	ABR	Stock	5.3	5.3	5.22	5.28	35900.0
2010-11-02	ABT	Stock	24.369	24.4986	24.3307	24.4122	15725927.0
2010-11-02	ABTL-DELISTED	Stock	4.1	4.145	4.0	4.1	20642.0
2010-11-02	ABV-DELISTED	Stock	140.89	141.05	138.18	139.07	393864.0
2010-11-02	ABVA-DELISTED	Stock	3.21	3.21	3.2099	3.2099	2000.0
2010-11-02	ABVT-DELISTED	Stock	57.99	58.3	57.59	58.15	165280.0
2010-11-02	ABX-DELISTED	Stock	48.6	49.03	48.14	48.74	6187188.0

> showing 50 of 6,010 rows — these rows as CSV

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