PREVIEW / stock_daily / 2017-05-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-17.parquet
  size:    216 KB
  rows:    6,473
  symbols: 3,027

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
2017-05-17	AAPL	Stock	38.4	38.6425	37.4275	37.5625	203070800.0
2017-05-17	MSFT	Stock	68.89	69.1	67.43	67.48	30548800.0
2017-05-17	NVDA	Stock	3.3525	3.3715	3.1888	3.193	1271368000.0
2017-05-17	AMZN	Stock	47.735	48.02	47.206	47.238	102912000.0
2017-05-17	GOOGL	Stock	47.985	48.0495	47.003	47.1085	48981160.0
2017-05-17	META	Stock	148.0	148.67	144.42	144.85	28300100.0
2017-05-17	TSLA	Stock	20.9593	20.9753	20.3667	20.4073	100678500.0
2017-05-17	TLT	Stock	122.63	123.54	122.385	123.28	11236435.0
2017-05-17	ES	Stock	59.73	60.45	59.66	60.19	1180200.0
2017-05-17	CL	Stock	71.58	76.86	71.58	75.69	18843900.0
2017-05-17	A	Stock	56.83	56.83	55.67	55.77	1839700.0
2017-05-17	AA	Stock	31.88	32.22	31.58	31.63	3739800.0
2017-05-17	AAAP-DELISTED	Stock	35.99	36.59	35.57	36.18	43423.0
2017-05-17	AABA-DELISTED	Stock	50.7	50.7	49.445	49.65	15997696.0
2017-05-17	AAC-DELISTED	Stock	7.03	7.07	6.86	6.86	120819.0
2017-05-17	AACG	Stock	3.59	3.59	3.51	3.52	4600.0
2017-05-17	AAIC-DELISTED	Stock	14.12	14.15	13.98	14.05	314336.0
2017-05-17	AAL	Stock	46.25	46.56	44.88	44.92	6906700.0
2017-05-17	AAM.A-DELISTED	Stock	25.81	25.84	25.67	25.67	113251.0
2017-05-17	AAMC-DELISTED	Stock	22.3088	22.3824	21.3824	21.4853	66943.0
2017-05-17	AAMI	Stock	14.47	14.66	14.07	14.09	1698300.0
2017-05-17	AAOI	Stock	63.04	64.0	60.1	61.38	3507000.0
2017-05-17	AAON	Stock	23.9667	24.3667	23.6333	23.6333	298650.0
2017-05-17	AAP	Stock	145.25	145.25	142.89	144.56	1205600.0
2017-05-17	AAT	Stock	38.34	38.88	38.05	38.77	387800.0
2017-05-17	AAU-DELISTED	Stock	1.35	1.41	1.31	1.35	407118.0
2017-05-17	AAUAF-DELISTED	Stock	1.35	1.41	1.31	1.35	411643.0
2017-05-17	AAV-DELISTED	Stock	6.55	6.65	6.45	6.475	180938.0
2017-05-17	AAWW-DELISTED	Stock	47.85	47.85	45.8	46.1	929347.0
2017-05-17	AAXJ	Stock	66.01	66.035	65.42	65.42	1682328.0
2017-05-17	AAXN-DELISTED	Stock	25.36	25.36	24.56	24.58	957426.0
2017-05-17	AB	Stock	21.2	21.35	20.85	21.0	622300.0
2017-05-17	ABAC-DELISTED	Stock	1.85	1.85	1.8	1.8	2768.0
2017-05-17	ABAX-DELISTED	Stock	47.44	48.11	46.96	47.02	66729.0
2017-05-17	ABB-DELISTED	Stock	24.83	24.92	24.69	24.7	1765392.0
2017-05-17	ABBNY-DELISTED	Stock	24.83	24.92	24.69	24.7	1811881.0
2017-05-17	ABBV	Stock	66.85	66.85	64.61	65.37	12771400.0
2017-05-17	ABC-DELISTED	Stock	87.48	88.45	86.13	86.3	1559564.0
2017-05-17	ABCB	Stock	44.6	45.05	43.53	43.65	166900.0
2017-05-17	ABCD-DELISTED	Stock	5.0	5.01	4.9374	5.0	18412.0
2017-05-17	ABCO-DELISTED	Stock	51.05	51.3	50.65	50.95	244965.0
2017-05-17	ABDC-DELISTED	Stock	13.51	13.601	13.41	13.56	629878.0
2017-05-17	ABE-DELISTED	Stock	13.89	13.907	13.8233	13.85	8420.0
2017-05-17	ABEO	Stock	153.75	153.75	143.75	148.75	15880.0
2017-05-17	ABEOW-DELISTED	Stock	3.48	3.48	3.48	3.48	285.0
2017-05-17	ABEV	Stock	6.34	6.36	6.21	6.23	29082100.0
2017-05-17	ABG	Stock	57.3	57.3	55.05	55.75	550900.0
2017-05-17	ABIL-DELISTED	Stock	0.8	0.8	0.7	0.7	73773.0
2017-05-17	ABM	Stock	42.01	42.01	41.12	41.43	197700.0
2017-05-17	ABMD-DELISTED	Stock	132.29	132.84	130.47	130.7	262982.0

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

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