PREVIEW / stock_daily / 2016-04-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-15.parquet
  size:    219 KB
  rows:    6,572
  symbols: 3,314

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-04-15	AAPL	Stock	28.0275	28.075	27.4325	27.4625	187756000.0
2016-04-15	MSFT	Stock	55.3	55.92	55.11	55.65	28793800.0
2016-04-15	NVDA	Stock	0.9208	0.9365	0.9178	0.9283	436972000.0
2016-04-15	AMZN	Stock	31.096	31.3385	30.9055	31.2945	57754000.0
2016-04-15	GOOGL	Stock	38.775	39.0465	38.7465	39.0	31711680.0
2016-04-15	META	Stock	110.79	110.97	109.2	109.64	20922800.0
2016-04-15	TSLA	Stock	16.754	16.9733	16.608	16.9673	56286000.0
2016-04-15	TLT	Stock	131.29	132.16	131.25	131.88	5831142.0
2016-04-15	ES	Stock	56.06	56.96	55.95	56.72	1892700.0
2016-04-15	CL	Stock	70.83	71.46	70.72	71.25	2799700.0
2016-04-15	A	Stock	40.77	40.95	40.63	40.91	1442300.0
2016-04-15	AA.B-DELISTED	Stock	34.03	35.18	34.03	34.9	121393.0
2016-04-15	AAAP-DELISTED	Stock	35.3	35.77	33.51	35.6799	15653.0
2016-04-15	AABA-DELISTED	Stock	37.12	37.15	36.42	36.5	18190390.0
2016-04-15	AAC-DELISTED	Stock	19.89	19.89	19.13	19.31	119097.0
2016-04-15	AACG	Stock	5.37	5.61	5.37	5.49	12400.0
2016-04-15	AAIC-DELISTED	Stock	12.66	12.81	12.62	12.77	175512.0
2016-04-15	AAL	Stock	41.3	41.36	40.72	40.91	6982200.0
2016-04-15	AAMC-DELISTED	Stock	5.7941	6.0559	5.7118	5.85	94687.0
2016-04-15	AAME	Stock	4.57	4.76	4.54	4.54	2000.0
2016-04-15	AAMI	Stock	13.71	13.76	13.48	13.54	197300.0
2016-04-15	AAOI	Stock	16.18	16.18	15.76	15.82	125100.0
2016-04-15	AAON	Stock	18.3	18.4	18.0933	18.18	157650.0
2016-04-15	AAP	Stock	161.02	162.02	160.02	161.19	411000.0
2016-04-15	AAT	Stock	38.35	38.8	38.35	38.55	166000.0
2016-04-15	AAU-DELISTED	Stock	1.15	1.18	1.13	1.1601	318323.0
2016-04-15	AAUAF-DELISTED	Stock	1.15	1.18	1.13	1.1601	319946.0
2016-04-15	AAV-DELISTED	Stock	5.22	5.22	5.13	5.15	169720.0
2016-04-15	AAVL-DELISTED	Stock	5.28	5.47	5.177	5.37	243035.0
2016-04-15	AAWW-DELISTED	Stock	40.08	40.7599	39.7	40.34	118336.0
2016-04-15	AAXJ	Stock	55.38	55.38	55.075	55.1	526795.0
2016-04-15	AAXN-DELISTED	Stock	19.21	19.39	18.89	19.14	414855.0
2016-04-15	AB	Stock	23.75	23.92	23.58	23.68	147200.0
2016-04-15	ABAC-DELISTED	Stock	0.59	0.62	0.59	0.6148	24780.0
2016-04-15	ABAX-DELISTED	Stock	45.62	46.1199	45.07	45.36	247553.0
2016-04-15	ABB-DELISTED	Stock	19.78	19.9	19.76	19.8	1459220.0
2016-04-15	ABBNY-DELISTED	Stock	19.78	19.9	19.76	19.79	1522960.0
2016-04-15	ABBV	Stock	59.55	59.74	58.78	59.51	4660800.0
2016-04-15	ABC-DELISTED	Stock	86.6	87.88	86.49	87.8	2169815.0
2016-04-15	ABCB	Stock	30.51	30.99	30.23	30.91	184900.0
2016-04-15	ABCD-DELISTED	Stock	4.37	4.49	4.2744	4.45	15158.0
2016-04-15	ABCO-DELISTED	Stock	31.84	33.46	31.84	33.05	237641.0
2016-04-15	ABCW-DELISTED	Stock	46.03	46.26	45.88	46.095	146369.0
2016-04-15	ABDC-DELISTED	Stock	11.715	12.0	11.38	11.75	47355.0
2016-04-15	ABE-DELISTED	Stock	12.0599	12.25	12.03	12.1699	22496.0
2016-04-15	ABEO	Stock	68.75	71.5	68.75	69.5	1800.0
2016-04-15	ABEV	Stock	5.28	5.35	5.27	5.34	14605700.0
2016-04-15	ABG	Stock	59.14	59.96	59.12	59.34	299100.0
2016-04-15	ABGB-DELISTED	Stock	1.4499	1.45	1.37	1.37	46922.0
2016-04-15	ABIL-DELISTED	Stock	6.83	6.83	6.8	6.8	1400.0

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

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