PREVIEW / etf_daily / 2017-12-07

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-07.parquet
  size:    59 KB
  rows:    1,517

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-12-07	SPY	ETF	264.07	264.43	262.94	264.07	77218600.0
2017-12-07	QQQ	ETF	153.49	154.46	153.33	154.02	32666207.0
2017-12-07	IWM	ETF	151.31	151.89	150.02	151.27	29675200.0
2017-12-07	DIA	ETF	241.21	242.87	241.1	242.36	2718300.0
2017-12-07	GLD	ETF	119.01	119.24	118.1	118.49	12900200.0
2017-12-07	TLT	ETF	127.93	128.1	126.3	126.68	13056800.0
2017-12-07	AADR	ETF	55.49	56.25	55.49	56.25	20000.0
2017-12-07	AAXJ	ETF	73.8	74.47	73.8	74.41	2755400.0
2017-12-07	ACSI	ETF	30.86	30.91	30.845	30.875	1320.0
2017-12-07	ACTX	ETF	68.1456	68.1456	56.6405	63.0716	587.0
2017-12-07	ACWF	ETF	30.28	30.29	30.24	30.265	2849.0
2017-12-07	ACWI	ETF	70.94	71.31	70.91	71.2	1864700.0
2017-12-07	ACWV	ETF	84.03	84.17	83.92	84.1	140600.0
2017-12-07	ACWX	ETF	48.88	49.1141	48.83	49.05	427485.0
2017-12-07	ADRE	ETF	41.54	41.8472	41.37	41.69	10093.0
2017-12-07	AFK	ETF	24.08	24.09	23.98	23.98	2164.0
2017-12-07	AFTY	ETF	18.22	18.22	18.17	18.205	2200.0
2017-12-07	AGG	ETF	109.38	109.46	109.15	109.23	2584100.0
2017-12-07	AGGY	ETF	50.81	50.85	50.69	50.727	32700.0
2017-12-07	AGNG	ETF	19.47	19.47	19.3	19.469	3800.0
2017-12-07	AGQ	ETF	29.61	29.75	28.99	29.36	290900.0
2017-12-07	AGZ	ETF	113.36	113.47	113.3228	113.36	21258.0
2017-12-07	AGZD	ETF	24.145	24.15	24.1	24.14	10400.0
2017-12-07	AIA	ETF	63.61	64.02	63.61	63.93	132478.0
2017-12-07	AIEQ	ETF	25.32	25.46	25.206	25.39	127200.0
2017-12-07	AIRR	ETF	26.98	27.12	26.87	26.87	28500.0
2017-12-07	AIVI	ETF	42.89	43.07	42.89	42.93	7800.0
2017-12-07	ALTY	ETF	15.308	15.34	15.22	15.34	3900.0
2017-12-07	AMJ	ETF	25.95	26.42	25.78	26.38	4985388.0
2017-12-07	AMLP	ETF	52.0	52.15	50.95	52.0	3988780.0
2017-12-07	AMZA	ETF	80.0	82.2	79.85	81.9	82550.0
2017-12-07	ANGL	ETF	29.98	30.0	29.93	29.95	151000.0
2017-12-07	AOA	ETF	54.75	55.01	54.75	54.94	67600.0
2017-12-07	AOK	ETF	34.42	34.52	34.41	34.41	45627.0
2017-12-07	AOM	ETF	38.44	38.5099	38.4168	38.44	153619.0
2017-12-07	AOR	ETF	45.62	45.72	45.5936	45.61	113685.0
2017-12-07	ARGT	ETF	32.37	32.75	32.35	32.71	81000.0
2017-12-07	ARKG	ETF	24.36	25.0	24.36	24.9	27900.0
2017-12-07	ARKK	ETF	36.77	37.2	36.652	37.06	463900.0
2017-12-07	ARKQ	ETF	33.3	33.831	33.3	33.61	45900.0
2017-12-07	ARKW	ETF	45.09	45.624	44.92	45.45	201900.0
2017-12-07	ASEA	ETF	16.57	16.57	16.57	16.57	100.0
2017-12-07	ASET	ETF	28.4499	28.4499	28.4483	28.4483	362.0
2017-12-07	ASHR	ETF	30.12	30.23	30.02	30.13	701900.0
2017-12-07	ASHS	ETF	33.54	33.66	33.54	33.56	5600.0
2017-12-07	ASHX	ETF	22.25	22.2501	22.25	22.2501	272.0
2017-12-07	ATMP	ETF	19.66	19.94	19.54	19.91	341300.0
2017-12-07	BAB	ETF	30.76	30.7699	30.65	30.66	55232.0
2017-12-07	BAL	ETF	48.08	49.1	48.08	49.07	10148.0
2017-12-07	BAR	ETF	12.531	12.531	12.455	12.455	6120.0

> showing 50 of 1,517 rows — these rows as CSV

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