PREVIEW / etf_daily / 2013-02-19

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-19.parquet
  size:    40 KB
  rows:    979

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-02-19	SPY	ETF	152.37	153.28	152.16	153.25	95105400.0
2013-02-19	QQQ	ETF	67.89	68.26	67.86	68.24	23433248.0
2013-02-19	IWM	ETF	91.88	92.56	91.87	92.55	21162300.0
2013-02-19	DIA	ETF	139.56	140.16	139.52	139.97	3944000.0
2013-02-19	GLD	ETF	155.8	155.84	154.93	155.33	11803900.0
2013-02-19	TLT	ETF	116.86	116.9	115.84	115.92	7383600.0
2013-02-19	AADR	ETF	33.47	33.47	33.4	33.4	3100.0
2013-02-19	AAXJ	ETF	60.66	60.8	60.52	60.69	529700.0
2013-02-19	ACTV	ETF	5.4	5.41	5.07	5.3	976830.0
2013-02-19	ACWI	ETF	50.34	50.51	50.27	50.47	1050700.0
2013-02-19	ACWV	ETF	58.67	59.0	58.67	58.94	47600.0
2013-02-19	ACWX	ETF	43.11	43.26	43.04	43.24	173846.0
2013-02-19	ADRE	ETF	40.2	40.36	40.18	40.25	48132.0
2013-02-19	AFK	ETF	31.42	31.42	31.0401	31.2199	24037.0
2013-02-19	AGEM	ETF	23.4599	23.46	23.3325	23.3325	3130.0
2013-02-19	AGG	ETF	110.26	110.29	110.07	110.12	1391300.0
2013-02-19	AGQ	ETF	168.6	168.72	161.48	163.48	480825.0
2013-02-19	AGZ	ETF	113.0	113.07	112.96	112.96	8760.0
2013-02-19	AIA	ETF	47.67	47.82	47.61	47.67	72501.0
2013-02-19	AIQ	ETF	6.96	7.2	6.75	7.17	4152.0
2013-02-19	AIVI	ETF	42.55	42.72	42.49	42.68	54500.0
2013-02-19	AMJ	ETF	45.69	45.69	43.44	44.14	1633212.0
2013-02-19	AMLP	ETF	85.65	86.4	85.65	86.4	577620.0
2013-02-19	ANGL	ETF	26.95	26.95	26.73	26.76	3500.0
2013-02-19	AOA	ETF	39.32	39.32	39.11	39.23	25400.0
2013-02-19	AOK	ETF	30.94	30.999	30.94	30.97	24602.0
2013-02-19	AOM	ETF	32.45	32.5	32.42	32.5	25936.0
2013-02-19	AOR	ETF	35.17	35.26	35.17	35.26	13861.0
2013-02-19	ARB	ETF	46.87	47.08	46.81	47.04	1463232.0
2013-02-19	ARGT	ETF	17.6	17.6	17.6	17.6	50.0
2013-02-19	ASEA	ETF	17.2	17.22	17.14	17.19	33500.0
2013-02-19	AWAY	ETF	24.97	25.2	24.75	25.07	1481993.0
2013-02-19	BAB	ETF	30.03	30.18	30.0	30.04	434342.0
2013-02-19	BAL	ETF	54.51	54.822	54.3572	54.4999	169098.0
2013-02-19	BALT	ETF	3.39	3.55	3.39	3.55	176346.0
2013-02-19	BBH	ETF	58.05	58.26	57.84	58.22	25800.0
2013-02-19	BCM	ETF	44.3299	44.3299	44.3299	44.3299	22124.0
2013-02-19	BIB	ETF	16.22	16.3792	16.125	16.345	50296.0
2013-02-19	BICK	ETF	25.38	25.399	25.286	25.326	6100.0
2013-02-19	BIL	ETF	91.62	91.62	91.6	91.6	89200.0
2013-02-19	BIS	ETF	2341.6	2341.6	2320.0	2320.0	41.25
2013-02-19	BIV	ETF	87.42	87.45	87.14	87.15	553500.0
2013-02-19	BIZD	ETF	20.4	20.54	20.4	20.52	39700.0
2013-02-19	BJK	ETF	38.76	38.76	38.49	38.57	7600.0
2013-02-19	BKF	ETF	41.05	41.1699	40.9947	41.05	181027.0
2013-02-19	BKLN	ETF	24.97	24.99	24.96	24.99	3456000.0
2013-02-19	BLNG	ETF	48.47	48.47	47.59	47.59	500.0
2013-02-19	BLV	ETF	91.08	91.3	90.87	90.88	267400.0
2013-02-19	BMVP	ETF	17.9033	18.042	17.6934	18.0315	7709.0
2013-02-19	BND	ETF	83.3	83.32	83.19	83.22	1055800.0

> showing 50 of 979 rows — these rows as CSV

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