PREVIEW / etf_daily / 2016-01-25

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-25.parquet
  size:    49 KB
  rows:    1,226

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-01-25	SPY	ETF	189.92	190.15	187.41	187.64	130371700.0
2016-01-25	QQQ	ETF	103.46	103.99	102.14	102.23	38881485.0
2016-01-25	IWM	ETF	100.74	101.08	98.85	99.12	35019600.0
2016-01-25	DIA	ETF	160.41	160.72	158.67	158.7	5782500.0
2016-01-25	GLD	ETF	105.76	106.09	105.6	106.08	6819400.0
2016-01-25	TLT	ETF	125.95	126.27	125.65	126.02	5738200.0
2016-01-25	AAXJ	ETF	48.51	48.59	47.93	47.99	1546300.0
2016-01-25	ACTX	ETF	6.4901	7.0801	5.9001	7.0801	651.0
2016-01-25	ACWF	ETF	21.14	21.14	21.14	21.14	561.0
2016-01-25	ACWI	ETF	51.63	51.69	50.99	51.05	4478200.0
2016-01-25	ACWV	ETF	66.26	66.44	65.8	65.81	163000.0
2016-01-25	ACWX	ETF	36.19	36.37	35.97	35.99	1866945.0
2016-01-25	ADRE	ETF	26.4	26.501	26.11	26.11	13942.0
2016-01-25	AFK	ETF	15.56	15.68	15.33	15.48	87451.0
2016-01-25	AFTY	ETF	12.09	12.092	12.0	12.0	11300.0
2016-01-25	AGG	ETF	108.95	108.98	108.77	108.78	3285000.0
2016-01-25	AGGY	ETF	49.3	49.42	49.29	49.41	169200.0
2016-01-25	AGQ	ETF	28.5	28.73	28.4	28.69	133900.0
2016-01-25	AGZ	ETF	113.77	113.77	113.5954	113.64	51437.0
2016-01-25	AGZD	ETF	23.785	23.785	23.69	23.7	3000.0
2016-01-25	AIA	ETF	38.26	38.3	37.86	37.875	116785.0
2016-01-25	AIQ	ETF	7.13	7.4	7.13	7.21	14279.0
2016-01-25	AIVI	ETF	35.76	35.8	35.51	35.54	61300.0
2016-01-25	ALTY	ETF	12.86	12.86	12.86	12.86	100.0
2016-01-25	AMJ	ETF	23.9	25.26	23.44	23.52	11702939.0
2016-01-25	AMLP	ETF	47.55	51.7	47.5	47.85	4747820.0
2016-01-25	AMUB	ETF	14.98	14.98	14.94	14.94	300.0
2016-01-25	AMZA	ETF	82.5	86.1	78.73	79.1	7600.0
2016-01-25	ANGL	ETF	23.74	23.74	23.52	23.72	30700.0
2016-01-25	AOA	ETF	42.17	42.17	41.77	41.81	193400.0
2016-01-25	AOK	ETF	30.94	30.98	30.84	30.89	39418.0
2016-01-25	AOM	ETF	33.12	33.1391	32.91	32.91	452708.0
2016-01-25	AOR	ETF	37.14	37.14	36.85	36.87	725769.0
2016-01-25	ARGT	ETF	16.44	16.45	16.13	16.13	6200.0
2016-01-25	ARKG	ETF	17.92	17.963	17.92	17.95	500.0
2016-01-25	ARKK	ETF	17.32	17.32	17.32	17.32	200.0
2016-01-25	ARKQ	ETF	16.265	16.265	16.265	16.265	100.0
2016-01-25	ARKW	ETF	19.649	19.649	19.649	19.649	500.0
2016-01-25	ASEA	ETF	11.53	11.54	11.47	11.47	4700.0
2016-01-25	ASHR	ETF	23.15	23.17	22.8	22.81	1096700.0
2016-01-25	ASHS	ETF	32.25	32.36	31.84	31.93	49800.0
2016-01-25	ASHX	ETF	21.0575	21.09	20.9	20.9	1624.0
2016-01-25	ATMP	ETF	15.68	16.87	15.63	15.78	330400.0
2016-01-25	BAB	ETF	29.77	29.86	29.75	29.8	192251.0
2016-01-25	BAL	ETF	40.97	40.97	40.84	40.873	4877.0
2016-01-25	BBC	ETF	21.44	21.485	20.95	20.95	1538.0
2016-01-25	BBH	ETF	108.88	110.58	107.92	108.04	64100.0
2016-01-25	BBP	ETF	25.52	25.97	25.42	25.42	2900.0
2016-01-25	BCM	ETF	22.45	22.55	22.255	22.255	750.0
2016-01-25	BFOR	ETF	6.8175	6.8175	6.7025	6.71	145600.0

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

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