PREVIEW / etf_daily / 2012-10-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-18.parquet
  size:    39 KB
  rows:    938

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-10-18	SPY	ETF	145.82	146.52	145.33	145.82	148108500.0
2012-10-18	QQQ	ETF	67.87	68.08	67.04	67.29	61706323.0
2012-10-18	IWM	ETF	83.94	84.15	83.45	83.54	31431700.0
2012-10-18	DIA	ETF	135.26	135.77	135.0	135.36	6305000.0
2012-10-18	GLD	ETF	168.8	169.31	168.59	168.79	6607100.0
2012-10-18	TLT	ETF	121.12	121.53	119.87	120.11	8558600.0
2012-10-18	AAXJ	ETF	57.29	57.5	57.04	57.23	243900.0
2012-10-18	ACTV	ETF	9.94	10.21	9.9	10.16	655857.0
2012-10-18	ACWI	ETF	47.76	48.0	47.6	47.75	1105500.0
2012-10-18	ACWV	ETF	57.31	57.47	57.01	57.13	15600.0
2012-10-18	ACWX	ETF	40.54	40.64	40.3501	40.44	136769.0
2012-10-18	ADRE	ETF	39.59	39.88	39.53	39.74	37831.0
2012-10-18	AFK	ETF	31.77	31.89	31.7	31.7699	22994.0
2012-10-18	AGEM	ETF	22.93	22.96	22.76	22.83	2445.0
2012-10-18	AGG	ETF	111.93	111.93	111.71	111.81	1249500.0
2012-10-18	AGQ	ETF	210.28	213.52	208.16	209.12	182300.0
2012-10-18	AGZ	ETF	113.75	113.75	113.56	113.73	39891.0
2012-10-18	AIA	ETF	45.1	45.57	45.1	45.25	4879.0
2012-10-18	AIQ	ETF	6.9	6.995	6.85	6.85	3420.0
2012-10-18	AIVI	ETF	41.23	41.48	41.13	41.19	20900.0
2012-10-18	AMJ	ETF	41.15	41.45	41.1	41.15	442249.0
2012-10-18	AMLP	ETF	84.25	84.4	83.9	83.95	322660.0
2012-10-18	ANGL	ETF	26.93	27.0	26.93	27.0	400.0
2012-10-18	AOA	ETF	37.19	37.23	37.1	37.18	3600.0
2012-10-18	AOK	ETF	30.62	30.6255	30.5671	30.6	9064.0
2012-10-18	AOM	ETF	31.79	31.81	31.74	31.78	42205.0
2012-10-18	AOR	ETF	33.99	34.0875	33.9401	33.959	38685.0
2012-10-18	ARB	ETF	37.72	37.94	37.45	37.47	73369.0
2012-10-18	ARGT	ETF	18.04	18.06	17.9	17.9	950.0
2012-10-18	ASEA	ETF	16.96	17.03	16.94	16.99	14600.0
2012-10-18	AWAY	ETF	26.17	26.17	25.75	25.991	225821.0
2012-10-18	BAB	ETF	29.63	29.74	29.61	29.62	195944.0
2012-10-18	BAL	ETF	50.73	51.35	49.4	51.21	22640.0
2012-10-18	BALT	ETF	3.34	3.46	3.34	3.39	97708.0
2012-10-18	BBH	ETF	55.71	55.71	54.86	54.9	22000.0
2012-10-18	BCM	ETF	45.77	45.77	45.7699	45.7699	228.0
2012-10-18	BIB	ETF	16.5	16.5025	16.0625	16.1	61712.0
2012-10-18	BICK	ETF	24.24	24.24	24.1	24.1	7933.0
2012-10-18	BIL	ETF	91.62	91.64	91.62	91.62	97000.0
2012-10-18	BIS	ETF	2480.4	2486.4	2471.36	2471.36	48.5
2012-10-18	BIV	ETF	89.98	90.03	89.78	89.82	153500.0
2012-10-18	BJK	ETF	34.88	34.88	34.6	34.6	400.0
2012-10-18	BKF	ETF	38.96	39.39	38.9	39.2	542711.0
2012-10-18	BKLN	ETF	24.95	24.96	24.94	24.95	2542600.0
2012-10-18	BLV	ETF	95.82	96.01	95.25	95.38	55300.0
2012-10-18	BMVP	ETF	16.23	16.25	16.19	16.21	2707.0
2012-10-18	BND	ETF	84.65	84.65	84.48	84.55	1367200.0
2012-10-18	BNO	ETF	40.715	41.07	40.635	40.855	60800.0
2012-10-18	BOIL	ETF	1118000.0	1180000.0	1092400.0	1173000.0	15.0
2012-10-18	BOND	ETF	109.07	109.16	109.0	109.05	290575.0

> showing 50 of 938 rows — these rows as CSV

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