PREVIEW / stock_daily / 2016-11-17

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-17.parquet
  size:    216 KB
  rows:    6,544
  symbols: 3,169

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-11-17	AAPL	Stock	27.4525	27.5875	27.2075	27.4875	110528000.0
2016-11-17	MSFT	Stock	60.41	60.95	59.97	60.64	32132700.0
2016-11-17	NVDA	Stock	2.3078	2.3698	2.2663	2.3098	832988000.0
2016-11-17	AMZN	Stock	37.466	37.875	37.4	37.82	73802000.0
2016-11-17	GOOGL	Stock	39.125	39.445	38.9925	39.308	30673580.0
2016-11-17	META	Stock	116.81	117.79	116.01	117.79	18597800.0
2016-11-17	TSLA	Stock	12.2327	12.6327	12.1407	12.5773	73306500.0
2016-11-17	TLT	Stock	121.95	122.11	120.99	121.2	11221604.0
2016-11-17	ES	Stock	51.95	52.47	51.95	52.2	872300.0
2016-11-17	CL	Stock	66.65	66.83	65.93	65.99	3831600.0
2016-11-17	A	Stock	46.16	46.16	45.55	45.94	2070600.0
2016-11-17	AA	Stock	31.3	32.02	30.77	31.85	4693200.0
2016-11-17	AAAP-DELISTED	Stock	36.58	36.58	34.77	35.98	55004.0
2016-11-17	AABA-DELISTED	Stock	41.34	41.65	41.2	41.45	7635631.0
2016-11-17	AAC-DELISTED	Stock	9.72	10.62	9.64	10.44	316537.0
2016-11-17	AACG	Stock	3.94	4.15	3.94	4.12	800.0
2016-11-17	AAIC-DELISTED	Stock	15.58	15.8	15.54	15.64	233679.0
2016-11-17	AAL	Stock	44.39	45.85	44.05	45.83	8558700.0
2016-11-17	AAMC-DELISTED	Stock	8.8088	8.8676	7.9338	8.5294	48137.0
2016-11-17	AAME	Stock	3.85	3.85	3.85	3.85	200.0
2016-11-17	AAMI	Stock	14.48	14.73	14.295	14.61	145700.0
2016-11-17	AAOI	Stock	25.98	26.15	25.36	26.15	532300.0
2016-11-17	AAON	Stock	21.7333	22.0	21.7333	21.9	180750.0
2016-11-17	AAP	Stock	163.44	166.97	162.34	166.32	1496400.0
2016-11-17	AAT	Stock	40.2	40.67	40.06	40.12	148400.0
2016-11-17	AAU-DELISTED	Stock	1.19	1.2109	1.11	1.11	244526.0
2016-11-17	AAUAF-DELISTED	Stock	1.19	1.2109	1.11	1.13	245944.0
2016-11-17	AAV-DELISTED	Stock	6.85	6.95	6.7	6.7	47663.0
2016-11-17	AAWW-DELISTED	Stock	50.0	50.6	48.725	50.45	310775.0
2016-11-17	AAXJ	Stock	55.82	56.12	55.78	55.84	2473054.0
2016-11-17	AAXN-DELISTED	Stock	27.84	28.2	27.67	27.96	458017.0
2016-11-17	AB	Stock	23.5	23.85	23.25	23.3	317100.0
2016-11-17	ABAC-DELISTED	Stock	2.7133	2.97	2.4	2.88	49987.0
2016-11-17	ABAX-DELISTED	Stock	52.63	53.29	52.03	52.93	150815.0
2016-11-17	ABB-DELISTED	Stock	20.94	21.0	20.86	20.895	1143621.0
2016-11-17	ABBNY-DELISTED	Stock	20.94	21.0	20.86	20.9	1174298.0
2016-11-17	ABBV	Stock	61.75	61.99	61.13	61.7	4879500.0
2016-11-17	ABC-DELISTED	Stock	78.2	80.25	77.71	80.11	2641905.0
2016-11-17	ABCB	Stock	42.0	42.25	40.05	41.85	272200.0
2016-11-17	ABCD-DELISTED	Stock	5.04	5.16	5.0	5.03	34149.0
2016-11-17	ABCO-DELISTED	Stock	35.05	35.9	35.0	35.7	278998.0
2016-11-17	ABDC-DELISTED	Stock	11.47	11.81	11.42	11.62	61756.0
2016-11-17	ABEO	Stock	175.0	182.5	172.5	181.25	13212.0
2016-11-17	ABEOW-DELISTED	Stock	3.6	3.75	3.5	3.7	6950.0
2016-11-17	ABEV	Stock	5.15	5.2	5.09	5.1	13463400.0
2016-11-17	ABG	Stock	58.4	58.85	57.95	58.35	233500.0
2016-11-17	ABIL-DELISTED	Stock	3.1501	3.1624	2.93	2.93	47025.0
2016-11-17	ABM	Stock	42.52	43.04	42.18	43.01	277500.0
2016-11-17	ABMD-DELISTED	Stock	111.98	113.95	110.96	113.61	371135.0
2016-11-17	ABR	Stock	7.48	7.5	7.4	7.45	72000.0

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

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