PREVIEW / stock_daily / 2011-11-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-02.parquet
  size:    195 KB
  rows:    6,079
  symbols: 3,513

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
2011-11-02	AAPL	Stock	14.2889	14.3014	14.1111	14.1932	327350800.0
2011-11-02	MSFT	Stock	26.1	26.2	25.7	26.01	53533100.0
2011-11-02	NVDA	Stock	0.355	0.3568	0.3382	0.3455	961608000.0
2011-11-02	AMZN	Stock	10.7775	10.8395	10.636	10.781	122440000.0
2011-11-02	TSLA	Stock	1.9333	1.9507	1.8833	1.914	13129500.0
2011-11-02	TLT	Stock	116.63	118.36	116.42	117.96	13181685.0
2011-11-02	ES	Stock	33.99	34.56	33.93	34.22	2203700.0
2011-11-02	CL	Stock	44.5	44.55	43.825	43.97	4431200.0
2011-11-02	A	Stock	25.6223	26.1445	25.3934	25.8655	5647361.0
2011-11-02	AABA-DELISTED	Stock	15.11	15.3	15.0	15.09	20535692.0
2011-11-02	AACC-DELISTED	Stock	3.5	3.5	3.18	3.32	4320.0
2011-11-02	AACG	Stock	9.88	10.25	9.75	9.77	26200.0
2011-11-02	AAIC-DELISTED	Stock	22.54	22.8	22.14	22.74	77227.0
2011-11-02	AAME	Stock	1.76	1.8	1.76	1.8	900.0
2011-11-02	AAON	Stock	6.0148	6.3556	6.0148	6.3259	292950.0
2011-11-02	AAP	Stock	65.52	65.52	64.38	64.9	564800.0
2011-11-02	AAT	Stock	19.29	19.73	19.03	19.65	128300.0
2011-11-02	AATI-DELISTED	Stock	4.27	4.29	4.23	4.29	212570.0
2011-11-02	AAU-DELISTED	Stock	2.76	2.87	2.7	2.84	106372.0
2011-11-02	AAUAF-DELISTED	Stock	2.74	2.85	2.7	2.84	107881.0
2011-11-02	AAV-DELISTED	Stock	5.06	5.14	4.97	5.14	197689.0
2011-11-02	AAWW-DELISTED	Stock	37.94	38.6	37.18	38.51	248798.0
2011-11-02	AAXJ	Stock	54.31	54.41	53.708	54.33	315567.0
2011-11-02	AAXN-DELISTED	Stock	5.02	5.185	5.01	5.18	664982.0
2011-11-02	AB	Stock	14.0	14.0	13.4	13.69	322600.0
2011-11-02	ABAC-DELISTED	Stock	1.83	2.0	1.83	1.98	59585.0
2011-11-02	ABAX-DELISTED	Stock	27.77	27.77	27.127	27.43	101072.0
2011-11-02	ABB-DELISTED	Stock	18.23	18.4272	18.05	18.33	3481139.0
2011-11-02	ABBNY-DELISTED	Stock	18.23	18.4272	18.05	18.32	3482714.0
2011-11-02	ABC-DELISTED	Stock	40.51	40.7	39.62	39.87	1968053.0
2011-11-02	ABCB	Stock	10.12	10.31	10.0	10.1	68800.0
2011-11-02	ABCD-DELISTED	Stock	3.27	3.37	3.19	3.32	22316.0
2011-11-02	ABCO-DELISTED	Stock	30.68	31.44	30.31	30.95	269122.0
2011-11-02	ABCW-DELISTED	Stock	0.49	0.51	0.49	0.5	14890.0
2011-11-02	ABD-DELISTED	Stock	6.6798	7.01	6.6097	6.9702	258640.0
2011-11-02	ABE-DELISTED	Stock	18.1	18.1	17.68	17.975	3450.0
2011-11-02	ABEO	Stock	2037.5	2037.5	1575.0	1650.0	164.0
2011-11-02	ABFS-DELISTED	Stock	19.88	20.23	19.32	20.0	563049.0
2011-11-02	ABG	Stock	18.7	19.0	18.49	18.8	464100.0
2011-11-02	ABH-DELISTED	Stock	16.49	16.74	16.16	16.27	324312.0
2011-11-02	ABM	Stock	19.43	19.66	19.21	19.42	423000.0
2011-11-02	ABMD-DELISTED	Stock	14.72	14.72	14.09	14.51	161647.0
2011-11-02	ABR	Stock	3.55	3.59	3.49	3.59	30400.0
2011-11-02	ABT	Stock	25.5685	25.6597	25.2855	25.3718	13003960.0
2011-11-02	ABTL-DELISTED	Stock	4.5025	4.5195	4.3524	4.4975	2605.0
2011-11-02	ABV-DELISTED	Stock	34.14	34.31	33.54	33.87	1695746.0
2011-11-02	ABVA-DELISTED	Stock	5.25	5.25	5.15	5.15	5195.0
2011-11-02	ABVT-DELISTED	Stock	56.5	57.27	55.031	57.0	120120.0
2011-11-02	ABX-DELISTED	Stock	49.97	51.51	49.95	50.59	8753527.0
2011-11-02	ACAD	Stock	1.2	1.2	1.15	1.18	45000.0

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

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