PREVIEW / stock_daily / 2016-08-08

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-08.parquet
  size:    219 KB
  rows:    6,545
  symbols: 3,240

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-08	AAPL	Stock	26.88	27.0925	26.79	27.0925	112148800.0
2016-08-08	MSFT	Stock	58.06	58.09	57.78	58.06	19473500.0
2016-08-08	NVDA	Stock	1.475	1.4785	1.453	1.4685	305064000.0
2016-08-08	AMZN	Stock	38.3405	38.35	38.051	38.328	39726000.0
2016-08-08	GOOGL	Stock	40.3	40.38	40.0845	40.2615	24432180.0
2016-08-08	META	Stock	125.25	125.45	124.55	125.26	15233900.0
2016-08-08	TSLA	Stock	15.2	15.3067	15.0727	15.0773	33954000.0
2016-08-08	TLT	Stock	137.6	138.54	137.32	138.26	5185234.0
2016-08-08	ES	Stock	56.89	57.18	56.43	56.77	1479800.0
2016-08-08	CL	Stock	74.48	74.51	73.94	74.43	2223400.0
2016-08-08	A	Stock	47.57	47.67	47.14	47.23	1311700.0
2016-08-08	AA.B-DELISTED	Stock	35.7901	36.01	35.65	36.0	17910.0
2016-08-08	AAAP-DELISTED	Stock	31.09	31.77	30.8	31.5	14515.0
2016-08-08	AABA-DELISTED	Stock	39.04	39.27	38.86	39.24	9428630.0
2016-08-08	AAC-DELISTED	Stock	19.01	19.3	18.63	18.77	95064.0
2016-08-08	AACG	Stock	3.74	3.74	3.58	3.58	500.0
2016-08-08	AAIC-DELISTED	Stock	14.94	15.14	14.9	15.03	265609.0
2016-08-08	AAL	Stock	34.22	34.88	34.12	34.35	7142400.0
2016-08-08	AAMC-DELISTED	Stock	4.2647	4.2647	3.9118	3.9985	92742.0
2016-08-08	AAME	Stock	4.14	4.14	4.14	4.14	500.0
2016-08-08	AAMI	Stock	13.88	13.97	13.62	13.73	117800.0
2016-08-08	AAOI	Stock	14.79	14.94	14.2	14.29	339200.0
2016-08-08	AAON	Stock	17.8	18.1933	17.7267	18.1667	225300.0
2016-08-08	AAP	Stock	170.49	171.31	168.75	168.88	1111700.0
2016-08-08	AAT	Stock	45.03	45.51	45.01	45.37	149300.0
2016-08-08	AAU-DELISTED	Stock	1.48	1.53	1.46	1.52	583736.0
2016-08-08	AAUAF-DELISTED	Stock	1.48	1.53	1.46	1.53	611611.0
2016-08-08	AAV-DELISTED	Stock	6.7	6.85	6.7	6.72	105460.0
2016-08-08	AAWW-DELISTED	Stock	36.1	36.81	35.85	35.85	298966.0
2016-08-08	AAXJ	Stock	58.58	58.69	58.52	58.54	1041337.0
2016-08-08	AAXN-DELISTED	Stock	29.25	29.4648	28.63	28.74	1351177.0
2016-08-08	AB	Stock	21.5	22.04	21.34	21.88	249800.0
2016-08-08	ABAC-DELISTED	Stock	0.64	0.6955	0.64	0.69	40923.0
2016-08-08	ABAX-DELISTED	Stock	49.15	49.49	48.68	48.93	72686.0
2016-08-08	ABB-DELISTED	Stock	21.32	21.41	21.32	21.39	1033645.0
2016-08-08	ABBNY-DELISTED	Stock	21.33	21.41	21.32	21.39	1067533.0
2016-08-08	ABBV	Stock	66.38	66.67	65.75	66.34	5309300.0
2016-08-08	ABC-DELISTED	Stock	89.71	89.71	88.47	88.67	1017379.0
2016-08-08	ABCB	Stock	33.68	33.8	33.36	33.49	96600.0
2016-08-08	ABCD-DELISTED	Stock	4.72	4.741	4.72	4.72	6764.0
2016-08-08	ABCO-DELISTED	Stock	42.09	42.51	41.36	41.54	171018.0
2016-08-08	ABDC-DELISTED	Stock	12.35	12.4	12.28	12.34	48909.0
2016-08-08	ABE-DELISTED	Stock	12.66	12.69	12.61	12.62	9137.0
2016-08-08	ABEO	Stock	86.25	94.25	86.25	91.75	5192.0
2016-08-08	ABEOW-DELISTED	Stock	1.1	1.1	1.1	1.1	1000.0
2016-08-08	ABEV	Stock	6.01	6.1	6.01	6.1	24239400.0
2016-08-08	ABG	Stock	58.18	58.4	56.92	57.6	177000.0
2016-08-08	ABIL-DELISTED	Stock	5.66	5.66	5.49	5.56	46046.0
2016-08-08	ABM	Stock	37.26	37.3	36.97	37.1	80700.0
2016-08-08	ABMD-DELISTED	Stock	120.0	120.312	118.33	120.26	306039.0

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

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