PREVIEW / stock_daily / 2016-11-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-09.parquet
  size:    215 KB
  rows:    6,522
  symbols: 3,162

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-09	AAPL	Stock	27.47	27.83	27.0125	27.72	236705600.0
2016-11-09	MSFT	Stock	60.0	60.59	59.2	60.17	49632500.0
2016-11-09	NVDA	Stock	1.7308	1.7725	1.718	1.749	456532000.0
2016-11-09	AMZN	Stock	38.2	38.875	38.0045	38.594	171258000.0
2016-11-09	GOOGL	Stock	40.0915	40.5855	39.6018	40.2795	61970200.0
2016-11-09	META	Stock	121.5	123.81	120.51	123.18	31916000.0
2016-11-09	TSLA	Stock	12.4587	12.8	12.2633	12.6707	122596500.0
2016-11-09	TLT	Stock	127.22	127.37	124.22	124.57	31233486.0
2016-11-09	ES	Stock	54.12	54.12	53.14	53.23	2228100.0
2016-11-09	CL	Stock	70.4	70.63	69.37	70.37	4901000.0
2016-11-09	A	Stock	45.41	46.09	44.49	45.94	3501200.0
2016-11-09	AA	Stock	26.83	29.14	26.0	28.72	10675900.0
2016-11-09	AAAP-DELISTED	Stock	35.0	37.0	34.71	36.98	99305.0
2016-11-09	AABA-DELISTED	Stock	40.44	41.39	40.219	41.21	22076642.0
2016-11-09	AAC-DELISTED	Stock	6.06	7.09	6.01	7.03	812676.0
2016-11-09	AACG	Stock	3.4	3.85	3.4	3.85	42200.0
2016-11-09	AAIC-DELISTED	Stock	14.39	14.9	14.33	14.77	368775.0
2016-11-09	AAL	Stock	40.76	42.75	40.44	42.41	8392100.0
2016-11-09	AAMC-DELISTED	Stock	10.0441	11.1029	10.0441	10.7353	6545.0
2016-11-09	AAME	Stock	4.35	4.35	3.8	4.0	1100.0
2016-11-09	AAMI	Stock	12.23	12.98	12.23	12.92	297200.0
2016-11-09	AAOI	Stock	22.0	23.78	21.66	23.55	443000.0
2016-11-09	AAON	Stock	18.9	20.0667	18.7667	19.8667	232200.0
2016-11-09	AAP	Stock	134.79	140.54	134.08	140.33	1349500.0
2016-11-09	AAT	Stock	39.03	39.83	38.35	39.52	322200.0
2016-11-09	AAU-DELISTED	Stock	1.35	1.39	1.27	1.306	251460.0
2016-11-09	AAUAF-DELISTED	Stock	1.35	1.39	1.27	1.306	253176.0
2016-11-09	AAV-DELISTED	Stock	6.5	6.7	6.4	6.7	63095.0
2016-11-09	AAWW-DELISTED	Stock	44.2	44.9	43.15	44.4	212627.0
2016-11-09	AAXJ	Stock	57.81	58.4	57.64	57.72	1971391.0
2016-11-09	AAXN-DELISTED	Stock	22.0	24.09	21.9	23.69	2736996.0
2016-11-09	AB	Stock	20.9	21.75	20.76	21.65	321500.0
2016-11-09	ABAC-DELISTED	Stock	2.71	2.75	2.71	2.75	7248.0
2016-11-09	ABAX-DELISTED	Stock	47.55	49.54	46.08	49.45	103704.0
2016-11-09	ABB-DELISTED	Stock	21.09	21.37	20.995	21.265	2995932.0
2016-11-09	ABBNY-DELISTED	Stock	21.09	21.37	20.995	21.27	3167096.0
2016-11-09	ABBV	Stock	64.1	64.69	60.41	62.64	18694000.0
2016-11-09	ABC-DELISTED	Stock	72.98	76.15	71.75	75.61	4826835.0
2016-11-09	ABCB	Stock	37.15	39.25	35.15	38.9	495200.0
2016-11-09	ABCD-DELISTED	Stock	5.1161	5.5	4.9685	5.5	36720.0
2016-11-09	ABCO-DELISTED	Stock	35.1	35.25	34.15	34.3	390972.0
2016-11-09	ABDC-DELISTED	Stock	12.01	12.46	11.81	12.41	66517.0
2016-11-09	ABE-DELISTED	Stock	11.93	11.98	11.79	11.81	18550.0
2016-11-09	ABEO	Stock	133.75	156.25	133.75	152.5	27716.0
2016-11-09	ABEOW-DELISTED	Stock	2.6	2.99	2.6	2.85	14150.0
2016-11-09	ABEV	Stock	5.45	5.59	5.45	5.48	21731300.0
2016-11-09	ABG	Stock	48.4	52.55	47.5	52.5	474300.0
2016-11-09	ABIL-DELISTED	Stock	3.0	3.09	2.97	3.01	23458.0
2016-11-09	ABM	Stock	39.07	40.32	38.88	40.28	349900.0
2016-11-09	ABMD-DELISTED	Stock	107.57	107.57	104.16	106.05	333702.0

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

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