PREVIEW / etf_daily / 2013-01-23

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-23.parquet
  size:    40 KB
  rows:    967

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-23	SPY	ETF	149.13	149.5	148.86	149.37	104596100.0
2013-01-23	QQQ	ETF	67.56	67.79	67.46	67.59	31977406.0
2013-01-23	IWM	ETF	89.24	89.29	88.91	89.0	32818900.0
2013-01-23	DIA	ETF	137.19	137.63	137.14	137.46	6397800.0
2013-01-23	GLD	ETF	163.92	163.95	163.0	163.21	6697000.0
2013-01-23	TLT	ETF	120.34	120.58	119.95	120.09	2848800.0
2013-01-23	AADR	ETF	32.74	32.74	32.74	32.74	100.0
2013-01-23	AAXJ	ETF	60.75	60.89	60.65	60.84	697500.0
2013-01-23	ACTV	ETF	5.46	5.54	5.37	5.47	724239.0
2013-01-23	ACWI	ETF	49.61	49.69	49.5	49.65	663600.0
2013-01-23	ACWV	ETF	57.58	57.67	57.38	57.52	27400.0
2013-01-23	ACWX	ETF	42.84	42.84	42.65	42.79	250443.0
2013-01-23	ADRE	ETF	41.2	41.31	41.15	41.19	66460.0
2013-01-23	AFK	ETF	30.96	30.965	30.86	30.9	19059.0
2013-01-23	AGEM	ETF	23.74	23.8047	23.687	23.687	724.0
2013-01-23	AGG	ETF	110.96	111.01	110.5	110.99	1393800.0
2013-01-23	AGQ	ETF	199.32	200.56	196.04	197.88	360650.0
2013-01-23	AGZ	ETF	113.41	113.51	113.32	113.35	15937.0
2013-01-23	AIA	ETF	48.09	48.12	47.93	48.08	28746.0
2013-01-23	AIQ	ETF	6.57	6.63	6.505	6.59	14770.0
2013-01-23	AIVI	ETF	42.72	42.83	42.67	42.8	37800.0
2013-01-23	ALTL	ETF	27.52	27.52	27.52	27.52	748.0
2013-01-23	AMJ	ETF	42.5	42.6698	42.14	42.25	2660520.0
2013-01-23	AMLP	ETF	85.5	85.5	84.8	85.0	566960.0
2013-01-23	ANGL	ETF	27.35	27.35	27.26	27.34	1900.0
2013-01-23	AOA	ETF	38.5	38.53	38.42	38.51	27000.0
2013-01-23	AOK	ETF	30.92	30.93	30.881	30.92	28127.0
2013-01-23	AOM	ETF	32.26	32.28	32.21	32.28	36201.0
2013-01-23	AOR	ETF	34.91	34.91	34.755	34.83	37658.0
2013-01-23	ARB	ETF	47.02	47.05	46.9	46.9	721034.0
2013-01-23	ARGT	ETF	18.42	18.56	18.34	18.48	1250.0
2013-01-23	ASEA	ETF	17.0	17.0	16.86	16.91	47800.0
2013-01-23	AWAY	ETF	22.7	23.33	22.28	23.24	385197.0
2013-01-23	BAB	ETF	30.31	30.34	30.2699	30.3	271284.0
2013-01-23	BAL	ETF	52.15	52.69	51.61	52.65	21774.0
2013-01-23	BALT	ETF	3.41	3.54	3.385	3.5	96066.0
2013-01-23	BBH	ETF	57.15	57.3	56.63	56.63	153800.0
2013-01-23	BCM	ETF	44.6999	44.7	44.6999	44.7	600.0
2013-01-23	BIB	ETF	16.3275	16.4125	16.018	16.0203	43696.0
2013-01-23	BICK	ETF	25.83	25.88	25.79	25.86	1822.0
2013-01-23	BIL	ETF	91.6	91.62	91.6	91.6	150250.0
2013-01-23	BIS	ETF	2342.8	2366.4	2342.8	2353.6	47.4
2013-01-23	BIV	ETF	88.21	88.22	88.1	88.12	235700.0
2013-01-23	BJK	ETF	38.4	38.4	38.09	38.1	190100.0
2013-01-23	BKF	ETF	41.97	42.01	41.8	41.97	230539.0
2013-01-23	BKLN	ETF	25.18	25.18	25.14	25.17	1337100.0
2013-01-23	BLNG	ETF	50.692	50.692	50.692	50.692	500.0
2013-01-23	BLV	ETF	93.6	93.8	93.42	93.51	155800.0
2013-01-23	BMVP	ETF	17.3367	17.38	17.2633	17.3534	7794.0
2013-01-23	BND	ETF	83.91	83.98	83.91	83.97	1278200.0

> showing 50 of 967 rows — these rows as CSV

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