PREVIEW / etf_daily / 2012-06-04

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-04.parquet
  size:    39 KB
  rows:    936

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-06-04	SPY	ETF	128.39	128.74	127.14	128.1	202545800.0
2012-06-04	QQQ	ETF	60.57	60.96	60.04	60.87	74119321.0
2012-06-04	IWM	ETF	74.09	74.35	72.94	73.65	50123200.0
2012-06-04	DIA	ETF	121.09	121.28	120.19	120.78	6369000.0
2012-06-04	GLD	ETF	157.26	157.44	156.16	157.32	11462100.0
2012-06-04	TLT	ETF	129.31	130.18	128.94	129.33	11681200.0
2012-06-04	AAXJ	ETF	49.32	49.59	49.07	49.39	481500.0
2012-06-04	ACTV	ETF	13.82	14.03	13.67	13.9	380584.0
2012-06-04	ACWI	ETF	41.45	41.58	41.06	41.39	1200600.0
2012-06-04	ACWV	ETF	52.35	52.35	51.94	51.94	13000.0
2012-06-04	ACWX	ETF	35.05	35.15	34.76	35.03	535136.0
2012-06-04	ADRE	ETF	35.51	35.77	35.4	35.62	43646.0
2012-06-04	AFK	ETF	27.1	27.28	26.87	27.06	68932.0
2012-06-04	AGEM	ETF	19.59	19.59	19.4701	19.4701	745.0
2012-06-04	AGG	ETF	111.32	111.87	111.32	111.34	1046100.0
2012-06-04	AGQ	ETF	165.16	165.16	160.56	163.76	319700.0
2012-06-04	AGZ	ETF	114.45	114.45	113.36	113.442	6910.0
2012-06-04	AIA	ETF	39.46	39.46	39.036	39.25	20871.0
2012-06-04	AIQ	ETF	4.9285	5.05	4.3005	5.0	30517.0
2012-06-04	AIS	ETF	2.89	2.89	2.711	2.82	1113170.0
2012-06-04	AIVI	ETF	36.25	36.33	35.89	36.13	70200.0
2012-06-04	AMJ	ETF	35.66	35.8	34.98	35.22	2729106.0
2012-06-04	AMLP	ETF	77.2	77.65	75.95	76.4	458220.0
2012-06-04	ANGL	ETF	24.92	24.92	24.92	24.92	500.0
2012-06-04	AOA	ETF	33.38	33.4	33.11	33.33	18700.0
2012-06-04	AOK	ETF	29.43	29.43	29.334	29.41	32142.0
2012-06-04	AOM	ETF	30.03	30.04	29.9464	30.02	17825.0
2012-06-04	AOR	ETF	31.42	31.47	31.26	31.4	29907.0
2012-06-04	ARB	ETF	33.34	34.73	32.7922	34.69	332574.0
2012-06-04	ARGT	ETF	15.48	15.48	15.16	15.16	500.0
2012-06-04	ASEA	ETF	14.48	14.53	14.4	14.49	5800.0
2012-06-04	AWAY	ETF	21.95	22.18	21.17	21.36	326929.0
2012-06-04	BAB	ETF	30.25	30.25	29.96	30.14	370546.0
2012-06-04	BAL	ETF	41.81	42.38	41.49	42.23	15917.0
2012-06-04	BALT	ETF	3.65	3.74	3.28	3.39	196119.0
2012-06-04	BBH	ETF	44.13	44.31	43.77	44.2	13500.0
2012-06-04	BCM	ETF	40.17	40.384	40.03	40.3833	42212.0
2012-06-04	BIB	ETF	11.1512	11.3675	10.9388	11.26	58544.0
2012-06-04	BICK	ETF	21.26	21.28	21.15	21.195	7824.0
2012-06-04	BIL	ETF	91.66	91.66	91.64	91.66	518200.0
2012-06-04	BIS	ETF	3811.2	3860.8	3715.2	3769.6	115.5
2012-06-04	BIV	ETF	88.83	88.97	88.73	88.78	381400.0
2012-06-04	BJK	ETF	30.42	30.5	29.91	30.15	49300.0
2012-06-04	BKF	ETF	34.23	34.41	34.05	34.22	121339.0
2012-06-04	BKLN	ETF	23.91	24.06	23.73	23.8	310800.0
2012-06-04	BLV	ETF	95.98	96.37	95.59	96.14	126800.0
2012-06-04	BMVP	ETF	14.09	14.11	13.89	14.02	15254.0
2012-06-04	BND	ETF	84.44	84.5	84.35	84.41	1700800.0
2012-06-04	BNO	ETF	34.535	35.375	34.355	34.98	47800.0
2012-06-04	BOIL	ETF	730200.0	752400.0	715400.0	752200.0	5.4

> showing 50 of 936 rows — these rows as CSV

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