PREVIEW / etf_daily / 2017-01-06

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-06.parquet
  size:    54 KB
  rows:    1,363

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-01-06	SPY	ETF	226.53	227.75	225.9	227.21	71559900.0
2017-01-06	QQQ	ETF	120.99	122.25	120.685	121.93	24074305.0
2017-01-06	IWM	ETF	136.41	136.71	135.68	135.69	23436000.0
2017-01-06	DIA	ETF	198.73	199.83	198.17	199.51	4322600.0
2017-01-06	GLD	ETF	111.81	112.38	111.57	111.75	7686100.0
2017-01-06	TLT	ETF	121.13	121.54	120.75	120.86	8369300.0
2017-01-06	AADR	ETF	42.14	42.4	42.14	42.27	2100.0
2017-01-06	AAXJ	ETF	56.58	56.63	56.4	56.53	993800.0
2017-01-06	ACSI	ETF	27.2075	27.29	27.1499	27.22	4954.0
2017-01-06	ACTX	ETF	27.7302	28.3203	24.7802	28.3203	1028.0
2017-01-06	ACWF	ETF	24.6799	24.68	24.561	24.561	544.0
2017-01-06	ACWI	ETF	60.35	60.46	60.15	60.38	1233800.0
2017-01-06	ACWV	ETF	73.67	73.72	73.46	73.64	314800.0
2017-01-06	ACWX	ETF	41.16	41.185	41.07	41.12	1443117.0
2017-01-06	ADRE	ETF	33.68	33.68	33.3201	33.37	5435.0
2017-01-06	AFK	ETF	20.55	20.6999	20.3101	20.47	10987.0
2017-01-06	AFTY	ETF	13.31	13.38	13.31	13.38	600.0
2017-01-06	AGG	ETF	108.43	108.5	108.26	108.29	2910100.0
2017-01-06	AGGY	ETF	49.82	49.88	49.708	49.77	19900.0
2017-01-06	AGQ	ETF	34.15	34.67	33.95	34.34	144500.0
2017-01-06	AGZ	ETF	112.49	113.0017	112.49	112.84	12633.0
2017-01-06	AGZD	ETF	24.17	24.175	24.09	24.125	2200.0
2017-01-06	AIA	ETF	47.51	47.51	47.34	47.42	27318.0
2017-01-06	AIQ	ETF	9.6	9.7	9.6	9.7	26681.0
2017-01-06	AIRR	ETF	23.73	23.96	23.69	23.74	138600.0
2017-01-06	AIVI	ETF	38.06	38.16	38.05	38.09	14200.0
2017-01-06	ALTY	ETF	15.38	15.41	15.26	15.41	2600.0
2017-01-06	AMJ	ETF	32.25	32.43	32.1358	32.35	1190112.0
2017-01-06	AMLP	ETF	64.25	64.4	64.0	64.05	2128240.0
2017-01-06	AMZA	ETF	110.3	110.5	109.6	110.1	62600.0
2017-01-06	ANGL	ETF	29.08	29.15	29.03	29.08	216200.0
2017-01-06	AOA	ETF	47.95	48.0	47.82	47.94	128700.0
2017-01-06	AOK	ETF	32.79	32.79	32.6801	32.73	74338.0
2017-01-06	AOM	ETF	35.43	35.5596	35.43	35.46	214722.0
2017-01-06	AOR	ETF	41.01	41.08	40.89	41.0	826696.0
2017-01-06	ARGT	ETF	23.99	24.36	23.94	24.34	146300.0
2017-01-06	ARKG	ETF	18.105	18.23	18.105	18.23	800.0
2017-01-06	ARKK	ETF	21.37	21.41	21.32	21.365	4400.0
2017-01-06	ARKQ	ETF	22.59	22.68	22.55	22.65	7500.0
2017-01-06	ARKW	ETF	26.59	26.63	26.3	26.566	5000.0
2017-01-06	ASEA	ETF	13.2	13.22	13.14	13.2	5200.0
2017-01-06	ASHR	ETF	24.37	24.4	24.2	24.25	1457400.0
2017-01-06	ASHS	ETF	33.65	33.65	33.42	33.42	9100.0
2017-01-06	ATMP	ETF	24.08	24.17	23.97	24.13	183300.0
2017-01-06	BAB	ETF	29.39	29.39	29.23	29.29	196804.0
2017-01-06	BAL	ETF	48.18	48.84	48.12	48.84	5454.0
2017-01-06	BBC	ETF	19.82	20.09	19.8003	20.0025	22178.0
2017-01-06	BBH	ETF	113.0	114.14	113.0	113.6	106100.0
2017-01-06	BBP	ETF	34.856	34.91	34.74	34.745	8200.0
2017-01-06	BCM	ETF	27.3854	27.3854	27.3601	27.3601	918.0

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

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