PREVIEW / stock_daily / 2016-11-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-04.parquet
  size:    213 KB
  rows:    6,501
  symbols: 3,158

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-04	AAPL	Stock	27.1325	27.5625	27.0275	27.21	123348000.0
2016-11-04	MSFT	Stock	58.65	59.28	58.52	58.71	28697000.0
2016-11-04	NVDA	Stock	1.6878	1.7183	1.6645	1.6892	328780000.0
2016-11-04	AMZN	Stock	38.1395	38.3	37.6615	37.7525	102442000.0
2016-11-04	GOOGL	Stock	38.565	39.424	38.5502	39.055	39412060.0
2016-11-04	META	Stock	119.59	121.93	119.25	120.75	30545500.0
2016-11-04	TSLA	Stock	12.6	12.8973	12.3973	12.704	77190000.0
2016-11-04	TLT	Stock	131.27	131.79	131.13	131.74	7622582.0
2016-11-04	ES	Stock	53.64	54.37	53.17	53.18	1658300.0
2016-11-04	CL	Stock	70.75	70.91	69.56	69.57	3874300.0
2016-11-04	A	Stock	43.69	44.92	43.69	44.32	2220900.0
2016-11-04	AA	Stock	23.82	25.5	23.56	25.2	6878700.0
2016-11-04	AAAP-DELISTED	Stock	34.81	36.01	34.81	35.51	46057.0
2016-11-04	AABA-DELISTED	Stock	39.96	40.67	39.8	40.28	4211556.0
2016-11-04	AAC-DELISTED	Stock	7.65	7.93	7.33	7.51	1207283.0
2016-11-04	AACG	Stock	3.68	3.79	3.65	3.75	19300.0
2016-11-04	AAIC-DELISTED	Stock	14.36	14.64	14.32	14.43	206312.0
2016-11-04	AAL	Stock	39.27	40.22	39.24	39.74	6717500.0
2016-11-04	AAMC-DELISTED	Stock	10.6029	10.8824	10.3471	10.7941	21009.0
2016-11-04	AAME	Stock	3.8	3.8	3.8	3.8	500.0
2016-11-04	AAMI	Stock	12.64	12.67	12.175	12.2	216300.0
2016-11-04	AAOI	Stock	23.3	23.3	20.63	21.65	1533500.0
2016-11-04	AAON	Stock	18.3333	19.2067	18.3333	18.3667	233250.0
2016-11-04	AAP	Stock	138.85	140.0	135.76	136.19	1095300.0
2016-11-04	AAT	Stock	38.52	38.63	38.27	38.41	181900.0
2016-11-04	AAU-DELISTED	Stock	1.36	1.41	1.35	1.39	153455.0
2016-11-04	AAUAF-DELISTED	Stock	1.36	1.41	1.35	1.39	154790.0
2016-11-04	AAV-DELISTED	Stock	6.5	6.6	6.4	6.4	184451.0
2016-11-04	AAWW-DELISTED	Stock	42.75	43.6	42.15	43.25	314987.0
2016-11-04	AAXJ	Stock	57.85	57.93	57.59	57.64	607312.0
2016-11-04	AAXN-DELISTED	Stock	22.06	22.45	21.93	21.98	738214.0
2016-11-04	AB	Stock	20.95	21.6	20.85	21.05	254700.0
2016-11-04	ABAC-DELISTED	Stock	2.696	2.7367	2.661	2.7367	5780.0
2016-11-04	ABAX-DELISTED	Stock	46.27	47.39	46.2	46.34	108830.0
2016-11-04	ABB-DELISTED	Stock	20.41	20.565	20.31	20.4	1579080.0
2016-11-04	ABBNY-DELISTED	Stock	20.41	20.565	20.31	20.4	1621035.0
2016-11-04	ABBV	Stock	56.07	56.87	55.87	56.04	11187000.0
2016-11-04	ABC-DELISTED	Stock	71.69	73.32	70.27	70.48	4472679.0
2016-11-04	ABCB	Stock	36.1	36.55	35.8	36.1	92600.0
2016-11-04	ABCD-DELISTED	Stock	5.17	5.17	4.945	4.98	8461.0
2016-11-04	ABCO-DELISTED	Stock	35.9	36.3	35.65	36.0	550011.0
2016-11-04	ABDC-DELISTED	Stock	12.92	13.04	12.7	12.74	96384.0
2016-11-04	ABE-DELISTED	Stock	11.9164	11.968	11.9164	11.968	2292.0
2016-11-04	ABEO	Stock	142.5	145.0	138.75	138.75	21112.0
2016-11-04	ABEOW-DELISTED	Stock	2.51	2.61	2.36	2.48	4006.0
2016-11-04	ABEV	Stock	5.5	5.53	5.41	5.43	33557000.0
2016-11-04	ABG	Stock	48.75	51.05	48.5	49.3	274100.0
2016-11-04	ABIL-DELISTED	Stock	2.82	2.999	2.82	2.86	10999.0
2016-11-04	ABM	Stock	38.33	38.63	38.23	38.29	148400.0
2016-11-04	ABMD-DELISTED	Stock	102.52	105.32	102.2832	104.7	514541.0

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

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