PREVIEW / stock_daily / 2016-05-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-27.parquet
  size:    218 KB
  rows:    6,545
  symbols: 3,270

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-27	AAPL	Stock	24.86	25.1175	24.8125	25.0875	145364800.0
2016-05-27	MSFT	Stock	51.92	52.32	51.77	52.32	17721400.0
2016-05-27	NVDA	Stock	1.1425	1.1493	1.1388	1.1475	277416000.0
2016-05-27	AMZN	Stock	35.75	35.83	35.555	35.612	44984000.0
2016-05-27	GOOGL	Stock	36.8755	37.3955	36.8505	37.38	34802600.0
2016-05-27	META	Stock	119.56	119.85	119.01	119.38	13493600.0
2016-05-27	TSLA	Stock	14.9993	15.062	14.7167	14.8693	54754500.0
2016-05-27	TLT	Stock	130.07	130.26	129.7	129.85	5267595.0
2016-05-27	ES	Stock	54.85	55.08	54.67	55.01	1296500.0
2016-05-27	CL	Stock	70.54	70.81	70.31	70.59	2326600.0
2016-05-27	A	Stock	45.55	45.85	45.37	45.82	1822700.0
2016-05-27	AA.B-DELISTED	Stock	33.75	33.75	32.94	33.12	36096.0
2016-05-27	AAAP-DELISTED	Stock	29.29	29.4	28.5	29.0	45848.0
2016-05-27	AABA-DELISTED	Stock	36.88	37.88	36.84	37.815	13887330.0
2016-05-27	AAC-DELISTED	Stock	20.6	21.5699	20.38	21.38	162736.0
2016-05-27	AACG	Stock	5.0	5.0	4.95	4.99	1900.0
2016-05-27	AAIC-DELISTED	Stock	12.88	13.14	12.82	13.11	234073.0
2016-05-27	AAL	Stock	31.6	31.84	31.41	31.65	8573700.0
2016-05-27	AAMC-DELISTED	Stock	5.0118	5.3676	5.0118	5.3176	90545.0
2016-05-27	AAME	Stock	3.39	3.56	3.26	3.56	5800.0
2016-05-27	AAMI	Stock	14.85	14.95	14.78	14.84	369100.0
2016-05-27	AAOI	Stock	10.13	10.295	9.85	10.18	371900.0
2016-05-27	AAON	Stock	18.5867	18.74	18.4733	18.6267	295650.0
2016-05-27	AAP	Stock	156.81	157.76	155.9	156.31	1075600.0
2016-05-27	AAT	Stock	40.06	40.51	39.94	40.15	70500.0
2016-05-27	AAU-DELISTED	Stock	1.07	1.08	1.02	1.03	233305.0
2016-05-27	AAUAF-DELISTED	Stock	1.07	1.08	1.02	1.03	233889.0
2016-05-27	AAV-DELISTED	Stock	5.83	5.94	5.75	5.85	51679.0
2016-05-27	AAWW-DELISTED	Stock	44.11	44.64	43.95	44.0699	209157.0
2016-05-27	AAXJ	Stock	52.95	53.17	52.79	52.89	461818.0
2016-05-27	AAXN-DELISTED	Stock	22.01	22.16	21.83	21.95	523488.0
2016-05-27	AB	Stock	23.33	23.48	23.11	23.42	183500.0
2016-05-27	ABAC-DELISTED	Stock	0.66	0.68	0.66	0.67	2855.0
2016-05-27	ABAX-DELISTED	Stock	44.92	45.87	44.4	45.87	96583.0
2016-05-27	ABB-DELISTED	Stock	21.04	21.09	20.96	20.98	1034459.0
2016-05-27	ABBNY-DELISTED	Stock	21.04	21.09	20.96	20.99	1140948.0
2016-05-27	ABBV	Stock	61.99	63.2	61.9	62.71	5768000.0
2016-05-27	ABC-DELISTED	Stock	73.78	74.11	73.62	74.01	1793574.0
2016-05-27	ABCB	Stock	31.94	32.1	31.69	32.04	133500.0
2016-05-27	ABCD-DELISTED	Stock	4.62	4.7	4.55	4.65	19137.0
2016-05-27	ABCO-DELISTED	Stock	32.55	32.82	32.25	32.33	183214.0
2016-05-27	ABDC-DELISTED	Stock	12.09	12.49	11.86	12.38	43136.0
2016-05-27	ABE-DELISTED	Stock	11.79	11.79	11.72	11.73	5671.0
2016-05-27	ABEO	Stock	81.25	84.0	80.25	81.5	5648.0
2016-05-27	ABEOW-DELISTED	Stock	1.3	1.3	1.2	1.2369	6800.0
2016-05-27	ABEV	Stock	5.28	5.36	5.25	5.35	26793200.0
2016-05-27	ABG	Stock	55.06	56.29	54.67	56.09	171300.0
2016-05-27	ABIL-DELISTED	Stock	2.9	2.9	2.8	2.83	20078.0
2016-05-27	ABM	Stock	33.65	34.13	33.49	34.02	296200.0
2016-05-27	ABMD-DELISTED	Stock	98.81	99.85	98.38	99.73	275236.0

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

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