PREVIEW / etf_daily / 2014-09-22

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-22.parquet
  size:    46 KB
  rows:    1,126

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
2014-09-22	SPY	ETF	200.35	200.38	198.73	199.15	125553000.0
2014-09-22	QQQ	ETF	99.74	99.75	98.62	99.05	48658049.0
2014-09-22	IWM	ETF	113.44	113.53	112.05	112.37	45800600.0
2014-09-22	DIA	ETF	172.35	172.38	171.22	171.41	4894200.0
2014-09-22	GLD	ETF	116.72	117.37	116.58	116.85	7601600.0
2014-09-22	TLT	ETF	114.66	115.04	114.44	114.74	6617200.0
2014-09-22	AADR	ETF	37.98	37.98	37.92	37.98	1900.0
2014-09-22	AAXJ	ETF	63.46	63.55	62.8	62.91	825000.0
2014-09-22	ACWI	ETF	60.28	60.33	59.85	59.96	497000.0
2014-09-22	ACWV	ETF	67.55	67.55	67.14	67.23	66900.0
2014-09-22	ACWX	ETF	46.86	46.86	46.52	46.64	540095.0
2014-09-22	ADRE	ETF	40.82	40.9	40.51	40.71	41562.0
2014-09-22	AFK	ETF	31.86	32.05	31.68	31.79	69959.0
2014-09-22	AGG	ETF	108.86	108.91	108.76	108.83	592400.0
2014-09-22	AGQ	ETF	49.47	50.74	49.34	50.37	397300.0
2014-09-22	AGZ	ETF	112.24	112.41	111.8721	112.29	13049.0
2014-09-22	AGZD	ETF	24.895	24.905	24.85	24.89	14400.0
2014-09-22	AIA	ETF	48.52	48.52	47.968	48.1292	49185.0
2014-09-22	AIQ	ETF	25.33	25.48	24.77	24.77	22817.0
2014-09-22	AIRR	ETF	19.01	19.01	18.95	18.98	6300.0
2014-09-22	AIVI	ETF	48.13	48.13	47.83	47.96	52500.0
2014-09-22	ALTL	ETF	35.8134	35.8134	35.78	35.78	254.0
2014-09-22	AMJ	ETF	53.67	53.88	52.78	53.15	2996559.0
2014-09-22	AMLP	ETF	96.2	96.25	95.05	95.25	580720.0
2014-09-22	ANGL	ETF	28.09	28.09	27.8	27.86	1300.0
2014-09-22	AOA	ETF	46.59	46.59	46.22	46.29	13000.0
2014-09-22	AOK	ETF	32.74	32.74	32.61	32.62	21521.0
2014-09-22	AOM	ETF	35.35	35.35	35.17	35.17	83743.0
2014-09-22	AOR	ETF	40.02	40.02	39.86	39.91	26313.0
2014-09-22	ARGT	ETF	21.42	21.51	21.25	21.44	43200.0
2014-09-22	ASEA	ETF	17.0	17.02	16.8	16.83	200100.0
2014-09-22	ASHR	ETF	25.02	25.14	24.8	24.82	709100.0
2014-09-22	ASHS	ETF	32.38	32.38	31.98	32.03	12300.0
2014-09-22	ATMP	ETF	32.64	32.64	32.21	32.25	45000.0
2014-09-22	AVIV	ETF	27.34	27.64	27.16	27.49	182119.0
2014-09-22	AWAY	ETF	34.19	34.3492	32.47	32.84	1084009.0
2014-09-22	BAB	ETF	29.45	29.519	29.41	29.507	68692.0
2014-09-22	BAL	ETF	42.09	42.14	41.59	41.85	31410.0
2014-09-22	BALT	ETF	5.14	5.2	4.6	4.65	1223200.0
2014-09-22	BAR	ETF	3.065	3.1247	3.065	3.081	19150.0
2014-09-22	BBH	ETF	106.86	106.86	105.09	106.03	204800.0
2014-09-22	BCHP	ETF	19.93	19.93	19.93	19.93	297.0
2014-09-22	BCM	ETF	36.94	37.0301	36.94	37.0301	1238.0
2014-09-22	BFOR	ETF	7.7575	7.7575	7.66	7.6875	199200.0
2014-09-22	BIB	ETF	52.5	52.5	50.71	51.61	352056.0
2014-09-22	BICK	ETF	26.12	26.32	26.03	26.04	1586.0
2014-09-22	BIL	ETF	91.5	91.52	91.5	91.52	1013800.0
2014-09-22	BIS	ETF	478.8	496.4	478.8	488.4	12370.0
2014-09-22	BIV	ETF	84.0	84.1	83.97	84.09	138800.0
2014-09-22	BIZD	ETF	20.04	20.04	19.82	19.86	26500.0

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

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