PREVIEW / etf_daily / 2013-01-29

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-29.parquet
  size:    40 KB
  rows:    971

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-29	SPY	ETF	149.77	150.85	149.67	150.66	105694400.0
2013-01-29	QQQ	ETF	67.06	67.31	66.63	67.16	35554610.0
2013-01-29	IWM	ETF	89.96	90.16	89.65	90.05	37055100.0
2013-01-29	DIA	ETF	138.44	139.38	138.44	139.23	3946700.0
2013-01-29	GLD	ETF	161.01	161.31	160.69	160.99	7364900.0
2013-01-29	TLT	ETF	117.62	118.08	116.87	116.95	5553900.0
2013-01-29	AAXJ	ETF	60.41	60.7	60.24	60.56	699700.0
2013-01-29	ACTV	ETF	5.67	5.672	5.495	5.52	400500.0
2013-01-29	ACWI	ETF	50.09	50.24	49.92	50.2	1115500.0
2013-01-29	ACWV	ETF	57.74	58.11	57.69	58.03	48100.0
2013-01-29	ACWX	ETF	43.03	43.36	43.03	43.315	493926.0
2013-01-29	ADRE	ETF	40.87	41.18	40.87	41.12	47965.0
2013-01-29	AFK	ETF	30.85	30.9599	30.8	30.9	15956.0
2013-01-29	AGEM	ETF	23.89	23.96	23.7801	23.9055	7488.0
2013-01-29	AGG	ETF	110.41	110.49	110.26	110.34	837700.0
2013-01-29	AGQ	ETF	183.92	188.0	183.64	186.56	225900.0
2013-01-29	AGZ	ETF	112.9	113.12	112.9	112.93	29471.0
2013-01-29	AIA	ETF	47.12	47.5999	47.12	47.56	10049.0
2013-01-29	AIQ	ETF	6.302	6.42	6.26	6.4	46750.0
2013-01-29	AIVI	ETF	43.23	43.53	43.23	43.5	47000.0
2013-01-29	AMJ	ETF	42.56	43.02	42.49	43.0	1213913.0
2013-01-29	AMLP	ETF	85.3	85.7	85.0	85.65	599880.0
2013-01-29	ANGL	ETF	27.25	27.3	27.13	27.2	30900.0
2013-01-29	AOA	ETF	38.71	38.86	38.68	38.85	36500.0
2013-01-29	AOK	ETF	30.87	30.94	30.8	30.94	60639.0
2013-01-29	AOM	ETF	32.3	32.35	32.2998	32.35	29218.0
2013-01-29	AOR	ETF	34.92	35.0	34.915	35.0	29117.0
2013-01-29	ARB	ETF	46.98	47.05	46.97	47.01	228668.0
2013-01-29	ARGT	ETF	18.22	18.42	18.22	18.42	800.0
2013-01-29	ASEA	ETF	16.97	17.02	16.87	17.01	18000.0
2013-01-29	AWAY	ETF	23.08	23.46	22.72	23.38	336141.0
2013-01-29	BAB	ETF	29.96	30.03	29.87	29.879	261685.0
2013-01-29	BAL	ETF	54.49	54.49	53.5	53.89	52826.0
2013-01-29	BALT	ETF	3.33	3.336	3.25	3.29	25007.0
2013-01-29	BBH	ETF	57.55	57.87	57.1	57.85	42700.0
2013-01-29	BCM	ETF	44.6399	44.6399	44.635	44.635	238.0
2013-01-29	BIB	ETF	16.2	16.428	16.0563	16.39	65780.0
2013-01-29	BICK	ETF	25.71	25.98	25.71	25.94	3602.0
2013-01-29	BIL	ETF	91.62	91.62	91.6	91.6	85300.0
2013-01-29	BIS	ETF	2359.2	2367.2	2326.8	2328.0	571.0
2013-01-29	BIV	ETF	87.49	87.55	87.31	87.34	289300.0
2013-01-29	BJK	ETF	38.15	38.25	38.15	38.17	6800.0
2013-01-29	BKF	ETF	41.83	42.2552	41.83	42.23	101562.0
2013-01-29	BKLN	ETF	25.2	25.22	25.2	25.22	1947500.0
2013-01-29	BLV	ETF	92.03	92.27	91.43	91.43	120500.0
2013-01-29	BMVP	ETF	17.5	17.5547	17.4722	17.5547	5139.0
2013-01-29	BND	ETF	83.47	83.55	83.36	83.39	1082600.0
2013-01-29	BNO	ETF	42.255	42.585	42.17	42.53	63000.0
2013-01-29	BOIL	ETF	724200.0	742400.0	718400.0	726800.0	20.6
2013-01-29	BOND	ETF	109.18	109.22	108.9999	109.046	1039074.0

> showing 50 of 971 rows — these rows as CSV

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