PREVIEW / stock_daily / 2016-12-01

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-01.parquet
  size:    216 KB
  rows:    6,519
  symbols: 3,150

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-01	AAPL	Stock	27.5925	27.735	27.2575	27.3725	148347600.0
2016-12-01	MSFT	Stock	60.11	60.15	58.94	59.2	34542100.0
2016-12-01	NVDA	Stock	2.3025	2.3042	2.1192	2.191	1035524000.0
2016-12-01	AMZN	Stock	37.6205	37.6685	36.9015	37.1825	93320000.0
2016-12-01	GOOGL	Stock	38.9275	38.93	37.668	38.2165	57341480.0
2016-12-01	META	Stock	118.38	118.45	114.0	115.1	43277000.0
2016-12-01	TSLA	Stock	12.55	12.5687	12.0667	12.1253	76896000.0
2016-12-01	TLT	Stock	118.51	118.99	117.64	118.73	21715714.0
2016-12-01	ES	Stock	51.27	51.44	50.56	51.1	1783000.0
2016-12-01	CL	Stock	65.23	65.38	64.64	65.08	4204700.0
2016-12-01	A	Stock	44.08	44.1	42.92	43.21	2823100.0
2016-12-01	AA	Stock	28.84	29.42	28.6	28.88	5006200.0
2016-12-01	AAAP-DELISTED	Stock	29.25	29.79	29.178	29.5	116927.0
2016-12-01	AABA-DELISTED	Stock	41.0	41.04	39.53	39.63	11907154.0
2016-12-01	AAC-DELISTED	Stock	8.3	8.54	8.08	8.52	285554.0
2016-12-01	AACG	Stock	3.7	3.98	3.69	3.79	20300.0
2016-12-01	AAIC-DELISTED	Stock	16.3	16.44	16.04	16.21	284898.0
2016-12-01	AAL	Stock	46.2	47.09	45.66	45.75	7435200.0
2016-12-01	AAMC-DELISTED	Stock	8.4265	8.5735	8.1176	8.1176	30529.0
2016-12-01	AAME	Stock	4.0	4.0	3.75	3.76	4000.0
2016-12-01	AAMI	Stock	14.68	14.97	14.65	14.77	109100.0
2016-12-01	AAOI	Stock	24.79	25.11	23.21	23.395	373800.0
2016-12-01	AAON	Stock	22.0333	22.3333	21.5667	21.8	202200.0
2016-12-01	AAP	Stock	169.18	171.57	167.32	170.76	858700.0
2016-12-01	AAT	Stock	39.78	40.1	38.97	39.24	315100.0
2016-12-01	AAU-DELISTED	Stock	1.07	1.14	1.04	1.06	288341.0
2016-12-01	AAUAF-DELISTED	Stock	1.07	1.14	1.04	1.06	289895.0
2016-12-01	AAV-DELISTED	Stock	7.3	7.55	7.155	7.3	278339.0
2016-12-01	AAWW-DELISTED	Stock	49.4	50.55	49.4	49.75	103675.0
2016-12-01	AAXJ	Stock	57.08	57.13	56.72	56.86	1278611.0
2016-12-01	AAXN-DELISTED	Stock	27.37	27.74	27.358	27.72	616580.0
2016-12-01	AB	Stock	22.6	23.39	22.6	22.9	333300.0
2016-12-01	ABAC-DELISTED	Stock	3.2	3.4102	2.948	3.2101	6194.0
2016-12-01	ABAX-DELISTED	Stock	51.72	52.025	50.36	51.16	315780.0
2016-12-01	ABB-DELISTED	Stock	20.45	20.709	20.43	20.59	1820400.0
2016-12-01	ABBNY-DELISTED	Stock	20.45	20.709	20.43	20.59	1872940.0
2016-12-01	ABBV	Stock	60.83	60.83	58.75	59.16	8266200.0
2016-12-01	ABC-DELISTED	Stock	77.88	78.7	77.61	77.81	1286812.0
2016-12-01	ABCB	Stock	44.75	44.85	44.4	44.45	211700.0
2016-12-01	ABCD-DELISTED	Stock	4.94	5.039	4.8	4.83	24310.0
2016-12-01	ABCO-DELISTED	Stock	35.4	35.4	32.35	32.5	669681.0
2016-12-01	ABDC-DELISTED	Stock	11.93	11.95	11.5	11.51	50276.0
2016-12-01	ABE-DELISTED	Stock	11.309	11.34	11.24	11.2686	10433.0
2016-12-01	ABEO	Stock	155.0	160.0	152.5	155.0	11680.0
2016-12-01	ABEOW-DELISTED	Stock	3.2	3.4	3.15	3.26	2336.0
2016-12-01	ABEV	Stock	4.84	4.91	4.74	4.76	51289800.0
2016-12-01	ABG	Stock	57.8	62.35	57.8	58.6	519000.0
2016-12-01	ABIL-DELISTED	Stock	3.49	3.49	3.3	3.31	17817.0
2016-12-01	ABM	Stock	43.82	43.91	42.91	43.06	508800.0
2016-12-01	ABMD-DELISTED	Stock	112.08	112.96	106.59	107.39	669533.0

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

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