PREVIEW / etf_daily / 2012-10-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-24.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-10-24	SPY	ETF	141.93	142.1	140.8	141.02	120179400.0
2012-10-24	QQQ	ETF	65.76	65.87	65.06	65.164	39872375.0
2012-10-24	IWM	ETF	81.7	81.85	80.91	81.2	24472200.0
2012-10-24	DIA	ETF	131.0	131.25	130.34	130.5	6097300.0
2012-10-24	GLD	ETF	165.78	165.83	164.6	164.86	10794600.0
2012-10-24	TLT	ETF	121.86	122.29	121.48	121.48	6824500.0
2012-10-24	AADR	ETF	29.71	29.71	29.71	29.71	200.0
2012-10-24	AAXJ	ETF	56.68	56.68	56.2	56.33	521200.0
2012-10-24	ACTV	ETF	9.55	9.61	9.13	9.19	481089.0
2012-10-24	ACWI	ETF	46.84	46.99	46.39	46.45	1079500.0
2012-10-24	ACWV	ETF	56.24	56.24	56.05	56.08	5600.0
2012-10-24	ACWX	ETF	39.73	39.76	39.439	39.46	62015.0
2012-10-24	ADRE	ETF	39.03	39.2	38.96	38.96	17108.0
2012-10-24	AFK	ETF	31.47	31.49	31.33	31.4064	8406.0
2012-10-24	AGEM	ETF	22.64	22.64	22.64	22.64	1600.0
2012-10-24	AGG	ETF	111.95	112.06	111.9	111.97	604900.0
2012-10-24	AGQ	ETF	197.92	198.48	193.48	195.72	252950.0
2012-10-24	AGZ	ETF	113.6	113.61	113.53	113.59	30366.0
2012-10-24	AIA	ETF	44.93	44.93	44.44	44.48	34339.0
2012-10-24	AIQ	ETF	6.95	7.0	6.8	6.8	4057.0
2012-10-24	AIVI	ETF	40.27	40.29	40.04	40.09	17400.0
2012-10-24	ALTL	ETF	25.34	25.34	25.34	25.34	727.0
2012-10-24	AMJ	ETF	40.83	41.12	40.65	40.84	786269.0
2012-10-24	AMLP	ETF	83.4	83.9	83.35	83.4	280460.0
2012-10-24	AOA	ETF	36.45	36.45	36.23	36.24	21300.0
2012-10-24	AOK	ETF	30.38	30.4	30.34	30.34	14075.0
2012-10-24	AOM	ETF	31.48	31.49	31.35	31.35	24114.0
2012-10-24	AOR	ETF	33.48	33.48	33.37	33.37	16225.0
2012-10-24	ARB	ETF	37.26	37.26	35.73	36.35	87050.0
2012-10-24	ARGT	ETF	17.12	17.12	17.12	17.12	100.0
2012-10-24	ASEA	ETF	16.69	16.77	16.66	16.66	6900.0
2012-10-24	AWAY	ETF	25.7	25.89	24.7	25.79	321406.0
2012-10-24	BAB	ETF	30.17	30.17	29.84	29.91	268112.0
2012-10-24	BAL	ETF	48.5035	48.5035	47.64	47.73	7477.0
2012-10-24	BALT	ETF	3.47	3.55	3.43	3.52	55229.0
2012-10-24	BBH	ETF	52.61	52.93	52.28	52.34	18600.0
2012-10-24	BCM	ETF	44.3001	44.51	44.3001	44.5083	1870.0
2012-10-24	BIB	ETF	14.595	14.785	13.955	14.4125	37828.0
2012-10-24	BICK	ETF	23.67	23.68	23.5	23.558	1244.0
2012-10-24	BIL	ETF	91.62	91.64	91.62	91.64	183450.0
2012-10-24	BIS	ETF	2730.0	2730.0	2715.2	2715.2	22.75
2012-10-24	BIV	ETF	89.9	90.01	89.86	89.93	163300.0
2012-10-24	BJK	ETF	34.17	34.17	34.11	34.11	700.0
2012-10-24	BKF	ETF	38.6	38.71	38.32	38.33	71584.0
2012-10-24	BKLN	ETF	24.87	24.89	24.86	24.87	1294100.0
2012-10-24	BLV	ETF	95.86	96.14	95.82	95.82	183300.0
2012-10-24	BMVP	ETF	15.8	15.853	15.73	15.73	5298.0
2012-10-24	BND	ETF	84.69	84.75	84.68	84.71	648000.0
2012-10-24	BNO	ETF	39.425	39.635	38.695	39.17	97600.0
2012-10-24	BOIL	ETF	1136800.0	1138000.0	1086200.0	1097400.0	10.0

> showing 50 of 945 rows — these rows as CSV

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