PREVIEW / stock_daily / 2011-12-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-21.parquet
  size:    197 KB
  rows:    6,198
  symbols: 3,583

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-12-21	AAPL	Stock	14.1675	14.1893	14.0004	14.1589	262948000.0
2011-12-21	MSFT	Stock	26.01	26.19	25.44	25.76	64132500.0
2011-12-21	NVDA	Stock	0.3455	0.3493	0.3362	0.343	548424000.0
2011-12-21	AMZN	Stock	9.096	9.175	8.6245	8.7175	161334000.0
2011-12-21	TSLA	Stock	1.8607	1.8713	1.7353	1.838	25582500.0
2011-12-21	TLT	Stock	120.63	120.83	119.07	119.1	11600084.0
2011-12-21	ES	Stock	34.83	35.25	34.65	35.17	2426700.0
2011-12-21	CL	Stock	45.875	46.5	45.79	46.485	5460400.0
2011-12-21	A	Stock	24.628	24.7854	24.2132	24.578	3751253.0
2011-12-21	AABA-DELISTED	Stock	15.15	16.24	14.74	15.98	45342026.0
2011-12-21	AACC-DELISTED	Stock	3.69	3.7001	3.64	3.65	3012.0
2011-12-21	AACG	Stock	7.96	8.5	7.96	8.4	2600.0
2011-12-21	AAIC-DELISTED	Stock	21.87	22.56	21.69	22.47	56416.0
2011-12-21	AAME	Stock	2.0	2.0	1.98	1.99	600.0
2011-12-21	AAON	Stock	6.3852	6.6519	6.2193	6.5363	277088.0
2011-12-21	AAP	Stock	68.97	69.18	68.17	68.5	1020200.0
2011-12-21	AAT	Stock	21.0	21.18	20.77	20.99	160600.0
2011-12-21	AATI-DELISTED	Stock	5.75	5.77	5.75	5.77	127913.0
2011-12-21	AAU-DELISTED	Stock	2.24	2.24	2.15	2.19	118490.0
2011-12-21	AAUAF-DELISTED	Stock	2.24	2.24	2.15	2.19	120090.0
2011-12-21	AAV-DELISTED	Stock	3.87	3.96	3.87	3.91	384732.0
2011-12-21	AAWW-DELISTED	Stock	37.78	38.95	37.55	38.67	151757.0
2011-12-21	AAXJ	Stock	49.78	50.02	49.31	50.01	278994.0
2011-12-21	AAXN-DELISTED	Stock	5.68	5.75	5.52	5.71	466902.0
2011-12-21	AB	Stock	13.5	13.51	12.85	13.08	340100.0
2011-12-21	ABAC-DELISTED	Stock	1.3	1.4	1.2701	1.4	46335.0
2011-12-21	ABAX-DELISTED	Stock	27.94	27.98	27.24	27.89	68923.0
2011-12-21	ABB-DELISTED	Stock	18.27	18.29	17.991	18.26	1937045.0
2011-12-21	ABBNY-DELISTED	Stock	18.27	18.29	17.991	18.24	1937045.0
2011-12-21	ABC-DELISTED	Stock	37.15	37.3	36.775	37.01	1534365.0
2011-12-21	ABCB	Stock	10.21	10.21	10.0	10.18	43400.0
2011-12-21	ABCD-DELISTED	Stock	3.17	3.28	3.09	3.26	43531.0
2011-12-21	ABCO-DELISTED	Stock	35.89	36.78	35.71	36.78	135213.0
2011-12-21	ABCW-DELISTED	Stock	0.2611	0.2711	0.251	0.2711	66360.0
2011-12-21	ABD-DELISTED	Stock	9.89	9.979	9.74	9.91	383980.0
2011-12-21	ABE-DELISTED	Stock	17.28	17.32	16.97	17.19	7490.0
2011-12-21	ABEO	Stock	1737.5	1737.5	1637.5	1737.5	19.0
2011-12-21	ABFS-DELISTED	Stock	18.75	18.98	18.16	18.88	191291.0
2011-12-21	ABG	Stock	19.71	20.5	19.48	20.39	246500.0
2011-12-21	ABH-DELISTED	Stock	14.97	14.97	14.22	14.27	585411.0
2011-12-21	ABM	Stock	20.69	20.9	20.23	20.82	316100.0
2011-12-21	ABMD-DELISTED	Stock	18.08	18.25	17.76	17.9	314511.0
2011-12-21	ABR	Stock	3.41	3.49	3.4	3.45	58500.0
2011-12-21	ABT	Stock	26.2643	26.6097	26.2547	26.6001	21375365.0
2011-12-21	ABTL-DELISTED	Stock	4.2503	4.3	4.1991	4.3	27544.0
2011-12-21	ABUS	Stock	1.51	1.65	1.51	1.65	7900.0
2011-12-21	ABV-DELISTED	Stock	36.25	36.33	35.71	36.02	2077845.0
2011-12-21	ABVA-DELISTED	Stock	3.53	3.53	3.35	3.52	9785.0
2011-12-21	ABVT-DELISTED	Stock	64.95	65.55	63.99	64.59	143112.0
2011-12-21	ABX-DELISTED	Stock	46.64	46.73	45.81	46.26	5913078.0

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

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