PREVIEW / stock_daily / 2014-10-02

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-02.parquet
  size:    222 KB
  rows:    6,636
  symbols: 3,579

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
2014-10-02	AAPL	Stock	24.8175	25.055	24.51	24.975	191031200.0
2014-10-02	MSFT	Stock	45.83	46.1	45.64	45.76	25119400.0
2014-10-02	NVDA	Stock	0.456	0.4582	0.4442	0.4548	288996000.0
2014-10-02	AMZN	Stock	15.846	15.9265	15.5655	15.9205	71078000.0
2014-10-02	GOOGL	Stock	28.9	29.162	28.7025	29.044	30738700.0
2014-10-02	META	Stock	76.57	77.48	75.64	77.08	36488000.0
2014-10-02	TSLA	Stock	16.68	16.8527	16.3573	16.7613	134973000.0
2014-10-02	TLT	Stock	117.83	118.2	117.14	117.2	8253062.0
2014-10-02	ES	Stock	44.84	45.3	44.79	45.05	2604100.0
2014-10-02	CL	Stock	64.75	64.98	64.51	64.78	3230500.0
2014-10-02	A	Stock	40.1502	40.2289	39.5494	39.9356	2387924.0
2014-10-02	AA.B-DELISTED	Stock	49.11	49.11	47.23	48.46	127534.0
2014-10-02	AABA-DELISTED	Stock	40.24	40.64	39.69	40.5	23373954.0
2014-10-02	AAC-DELISTED	Stock	20.0	20.1	17.6	18.58	2753789.0
2014-10-02	AACG	Stock	4.34	4.5	4.25	4.45	5200.0
2014-10-02	AAIC-DELISTED	Stock	25.5	25.62	25.12	25.52	538313.0
2014-10-02	AAL	Stock	34.47	35.38	33.51	33.93	21476300.0
2014-10-02	AAMC-DELISTED	Stock	198.8412	204.2618	196.9118	200.0735	17303.0
2014-10-02	AAME	Stock	3.89	4.0	3.88	4.0	900.0
2014-10-02	AAOI	Stock	15.22	15.52	14.37	15.19	531400.0
2014-10-02	AAON	Stock	11.5467	11.9467	11.5267	11.7333	241950.0
2014-10-02	AAP	Stock	130.2	133.23	130.03	132.97	944500.0
2014-10-02	AAT	Stock	33.17	33.58	33.0	33.57	209800.0
2014-10-02	AAU-DELISTED	Stock	1.35	1.35	1.29	1.3	104324.0
2014-10-02	AAUAF-DELISTED	Stock	1.35	1.35	1.29	1.31	105479.0
2014-10-02	AAV-DELISTED	Stock	4.99	5.0	4.8334	4.97	427062.0
2014-10-02	AAVL-DELISTED	Stock	32.37	34.4	31.74	34.26	130111.0
2014-10-02	AAWW-DELISTED	Stock	31.61	32.35	31.46	31.99	354810.0
2014-10-02	AAXJ	Stock	60.27	60.77	59.74	60.53	733133.0
2014-10-02	AAXN-DELISTED	Stock	14.6	15.37	14.59	15.255	1987307.0
2014-10-02	AB	Stock	25.39	25.65	25.39	25.55	169200.0
2014-10-02	ABAC-DELISTED	Stock	1.97	2.0201	1.88	1.99	31378.0
2014-10-02	ABAX-DELISTED	Stock	51.21	51.63	50.871	51.4	225544.0
2014-10-02	ABB-DELISTED	Stock	22.05	22.08	21.7	21.9	1650463.0
2014-10-02	ABBNY-DELISTED	Stock	22.05	22.08	21.7	21.91	1758542.0
2014-10-02	ABBV	Stock	57.54	57.7	56.14	56.67	8371500.0
2014-10-02	ABC-DELISTED	Stock	76.61	77.25	76.365	76.88	1317896.0
2014-10-02	ABCB	Stock	21.89	22.5	21.89	22.39	108500.0
2014-10-02	ABCD-DELISTED	Stock	1.6825	1.6825	1.56	1.6099	4400.0
2014-10-02	ABCO-DELISTED	Stock	45.39	46.49	45.39	45.91	196914.0
2014-10-02	ABDC-DELISTED	Stock	13.25	13.5	13.069	13.31	38662.0
2014-10-02	ABE-DELISTED	Stock	13.83	13.99	13.82	13.93	18098.0
2014-10-02	ABEO	Stock	337.5	337.5	325.0	337.5	4.0
2014-10-02	ABEV	Stock	6.26	6.43	6.18	6.42	19356600.0
2014-10-02	ABG	Stock	63.83	67.36	63.83	65.47	604300.0
2014-10-02	ABGB-DELISTED	Stock	24.09	24.09	23.4	23.68	54857.0
2014-10-02	ABIL-DELISTED	Stock	9.8	9.8	9.8	9.8	500.0
2014-10-02	ABM	Stock	25.15	25.57	25.12	25.44	152000.0
2014-10-02	ABMD-DELISTED	Stock	24.24	24.46	24.06	24.33	187627.0
2014-10-02	ABR	Stock	6.69	6.73	6.61	6.64	44900.0

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

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