PREVIEW / etf_daily / 2013-09-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-05.parquet
  size:    42 KB
  rows:    1,026

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-09-05	SPY	ETF	165.85	166.4	165.73	165.96	63090500.0
2013-09-05	QQQ	ETF	76.75	77.055	76.73	76.84	17815365.0
2013-09-05	IWM	ETF	102.03	102.53	101.85	102.11	22770200.0
2013-09-05	DIA	ETF	149.18	149.71	149.02	149.12	6021300.0
2013-09-05	GLD	ETF	134.13	134.35	131.8	132.2	11118600.0
2013-09-05	TLT	ETF	103.47	103.6	102.53	102.54	12290600.0
2013-09-05	AADR	ETF	33.94	34.0	33.74	33.75	94600.0
2013-09-05	AAXJ	ETF	56.16	56.73	56.16	56.6	235100.0
2013-09-05	ACTV	ETF	9.81	10.0	9.77	9.95	445259.0
2013-09-05	ACWI	ETF	52.03	52.2	51.97	52.15	761000.0
2013-09-05	ACWV	ETF	60.32	60.32	60.1	60.17	42600.0
2013-09-05	ACWX	ETF	42.72	42.96	42.72	42.96	232870.0
2013-09-05	ADRE	ETF	35.48	35.95	35.47	35.9	22579.0
2013-09-05	AFK	ETF	28.9999	28.9999	28.601	28.74	35884.0
2013-09-05	AGEM	ETF	21.31	21.31	21.2	21.29	1048.0
2013-09-05	AGG	ETF	105.34	105.34	104.88	104.89	1058500.0
2013-09-05	AGQ	ETF	94.88	95.24	91.64	93.28	391725.0
2013-09-05	AGZ	ETF	109.92	109.96	109.73	109.73	14647.0
2013-09-05	AIA	ETF	45.73	45.86	45.71	45.83	11564.0
2013-09-05	AIQ	ETF	25.36	26.02	24.85	25.1	55487.0
2013-09-05	AIVI	ETF	42.98	43.2	42.98	43.1	31200.0
2013-09-05	AMJ	ETF	44.43	44.64	44.14	44.29	587757.0
2013-09-05	AMLP	ETF	86.15	86.55	85.95	86.2	340620.0
2013-09-05	ANGL	ETF	26.29	26.29	26.16	26.25	1600.0
2013-09-05	AOA	ETF	40.78	40.9	40.78	40.83	32100.0
2013-09-05	AOK	ETF	30.82	30.82	30.74	30.74	12183.0
2013-09-05	AOM	ETF	32.58	32.62	32.56	32.59	51817.0
2013-09-05	AOR	ETF	35.98	36.04	35.921	35.96	29909.0
2013-09-05	ARB	ETF	47.19	47.26	47.15	47.21	90846.0
2013-09-05	ARGT	ETF	18.83	18.83	18.83	18.83	600.0
2013-09-05	ASEA	ETF	15.31	15.35	15.24	15.35	166000.0
2013-09-05	ATMP	ETF	25.39	25.48	25.39	25.41	48700.0
2013-09-05	AVIV	ETF	22.0	22.2	21.56	21.64	722750.0
2013-09-05	AWAY	ETF	31.94	32.2	31.59	31.8	428233.0
2013-09-05	BAB	ETF	27.0	27.01	26.83	26.97	257174.0
2013-09-05	BAL	ETF	52.83	52.83	52.49	52.66	20459.0
2013-09-05	BALT	ETF	4.83	5.25	4.82	5.22	621798.0
2013-09-05	BBH	ETF	80.8	81.0	80.39	80.8	74200.0
2013-09-05	BCM	ETF	41.2084	41.37	41.2084	41.37	2471.0
2013-09-05	BFOR	ETF	6.5625	6.595	6.5625	6.58	91200.0
2013-09-05	BIB	ETF	30.5625	30.755	30.25	30.4435	252316.0
2013-09-05	BICK	ETF	22.23	22.5127	22.23	22.5127	750.0
2013-09-05	BIL	ETF	91.58	91.6	91.58	91.6	527000.0
2013-09-05	BIS	ETF	1108.4	1113.2	1096.4	1104.0	53.5
2013-09-05	BIV	ETF	81.4	81.53	81.11	81.11	372700.0
2013-09-05	BIZD	ETF	19.96	20.06	19.96	20.05	6200.0
2013-09-05	BJK	ETF	44.18	44.25	44.14	44.2	8200.0
2013-09-05	BKF	ETF	35.17	35.823	35.16	35.74	94044.0
2013-09-05	BKLN	ETF	24.75	24.77	24.72	24.76	4183300.0
2013-09-05	BLV	ETF	81.19	81.19	80.36	80.36	160900.0

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

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