PREVIEW / stock_daily / 2016-05-31

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-31.parquet
  size:    219 KB
  rows:    6,585
  symbols: 3,304

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-05-31	AAPL	Stock	24.9	25.1	24.705	24.965	169228800.0
2016-05-31	MSFT	Stock	52.26	53.0	52.08	53.0	37653100.0
2016-05-31	NVDA	Stock	1.1525	1.1705	1.1518	1.168	412524000.0
2016-05-31	AMZN	Stock	35.6165	36.2115	35.566	36.1395	72366000.0
2016-05-31	GOOGL	Stock	37.438	37.674	37.2785	37.4425	42484960.0
2016-05-31	META	Stock	119.46	120.1	118.12	118.81	23547600.0
2016-05-31	TSLA	Stock	14.8693	14.9833	14.7667	14.882	41835000.0
2016-05-31	TLT	Stock	129.02	130.44	128.98	130.16	8344257.0
2016-05-31	ES	Stock	54.87	55.31	54.67	55.24	2213200.0
2016-05-31	CL	Stock	70.76	70.96	70.1	70.41	3567400.0
2016-05-31	A	Stock	45.79	46.0	45.58	45.89	2256400.0
2016-05-31	AA.B-DELISTED	Stock	33.44	33.47	32.65	32.67	52269.0
2016-05-31	AAAP-DELISTED	Stock	29.5	30.51	28.9001	29.87	80675.0
2016-05-31	AABA-DELISTED	Stock	37.8	38.08	37.5	37.95	12103425.0
2016-05-31	AAC-DELISTED	Stock	21.52	21.795	21.27	21.45	69693.0
2016-05-31	AACG	Stock	4.99	5.05	4.89	4.95	5900.0
2016-05-31	AAIC-DELISTED	Stock	13.06	13.33	13.0	13.3	316064.0
2016-05-31	AAL	Stock	31.75	31.97	31.33	31.91	9618700.0
2016-05-31	AAMC-DELISTED	Stock	5.4118	5.6118	5.1265	5.6118	106757.0
2016-05-31	AAME	Stock	3.56	3.69	3.56	3.68	3300.0
2016-05-31	AAMI	Stock	14.91	15.29	14.76	15.18	132600.0
2016-05-31	AAOI	Stock	10.35	10.76	10.3	10.55	419200.0
2016-05-31	AAON	Stock	18.6267	18.6267	18.0867	18.2933	438150.0
2016-05-31	AAP	Stock	156.99	156.99	153.71	153.84	1689900.0
2016-05-31	AAT	Stock	40.37	40.37	39.8	40.01	133000.0
2016-05-31	AAU-DELISTED	Stock	1.03	1.0699	1.02	1.06	109371.0
2016-05-31	AAUAF-DELISTED	Stock	1.03	1.08	1.02	1.05	274703.0
2016-05-31	AAV-DELISTED	Stock	5.8	5.93	5.77	5.89	46598.0
2016-05-31	AAWW-DELISTED	Stock	44.14	44.89	43.57	43.84	279942.0
2016-05-31	AAXJ	Stock	53.21	53.45	53.05	53.31	661225.0
2016-05-31	AAXN-DELISTED	Stock	22.01	22.42	21.82	22.37	569741.0
2016-05-31	AB	Stock	23.52	23.68	23.36	23.51	158600.0
2016-05-31	ABAC-DELISTED	Stock	0.64	0.689	0.64	0.6841	3125.0
2016-05-31	ABAX-DELISTED	Stock	45.9	46.15	45.36	46.05	131042.0
2016-05-31	ABB-DELISTED	Stock	20.87	20.99	20.7	20.78	2404938.0
2016-05-31	ABBNY-DELISTED	Stock	20.87	20.99	20.7	20.78	2493168.0
2016-05-31	ABBV	Stock	62.71	63.49	62.64	62.93	7147900.0
2016-05-31	ABC-DELISTED	Stock	74.2	75.05	73.89	74.99	3501773.0
2016-05-31	ABCB	Stock	32.24	32.24	31.7	31.83	150500.0
2016-05-31	ABCD-DELISTED	Stock	4.67	4.67	4.53	4.63	8665.0
2016-05-31	ABCO-DELISTED	Stock	32.42	32.775	32.34	32.56	68897.0
2016-05-31	ABDC-DELISTED	Stock	12.43	12.43	12.21	12.22	26398.0
2016-05-31	ABE-DELISTED	Stock	11.74	11.81	11.74	11.764	6141.0
2016-05-31	ABEO	Stock	83.0	83.75	72.75	73.0	8392.0
2016-05-31	ABEOW-DELISTED	Stock	1.3	1.3	1.2999	1.2999	4000.0
2016-05-31	ABEV	Stock	5.3	5.34	5.22	5.26	26736000.0
2016-05-31	ABG	Stock	56.18	56.84	55.91	56.1	528200.0
2016-05-31	ABIL-DELISTED	Stock	2.91	3.44	2.9	3.3601	92178.0
2016-05-31	ABM	Stock	33.96	34.2	33.79	34.17	258800.0
2016-05-31	ABMD-DELISTED	Stock	99.22	100.7099	98.83	99.3	387075.0

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

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