PREVIEW / stock_daily / 2015-07-02

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-02.parquet
  size:    223 KB
  rows:    6,653
  symbols: 3,484

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
2015-07-02	AAPL	Stock	31.6075	31.6725	31.4425	31.61	108844000.0
2015-07-02	MSFT	Stock	44.48	44.75	44.06	44.4	21752000.0
2015-07-02	NVDA	Stock	0.5098	0.5138	0.5072	0.5105	145764000.0
2015-07-02	AMZN	Stock	21.85	21.91	21.674	21.8855	26868000.0
2015-07-02	GOOGL	Stock	27.237	27.4	27.1785	27.367	28124260.0
2015-07-02	META	Stock	87.4	87.44	86.34	87.29	16908800.0
2015-07-02	TSLA	Stock	18.68	18.83	18.2207	18.668	107458500.0
2015-07-02	TLT	Stock	116.32	116.66	115.88	116.0	6682132.0
2015-07-02	ES	Stock	45.97	46.56	45.79	46.51	1839700.0
2015-07-02	CL	Stock	66.38	66.58	65.98	66.16	2024700.0
2015-07-02	A	Stock	39.36	39.64	39.15	39.58	2160800.0
2015-07-02	AA.B-DELISTED	Stock	39.92	40.5199	39.58	40.28	19574.0
2015-07-02	AABA-DELISTED	Stock	39.26	39.64	39.19	39.37	7357717.0
2015-07-02	AAC-DELISTED	Stock	43.17	45.0	43.0	44.71	142099.0
2015-07-02	AACG	Stock	5.69	5.69	5.41	5.41	16500.0
2015-07-02	AAIC-DELISTED	Stock	19.55	19.86	19.52	19.66	234910.0
2015-07-02	AAL	Stock	39.02	39.81	38.4	39.03	11080000.0
2015-07-02	AAMC-DELISTED	Stock	42.7559	42.7559	41.3235	41.3235	4709.0
2015-07-02	AAME	Stock	3.71	3.71	3.71	3.71	200.0
2015-07-02	AAMI	Stock	17.78	17.83	17.57	17.69	133900.0
2015-07-02	AAOI	Stock	17.96	17.96	17.02	17.06	326200.0
2015-07-02	AAON	Stock	15.2733	15.32	14.98	15.1667	173250.0
2015-07-02	AAP	Stock	163.58	164.3	161.18	162.11	414400.0
2015-07-02	AAT	Stock	39.49	40.21	39.2	39.69	248700.0
2015-07-02	AAU-DELISTED	Stock	0.8396	0.8523	0.8253	0.85	135525.0
2015-07-02	AAUAF-DELISTED	Stock	0.83	0.85	0.8159	0.85	137764.0
2015-07-02	AAV-DELISTED	Stock	6.2	6.4385	6.18	6.31	84482.0
2015-07-02	AAVL-DELISTED	Stock	16.02	16.165	15.7	16.05	278308.0
2015-07-02	AAWW-DELISTED	Stock	54.66	55.03	54.02	54.56	263516.0
2015-07-02	AAXJ	Stock	63.56	63.88	63.44	63.48	592037.0
2015-07-02	AAXN-DELISTED	Stock	33.18	33.4	32.299	32.49	892915.0
2015-07-02	AB	Stock	29.6	29.64	29.05	29.3	118800.0
2015-07-02	ABAC-DELISTED	Stock	1.2901	1.4128	1.2901	1.3	9788.0
2015-07-02	ABAX-DELISTED	Stock	52.03	52.06	50.45	50.48	80156.0
2015-07-02	ABB-DELISTED	Stock	20.89	20.93	20.73	20.79	1700902.0
2015-07-02	ABBNY-DELISTED	Stock	20.89	20.93	20.73	20.8	1748779.0
2015-07-02	ABBV	Stock	68.68	68.9	67.79	68.21	6245700.0
2015-07-02	ABC-DELISTED	Stock	107.71	108.32	107.03	107.1	1048168.0
2015-07-02	ABCB	Stock	25.25	25.25	24.74	24.97	142400.0
2015-07-02	ABCD-DELISTED	Stock	4.27	4.27	4.15	4.18	19211.0
2015-07-02	ABCO-DELISTED	Stock	54.47	54.6	53.59	54.41	222052.0
2015-07-02	ABCW-DELISTED	Stock	39.37	39.9	39.37	39.67	12156.0
2015-07-02	ABDC-DELISTED	Stock	12.7899	12.7899	12.37	12.54	41369.0
2015-07-02	ABE-DELISTED	Stock	12.92	12.922	12.84	12.87	6629.0
2015-07-02	ABEO	Stock	125.75	131.25	124.5	127.5	14976.0
2015-07-02	ABEOW-DELISTED	Stock	1.5	1.61	1.1	1.48	14835.0
2015-07-02	ABEV	Stock	6.14	6.14	6.09	6.14	18017500.0
2015-07-02	ABG	Stock	92.49	93.31	90.98	91.06	239300.0
2015-07-02	ABGB-DELISTED	Stock	16.32	16.45	16.32	16.33	19336.0
2015-07-02	ABM	Stock	32.87	32.91	32.25	32.64	374000.0

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

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