PREVIEW / stock_daily / 2016-12-13

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-13.parquet
  size:    217 KB
  rows:    6,521
  symbols: 3,137

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-12-13	AAPL	Stock	28.46	28.98	28.4375	28.7975	174935200.0
2016-12-13	MSFT	Stock	62.5	63.42	62.24	62.98	35718900.0
2016-12-13	NVDA	Stock	2.2522	2.3073	2.2513	2.2793	387796000.0
2016-12-13	AMZN	Stock	38.248	39.123	38.1	38.717	105706000.0
2016-12-13	GOOGL	Stock	40.6195	41.215	40.597	40.767	42564200.0
2016-12-13	META	Stock	117.86	121.52	117.61	120.31	29768000.0
2016-12-13	TSLA	Stock	12.8787	13.4187	12.8667	13.21	102358500.0
2016-12-13	TLT	Stock	118.4	118.49	117.44	118.14	12189195.0
2016-12-13	ES	Stock	54.28	54.72	54.04	54.55	1392800.0
2016-12-13	CL	Stock	66.76	67.3	66.7	66.89	3456400.0
2016-12-13	A	Stock	46.31	46.61	46.16	46.39	1734700.0
2016-12-13	AA	Stock	31.4	31.73	30.03	30.24	4215100.0
2016-12-13	AAAP-DELISTED	Stock	29.18	29.26	27.07	27.5	190613.0
2016-12-13	AABA-DELISTED	Stock	41.35	41.79	41.14	41.47	6083999.0
2016-12-13	AAC-DELISTED	Stock	8.21	8.21	7.35	7.42	260532.0
2016-12-13	AACG	Stock	4.03	4.09	4.02	4.02	2600.0
2016-12-13	AAIC-DELISTED	Stock	16.8	16.84	16.2	16.24	354793.0
2016-12-13	AAL	Stock	47.94	48.49	47.71	47.84	6147700.0
2016-12-13	AAMC-DELISTED	Stock	12.2794	12.3088	11.6765	12.3088	51071.0
2016-12-13	AAME	Stock	3.75	3.9	3.75	3.9	1000.0
2016-12-13	AAMI	Stock	14.95	14.95	14.37	14.52	1135600.0
2016-12-13	AAOI	Stock	23.86	24.72	23.73	24.29	215600.0
2016-12-13	AAON	Stock	22.0333	22.3333	21.7333	21.8	252750.0
2016-12-13	AAP	Stock	173.26	174.95	171.15	171.87	1015200.0
2016-12-13	AAT	Stock	43.44	43.44	42.74	43.12	398600.0
2016-12-13	AAU-DELISTED	Stock	1.13	1.14	1.1	1.11	169308.0
2016-12-13	AAUAF-DELISTED	Stock	1.13	1.14	1.1	1.12	170993.0
2016-12-13	AAV-DELISTED	Stock	7.15	7.2	7.07	7.15	99965.0
2016-12-13	AAWW-DELISTED	Stock	52.45	53.4	52.25	52.4	221215.0
2016-12-13	AAXJ	Stock	57.19	57.645	57.19	57.57	2407343.0
2016-12-13	AAXN-DELISTED	Stock	23.56	23.98	23.34	23.57	675587.0
2016-12-13	AB	Stock	22.7	23.1	22.6	22.8	326800.0
2016-12-13	ABAC-DELISTED	Stock	3.75	4.07	3.75	3.85	58970.0
2016-12-13	ABAX-DELISTED	Stock	55.0	55.95	54.71	55.01	124574.0
2016-12-13	ABB-DELISTED	Stock	21.2	21.38	21.12	21.27	2446517.0
2016-12-13	ABBNY-DELISTED	Stock	21.2	21.38	21.12	21.28	2522313.0
2016-12-13	ABBV	Stock	62.33	62.44	61.36	61.99	8599600.0
2016-12-13	ABC-DELISTED	Stock	78.38	79.17	78.17	79.03	1098817.0
2016-12-13	ABCB	Stock	45.5	46.2	45.2	45.7	163200.0
2016-12-13	ABCD-DELISTED	Stock	4.96	4.97	4.75	4.82	34412.0
2016-12-13	ABCO-DELISTED	Stock	33.4	33.4	32.1	32.25	1219894.0
2016-12-13	ABDC-DELISTED	Stock	12.4	12.4723	12.21	12.43	52680.0
2016-12-13	ABE-DELISTED	Stock	11.3869	11.4071	11.38	11.4071	2341.0
2016-12-13	ABEO	Stock	106.25	122.5	105.5	122.5	33924.0
2016-12-13	ABEOW-DELISTED	Stock	2.4	2.61	2.4	2.61	1151.0
2016-12-13	ABEV	Stock	4.86	4.89	4.8	4.88	30562300.0
2016-12-13	ABG	Stock	62.5	63.15	61.7	62.35	160000.0
2016-12-13	ABIL-DELISTED	Stock	3.21	3.21	3.08	3.14	11046.0
2016-12-13	ABM	Stock	43.21	43.37	42.53	42.92	723700.0
2016-12-13	ABMD-DELISTED	Stock	119.61	120.89	118.04	118.68	290619.0

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

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