PREVIEW / stock_daily / 2016-06-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-29.parquet
  size:    219 KB
  rows:    6,577
  symbols: 3,282

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-06-29	AAPL	Stock	23.4925	23.6375	23.4075	23.6	146124000.0
2016-06-29	MSFT	Stock	49.91	50.72	49.8	50.54	31304000.0
2016-06-29	NVDA	Stock	1.1575	1.1752	1.1545	1.1662	318932000.0
2016-06-29	AMZN	Stock	35.7875	35.975	35.677	35.78	61402000.0
2016-06-29	GOOGL	Stock	34.713	34.975	34.6342	34.7595	43124360.0
2016-06-29	META	Stock	113.37	114.25	113.04	114.16	20968300.0
2016-06-29	TSLA	Stock	13.6753	14.1187	13.5333	14.0127	89923500.0
2016-06-29	TLT	Stock	139.68	140.13	138.2601	138.39	12999793.0
2016-06-29	ES	Stock	58.51	58.78	58.25	58.58	1332000.0
2016-06-29	CL	Stock	71.36	71.93	71.32	71.86	2264100.0
2016-06-29	A	Stock	43.55	43.98	43.19	43.76	2402600.0
2016-06-29	AA.B-DELISTED	Stock	33.7	33.7	32.1	32.335	44472.0
2016-06-29	AAAP-DELISTED	Stock	29.4	30.95	29.2101	30.3	41476.0
2016-06-29	AABA-DELISTED	Stock	36.25	37.08	36.25	36.86	9917539.0
2016-06-29	AAC-DELISTED	Stock	21.38	22.0	21.26	21.99	98857.0
2016-06-29	AACG	Stock	5.14	5.14	4.85	4.85	1500.0
2016-06-29	AAIC-DELISTED	Stock	12.87	13.06	12.77	12.86	283015.0
2016-06-29	AAL	Stock	26.94	28.07	26.94	27.7	15008800.0
2016-06-29	AAMC-DELISTED	Stock	4.2382	4.8471	4.2382	4.2794	65474.0
2016-06-29	AAME	Stock	3.96	4.46	3.96	3.99	1300.0
2016-06-29	AAMI	Stock	13.05	13.16	12.86	13.12	358100.0
2016-06-29	AAOI	Stock	10.18	10.489	10.0	10.4	210600.0
2016-06-29	AAON	Stock	17.4733	17.7667	17.4533	17.7	164700.0
2016-06-29	AAP	Stock	158.03	161.78	158.03	161.01	1560000.0
2016-06-29	AAT	Stock	41.74	42.42	41.74	41.94	137100.0
2016-06-29	AAU-DELISTED	Stock	1.4	1.58	1.4	1.56	914659.0
2016-06-29	AAUAF-DELISTED	Stock	1.4	1.58	1.4	1.56	921586.0
2016-06-29	AAV-DELISTED	Stock	5.49	5.7001	5.43	5.67	116890.0
2016-06-29	AAWW-DELISTED	Stock	39.57	40.33	38.99	40.2	269701.0
2016-06-29	AAXJ	Stock	53.89	54.17	53.89	54.06	674179.0
2016-06-29	AAXN-DELISTED	Stock	23.89	24.3	23.66	24.22	717852.0
2016-06-29	AB	Stock	22.32	22.97	22.32	22.95	222500.0
2016-06-29	ABAC-DELISTED	Stock	0.82	0.8484	0.78	0.78	11732.0
2016-06-29	ABAX-DELISTED	Stock	44.87	46.23	44.74	46.15	83550.0
2016-06-29	ABB-DELISTED	Stock	19.26	19.49	19.23	19.45	2283120.0
2016-06-29	ABBNY-DELISTED	Stock	19.26	19.49	19.23	19.44	2341722.0
2016-06-29	ABBV	Stock	60.58	62.03	60.23	61.81	9308000.0
2016-06-29	ABC-DELISTED	Stock	76.08	77.5	76.03	77.27	1724988.0
2016-06-29	ABCB	Stock	28.73	29.27	28.32	29.21	147500.0
2016-06-29	ABCD-DELISTED	Stock	4.42	4.49	4.4	4.48	33807.0
2016-06-29	ABCO-DELISTED	Stock	33.96	34.87	32.62	34.59	378963.0
2016-06-29	ABDC-DELISTED	Stock	12.08	12.2	12.0	12.15	74647.0
2016-06-29	ABE-DELISTED	Stock	11.86	12.05	11.86	11.9989	5139.0
2016-06-29	ABEO	Stock	60.75	61.0	58.25	59.25	2076.0
2016-06-29	ABEOW-DELISTED	Stock	0.8058	1.1	0.8058	1.1	5000.0
2016-06-29	ABEV	Stock	5.74	5.89	5.74	5.84	14212800.0
2016-06-29	ABG	Stock	52.58	53.64	52.01	53.62	240900.0
2016-06-29	ABIL-DELISTED	Stock	4.22	4.22	4.145	4.2	15829.0
2016-06-29	ABM	Stock	35.53	35.92	35.53	35.74	209100.0
2016-06-29	ABMD-DELISTED	Stock	105.98	108.48	105.66	108.16	663176.0

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

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