PREVIEW / stock_daily / 2016-06-13

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-13.parquet
  size:    218 KB
  rows:    6,566
  symbols: 3,284

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-13	AAPL	Stock	24.6725	24.78	24.275	24.335	152082000.0
2016-06-13	MSFT	Stock	49.58	50.72	49.06	50.14	83217800.0
2016-06-13	NVDA	Stock	1.1562	1.1925	1.1562	1.1698	475588000.0
2016-06-13	AMZN	Stock	35.7005	36.0995	35.558	35.762	67044000.0
2016-06-13	GOOGL	Stock	36.491	36.95	36.491	36.594	23354720.0
2016-06-13	META	Stock	115.0	115.48	113.31	113.95	31718200.0
2016-06-13	TSLA	Stock	14.6333	15.0513	14.5107	14.5247	62895000.0
2016-06-13	TLT	Stock	135.09	135.39	134.77	135.38	7688936.0
2016-06-13	ES	Stock	56.86	57.18	56.66	56.92	1423900.0
2016-06-13	CL	Stock	72.15	72.45	71.66	71.67	2887000.0
2016-06-13	A	Stock	45.32	45.52	44.91	44.92	1272800.0
2016-06-13	AA.B-DELISTED	Stock	33.37	33.5462	32.56	32.75	24910.0
2016-06-13	AAAP-DELISTED	Stock	31.26	31.26	30.33	30.42	38555.0
2016-06-13	AABA-DELISTED	Stock	36.7	36.91	36.42	36.48	6038686.0
2016-06-13	AAC-DELISTED	Stock	20.04	20.73	19.73	20.0	102930.0
2016-06-13	AACG	Stock	5.18	5.28	4.85	5.24	18600.0
2016-06-13	AAIC-DELISTED	Stock	13.6	13.69	13.24	13.34	207655.0
2016-06-13	AAL	Stock	32.99	32.99	31.64	31.8	9225600.0
2016-06-13	AAMC-DELISTED	Stock	5.5206	5.5206	4.8529	4.8912	104353.0
2016-06-13	AAME	Stock	3.68	3.68	3.52	3.67	1300.0
2016-06-13	AAMI	Stock	14.25	14.385	14.08	14.09	150200.0
2016-06-13	AAOI	Stock	10.17	10.55	9.9	9.95	340600.0
2016-06-13	AAON	Stock	18.0267	18.0733	17.72	17.7733	129300.0
2016-06-13	AAP	Stock	152.49	155.07	152.49	152.55	859900.0
2016-06-13	AAT	Stock	41.31	41.73	41.07	41.19	96000.0
2016-06-13	AAU-DELISTED	Stock	1.18	1.21	1.06	1.11	1004285.0
2016-06-13	AAUAF-DELISTED	Stock	1.18	1.21	1.06	1.08	1011720.0
2016-06-13	AAV-DELISTED	Stock	5.76	5.8686	5.64	5.68	86908.0
2016-06-13	AAWW-DELISTED	Stock	45.64	45.7	44.489	44.71	223945.0
2016-06-13	AAXJ	Stock	53.0	53.32	52.835	52.88	816431.0
2016-06-13	AAXN-DELISTED	Stock	22.73	22.955	22.4	22.755	543895.0
2016-06-13	AB	Stock	23.06	23.37	22.96	23.06	185800.0
2016-06-13	ABAC-DELISTED	Stock	0.67	0.78	0.67	0.78	3898.0
2016-06-13	ABAX-DELISTED	Stock	45.25	46.04	44.96	45.55	77950.0
2016-06-13	ABB-DELISTED	Stock	20.25	20.41	20.23	20.27	2269087.0
2016-06-13	ABBNY-DELISTED	Stock	20.25	20.41	20.23	20.27	2563464.0
2016-06-13	ABBV	Stock	60.46	61.39	59.85	59.93	11673600.0
2016-06-13	ABC-DELISTED	Stock	76.44	77.18	76.21	76.44	2595625.0
2016-06-13	ABCB	Stock	31.05	31.47	30.25	30.87	192600.0
2016-06-13	ABCD-DELISTED	Stock	4.64	4.66	4.64	4.66	6134.0
2016-06-13	ABCO-DELISTED	Stock	33.56	34.06	33.235	33.26	136381.0
2016-06-13	ABDC-DELISTED	Stock	12.21	12.27	12.17	12.17	39253.0
2016-06-13	ABE-DELISTED	Stock	12.08	12.08	11.9	11.9	1709.0
2016-06-13	ABEO	Stock	76.25	79.5	74.0	75.0	2608.0
2016-06-13	ABEOW-DELISTED	Stock	0.95	0.95	0.95	0.95	210.0
2016-06-13	ABEV	Stock	5.38	5.44	5.37	5.41	8028600.0
2016-06-13	ABG	Stock	54.11	54.64	53.09	54.1	317500.0
2016-06-13	ABIL-DELISTED	Stock	3.96	3.96	3.49	3.61	60002.0
2016-06-13	ABM	Stock	37.14	37.48	36.69	36.71	550100.0
2016-06-13	ABMD-DELISTED	Stock	101.93	103.48	101.59	101.77	341755.0

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

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