PREVIEW / etf_daily / 2013-02-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-20.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-02-20	SPY	ETF	153.14	153.19	151.26	151.34	160574800.0
2013-02-20	QQQ	ETF	68.24	68.25	67.18	67.19	38200238.0
2013-02-20	IWM	ETF	92.63	92.68	90.74	90.83	41753800.0
2013-02-20	DIA	ETF	140.0	140.28	138.88	138.88	5974200.0
2013-02-20	GLD	ETF	153.9	153.93	150.84	151.44	30924000.0
2013-02-20	TLT	ETF	115.69	116.37	115.57	116.27	9603900.0
2013-02-20	AADR	ETF	33.59	33.59	33.21	33.21	1400.0
2013-02-20	AAXJ	ETF	61.05	61.05	60.38	60.41	1659200.0
2013-02-20	ACTV	ETF	5.29	5.38	4.99	4.99	949140.0
2013-02-20	ACWI	ETF	50.54	50.56	49.93	49.94	441700.0
2013-02-20	ACWV	ETF	59.13	59.16	58.79	58.79	41800.0
2013-02-20	ACWX	ETF	43.31	43.39	42.77	42.78	430154.0
2013-02-20	ADRE	ETF	40.3	40.3	39.6	39.6	39856.0
2013-02-20	AFK	ETF	31.39	31.39	30.8678	30.92	19106.0
2013-02-20	AGEM	ETF	23.4125	23.4799	23.06	23.06	2500.0
2013-02-20	AGG	ETF	110.09	110.25	110.03	110.19	2028900.0
2013-02-20	AGQ	ETF	158.68	159.04	151.16	153.76	773625.0
2013-02-20	AGZ	ETF	113.15	113.15	112.821	113.0299	18676.0
2013-02-20	AIA	ETF	48.0	48.07	47.544	47.639	21410.0
2013-02-20	AIQ	ETF	6.99	7.25	6.96	6.96	16756.0
2013-02-20	AIVI	ETF	42.68	42.68	42.08	42.09	21200.0
2013-02-20	AMJ	ETF	44.35	44.35	43.74	43.79	1613100.0
2013-02-20	AMLP	ETF	86.6	86.7	85.8	85.95	594080.0
2013-02-20	ANGL	ETF	26.81	26.81	26.81	26.81	1000.0
2013-02-20	AOA	ETF	39.25	39.31	38.83	38.85	22300.0
2013-02-20	AOK	ETF	30.97	31.0099	30.87	30.87	19591.0
2013-02-20	AOM	ETF	32.51	32.51	32.3298	32.33	38036.0
2013-02-20	AOR	ETF	35.23	35.26	34.99	35.0	10386.0
2013-02-20	ARB	ETF	47.03	47.105	46.9	46.9	152367.0
2013-02-20	ARGT	ETF	17.6	17.6	17.28	17.28	5350.0
2013-02-20	ASEA	ETF	17.25	17.25	17.04	17.08	15200.0
2013-02-20	AWAY	ETF	25.0	25.73	24.91	25.04	2019629.0
2013-02-20	BAB	ETF	30.01	30.1	30.01	30.06	154421.0
2013-02-20	BAL	ETF	54.98	55.06	54.39	54.62	23567.0
2013-02-20	BALT	ETF	3.52	3.54	3.41	3.46	64021.0
2013-02-20	BBH	ETF	58.11	58.52	57.72	57.76	32500.0
2013-02-20	BCM	ETF	43.94	43.95	43.71	43.7747	2022.0
2013-02-20	BIB	ETF	16.365	16.5175	16.0305	16.0305	41348.0
2013-02-20	BICK	ETF	25.39	25.39	25.12	25.12	8521.0
2013-02-20	BIL	ETF	91.62	91.62	91.6	91.62	110450.0
2013-02-20	BIS	ETF	2306.4	2349.92	2298.8	2349.92	14.25
2013-02-20	BIV	ETF	87.15	87.33	87.14	87.33	204200.0
2013-02-20	BIZD	ETF	20.48	20.48	20.3	20.3	13500.0
2013-02-20	BJK	ETF	38.31	38.32	37.77	37.77	5800.0
2013-02-20	BKF	ETF	41.02	41.06	40.361	40.39	130298.0
2013-02-20	BKLN	ETF	24.99	24.99	24.96	24.96	1726500.0
2013-02-20	BLV	ETF	90.65	91.06	90.52	91.06	98600.0
2013-02-20	BMVP	ETF	18.0601	18.0601	17.6933	17.6933	3927.0
2013-02-20	BND	ETF	83.17	83.32	83.17	83.28	944600.0
2013-02-20	BNO	ETF	43.875	43.89	43.04	43.215	269800.0

> showing 50 of 971 rows — these rows as CSV

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