PREVIEW / stock_daily / 2016-12-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-16.parquet
  size:    219 KB
  rows:    6,552
  symbols: 3,157

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-16	AAPL	Stock	29.1175	29.125	28.9125	28.9925	177404400.0
2016-12-16	MSFT	Stock	62.95	62.95	62.12	62.3	42453100.0
2016-12-16	NVDA	Stock	2.4958	2.5175	2.4433	2.5102	1089528000.0
2016-12-16	AMZN	Stock	38.25	38.2565	37.7	37.8885	96964000.0
2016-12-16	GOOGL	Stock	40.9155	40.96	40.406	40.492	51977320.0
2016-12-16	META	Stock	120.9	121.5	119.27	119.87	25324300.0
2016-12-16	TSLA	Stock	13.2053	13.506	13.1733	13.4993	56953500.0
2016-12-16	TLT	Stock	117.61	117.915	116.8	117.14	14924640.0
2016-12-16	ES	Stock	53.73	54.67	53.72	54.57	2373500.0
2016-12-16	CL	Stock	66.32	66.47	65.7	66.23	4382800.0
2016-12-16	A	Stock	46.61	46.92	45.81	45.91	2103200.0
2016-12-16	AA	Stock	29.65	30.42	29.16	29.4	8133000.0
2016-12-16	AAAP-DELISTED	Stock	27.9	28.1552	27.28	27.49	41678.0
2016-12-16	AABA-DELISTED	Stock	38.62	39.22	38.42	38.61	20657853.0
2016-12-16	AAC-DELISTED	Stock	7.83	8.09	7.68	7.7	230943.0
2016-12-16	AACG	Stock	3.93	3.93	3.85	3.85	3200.0
2016-12-16	AAIC-DELISTED	Stock	15.13	15.5819	15.1	15.26	1015462.0
2016-12-16	AAL	Stock	48.61	49.07	47.56	47.63	9299700.0
2016-12-16	AAMC-DELISTED	Stock	13.9265	15.8676	13.9265	15.8676	106155.0
2016-12-16	AAME	Stock	3.95	4.05	3.9	3.9	1100.0
2016-12-16	AAMI	Stock	14.33	14.4	14.23	14.34	767800.0
2016-12-16	AAOI	Stock	24.59	24.85	24.03	24.68	483400.0
2016-12-16	AAON	Stock	21.9	22.2	21.7	21.8	591600.0
2016-12-16	AAP	Stock	173.36	173.99	171.17	171.91	891700.0
2016-12-16	AAT	Stock	41.65	42.87	41.65	42.59	762000.0
2016-12-16	AAU-DELISTED	Stock	0.905	0.94	0.9	0.9288	356434.0
2016-12-16	AAUAF-DELISTED	Stock	0.905	0.94	0.9	0.92	357909.0
2016-12-16	AAV-DELISTED	Stock	6.9	6.9	6.75	6.8	48365.0
2016-12-16	AAWW-DELISTED	Stock	52.15	52.65	50.525	50.75	420877.0
2016-12-16	AAXJ	Stock	55.99	56.075	55.68	55.87	1437168.0
2016-12-16	AAXN-DELISTED	Stock	24.19	24.43	23.91	23.98	836510.0
2016-12-16	AB	Stock	22.1	22.75	22.1	22.4	283700.0
2016-12-16	ABAC-DELISTED	Stock	3.6	3.69	3.4832	3.69	4200.0
2016-12-16	ABAX-DELISTED	Stock	53.77	54.7499	53.02	53.13	213783.0
2016-12-16	ABB-DELISTED	Stock	20.93	21.11	20.93	20.97	1160247.0
2016-12-16	ABBNY-DELISTED	Stock	20.93	21.11	20.93	20.96	1206846.0
2016-12-16	ABBV	Stock	62.12	62.49	61.83	62.22	10555800.0
2016-12-16	ABC-DELISTED	Stock	76.94	77.585	76.5	77.39	3260639.0
2016-12-16	ABCB	Stock	45.65	46.05	45.05	45.15	411400.0
2016-12-16	ABCD-DELISTED	Stock	4.89	5.0	4.89	4.9	62082.0
2016-12-16	ABCO-DELISTED	Stock	32.7	33.3787	32.2	32.4	608077.0
2016-12-16	ABDC-DELISTED	Stock	12.46	12.59	12.4	12.41	42043.0
2016-12-16	ABE-DELISTED	Stock	11.148	11.2	11.148	11.18	2312.0
2016-12-16	ABEO	Stock	118.75	123.75	111.25	112.5	11092.0
2016-12-16	ABEOW-DELISTED	Stock	2.65	2.65	2.65	2.65	200.0
2016-12-16	ABEV	Stock	4.88	4.93	4.83	4.91	26290100.0
2016-12-16	ABG	Stock	62.35	62.65	61.7	62.45	535800.0
2016-12-16	ABIL-DELISTED	Stock	2.96	3.0	2.8613	3.0	13652.0
2016-12-16	ABM	Stock	39.73	40.32	39.47	40.05	1518400.0
2016-12-16	ABMD-DELISTED	Stock	118.65	119.44	117.31	117.54	482888.0

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

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