PREVIEW / stock_daily / 2016-11-01

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-01.parquet
  size:    213 KB
  rows:    6,477
  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-11-01	AAPL	Stock	28.365	28.4425	27.6325	27.8725	175303200.0
2016-11-01	MSFT	Stock	59.97	60.02	59.25	59.8	24533000.0
2016-11-01	NVDA	Stock	1.7855	1.7953	1.7072	1.7262	473224000.0
2016-11-01	AMZN	Stock	39.95	40.042	38.8355	39.2705	106108000.0
2016-11-01	GOOGL	Stock	40.5435	40.698	39.913	40.274	47117800.0
2016-11-01	META	Stock	131.41	131.94	128.65	129.5	22077800.0
2016-11-01	TSLA	Stock	13.2027	13.2333	12.5407	12.7193	105900000.0
2016-11-01	TLT	Stock	130.16	131.6	129.88	131.01	12622367.0
2016-11-01	ES	Stock	55.16	55.16	53.94	54.08	1378300.0
2016-11-01	CL	Stock	71.46	71.58	70.8	70.99	2329700.0
2016-11-01	A	Stock	43.73	44.11	43.14	43.49	2133100.0
2016-11-01	AA	Stock	22.1	23.55	21.78	23.0	32216900.0
2016-11-01	AAAP-DELISTED	Stock	36.12	37.425	36.12	36.81	79017.0
2016-11-01	AABA-DELISTED	Stock	41.13	41.34	40.69	41.33	10951525.0
2016-11-01	AAC-DELISTED	Stock	16.44	16.72	16.02	16.29	108829.0
2016-11-01	AACG	Stock	3.66	3.99	3.66	3.99	600.0
2016-11-01	AAIC-DELISTED	Stock	14.43	14.44	14.17	14.24	208595.0
2016-11-01	AAL	Stock	40.51	40.85	39.57	39.8	9028700.0
2016-11-01	AAMC-DELISTED	Stock	10.2059	10.6136	10.0	10.3088	33643.0
2016-11-01	AAME	Stock	3.52	3.95	3.52	3.85	2600.0
2016-11-01	AAMI	Stock	14.12	14.24	13.72	14.0	168900.0
2016-11-01	AAOI	Stock	19.25	19.86	18.85	19.15	249200.0
2016-11-01	AAON	Stock	20.0667	20.1267	19.0333	19.3667	222450.0
2016-11-01	AAP	Stock	139.88	140.92	138.54	139.79	802100.0
2016-11-01	AAT	Stock	39.46	39.68	38.24	38.53	386300.0
2016-11-01	AAU-DELISTED	Stock	1.34	1.4	1.3375	1.375	277434.0
2016-11-01	AAUAF-DELISTED	Stock	1.34	1.4	1.3375	1.39	280668.0
2016-11-01	AAV-DELISTED	Stock	6.75	6.9	6.75	6.85	135566.0
2016-11-01	AAWW-DELISTED	Stock	41.95	42.4	40.8	41.8	156022.0
2016-11-01	AAXJ	Stock	59.24	59.29	58.41	58.78	681985.0
2016-11-01	AAXN-DELISTED	Stock	22.36	22.77	22.36	22.62	884052.0
2016-11-01	AB	Stock	21.8	21.85	21.45	21.55	222900.0
2016-11-01	ABAC-DELISTED	Stock	2.75	2.75	2.71	2.7208	3250.0
2016-11-01	ABAX-DELISTED	Stock	47.69	47.79	46.23	46.4	169226.0
2016-11-01	ABB-DELISTED	Stock	20.62	20.64	20.45	20.52	1941587.0
2016-11-01	ABBNY-DELISTED	Stock	20.63	20.64	20.45	20.52	2001562.0
2016-11-01	ABBV	Stock	56.0	56.61	55.68	56.45	9799400.0
2016-11-01	ABC-DELISTED	Stock	69.85	71.18	69.65	69.8	3838146.0
2016-11-01	ABCB	Stock	36.3	36.99	35.63	36.25	162000.0
2016-11-01	ABCD-DELISTED	Stock	5.37	5.37	5.05	5.06	13584.0
2016-11-01	ABCO-DELISTED	Stock	39.65	39.75	38.85	39.6	221489.0
2016-11-01	ABDC-DELISTED	Stock	12.9	13.0	12.78	12.95	14548.0
2016-11-01	ABE-DELISTED	Stock	12.3	12.3	12.26	12.26	6930.0
2016-11-01	ABEO	Stock	163.75	167.5	155.0	162.5	25240.0
2016-11-01	ABEOW-DELISTED	Stock	3.24	3.24	2.62	2.81	9129.0
2016-11-01	ABEV	Stock	5.82	5.84	5.63	5.63	27588000.0
2016-11-01	ABG	Stock	51.0	51.5	49.5	49.95	237600.0
2016-11-01	ABIL-DELISTED	Stock	3.011	3.03	2.7711	2.9999	11996.0
2016-11-01	ABM	Stock	39.08	39.31	38.5	38.58	351900.0
2016-11-01	ABMD-DELISTED	Stock	106.03	106.15	104.34	105.75	602280.0

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

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