PREVIEW / stock_daily / 2017-02-15

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-15.parquet
  size:    217 KB
  rows:    6,508
  symbols: 3,093

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-02-15	AAPL	Stock	33.88	34.0675	33.655	33.8775	142492400.0
2017-02-15	MSFT	Stock	64.5	64.57	64.16	64.53	17005200.0
2017-02-15	NVDA	Stock	2.7225	2.745	2.694	2.725	373020000.0
2017-02-15	AMZN	Stock	41.7	42.1405	41.641	42.135	59378000.0
2017-02-15	GOOGL	Stock	41.9405	42.0886	41.811	41.866	27143700.0
2017-02-15	META	Stock	133.45	133.7	132.66	133.44	13226500.0
2017-02-15	TSLA	Stock	18.6667	18.816	18.4293	18.6507	74218500.0
2017-02-15	TLT	Stock	118.76	119.22	118.65	118.96	8481015.0
2017-02-15	ES	Stock	55.6	55.78	55.2	55.76	995600.0
2017-02-15	CL	Stock	67.53	68.74	67.52	68.61	4576200.0
2017-02-15	A	Stock	51.14	51.84	50.62	51.62	5724500.0
2017-02-15	AA	Stock	38.25	38.3	37.73	37.87	11488900.0
2017-02-15	AAAP-DELISTED	Stock	35.6	36.12	35.25	35.75	75430.0
2017-02-15	AABA-DELISTED	Stock	45.03	46.72	44.64	45.65	21174531.0
2017-02-15	AAC-DELISTED	Stock	7.92	8.175	7.89	8.11	106204.0
2017-02-15	AACG	Stock	3.75	3.81	3.66	3.66	7500.0
2017-02-15	AAIC-DELISTED	Stock	14.92	14.92	14.6	14.77	505990.0
2017-02-15	AAL	Stock	47.59	48.05	46.93	47.54	8394800.0
2017-02-15	AAMC-DELISTED	Stock	22.4559	23.0515	22.4559	22.9338	10581.0
2017-02-15	AAME	Stock	3.85	4.0	3.85	3.9	21900.0
2017-02-15	AAMI	Stock	15.11	15.37	15.015	15.31	313300.0
2017-02-15	AAOI	Stock	36.65	36.65	35.36	35.97	709800.0
2017-02-15	AAON	Stock	22.8	23.2733	22.7667	23.0667	194100.0
2017-02-15	AAP	Stock	163.29	165.3	163.01	163.88	694700.0
2017-02-15	AAT	Stock	42.59	43.41	41.97	43.09	258300.0
2017-02-15	AAU-DELISTED	Stock	1.23	1.25	1.2	1.21	217188.0
2017-02-15	AAUAF-DELISTED	Stock	1.23	1.25	1.2	1.24	239724.0
2017-02-15	AAV-DELISTED	Stock	6.45	6.625	6.45	6.625	30607.0
2017-02-15	AAWW-DELISTED	Stock	52.25	54.55	52.105	54.35	144535.0
2017-02-15	AAXJ	Stock	60.49	60.88	60.38	60.81	601683.0
2017-02-15	AAXN-DELISTED	Stock	26.67	26.85	26.35	26.52	632436.0
2017-02-15	AB	Stock	24.2	24.2	23.55	23.65	990600.0
2017-02-15	ABAC-DELISTED	Stock	3.58	3.58	3.3381	3.35	16533.0
2017-02-15	ABAX-DELISTED	Stock	48.89	49.39	48.89	49.13	176062.0
2017-02-15	ABB-DELISTED	Stock	22.68	22.94	22.68	22.92	1651900.0
2017-02-15	ABBNY-DELISTED	Stock	22.68	22.94	22.68	22.93	1987499.0
2017-02-15	ABBV	Stock	60.92	61.84	60.4	61.65	8927600.0
2017-02-15	ABC-DELISTED	Stock	90.65	91.47	89.66	91.15	1638965.0
2017-02-15	ABCB	Stock	47.85	48.0	47.25	47.9	126700.0
2017-02-15	ABCD-DELISTED	Stock	4.86	4.88	4.7671	4.85	30667.0
2017-02-15	ABCO-DELISTED	Stock	47.4	47.6	46.95	47.25	453066.0
2017-02-15	ABDC-DELISTED	Stock	12.76	12.85	12.53	12.71	47548.0
2017-02-15	ABE-DELISTED	Stock	12.04	12.0736	11.99	12.03	61928.0
2017-02-15	ABEO	Stock	140.0	160.0	138.75	147.5	34992.0
2017-02-15	ABEOW-DELISTED	Stock	3.23	3.25	3.23	3.25	300.0
2017-02-15	ABEV	Stock	5.66	5.88	5.65	5.84	29433900.0
2017-02-15	ABG	Stock	66.0	68.0	65.55	67.95	325100.0
2017-02-15	ABIL-DELISTED	Stock	3.3	3.3	3.12	3.12	6322.0
2017-02-15	ABM	Stock	40.23	40.7	40.15	40.41	337800.0
2017-02-15	ABMD-DELISTED	Stock	108.7	110.7	108.215	110.665	383532.0

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

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