PREVIEW / etf_daily / 2013-06-24

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-24.parquet
  size:    42 KB
  rows:    1,018

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-06-24	SPY	ETF	157.41	158.43	155.73	157.06	222329000.0
2013-06-24	QQQ	ETF	69.84	70.27	69.15	69.73	41492206.0
2013-06-24	IWM	ETF	94.91	95.52	93.83	94.71	58774600.0
2013-06-24	DIA	ETF	146.33	147.43	145.17	146.28	14129300.0
2013-06-24	GLD	ETF	124.31	124.7	123.31	123.93	12749300.0
2013-06-24	TLT	ETF	107.83	109.39	107.76	108.85	24588900.0
2013-06-24	AADR	ETF	31.63	31.66	31.25	31.66	700.0
2013-06-24	AAXJ	ETF	52.25	52.57	51.6	52.16	655600.0
2013-06-24	ACTV	ETF	6.84	6.88	6.55	6.73	282477.0
2013-06-24	ACWI	ETF	49.23	49.61	48.8	49.23	3674100.0
2013-06-24	ACWV	ETF	58.59	59.05	57.93	58.37	228700.0
2013-06-24	ACWX	ETF	40.05	40.38	39.73	40.06	505244.0
2013-06-24	ADRE	ETF	32.67	32.83	32.072	32.46	132958.0
2013-06-24	AFK	ETF	26.99	26.99	26.05	26.05	170037.0
2013-06-24	AGEM	ETF	19.53	19.53	18.9901	19.3466	8275.0
2013-06-24	AGG	ETF	106.01	106.6	105.82	106.18	2270900.0
2013-06-24	AGQ	ETF	69.72	70.24	67.36	68.56	671400.0
2013-06-24	AGZ	ETF	110.61	110.85	109.96	110.005	21662.0
2013-06-24	AIA	ETF	40.59	41.058	40.314	40.76	103781.0
2013-06-24	AIQ	ETF	16.1	16.16	15.74	16.01	43753.0
2013-06-24	AIVI	ETF	39.33	39.48	38.88	39.22	62700.0
2013-06-24	ALTL	ETF	27.45	27.45	27.45	27.45	1000.0
2013-06-24	AMJ	ETF	44.15	44.7299	42.18	43.97	1387301.0
2013-06-24	AMLP	ETF	85.55	86.35	83.75	85.8	1446720.0
2013-06-24	ANGL	ETF	26.12	26.14	25.9	26.01	4900.0
2013-06-24	AOA	ETF	38.95	39.16	38.62	39.05	64000.0
2013-06-24	AOK	ETF	30.35	30.4499	30.21	30.34	78806.0
2013-06-24	AOM	ETF	31.88	31.9999	31.68	31.84	605838.0
2013-06-24	AOR	ETF	34.81	34.9605	34.56	34.78	118677.0
2013-06-24	ARB	ETF	46.78	46.85	46.71	46.82	178253.0
2013-06-24	ARGT	ETF	15.65	15.65	15.41	15.41	700.0
2013-06-24	ASEA	ETF	15.7	15.95	15.6	15.87	96300.0
2013-06-24	ATMP	ETF	24.91	24.91	24.16	24.72	22200.0
2013-06-24	AVIV	ETF	24.65	25.02	24.4	24.64	282495.0
2013-06-24	AWAY	ETF	29.92	30.53	29.8	30.24	767396.0
2013-06-24	BAB	ETF	27.98	28.01	27.34	27.72	1062916.0
2013-06-24	BAL	ETF	53.85	54.11	53.21	53.27	76680.0
2013-06-24	BALT	ETF	3.47	3.47	3.41	3.43	107410.0
2013-06-24	BBH	ETF	65.1	66.66	64.25	65.99	86900.0
2013-06-24	BCM	ETF	38.68	39.109	38.68	38.98	13541.0
2013-06-24	BFOR	ETF	6.075	6.075	5.9775	6.04	351600.0
2013-06-24	BIB	ETF	20.9275	21.6075	20.25	21.2125	314744.0
2013-06-24	BICK	ETF	20.12	20.152	19.86	20.152	1670.0
2013-06-24	BIL	ETF	91.6	91.62	91.6	91.62	384500.0
2013-06-24	BIS	ETF	1675.6	1710.72	1613.2	1637.2	513.0
2013-06-24	BIV	ETF	82.46	82.75	82.21	82.45	659800.0
2013-06-24	BIZD	ETF	19.27	19.27	18.79	19.26	15100.0
2013-06-24	BJK	ETF	38.72	38.72	38.05	38.52	32000.0
2013-06-24	BKF	ETF	33.05	33.47	32.62	33.2	214073.0
2013-06-24	BKLN	ETF	24.66	24.68	24.49	24.65	7732900.0

> showing 50 of 1,018 rows — these rows as CSV

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