PREVIEW / etf_daily / 2017-03-14

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-14.parquet
  size:    54 KB
  rows:    1,369

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-03-14	SPY	ETF	237.18	237.24	236.19	236.9	59880800.0
2017-03-14	QQQ	ETF	131.31	131.36	130.76	131.29	14019689.0
2017-03-14	IWM	ETF	135.75	135.83	134.56	135.63	30037800.0
2017-03-14	DIA	ETF	208.57	208.88	207.98	208.54	4433000.0
2017-03-14	GLD	ETF	114.54	115.01	114.03	114.12	5301800.0
2017-03-14	TLT	ETF	116.77	117.35	116.71	117.07	9869200.0
2017-03-14	AADR	ETF	45.25	45.25	44.89	44.89	4800.0
2017-03-14	AAXJ	ETF	61.3	61.32	61.11	61.12	411600.0
2017-03-14	ACSI	ETF	27.7484	27.803	27.7484	27.803	304.0
2017-03-14	ACTX	ETF	110.331	118.0011	100.3009	106.201	1826.0
2017-03-14	ACWF	ETF	25.55	25.55	25.46	25.46	9221.0
2017-03-14	ACWI	ETF	62.74	62.78	62.56	62.66	1780800.0
2017-03-14	ACWV	ETF	76.35	76.46	76.3	76.34	84900.0
2017-03-14	ACWX	ETF	42.65	42.665	42.555	42.6	284872.0
2017-03-14	ADRE	ETF	35.77	35.79	35.601	35.75	13813.0
2017-03-14	AFK	ETF	20.74	20.74	20.56	20.5699	5232.0
2017-03-14	AFTY	ETF	13.88	13.89	13.84	13.87	4800.0
2017-03-14	AGG	ETF	107.08	107.24	107.08	107.16	2639200.0
2017-03-14	AGGY	ETF	49.14	49.18	49.12	49.15	19400.0
2017-03-14	AGNG	ETF	16.9	16.9	16.885	16.885	1400.0
2017-03-14	AGQ	ETF	35.88	36.12	35.51	35.54	63000.0
2017-03-14	AGZ	ETF	112.22	112.55	111.8501	112.22	31612.0
2017-03-14	AGZD	ETF	24.13	24.13	24.045	24.075	4800.0
2017-03-14	AIA	ETF	51.18	51.21	51.0748	51.14	17077.0
2017-03-14	AIQ	ETF	10.051	10.2	10.05	10.1	3252.0
2017-03-14	AIRR	ETF	23.47	23.58	23.2	23.57	40600.0
2017-03-14	AIVI	ETF	38.72	38.72	38.58	38.65	43800.0
2017-03-14	ALTY	ETF	15.29	15.29	15.06	15.11	16200.0
2017-03-14	AMJ	ETF	31.85	31.93	31.475	31.67	1690408.0
2017-03-14	AMLP	ETF	63.3	63.4	62.7	62.9	1405060.0
2017-03-14	AMZA	ETF	110.0	110.0	108.59	109.35	68460.0
2017-03-14	ANGL	ETF	28.8	28.84	28.75	28.82	221000.0
2017-03-14	AOA	ETF	49.53	49.53	49.29	49.38	24900.0
2017-03-14	AOK	ETF	32.84	32.9468	32.84	32.91	25329.0
2017-03-14	AOM	ETF	35.98	36.0011	35.899	35.98	54969.0
2017-03-14	AOR	ETF	41.94	41.94	41.8	41.89	208632.0
2017-03-14	ARGT	ETF	26.75	26.75	26.47	26.74	46100.0
2017-03-14	ARKG	ETF	20.35	20.5	20.35	20.48	2100.0
2017-03-14	ARKK	ETF	23.32	23.38	23.21	23.38	5100.0
2017-03-14	ARKQ	ETF	23.69	23.78	23.67	23.75	2800.0
2017-03-14	ARKW	ETF	28.57	28.57	28.372	28.49	1500.0
2017-03-14	ASEA	ETF	13.58	13.67	13.58	13.66	800.0
2017-03-14	ASET	ETF	25.7898	25.7898	25.76	25.78	1172.0
2017-03-14	ASHR	ETF	24.89	24.9	24.82	24.82	281400.0
2017-03-14	ASHS	ETF	34.08	34.08	34.01	34.08	1100.0
2017-03-14	ASHX	ETF	19.39	19.39	19.386	19.386	765.0
2017-03-14	ATMP	ETF	23.31	23.4	23.05	23.3	59300.0
2017-03-14	BAB	ETF	29.08	29.14	29.0	29.077	65100.0
2017-03-14	BAL	ETF	49.92	50.12	49.92	50.1	5160.0
2017-03-14	BBC	ETF	23.6	23.6	23.0	23.29	16660.0

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

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