PREVIEW / stock_daily / 2016-10-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-28.parquet
  size:    214 KB
  rows:    6,488
  symbols: 3,164

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-10-28	AAPL	Stock	28.4675	28.8025	28.3625	28.43	151446800.0
2016-10-28	MSFT	Stock	60.01	60.52	59.58	59.87	33574700.0
2016-10-28	NVDA	Stock	1.7755	1.8025	1.7608	1.764	290856000.0
2016-10-28	AMZN	Stock	39.1	39.4745	38.7305	38.816	216822000.0
2016-10-28	GOOGL	Stock	41.497	41.95	40.85	40.978	87097680.0
2016-10-28	META	Stock	130.5	132.97	129.93	131.29	24545500.0
2016-10-28	TSLA	Stock	13.6	13.688	13.322	13.3313	64201500.0
2016-10-28	TLT	Stock	130.39	130.93	130.33	130.45	7540950.0
2016-10-28	ES	Stock	54.04	54.41	53.84	54.2	867800.0
2016-10-28	CL	Stock	70.75	71.33	70.61	71.17	3295100.0
2016-10-28	A	Stock	43.38	43.87	43.11	43.22	1470500.0
2016-10-28	AA	Stock	22.4921	22.8525	22.4841	22.7244	11158052.0
2016-10-28	AA.B-DELISTED	Stock	30.73	31.1	30.6341	30.75	45135.0
2016-10-28	AAAP-DELISTED	Stock	37.78	37.8865	35.8983	36.3099	39301.0
2016-10-28	AABA-DELISTED	Stock	42.03	42.22	41.71	41.79	5597017.0
2016-10-28	AAC-DELISTED	Stock	17.15	17.39	16.65	16.68	89434.0
2016-10-28	AACG	Stock	3.59	3.6	3.55	3.55	18900.0
2016-10-28	AAIC-DELISTED	Stock	14.4	14.59	14.3	14.39	171919.0
2016-10-28	AAL	Stock	39.85	40.57	39.8	40.06	6710700.0
2016-10-28	AAMC-DELISTED	Stock	9.4265	9.7941	9.4265	9.6691	49161.0
2016-10-28	AAMI	Stock	14.06	14.24	13.94	14.0	112800.0
2016-10-28	AAOI	Stock	19.8	20.37	19.55	19.69	156400.0
2016-10-28	AAON	Stock	19.6	19.7333	19.5	19.6333	144150.0
2016-10-28	AAP	Stock	138.45	141.41	138.19	140.2	1014700.0
2016-10-28	AAT	Stock	38.4	38.95	38.27	38.8	342500.0
2016-10-28	AAU-DELISTED	Stock	1.3	1.31	1.28	1.31	92340.0
2016-10-28	AAUAF-DELISTED	Stock	1.3	1.31	1.28	1.3	106180.0
2016-10-28	AAV-DELISTED	Stock	7.01	7.02	6.7	6.76	123923.0
2016-10-28	AAWW-DELISTED	Stock	42.05	42.85	41.6	42.1	69863.0
2016-10-28	AAXJ	Stock	59.17	59.33	58.69	58.86	804458.0
2016-10-28	AAXN-DELISTED	Stock	22.5	22.81	22.4	22.47	581090.0
2016-10-28	AB	Stock	21.7	22.0	21.7	21.8	367600.0
2016-10-28	ABAC-DELISTED	Stock	2.67	2.8	2.58	2.7612	13109.0
2016-10-28	ABAX-DELISTED	Stock	47.08	48.27	46.835	47.39	88787.0
2016-10-28	ABB-DELISTED	Stock	20.49	20.63	20.46	20.62	3036996.0
2016-10-28	ABBNY-DELISTED	Stock	20.49	20.63	20.46	20.62	3182251.0
2016-10-28	ABBV	Stock	57.55	58.39	55.06	57.6	24865300.0
2016-10-28	ABC-DELISTED	Stock	69.49	71.41	68.38	69.14	8978515.0
2016-10-28	ABCB	Stock	36.15	36.2	35.76	36.05	89000.0
2016-10-28	ABCD-DELISTED	Stock	5.06	5.09	4.9732	5.02	9071.0
2016-10-28	ABCO-DELISTED	Stock	40.54	40.54	39.85	40.23	146699.0
2016-10-28	ABDC-DELISTED	Stock	13.21	13.21	13.1632	13.2	23187.0
2016-10-28	ABE-DELISTED	Stock	12.38	12.39	12.25	12.25	6629.0
2016-10-28	ABEO	Stock	182.5	182.5	173.75	176.25	14884.0
2016-10-28	ABEOW-DELISTED	Stock	3.59	3.76	3.5899	3.59	4500.0
2016-10-28	ABEV	Stock	5.95	6.04	5.91	5.93	34959300.0
2016-10-28	ABG	Stock	49.2	51.55	49.2	51.0	229800.0
2016-10-28	ABIL-DELISTED	Stock	3.29	3.29	2.99	3.0	44169.0
2016-10-28	ABM	Stock	38.33	38.86	38.3	38.59	147900.0
2016-10-28	ABMD-DELISTED	Stock	103.01	106.29	101.28	105.13	1343702.0

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

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