PREVIEW / etf_daily / 2012-09-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-17.parquet
  size:    39 KB
  rows:    953

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
2012-09-17	SPY	ETF	146.94	147.19	146.37	146.74	119427800.0
2012-09-17	QQQ	ETF	70.2	70.24	69.96	70.21	31798335.0
2012-09-17	IWM	ETF	85.98	86.22	85.57	86.0	30183000.0
2012-09-17	DIA	ETF	135.57	135.88	135.24	135.53	2606500.0
2012-09-17	GLD	ETF	171.77	171.96	170.06	170.4	11281600.0
2012-09-17	TLT	ETF	118.87	119.9	118.8	119.72	5573300.0
2012-09-17	AAXJ	ETF	56.73	56.77	56.32	56.46	348600.0
2012-09-17	ACTV	ETF	12.37	12.37	12.04	12.13	318299.0
2012-09-17	ACWI	ETF	47.86	48.07	47.75	47.84	518400.0
2012-09-17	ACWV	ETF	56.36	56.5	56.25	56.26	13100.0
2012-09-17	ACWX	ETF	40.88	40.9	40.58	40.68	127184.0
2012-09-17	ADRE	ETF	40.43	40.53	40.19	40.24	65274.0
2012-09-17	AFK	ETF	31.95	31.95	31.6601	31.71	19388.0
2012-09-17	AGEM	ETF	22.77	22.91	22.77	22.91	260.0
2012-09-17	AGG	ETF	111.51	111.62	111.43	111.55	1063800.0
2012-09-17	AGQ	ETF	234.48	236.04	224.8	227.6	494275.0
2012-09-17	AGZ	ETF	113.52	113.6666	113.36	113.54	7912.0
2012-09-17	AIA	ETF	44.98	44.98	44.7	44.73	25904.0
2012-09-17	AIQ	ETF	7.1	7.15	6.9	7.0	13017.0
2012-09-17	AIVI	ETF	42.19	42.2	41.85	41.94	15600.0
2012-09-17	ALTL	ETF	26.23	26.24	26.183	26.183	8444.0
2012-09-17	AMJ	ETF	40.5	40.5	40.31	40.4	542097.0
2012-09-17	AMLP	ETF	82.9	83.0	82.7	82.8	308260.0
2012-09-17	ANGL	ETF	26.75	26.75	26.63	26.64	1700.0
2012-09-17	AOA	ETF	37.53	37.55	37.35	37.43	12700.0
2012-09-17	AOK	ETF	30.68	30.74	30.61	30.67	22560.0
2012-09-17	AOM	ETF	31.96	31.97	31.88	31.91	16287.0
2012-09-17	AOR	ETF	34.26	34.26	34.12	34.16	8787.0
2012-09-17	ARB	ETF	38.29	38.29	37.93	38.11	94304.0
2012-09-17	ARGT	ETF	18.34	18.34	18.34	18.34	50.0
2012-09-17	ASEA	ETF	16.99	16.99	16.86	16.86	3100.0
2012-09-17	AWAY	ETF	24.5	24.6099	23.98	24.25	321423.0
2012-09-17	BAB	ETF	29.37	29.57	29.36	29.53	420427.0
2012-09-17	BAL	ETF	50.03	50.67	49.65	49.66	20436.0
2012-09-17	BALT	ETF	3.42	3.43	3.36	3.39	14319.0
2012-09-17	BBH	ETF	53.54	53.77	52.94	53.72	216100.0
2012-09-17	BCM	ETF	46.8	46.81	46.7983	46.802	1794.0
2012-09-17	BIB	ETF	15.75	15.8737	15.575	15.8613	54400.0
2012-09-17	BICK	ETF	24.25	24.25	24.1	24.1	23823.0
2012-09-17	BIL	ETF	91.62	91.64	91.62	91.62	141700.0
2012-09-17	BIS	ETF	2654.4	2654.4	2558.4	2558.4	40.5
2012-09-17	BIV	ETF	89.18	89.4	89.18	89.3	264200.0
2012-09-17	BJK	ETF	34.39	34.58	34.27	34.34	1400.0
2012-09-17	BKF	ETF	38.68	38.69	38.37	38.45	283664.0
2012-09-17	BKLN	ETF	25.0	25.04	24.96	25.01	472600.0
2012-09-17	BLNG	ETF	58.8	58.8	53.52	53.52	1040.0
2012-09-17	BLV	ETF	93.46	94.23	93.46	93.93	166100.0
2012-09-17	BMVP	ETF	16.36	16.36	16.28	16.31	22889.0
2012-09-17	BND	ETF	84.34	84.49	84.34	84.4	852900.0
2012-09-17	BNO	ETF	42.0	42.125	40.385	40.92	384800.0

> showing 50 of 953 rows — these rows as CSV

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