PREVIEW / stock_daily / 2016-11-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-23.parquet
  size:    214 KB
  rows:    6,513
  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-23	AAPL	Stock	27.84	27.8775	27.5825	27.8075	109705600.0
2016-11-23	MSFT	Stock	61.01	61.1	60.25	60.4	21848900.0
2016-11-23	NVDA	Stock	2.343	2.3812	2.3192	2.3492	443236000.0
2016-11-23	AMZN	Stock	39.0865	39.0875	38.656	39.006	70806000.0
2016-11-23	GOOGL	Stock	39.476	39.476	38.6325	38.95	26259620.0
2016-11-23	META	Stock	121.23	121.31	119.94	120.84	15672100.0
2016-11-23	TSLA	Stock	12.7073	13.0427	12.6	12.876	73378500.0
2016-11-23	TLT	Stock	119.99	120.91	119.25	120.64	13563514.0
2016-11-23	ES	Stock	51.87	52.45	51.65	51.74	1339700.0
2016-11-23	CL	Stock	66.01	66.28	65.87	65.99	2230100.0
2016-11-23	A	Stock	44.18	44.78	43.97	44.65	1926300.0
2016-11-23	AA	Stock	31.0	31.93	30.0	31.51	4111400.0
2016-11-23	AAAP-DELISTED	Stock	32.29	35.84	29.21	35.03	91817.0
2016-11-23	AABA-DELISTED	Stock	40.91	40.98	40.545	40.96	3171716.0
2016-11-23	AAC-DELISTED	Stock	9.43	9.43	9.24	9.26	115469.0
2016-11-23	AACG	Stock	4.15	4.39	3.9	4.2	9400.0
2016-11-23	AAIC-DELISTED	Stock	16.25	16.8	16.1572	16.44	510251.0
2016-11-23	AAL	Stock	46.05	46.39	45.7	46.34	5160200.0
2016-11-23	AAMC-DELISTED	Stock	8.3088	8.6328	8.25	8.5294	17442.0
2016-11-23	AAME	Stock	3.7	4.0	3.7	3.9	19000.0
2016-11-23	AAMI	Stock	14.78	14.83	14.62	14.81	96900.0
2016-11-23	AAOI	Stock	25.85	25.85	24.85	25.15	559400.0
2016-11-23	AAON	Stock	21.9333	22.3667	21.9	22.2667	175800.0
2016-11-23	AAP	Stock	170.26	171.51	168.65	171.04	982000.0
2016-11-23	AAT	Stock	40.37	40.72	40.2	40.5	102700.0
2016-11-23	AAU-DELISTED	Stock	1.11	1.1101	1.04	1.08	446356.0
2016-11-23	AAUAF-DELISTED	Stock	1.11	1.1101	1.04	1.08	450900.0
2016-11-23	AAV-DELISTED	Stock	7.0	7.175	6.95	7.05	84169.0
2016-11-23	AAWW-DELISTED	Stock	50.95	51.5	50.7741	51.275	123217.0
2016-11-23	AAXJ	Stock	56.12	56.26	56.0	56.23	604362.0
2016-11-23	AAXN-DELISTED	Stock	27.85	28.38	27.8	28.11	661401.0
2016-11-23	AB	Stock	23.5	23.65	23.2	23.3	311000.0
2016-11-23	ABAC-DELISTED	Stock	2.61	3.15	2.6	3.1	44678.0
2016-11-23	ABAX-DELISTED	Stock	50.98	52.81	49.865	52.73	91656.0
2016-11-23	ABB-DELISTED	Stock	20.5	20.62	20.48	20.59	1509119.0
2016-11-23	ABBNY-DELISTED	Stock	20.5	20.62	20.48	20.59	1699752.0
2016-11-23	ABBV	Stock	58.81	60.38	58.6	60.18	5546600.0
2016-11-23	ABC-DELISTED	Stock	78.07	78.9	77.76	78.7	1136900.0
2016-11-23	ABCB	Stock	44.1	44.55	43.85	44.45	163000.0
2016-11-23	ABCD-DELISTED	Stock	4.98	5.0	4.6	4.85	62924.0
2016-11-23	ABCO-DELISTED	Stock	36.8	37.2	36.5	37.1	165942.0
2016-11-23	ABDC-DELISTED	Stock	12.23	12.33	12.12	12.15	32659.0
2016-11-23	ABE-DELISTED	Stock	11.42	11.43	11.15	11.43	2427.0
2016-11-23	ABEO	Stock	173.75	180.0	165.0	175.0	13540.0
2016-11-23	ABEOW-DELISTED	Stock	3.5	3.61	3.3	3.61	1589.0
2016-11-23	ABEV	Stock	4.97	5.17	4.97	5.17	21245400.0
2016-11-23	ABG	Stock	59.0	60.5	58.6	59.6	311200.0
2016-11-23	ABIL-DELISTED	Stock	3.401	3.49	3.25	3.26	9623.0
2016-11-23	ABM	Stock	44.09	44.39	43.83	44.03	376200.0
2016-11-23	ABMD-DELISTED	Stock	110.21	113.34	109.75	112.85	366347.0

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

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