PREVIEW / etf_daily / 2013-08-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-05.parquet
  size:    41 KB
  rows:    1,001

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-08-05	SPY	ETF	170.57	170.96	170.35	170.7	54072700.0
2013-08-05	QQQ	ETF	76.89	77.08	76.78	77.02	15462781.0
2013-08-05	IWM	ETF	105.05	105.63	104.9	105.52	14985000.0
2013-08-05	DIA	ETF	155.91	156.01	155.5	155.79	3077100.0
2013-08-05	GLD	ETF	126.51	126.64	125.34	125.7	4003900.0
2013-08-05	TLT	ETF	106.19	106.25	105.54	105.7	6611800.0
2013-08-05	AADR	ETF	34.3	34.33	34.16	34.32	1000.0
2013-08-05	AAXJ	ETF	56.55	56.65	56.18	56.39	271800.0
2013-08-05	ACTV	ETF	10.24	11.6	10.23	11.3	1836904.0
2013-08-05	ACWI	ETF	53.09	53.11	52.92	53.1	1671900.0
2013-08-05	ACWV	ETF	62.3	62.38	62.13	62.25	50400.0
2013-08-05	ACWX	ETF	43.25	43.3	43.1353	43.25	1140537.0
2013-08-05	ADRE	ETF	35.75	35.75	35.51	35.58	17262.0
2013-08-05	AFK	ETF	29.46	29.6199	29.46	29.6	13215.0
2013-08-05	AGEM	ETF	21.66	21.66	21.32	21.39	2844.0
2013-08-05	AGG	ETF	106.93	106.95	106.74	106.9	1166600.0
2013-08-05	AGQ	ETF	68.48	68.8	67.72	68.08	220600.0
2013-08-05	AGZ	ETF	111.1111	111.1111	110.98	111.0001	7349.0
2013-08-05	AIA	ETF	44.37	44.37	44.22	44.31	51354.0
2013-08-05	AIQ	ETF	19.84	20.37	19.84	20.25	180080.0
2013-08-05	AIVI	ETF	42.71	42.86	42.7	42.83	87200.0
2013-08-05	ALTL	ETF	30.27	30.27	30.27	30.27	2050.0
2013-08-05	AMJ	ETF	46.88	47.02	46.46	46.6	225931.0
2013-08-05	AMLP	ETF	89.25	89.35	88.6	89.0	392900.0
2013-08-05	ANGL	ETF	27.5	27.5	27.25	27.25	5300.0
2013-08-05	AOA	ETF	41.77	41.82	41.71	41.82	12200.0
2013-08-05	AOK	ETF	31.27	31.27	31.21	31.23	27084.0
2013-08-05	AOM	ETF	33.19	33.21	33.1201	33.15	26794.0
2013-08-05	AOR	ETF	36.71	36.74	36.63	36.74	14560.0
2013-08-05	ARB	ETF	46.14	46.22	46.01	46.03	312004.0
2013-08-05	ASEA	ETF	17.12	17.12	17.01	17.02	15000.0
2013-08-05	ATMP	ETF	26.56	26.57	26.34	26.54	18100.0
2013-08-05	AVIV	ETF	24.48	24.905	24.48	24.7	82776.0
2013-08-05	AWAY	ETF	29.91	30.55	29.9	30.2	611995.0
2013-08-05	BAB	ETF	27.69	27.81	27.6	27.799	293186.0
2013-08-05	BAL	ETF	54.73	54.9	54.46	54.46	5286.0
2013-08-05	BALT	ETF	3.8	3.9	3.8	3.85	104497.0
2013-08-05	BBH	ETF	80.51	80.67	80.0	80.26	89900.0
2013-08-05	BCM	ETF	39.5701	39.5701	39.5701	39.5701	114.0
2013-08-05	BFOR	ETF	6.7125	6.7275	6.6975	6.7175	140400.0
2013-08-05	BIB	ETF	30.28	30.5	29.98	30.2075	105044.0
2013-08-05	BICK	ETF	21.87	21.87	21.79	21.808	3498.0
2013-08-05	BIL	ETF	91.6	91.6	91.58	91.6	149900.0
2013-08-05	BIS	ETF	1129.2	1144.0	1129.2	1140.0	112.5
2013-08-05	BIV	ETF	83.36	83.36	83.14	83.2	171500.0
2013-08-05	BIZD	ETF	20.56	20.56	20.37	20.42	8700.0
2013-08-05	BJK	ETF	42.79	42.89	42.73	42.84	2600.0
2013-08-05	BKF	ETF	34.97	34.995	34.8	34.86	74816.0
2013-08-05	BKLN	ETF	24.94	24.95	24.9	24.93	3315100.0
2013-08-05	BLV	ETF	83.52	83.52	83.0	83.05	32300.0

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

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