PREVIEW / etf_daily / 2013-01-17

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-17.parquet
  size:    40 KB
  rows:    965

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
2013-01-17	SPY	ETF	147.7	148.42	147.15	148.0	133833500.0
2013-01-17	QQQ	ETF	67.18	67.48	67.06	67.22	32030740.0
2013-01-17	IWM	ETF	87.91	88.51	87.83	88.32	34219400.0
2013-01-17	DIA	ETF	135.37	136.19	135.23	135.83	6227500.0
2013-01-17	GLD	ETF	161.94	164.4	161.83	163.35	14911400.0
2013-01-17	TLT	ETF	119.33	119.55	118.75	119.12	7019200.0
2013-01-17	AADR	ETF	32.49	32.6	32.28	32.6	1900.0
2013-01-17	AAXJ	ETF	60.89	61.3	60.83	61.06	1202700.0
2013-01-17	ACTV	ETF	5.81	5.9	5.54	5.57	576512.0
2013-01-17	ACWI	ETF	49.47	49.64	49.36	49.52	1519400.0
2013-01-17	ACWV	ETF	57.17	57.45	57.14	57.32	18400.0
2013-01-17	ACWX	ETF	42.73	42.96	42.72	42.81	392013.0
2013-01-17	ADRE	ETF	41.09	41.28	41.09	41.13	24895.0
2013-01-17	AFK	ETF	31.15	31.2898	31.1	31.199	28257.0
2013-01-17	AGEM	ETF	23.67	23.87	23.66	23.81	11037.0
2013-01-17	AGG	ETF	110.78	110.91	110.71	110.8	1281000.0
2013-01-17	AGQ	ETF	185.08	193.92	184.64	191.48	384925.0
2013-01-17	AGZ	ETF	113.37	113.37	113.15	113.309	68230.0
2013-01-17	AIA	ETF	47.9	48.2565	47.9	48.21	36778.0
2013-01-17	AIQ	ETF	6.79	6.85	6.63	6.63	3622.0
2013-01-17	AIVI	ETF	42.95	43.14	42.92	43.07	26100.0
2013-01-17	AMJ	ETF	41.6	41.8844	41.41	41.7	2229509.0
2013-01-17	AMLP	ETF	83.9	84.3	83.75	84.15	629580.0
2013-01-17	ANGL	ETF	27.43	27.43	27.12	27.12	1800.0
2013-01-17	AOA	ETF	38.3	38.37	38.21	38.32	38300.0
2013-01-17	AOK	ETF	30.85	30.8598	30.8	30.83	20975.0
2013-01-17	AOM	ETF	32.127	32.2	32.11	32.17	13852.0
2013-01-17	AOR	ETF	34.64	34.72	34.6	34.69	24531.0
2013-01-17	ARB	ETF	46.82	46.82	46.75	46.79	180623.0
2013-01-17	ARGT	ETF	18.16	18.26	18.14	18.26	2400.0
2013-01-17	ASEA	ETF	17.08	17.1	17.02	17.07	17200.0
2013-01-17	AWAY	ETF	22.8	22.94	22.31	22.87	385806.0
2013-01-17	BAB	ETF	30.09	30.1	29.98	29.98	186756.0
2013-01-17	BAL	ETF	50.62	51.05	50.5778	50.79	23310.0
2013-01-17	BALT	ETF	3.38	3.42	3.28	3.38	94036.0
2013-01-17	BBH	ETF	56.3	56.64	56.0	56.45	55700.0
2013-01-17	BCM	ETF	44.47	44.47	44.44	44.44	835.0
2013-01-17	BIB	ETF	16.25	16.25	15.8775	16.085	313304.0
2013-01-17	BICK	ETF	25.94	26.0498	25.94	26.0498	13604.0
2013-01-17	BIL	ETF	91.6	91.62	91.6	91.62	739550.0
2013-01-17	BIS	ETF	2392.8	2392.8	2384.0	2384.0	20.0
2013-01-17	BIV	ETF	88.01	88.01	87.85	87.88	238600.0
2013-01-17	BJK	ETF	37.97	38.13	37.91	38.13	3500.0
2013-01-17	BKF	ETF	41.8	42.02	41.754	41.89	94193.0
2013-01-17	BKLN	ETF	25.15	25.16	25.12	25.14	2954400.0
2013-01-17	BLV	ETF	92.94	93.17	92.78	93.05	46500.0
2013-01-17	BMVP	ETF	17.09	17.17	17.09	17.16	11485.0
2013-01-17	BND	ETF	83.84	83.86	83.74	83.79	1043700.0
2013-01-17	BNO	ETF	41.225	41.445	41.05	41.375	69400.0
2013-01-17	BOIL	ETF	799000.0	852000.0	791400.0	833200.0	22.6

> showing 50 of 965 rows — these rows as CSV

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