PREVIEW / stock_daily / 2016-08-02

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-02.parquet
  size:    219 KB
  rows:    6,521
  symbols: 3,229

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
2016-08-02	AAPL	Stock	26.5125	26.5175	26.0	26.12	135266400.0
2016-08-02	MSFT	Stock	56.85	56.9	56.31	56.58	35122000.0
2016-08-02	NVDA	Stock	1.425	1.4258	1.3875	1.401	282748000.0
2016-08-02	AMZN	Stock	38.1905	38.2505	37.851	38.029	72066000.0
2016-08-02	GOOGL	Stock	39.8665	40.116	39.7265	40.006	39927080.0
2016-08-02	META	Stock	124.06	124.8	122.07	123.09	23968400.0
2016-08-02	TSLA	Stock	15.2913	15.3247	14.76	15.1467	59016000.0
2016-08-02	TLT	Stock	137.83	139.26	137.5	138.33	10051207.0
2016-08-02	ES	Stock	58.79	59.01	58.11	58.49	1364100.0
2016-08-02	CL	Stock	75.25	75.34	74.46	74.87	3748000.0
2016-08-02	A	Stock	47.71	47.75	46.97	47.18	1595900.0
2016-08-02	AA.B-DELISTED	Stock	36.04	36.04	35.25	35.5	16128.0
2016-08-02	AAAP-DELISTED	Stock	31.77	31.79	31.293	31.63	24845.0
2016-08-02	AABA-DELISTED	Stock	38.6	38.67	38.26	38.58	6692507.0
2016-08-02	AAC-DELISTED	Stock	21.54	22.0	21.1	21.3	55182.0
2016-08-02	AAIC-DELISTED	Stock	14.09	14.233	14.03	14.13	293574.0
2016-08-02	AAL	Stock	35.39	35.4	33.38	33.51	12100400.0
2016-08-02	AAMC-DELISTED	Stock	3.7676	3.8765	3.6824	3.7765	48069.0
2016-08-02	AAME	Stock	4.17	4.25	4.1	4.25	300.0
2016-08-02	AAMI	Stock	13.68	13.79	13.44	13.47	67200.0
2016-08-02	AAOI	Stock	12.12	12.3	11.6	11.64	199400.0
2016-08-02	AAON	Stock	17.66	17.86	17.42	17.5467	172050.0
2016-08-02	AAP	Stock	168.17	168.48	165.35	166.61	881800.0
2016-08-02	AAT	Stock	45.77	45.91	44.96	45.46	279600.0
2016-08-02	AAU-DELISTED	Stock	1.56	1.56	1.42	1.46	414335.0
2016-08-02	AAUAF-DELISTED	Stock	1.56	1.56	1.42	1.46	422060.0
2016-08-02	AAV-DELISTED	Stock	6.18	6.2902	6.13	6.24	72068.0
2016-08-02	AAWW-DELISTED	Stock	43.37	43.95	40.94	41.16	306356.0
2016-08-02	AAXJ	Stock	57.52	57.65	57.019	57.36	571254.0
2016-08-02	AAXN-DELISTED	Stock	29.18	29.42	28.53	28.84	781195.0
2016-08-02	AB	Stock	23.5	23.69	22.4	22.45	408000.0
2016-08-02	ABAC-DELISTED	Stock	0.6869	0.6869	0.61	0.66	21041.0
2016-08-02	ABAX-DELISTED	Stock	48.86	49.74	48.42	48.6	102442.0
2016-08-02	ABB-DELISTED	Stock	21.21	21.21	21.0	21.07	1404360.0
2016-08-02	ABBNY-DELISTED	Stock	21.21	21.21	21.0	21.08	1542893.0
2016-08-02	ABBV	Stock	66.93	67.06	66.05	66.78	8763200.0
2016-08-02	ABC-DELISTED	Stock	88.64	90.54	87.58	89.4	4085720.0
2016-08-02	ABCB	Stock	32.83	32.94	32.62	32.77	113400.0
2016-08-02	ABCD-DELISTED	Stock	4.87	4.8999	4.87	4.87	3757.0
2016-08-02	ABCO-DELISTED	Stock	41.82	42.71	40.6	41.33	376087.0
2016-08-02	ABDC-DELISTED	Stock	12.33	12.35	12.2001	12.25	25650.0
2016-08-02	ABE-DELISTED	Stock	12.678	12.678	12.43	12.486	4909.0
2016-08-02	ABEO	Stock	71.75	75.0	70.0	74.5	6428.0
2016-08-02	ABEOW-DELISTED	Stock	1.05	1.3	1.05	1.2	1465.0
2016-08-02	ABEV	Stock	5.82	5.84	5.72	5.75	17890900.0
2016-08-02	ABG	Stock	59.64	59.64	55.85	55.89	279300.0
2016-08-02	ABIL-DELISTED	Stock	4.97	5.08	4.96	5.05	94185.0
2016-08-02	ABM	Stock	37.18	37.42	36.75	36.85	237800.0
2016-08-02	ABMD-DELISTED	Stock	119.5	119.899	117.5	118.83	506130.0
2016-08-02	ABR	Stock	7.19	7.2	7.13	7.2	53600.0

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

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