PREVIEW / stock_daily / 2016-06-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-28.parquet
  size:    218 KB
  rows:    6,556
  symbols: 3,270

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-28	AAPL	Stock	23.225	23.415	23.035	23.3975	161779600.0
2016-06-28	MSFT	Stock	48.92	49.47	48.67	49.44	38140700.0
2016-06-28	NVDA	Stock	1.1525	1.1538	1.1318	1.1475	381920000.0
2016-06-28	AMZN	Stock	35.0	35.4	34.9085	35.3975	80740000.0
2016-06-28	GOOGL	Stock	34.5685	34.637	34.2425	34.563	38245600.0
2016-06-28	META	Stock	110.63	112.75	110.55	112.7	26813800.0
2016-06-28	TSLA	Stock	13.4593	13.6033	13.294	13.4527	93186000.0
2016-06-28	TLT	Stock	139.44	139.895	138.88	139.46	14006412.0
2016-06-28	ES	Stock	58.57	58.59	57.54	58.33	1643800.0
2016-06-28	CL	Stock	70.37	71.15	70.03	71.13	2878600.0
2016-06-28	A	Stock	42.67	43.11	42.16	43.11	4300800.0
2016-06-28	AA.B-DELISTED	Stock	32.72	33.05	32.4	32.97	31446.0
2016-06-28	AAAP-DELISTED	Stock	28.1	29.5	28.1	29.37	32114.0
2016-06-28	AABA-DELISTED	Stock	35.57	36.14	35.5	36.04	10258018.0
2016-06-28	AAC-DELISTED	Stock	20.36	21.105	20.1	21.09	145985.0
2016-06-28	AACG	Stock	5.1	5.1	4.6	4.95	1300.0
2016-06-28	AAIC-DELISTED	Stock	12.69	13.11	12.67	12.79	445345.0
2016-06-28	AAL	Stock	26.12	26.88	25.76	26.77	20026100.0
2016-06-28	AAMC-DELISTED	Stock	4.0353	4.4118	3.9059	4.1176	139104.0
2016-06-28	AAME	Stock	4.33	4.33	3.96	4.15	3500.0
2016-06-28	AAMI	Stock	13.05	13.07	12.795	12.9	1003000.0
2016-06-28	AAOI	Stock	9.53	9.92	9.52	9.9	204600.0
2016-06-28	AAON	Stock	17.64	17.7733	17.26	17.2867	266100.0
2016-06-28	AAP	Stock	154.87	157.16	154.28	156.98	1533700.0
2016-06-28	AAT	Stock	40.98	41.75	40.64	41.59	123900.0
2016-06-28	AAU-DELISTED	Stock	1.29	1.4	1.27	1.4	610013.0
2016-06-28	AAUAF-DELISTED	Stock	1.29	1.4	1.27	1.4	615217.0
2016-06-28	AAV-DELISTED	Stock	5.39	5.48	5.37	5.42	151834.0
2016-06-28	AAWW-DELISTED	Stock	39.2	39.54	38.42	38.8	205148.0
2016-06-28	AAXJ	Stock	52.96	53.09	52.625	53.06	874874.0
2016-06-28	AAXN-DELISTED	Stock	23.1	23.9199	23.1	23.55	730977.0
2016-06-28	AB	Stock	21.82	22.28	21.77	22.19	209000.0
2016-06-28	ABAC-DELISTED	Stock	0.783	0.85	0.78	0.79	16444.0
2016-06-28	ABAX-DELISTED	Stock	44.2	44.925	43.8	44.51	92379.0
2016-06-28	ABB-DELISTED	Stock	19.31	19.4	19.14	19.32	2052345.0
2016-06-28	ABBNY-DELISTED	Stock	19.31	19.4	19.14	19.33	2702007.0
2016-06-28	ABBV	Stock	59.28	60.13	59.15	59.99	9897600.0
2016-06-28	ABC-DELISTED	Stock	74.32	75.45	74.06	75.34	2474154.0
2016-06-28	ABCB	Stock	28.31	28.66	27.92	28.43	124100.0
2016-06-28	ABCD-DELISTED	Stock	4.41	4.51	4.4	4.41	25667.0
2016-06-28	ABCO-DELISTED	Stock	34.08	34.47	33.5	33.62	277517.0
2016-06-28	ABDC-DELISTED	Stock	12.15	12.19	11.98	12.1	48871.0
2016-06-28	ABEO	Stock	61.0	65.0	59.0	60.75	1872.0
2016-06-28	ABEV	Stock	5.58	5.68	5.57	5.62	23500200.0
2016-06-28	ABG	Stock	52.76	53.34	51.71	52.13	424000.0
2016-06-28	ABIL-DELISTED	Stock	3.99	4.17	3.96	4.03	57908.0
2016-06-28	ABM	Stock	35.34	35.72	35.19	35.24	426900.0
2016-06-28	ABMD-DELISTED	Stock	101.94	105.35	101.25	105.1	569636.0
2016-06-28	ABR	Stock	6.71	6.9	6.71	6.89	146900.0
2016-06-28	ABR.A-DELISTED	Stock	25.0	25.18	25.0	25.18	1300.0

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

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