PREVIEW / stock_daily / 2011-12-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-02.parquet
  size:    196 KB
  rows:    6,140
  symbols: 3,552

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-02	AAPL	Stock	13.9225	14.0582	13.8779	13.9179	379055600.0
2011-12-02	MSFT	Stock	25.59	25.62	25.16	25.22	52293800.0
2011-12-02	NVDA	Stock	0.3998	0.4013	0.3893	0.393	546464000.0
2011-12-02	AMZN	Stock	9.8535	9.983	9.759	9.8015	150524000.0
2011-12-02	TSLA	Stock	2.1887	2.246	2.16	2.22	12042000.0
2011-12-02	TLT	Stock	116.62	118.68	116.56	118.64	7764842.0
2011-12-02	ES	Stock	34.93	35.0	34.26	34.34	1742300.0
2011-12-02	CL	Stock	45.445	45.625	45.045	45.095	3954600.0
2011-12-02	A	Stock	27.4607	27.5966	26.2303	26.2947	4885311.0
2011-12-02	AABA-DELISTED	Stock	16.32	16.41	16.03	16.05	22659864.0
2011-12-02	AACC-DELISTED	Stock	3.55	3.75	3.39	3.74	35251.0
2011-12-02	AACG	Stock	9.49	9.56	9.48	9.48	900.0
2011-12-02	AAIC-DELISTED	Stock	19.79	20.06	19.78	19.92	66469.0
2011-12-02	AAME	Stock	1.97	1.98	1.82	1.98	6400.0
2011-12-02	AAON	Stock	6.3407	6.4119	6.2933	6.3467	139050.0
2011-12-02	AAP	Stock	69.44	69.47	68.49	69.06	616900.0
2011-12-02	AAT	Stock	20.48	20.52	20.18	20.21	325300.0
2011-12-02	AATI-DELISTED	Stock	5.76	5.76	5.75	5.755	548970.0
2011-12-02	AAU-DELISTED	Stock	2.65	2.65	2.54	2.55	145796.0
2011-12-02	AAUAF-DELISTED	Stock	2.65	2.65	2.54	2.55	146396.0
2011-12-02	AAV-DELISTED	Stock	4.79	4.83	4.66	4.68	280255.0
2011-12-02	AAWW-DELISTED	Stock	41.1	41.82	39.36	39.88	201495.0
2011-12-02	AAXJ	Stock	52.76	53.12	52.24	52.38	658555.0
2011-12-02	AAXN-DELISTED	Stock	6.16	6.27	6.08	6.1	418414.0
2011-12-02	AB	Stock	13.4	13.43	13.13	13.19	469200.0
2011-12-02	ABAC-DELISTED	Stock	1.62	1.68	1.5701	1.59	14214.0
2011-12-02	ABAX-DELISTED	Stock	27.57	27.93	27.52	27.7	141038.0
2011-12-02	ABB-DELISTED	Stock	18.92	18.96	18.58	18.635	2213816.0
2011-12-02	ABBNY-DELISTED	Stock	18.92	18.96	18.58	18.63	2415623.0
2011-12-02	ABC-DELISTED	Stock	37.6	37.65	36.85	37.0	1984211.0
2011-12-02	ABCB	Stock	9.95	10.02	9.83	9.98	25700.0
2011-12-02	ABCD-DELISTED	Stock	3.05	3.14	2.93	3.01	37253.0
2011-12-02	ABCO-DELISTED	Stock	36.29	36.51	36.0	36.13	108689.0
2011-12-02	ABCW-DELISTED	Stock	0.3815	0.4016	0.3715	0.4016	51530.0
2011-12-02	ABD-DELISTED	Stock	9.46	9.54	9.21	9.28	300810.0
2011-12-02	ABE-DELISTED	Stock	18.01	18.05	17.9	18.05	5717.0
2011-12-02	ABEO	Stock	1725.0	1800.0	1650.0	1800.0	22.0
2011-12-02	ABFS-DELISTED	Stock	19.08	19.39	18.75	18.8	238161.0
2011-12-02	ABG	Stock	20.0	20.31	19.87	20.24	623800.0
2011-12-02	ABH-DELISTED	Stock	15.0	15.16	14.88	14.95	566826.0
2011-12-02	ABM	Stock	21.86	22.96	21.86	22.04	1022100.0
2011-12-02	ABMD-DELISTED	Stock	20.16	20.3	19.63	19.88	271000.0
2011-12-02	ABR	Stock	3.48	3.5	3.42	3.5	47900.0
2011-12-02	ABT	Stock	26.1875	26.3026	25.8852	25.9812	13350563.0
2011-12-02	ABTL-DELISTED	Stock	3.7578	3.9609	3.5801	3.9	5964.0
2011-12-02	ABUS	Stock	1.64	1.7	1.64	1.7	8000.0
2011-12-02	ABV-DELISTED	Stock	35.4	35.43	34.47	34.52	3104701.0
2011-12-02	ABVA-DELISTED	Stock	3.8	3.82	3.6	3.75	11400.0
2011-12-02	ABVT-DELISTED	Stock	60.13	61.03	59.23	60.79	214158.0
2011-12-02	ABX-DELISTED	Stock	53.01	53.14	50.91	51.0	6966230.0

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

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