PREVIEW / stock_daily / 2016-08-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-18.parquet
  size:    219 KB
  rows:    6,540
  symbols: 3,232

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-08-18	AAPL	Stock	27.3075	27.4	27.255	27.27	87938800.0
2016-08-18	MSFT	Stock	57.42	57.7	57.27	57.6	14214300.0
2016-08-18	NVDA	Stock	1.5265	1.555	1.5205	1.5525	331684000.0
2016-08-18	AMZN	Stock	38.2	38.2585	38.03	38.223	29176000.0
2016-08-18	GOOGL	Stock	40.268	40.4	40.0815	40.1375	17303200.0
2016-08-18	META	Stock	124.01	124.26	123.64	123.91	12400800.0
2016-08-18	TSLA	Stock	14.9213	15.044	14.8193	14.9007	25717500.0
2016-08-18	TLT	Stock	139.2	139.765	138.79	139.44	3805233.0
2016-08-18	ES	Stock	55.6	56.59	55.6	56.53	2493400.0
2016-08-18	CL	Stock	74.58	74.86	74.48	74.59	2059600.0
2016-08-18	A	Stock	46.88	47.34	46.09	46.72	4660000.0
2016-08-18	AA.B-DELISTED	Stock	35.12	35.66	35.12	35.55	97018.0
2016-08-18	AAAP-DELISTED	Stock	31.78	32.35	31.78	32.35	6849.0
2016-08-18	AABA-DELISTED	Stock	42.69	42.97	42.585	42.9	9467889.0
2016-08-18	AAC-DELISTED	Stock	18.0	18.0326	17.5	17.58	287688.0
2016-08-18	AACG	Stock	4.03	4.27	4.03	4.14	1600.0
2016-08-18	AAIC-DELISTED	Stock	14.42	14.71	14.42	14.51	132767.0
2016-08-18	AAL	Stock	36.43	36.7	36.05	36.67	5292900.0
2016-08-18	AAMC-DELISTED	Stock	4.0353	4.2324	3.9824	4.1353	47974.0
2016-08-18	AAMI	Stock	13.58	13.64	13.49	13.61	82200.0
2016-08-18	AAOI	Stock	13.17	13.437	13.06	13.34	447600.0
2016-08-18	AAON	Stock	18.2067	18.4267	18.14	18.3733	119700.0
2016-08-18	AAP	Stock	158.5	158.79	156.63	157.43	1370600.0
2016-08-18	AAT	Stock	44.75	44.93	44.46	44.63	133600.0
2016-08-18	AAU-DELISTED	Stock	1.75	1.75	1.64	1.69	214946.0
2016-08-18	AAUAF-DELISTED	Stock	1.75	1.75	1.64	1.7	219997.0
2016-08-18	AAV-DELISTED	Stock	7.18	7.43	7.16	7.415	131785.0
2016-08-18	AAWW-DELISTED	Stock	34.85	35.01	34.58	34.68	111924.0
2016-08-18	AAXJ	Stock	59.65	59.87	59.53	59.85	669405.0
2016-08-18	AAXN-DELISTED	Stock	29.26	29.56	29.14	29.43	470434.0
2016-08-18	AB	Stock	21.9	22.13	21.9	21.99	115500.0
2016-08-18	ABAC-DELISTED	Stock	0.78	0.84	0.7212	0.7717	24147.0
2016-08-18	ABAX-DELISTED	Stock	49.0	49.46	48.86	49.34	70417.0
2016-08-18	ABB-DELISTED	Stock	22.23	22.36	22.21	22.355	1089335.0
2016-08-18	ABBNY-DELISTED	Stock	22.23	22.36	22.21	22.36	1122555.0
2016-08-18	ABBV	Stock	66.57	67.43	66.55	66.77	8205800.0
2016-08-18	ABC-DELISTED	Stock	88.58	88.99	88.11	88.97	1192180.0
2016-08-18	ABCB	Stock	33.45	33.76	33.44	33.75	90000.0
2016-08-18	ABCD-DELISTED	Stock	4.7038	4.795	4.68	4.78	15733.0
2016-08-18	ABCO-DELISTED	Stock	41.19	41.51	39.21	41.4	177977.0
2016-08-18	ABDC-DELISTED	Stock	12.4	12.44	12.31	12.4	18940.0
2016-08-18	ABE-DELISTED	Stock	12.8	12.8	12.77	12.77	566.0
2016-08-18	ABEO	Stock	102.25	109.75	101.25	109.25	3364.0
2016-08-18	ABEOW-DELISTED	Stock	1.7	1.8306	1.65	1.8306	3136.0
2016-08-18	ABEV	Stock	6.2	6.22	6.14	6.15	12941800.0
2016-08-18	ABG	Stock	54.76	54.77	54.06	54.36	205900.0
2016-08-18	ABIL-DELISTED	Stock	4.06	4.37	4.03	4.26	54852.0
2016-08-18	ABM	Stock	37.95	38.05	37.74	37.92	169900.0
2016-08-18	ABMD-DELISTED	Stock	122.23	123.91	121.05	121.5	211766.0
2016-08-18	ABR	Stock	7.32	7.32	7.27	7.32	144700.0

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

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