PREVIEW / etf_daily / 2012-06-01

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-01.parquet
  size:    39 KB
  rows:    939

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-01	SPY	ETF	129.41	131.5	128.16	128.16	253240900.0
2012-06-01	QQQ	ETF	60.97	61.32	60.39	60.409	71430752.0
2012-06-01	IWM	ETF	74.4	75.01	73.71	73.82	76127100.0
2012-06-01	DIA	ETF	122.13	122.42	120.91	121.01	11815100.0
2012-06-01	GLD	ETF	155.41	158.31	154.87	157.5	27399400.0
2012-06-01	TLT	ETF	128.87	130.38	128.53	130.36	23526000.0
2012-06-01	AAXJ	ETF	49.74	50.01	49.42	49.46	407500.0
2012-06-01	ACTV	ETF	13.83	13.93	13.7	13.8	306094.0
2012-06-01	ACWI	ETF	41.63	41.74	41.26	41.27	940500.0
2012-06-01	ACWV	ETF	52.4	52.53	51.81	51.83	14700.0
2012-06-01	ACWX	ETF	35.08	35.221	34.78	34.8	187644.0
2012-06-01	ADRE	ETF	35.67	35.97	35.49	35.52	82490.0
2012-06-01	AFK	ETF	27.01	27.49	27.0	27.12	76098.0
2012-06-01	AGEM	ETF	19.58	19.6802	19.49	19.5165	5648.0
2012-06-01	AGG	ETF	111.5	111.67	111.41	111.6	1851600.0
2012-06-01	AGQ	ETF	163.84	168.52	162.4	165.72	600775.0
2012-06-01	AGZ	ETF	114.45	114.45	113.288	113.84	17270.0
2012-06-01	AIA	ETF	39.47	39.67	39.28	39.3023	74746.0
2012-06-01	AIQ	ETF	5.0	5.25	4.85	4.85	23199.0
2012-06-01	AIS	ETF	2.7	2.78	2.6	2.76	1260505.0
2012-06-01	AIVI	ETF	36.07	36.27	35.72	35.73	452100.0
2012-06-01	AMJ	ETF	36.14	36.25	35.53	35.69	2209419.0
2012-06-01	AMLP	ETF	78.0	78.4	77.25	77.3	440100.0
2012-06-01	ANGL	ETF	25.0	25.15	24.94	25.15	11800.0
2012-06-01	AOA	ETF	33.55	33.61	33.31	33.34	10800.0
2012-06-01	AOK	ETF	29.517	29.517	29.44	29.44	15323.0
2012-06-01	AOM	ETF	30.1	30.1692	30.02	30.02	44364.0
2012-06-01	AOR	ETF	31.57	31.64	31.401	31.423	13487.0
2012-06-01	ARB	ETF	32.34	33.25	32.34	33.21	246918.0
2012-06-01	ARGT	ETF	15.14	15.48	15.14	15.46	500.0
2012-06-01	ASEA	ETF	14.51	14.6	14.4	14.45	8500.0
2012-06-01	AWAY	ETF	23.31	23.31	21.45	21.91	796667.0
2012-06-01	BAB	ETF	30.2	30.37	30.04	30.25	232910.0
2012-06-01	BAL	ETF	44.28	44.28	42.2	42.4	10098.0
2012-06-01	BALT	ETF	3.6	3.73	3.59	3.64	101309.0
2012-06-01	BBH	ETF	44.79	44.79	44.03	44.13	17600.0
2012-06-01	BCM	ETF	40.19	40.3444	40.168	40.168	12922.0
2012-06-01	BIB	ETF	11.5	11.5675	11.0962	11.1625	94384.0
2012-06-01	BICK	ETF	21.44	21.5048	21.36	21.386	7195.0
2012-06-01	BIL	ETF	91.66	91.66	91.64	91.66	290650.0
2012-06-01	BIS	ETF	3584.0	3798.4	3584.0	3782.4	309.5
2012-06-01	BIV	ETF	89.05	89.24	88.85	89.17	357100.0
2012-06-01	BJK	ETF	30.84	30.84	30.37	30.41	19400.0
2012-06-01	BKF	ETF	34.23	34.48	34.09	34.17	152209.0
2012-06-01	BKLN	ETF	23.99	24.2	23.6	23.75	783600.0
2012-06-01	BLV	ETF	95.94	96.98	95.78	96.73	227700.0
2012-06-01	BMVP	ETF	14.2367	14.2367	14.0767	14.1366	21471.0
2012-06-01	BND	ETF	84.6	84.67	84.47	84.62	1657000.0
2012-06-01	BNO	ETF	35.165	35.25	34.46	34.83	120600.0
2012-06-01	BOIL	ETF	716200.0	717800.0	682200.0	690600.0	6.8

> showing 50 of 939 rows — these rows as CSV

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