PREVIEW / etf_daily / 2012-09-25

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-25.parquet
  size:    39 KB
  rows:    945

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-25	SPY	ETF	145.96	146.24	144.06	144.1	133165200.0
2012-09-25	QQQ	ETF	69.92	70.08	68.73	68.76	41308853.0
2012-09-25	IWM	ETF	85.43	85.51	83.58	83.67	74752200.0
2012-09-25	DIA	ETF	135.53	135.9	134.28	134.34	6292300.0
2012-09-25	GLD	ETF	171.76	172.11	170.5	170.77	10365300.0
2012-09-25	TLT	ETF	122.8	123.74	122.13	123.71	5893500.0
2012-09-25	AADR	ETF	30.35	30.35	29.54	29.54	600.0
2012-09-25	AAXJ	ETF	56.26	56.51	55.59	55.59	202500.0
2012-09-25	ACTV	ETF	12.63	12.74	12.19	12.25	467945.0
2012-09-25	ACWI	ETF	47.5	47.66	46.97	46.99	426600.0
2012-09-25	ACWV	ETF	56.94	56.94	56.23	56.25	54100.0
2012-09-25	ACWX	ETF	40.46	40.54	39.91	39.92	83556.0
2012-09-25	ADRE	ETF	39.6	39.64	38.96	39.0	29494.0
2012-09-25	AFK	ETF	31.61	31.64	31.12	31.135	13270.0
2012-09-25	AGEM	ETF	22.52	22.52	22.52	22.52	106.0
2012-09-25	AGG	ETF	112.12	112.25	112.01	112.25	836400.0
2012-09-25	AGQ	ETF	229.8	231.44	222.08	222.8	388125.0
2012-09-25	AGZ	ETF	113.83	113.92	113.74	113.84	17632.0
2012-09-25	AIA	ETF	44.7	44.88	44.11	44.12	44821.0
2012-09-25	AIQ	ETF	6.95	7.0	6.7	6.85	5257.0
2012-09-25	AIVI	ETF	41.29	41.55	40.91	40.94	52400.0
2012-09-25	ALTL	ETF	26.13	26.13	26.11	26.11	6400.0
2012-09-25	AMJ	ETF	40.45	40.59	40.16	40.16	464955.0
2012-09-25	AMLP	ETF	82.95	83.0	82.35	82.4	311420.0
2012-09-25	ANGL	ETF	26.39	26.44	26.39	26.42	1200.0
2012-09-25	AOA	ETF	37.28	37.36	36.89	36.89	9500.0
2012-09-25	AOK	ETF	30.7	30.7	30.59	30.59	6501.0
2012-09-25	AOM	ETF	31.91	31.91	31.7156	31.76	19054.0
2012-09-25	AOR	ETF	34.16	34.17	33.932	33.932	11760.0
2012-09-25	ARB	ETF	38.24	38.37	37.82	37.91	224468.0
2012-09-25	ARGT	ETF	18.14	18.14	18.1	18.1	300.0
2012-09-25	ASEA	ETF	16.76	16.76	16.57	16.58	6800.0
2012-09-25	AWAY	ETF	24.9	24.9	23.94	23.98	530371.0
2012-09-25	BAB	ETF	30.07	30.14	29.9691	30.1	216859.0
2012-09-25	BAL	ETF	47.93	48.44	47.633	47.633	7886.0
2012-09-25	BALT	ETF	3.38	3.4	3.21	3.28	41783.0
2012-09-25	BBH	ETF	54.32	54.88	54.0	54.0	25800.0
2012-09-25	BCM	ETF	46.22	46.35	46.049	46.049	995.0
2012-09-25	BIB	ETF	16.0938	16.3025	15.7125	15.7125	60024.0
2012-09-25	BICK	ETF	23.9	23.948	23.611	23.611	6264.0
2012-09-25	BIL	ETF	91.62	91.64	91.62	91.62	276650.0
2012-09-25	BIS	ETF	2537.6	2555.6	2521.6	2544.0	26.7
2012-09-25	BIV	ETF	89.92	90.05	89.78	90.04	232100.0
2012-09-25	BJK	ETF	34.13	34.13	33.59	33.59	4000.0
2012-09-25	BKF	ETF	38.34	38.34	37.58	37.6	61770.0
2012-09-25	BKLN	ETF	25.02	25.04	25.0	25.01	1406600.0
2012-09-25	BLV	ETF	95.87	96.22	95.5	96.21	28900.0
2012-09-25	BMVP	ETF	16.26	16.279	16.053	16.053	11494.0
2012-09-25	BND	ETF	84.86	84.99	84.8	84.98	1235500.0
2012-09-25	BNO	ETF	39.975	40.205	39.68	39.765	121400.0

> showing 50 of 945 rows — these rows as CSV

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