PREVIEW / stock_daily / 2013-01-02

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-02.parquet
  size:    204 KB
  rows:    6,265
  symbols: 3,537

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
2013-01-02	AAPL	Stock	19.7793	19.8214	19.3439	19.6082	560518000.0
2013-01-02	MSFT	Stock	27.25	27.73	27.15	27.62	52899300.0
2013-01-02	NVDA	Stock	0.314	0.3183	0.3128	0.318	478836000.0
2013-01-02	AMZN	Stock	12.804	12.905	12.663	12.8655	65420000.0
2013-01-02	META	Stock	27.44	28.18	27.42	28.0	69846400.0
2013-01-02	TSLA	Stock	2.3333	2.3633	2.314	2.3573	17922000.0
2013-01-02	TLT	Stock	119.76	119.9	119.41	119.56	7473685.0
2013-01-02	ES	Stock	39.47	39.9	39.41	39.82	1419200.0
2013-01-02	CL	Stock	52.805	53.155	52.615	53.155	4150200.0
2013-01-02	A	Stock	30.1645	30.1645	29.4349	29.9571	8790205.0
2013-01-02	AABA-DELISTED	Stock	20.24	20.317	20.01	20.08	20245946.0
2013-01-02	AACC-DELISTED	Stock	4.69	5.0	4.69	4.85	117428.0
2013-01-02	AACG	Stock	6.66	6.66	5.84	6.0	22200.0
2013-01-02	AAIC-DELISTED	Stock	21.24	21.72	21.24	21.65	169277.0
2013-01-02	AAMC-DELISTED	Stock	24.5588	25.0	22.2794	22.3529	88213.0
2013-01-02	AAME	Stock	3.09	3.24	3.09	3.2	3500.0
2013-01-02	AAMRQ-DELISTED	Stock	0.8046	0.863	0.8012	0.859	5449555.0
2013-01-02	AAON	Stock	6.3378	6.4	6.2252	6.3022	751613.0
2013-01-02	AAP	Stock	73.49	73.76	71.69	72.49	800500.0
2013-01-02	AAT	Stock	28.49	28.79	28.25	28.53	240900.0
2013-01-02	AAU-DELISTED	Stock	3.23	3.26	3.21	3.26	152889.0
2013-01-02	AAUAF-DELISTED	Stock	3.24	3.25	3.21	3.25	154468.0
2013-01-02	AAV-DELISTED	Stock	3.28	3.3	3.18	3.19	185524.0
2013-01-02	AAWW-DELISTED	Stock	45.54	46.006	44.52	45.61	273166.0
2013-01-02	AAXJ	Stock	61.44	61.94	61.34	61.76	520133.0
2013-01-02	AAXN-DELISTED	Stock	9.1	9.14	8.68	8.95	907752.0
2013-01-02	AB	Stock	17.65	18.02	17.65	17.99	415300.0
2013-01-02	ABAC-DELISTED	Stock	0.88	0.98	0.88	0.9601	12300.0
2013-01-02	ABAX-DELISTED	Stock	38.0	38.26	37.11	37.89	272020.0
2013-01-02	ABB-DELISTED	Stock	21.21	21.32	21.06	21.18	2064992.0
2013-01-02	ABBNY-DELISTED	Stock	21.21	21.32	21.06	21.19	2097157.0
2013-01-02	ABC-DELISTED	Stock	43.59	43.74	43.225	43.48	1912266.0
2013-01-02	ABCB	Stock	12.67	12.92	12.57	12.83	186400.0
2013-01-02	ABCD-DELISTED	Stock	1.11	1.22	1.11	1.19	35466.0
2013-01-02	ABCO-DELISTED	Stock	47.51	49.32	47.51	49.27	263499.0
2013-01-02	ABCW-DELISTED	Stock	0.35	0.39	0.3376	0.385	18841.0
2013-01-02	ABE-DELISTED	Stock	21.71	21.95	21.6601	21.83	12027.0
2013-01-02	ABEO	Stock	312.5	337.5	287.5	337.5	20.0
2013-01-02	ABFS-DELISTED	Stock	9.74	10.06	9.61	9.73	321576.0
2013-01-02	ABG	Stock	32.48	33.4	32.09	32.26	600000.0
2013-01-02	ABM	Stock	20.22	20.68	20.04	20.39	451000.0
2013-01-02	ABMD-DELISTED	Stock	13.69	14.13	13.68	13.69	846223.0
2013-01-02	ABR	Stock	6.09	6.13	5.97	6.04	243400.0
2013-01-02	ABT	Stock	32.3	32.45	31.64	32.05	20266400.0
2013-01-02	ABTL-DELISTED	Stock	3.88	3.99	3.88	3.99	3510.0
2013-01-02	ABUS	Stock	5.0	5.09	4.99	5.06	50200.0
2013-01-02	ABV-DELISTED	Stock	42.01	42.5662	41.83	42.13	1623532.0
2013-01-02	ABX-DELISTED	Stock	35.92	36.08	35.38	35.52	6867721.0
2013-01-02	ACAD	Stock	4.78	4.82	4.65	4.73	821700.0
2013-01-02	ACAS-DELISTED	Stock	12.25	12.4	12.24	12.37	5390285.0

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

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