PREVIEW / stock_daily / 2017-05-31

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-31.parquet
  size:    215 KB
  rows:    6,466
  symbols: 3,012

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-31	AAPL	Stock	38.4925	38.5425	38.095	38.19	97804800.0
2017-05-31	MSFT	Stock	70.53	70.74	69.81	69.84	30436400.0
2017-05-31	NVDA	Stock	3.6672	3.675	3.5513	3.6088	887316000.0
2017-05-31	AMZN	Stock	50.0	50.006	49.108	49.731	78262000.0
2017-05-31	GOOGL	Stock	49.8105	49.98	49.084	49.3545	34481900.0
2017-05-31	META	Stock	152.7	153.35	151.09	151.46	18023900.0
2017-05-31	TSLA	Stock	22.5127	22.8593	22.344	22.734	149451000.0
2017-05-31	TLT	Stock	124.05	124.645	124.03	124.4	8000164.0
2017-05-31	ES	Stock	61.54	62.19	61.51	62.07	1565200.0
2017-05-31	CL	Stock	76.19	76.83	76.07	76.36	6266700.0
2017-05-31	A	Stock	59.45	60.81	59.45	60.34	2552400.0
2017-05-31	AA	Stock	32.88	33.05	31.76	32.94	4547000.0
2017-05-31	AAAP-DELISTED	Stock	38.36	39.0	36.5212	37.98	107806.0
2017-05-31	AABA-DELISTED	Stock	50.6	50.65	49.965	50.32	7848286.0
2017-05-31	AAC-DELISTED	Stock	6.26	6.315	6.25	6.28	159759.0
2017-05-31	AACG	Stock	3.48	3.55	3.48	3.55	10200.0
2017-05-31	AAIC-DELISTED	Stock	14.4	14.42	14.21	14.36	265801.0
2017-05-31	AAL	Stock	48.2	48.48	47.53	48.41	4486100.0
2017-05-31	AAM.A-DELISTED	Stock	25.44	25.55	25.44	25.49	69611.0
2017-05-31	AAMC-DELISTED	Stock	25.0	27.2353	24.0588	26.7647	73015.0
2017-05-31	AAME	Stock	3.7	3.8	3.6	3.6	5800.0
2017-05-31	AAMI	Stock	13.87	13.98	13.57	13.96	1405400.0
2017-05-31	AAOI	Stock	71.07	71.65	68.72	69.82	2395600.0
2017-05-31	AAON	Stock	24.2	24.2333	23.8333	24.1133	252000.0
2017-05-31	AAP	Stock	134.14	135.4	131.62	133.63	2118500.0
2017-05-31	AAT	Stock	39.05	39.19	38.71	39.05	195100.0
2017-05-31	AAU-DELISTED	Stock	1.36	1.37	1.3	1.32	199740.0
2017-05-31	AAUAF-DELISTED	Stock	1.36	1.37	1.3	1.32	203393.0
2017-05-31	AAV-DELISTED	Stock	6.2	6.325	6.15	6.3	99493.0
2017-05-31	AAWW-DELISTED	Stock	49.3	49.3	47.8	48.75	200376.0
2017-05-31	AAXJ	Stock	67.08	67.08	66.67	66.76	877247.0
2017-05-31	AAXN-DELISTED	Stock	24.67	24.74	23.98	24.02	687960.0
2017-05-31	AB	Stock	22.2	22.73	21.9	22.55	963900.0
2017-05-31	ABAC-DELISTED	Stock	2.05	2.05	1.85	1.87	13326.0
2017-05-31	ABAX-DELISTED	Stock	50.08	50.08	46.7711	48.38	70034.0
2017-05-31	ABB-DELISTED	Stock	25.2	25.285	25.08	25.13	2022928.0
2017-05-31	ABBNY-DELISTED	Stock	25.2	25.285	25.08	25.13	2066738.0
2017-05-31	ABBV	Stock	66.24	66.41	65.61	66.02	6935800.0
2017-05-31	ABC-DELISTED	Stock	91.33	91.79	90.75	91.77	1650546.0
2017-05-31	ABCB	Stock	44.15	44.15	42.6	43.35	225300.0
2017-05-31	ABCD-DELISTED	Stock	4.99	5.02	4.801	5.0	23277.0
2017-05-31	ABCO-DELISTED	Stock	51.15	52.0	50.8	51.65	199491.0
2017-05-31	ABDC-DELISTED	Stock	13.21	13.46	13.2	13.21	55827.0
2017-05-31	ABE-DELISTED	Stock	13.81	13.812	13.74	13.7894	5997.0
2017-05-31	ABEO	Stock	140.0	141.25	129.5	133.75	9800.0
2017-05-31	ABEV	Stock	5.76	5.79	5.7	5.71	44004300.0
2017-05-31	ABG	Stock	56.05	56.05	54.7	55.95	155400.0
2017-05-31	ABIL-DELISTED	Stock	0.572	0.59	0.5653	0.59	30542.0
2017-05-31	ABM	Stock	42.6	43.15	42.41	43.04	327800.0
2017-05-31	ABMD-DELISTED	Stock	139.74	141.24	137.34	137.43	269625.0

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

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