PREVIEW / stock_daily / 2017-11-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-27.parquet
  size:    216 KB
  rows:    6,478
  symbols: 2,910

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-11-27	AAPL	Stock	43.7625	43.77	43.335	43.5225	82867200.0
2017-11-27	MSFT	Stock	83.31	83.98	83.3	83.87	18265200.0
2017-11-27	NVDA	Stock	5.4328	5.434	5.3502	5.3535	422896000.0
2017-11-27	AMZN	Stock	60.133	60.6705	59.5575	59.7915	134880000.0
2017-11-27	GOOGL	Stock	52.9285	53.6518	52.7386	53.6005	35429820.0
2017-11-27	META	Stock	182.56	183.73	181.99	183.03	12344500.0
2017-11-27	TSLA	Stock	20.8833	21.156	20.634	21.1207	68338500.0
2017-11-27	TLT	Stock	126.86	127.05	126.42	126.62	6079853.0
2017-11-27	ES	Stock	64.2	64.64	64.01	64.42	1058900.0
2017-11-27	CL	Stock	72.29	72.46	71.91	72.0	3295100.0
2017-11-27	A	Stock	69.22	69.49	69.17	69.31	1439300.0
2017-11-27	AA	Stock	42.15	42.42	41.49	42.04	3091700.0
2017-11-27	AAAP-DELISTED	Stock	81.25	81.35	81.2	81.3	301483.0
2017-11-27	AABA-DELISTED	Stock	72.82	73.12	71.92	72.09	7042991.0
2017-11-27	AAC-DELISTED	Stock	8.98	9.01	8.53	8.59	124882.0
2017-11-27	AACG	Stock	5.1	5.3	5.09	5.1	27400.0
2017-11-27	AAIC-DELISTED	Stock	11.75	11.84	11.72	11.72	249032.0
2017-11-27	AAL	Stock	48.61	48.83	48.3	48.42	2630800.0
2017-11-27	AAM.A-DELISTED	Stock	26.33	26.41	26.33	26.35	33535.0
2017-11-27	AAMC-DELISTED	Stock	22.6471	22.6471	22.5	22.5	6219.0
2017-11-27	AAME	Stock	3.61	3.7	3.51	3.6	7500.0
2017-11-27	AAMI	Stock	16.06	16.255	16.005	16.04	454600.0
2017-11-27	AAOI	Stock	42.21	42.45	41.18	41.24	945600.0
2017-11-27	AAON	Stock	23.8667	23.9	23.4667	23.5	151650.0
2017-11-27	AAP	Stock	89.61	90.78	89.04	89.87	858800.0
2017-11-27	AAT	Stock	39.65	39.65	39.06	39.21	167300.0
2017-11-27	AAU-DELISTED	Stock	0.9401	0.95	0.8738	0.8849	732060.0
2017-11-27	AAUAF-DELISTED	Stock	0.9401	0.95	0.8738	0.9	748893.0
2017-11-27	AAV-DELISTED	Stock	4.85	4.85	4.7	4.725	98771.0
2017-11-27	AAWW-DELISTED	Stock	54.85	55.25	53.575	54.75	297862.0
2017-11-27	AAXJ	Stock	77.6	77.6	76.95	76.98	1147625.0
2017-11-27	AAXN-DELISTED	Stock	24.1	24.45	23.92	24.43	420263.0
2017-11-27	AB	Stock	25.35	25.7	24.01	25.2	458100.0
2017-11-27	ABAC-DELISTED	Stock	3.14	3.2335	3.06	3.17	10041.0
2017-11-27	ABAX-DELISTED	Stock	49.7	50.27	49.59	49.87	30595.0
2017-11-27	ABB-DELISTED	Stock	25.54	25.68	25.53	25.63	1780877.0
2017-11-27	ABBNY-DELISTED	Stock	25.54	25.68	25.53	25.63	1981328.0
2017-11-27	ABBV	Stock	94.69	95.63	94.44	95.42	3044600.0
2017-11-27	ABC-DELISTED	Stock	81.07	81.78	80.65	81.12	1024841.0
2017-11-27	ABCB	Stock	48.6	48.8	48.05	48.25	162300.0
2017-11-27	ABCD-DELISTED	Stock	5.89	5.89	5.72	5.74	48029.0
2017-11-27	ABDC-DELISTED	Stock	7.98	8.1	7.94	8.02	101246.0
2017-11-27	ABE-DELISTED	Stock	14.2901	14.3065	14.25	14.25	7719.0
2017-11-27	ABEO	Stock	418.75	421.25	397.5	416.25	37980.0
2017-11-27	ABEOW-DELISTED	Stock	11.82	11.82	11.15	11.66	678.0
2017-11-27	ABEV	Stock	6.32	6.4	6.3	6.36	12029100.0
2017-11-27	ABG	Stock	63.7	64.6	63.7	64.3	320400.0
2017-11-27	ABIL-DELISTED	Stock	0.52	0.58	0.4901	0.5399	332055.0
2017-11-27	ABLX-DELISTED	Stock	22.81	23.2	22.7	22.96	159034.0
2017-11-27	ABM	Stock	41.1	41.49	41.1	41.21	259000.0

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

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