PREVIEW / etf_daily / 2012-10-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-03.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-10-03	SPY	ETF	144.89	145.43	144.13	145.09	121283100.0
2012-10-03	QQQ	ETF	68.88	69.24	68.59	69.11	38235965.0
2012-10-03	IWM	ETF	83.94	84.22	83.17	83.64	38568500.0
2012-10-03	DIA	ETF	134.75	135.11	134.1	134.68	3319800.0
2012-10-03	GLD	ETF	172.51	172.61	171.89	172.41	5647600.0
2012-10-03	TLT	ETF	123.86	124.3	123.62	124.29	3800900.0
2012-10-03	AADR	ETF	29.63	29.63	29.63	29.63	200.0
2012-10-03	AAXJ	ETF	57.06	57.06	56.53	56.79	306200.0
2012-10-03	ACTV	ETF	12.0	12.0486	11.73	11.78	656853.0
2012-10-03	ACWI	ETF	47.12	47.16	46.84	47.04	622000.0
2012-10-03	ACWV	ETF	56.81	57.06	56.81	56.98	14300.0
2012-10-03	ACWX	ETF	39.92	39.92	39.681	39.75	179568.0
2012-10-03	ADRE	ETF	39.5	39.5	39.15	39.18	20490.0
2012-10-03	AFK	ETF	31.21	31.21	31.0	31.02	20038.0
2012-10-03	AGEM	ETF	22.44	22.49	22.35	22.49	800.0
2012-10-03	AGG	ETF	112.18	112.31	112.18	112.25	1187500.0
2012-10-03	AGQ	ETF	236.52	236.72	232.76	234.2	183850.0
2012-10-03	AGZ	ETF	114.01	114.05	113.9201	114.03	9257.0
2012-10-03	AIA	ETF	44.91	45.05	44.71	44.86	11973.0
2012-10-03	AIQ	ETF	6.95	7.05	6.8	7.0	16219.0
2012-10-03	AIVI	ETF	40.55	40.59	40.35	40.41	31300.0
2012-10-03	AMJ	ETF	40.74	41.04	40.7	41.01	532698.0
2012-10-03	AMLP	ETF	83.45	83.85	83.35	83.8	354500.0
2012-10-03	AOA	ETF	36.87	36.9	36.75	36.82	1900.0
2012-10-03	AOK	ETF	30.56	30.582	30.5318	30.5318	7760.0
2012-10-03	AOM	ETF	31.68	31.7183	31.62	31.64	38094.0
2012-10-03	AOR	ETF	33.79	33.9	33.71	33.78	11209.0
2012-10-03	ARB	ETF	37.86	38.01	36.91	37.12	111166.0
2012-10-03	ARGT	ETF	18.14	18.14	17.82	17.92	900.0
2012-10-03	ASEA	ETF	16.72	16.77	16.69	16.71	2200.0
2012-10-03	AWAY	ETF	25.0	25.55	24.9	25.54	1001214.0
2012-10-03	BAB	ETF	30.1	30.15	30.05	30.13	208913.0
2012-10-03	BAL	ETF	47.09	47.5	46.76	47.16	8105.0
2012-10-03	BALT	ETF	3.15	3.15	3.09	3.12	35850.0
2012-10-03	BBH	ETF	55.6	55.86	55.31	55.81	50500.0
2012-10-03	BCM	ETF	45.9	45.9	45.69	45.69	1557.0
2012-10-03	BIB	ETF	16.5025	16.6288	16.415	16.6288	116416.0
2012-10-03	BICK	ETF	23.82	23.899	23.82	23.8825	8492.0
2012-10-03	BIL	ETF	91.62	91.64	91.62	91.62	138500.0
2012-10-03	BIS	ETF	2432.992	2468.144	2424.0	2424.0	15.2
2012-10-03	BIV	ETF	90.27	90.36	90.19	90.36	275100.0
2012-10-03	BJK	ETF	34.25	34.28	34.09	34.11	8300.0
2012-10-03	BKF	ETF	38.21	38.21	37.93	38.0	34029.0
2012-10-03	BKLN	ETF	24.99	25.0	24.96	24.98	783800.0
2012-10-03	BLV	ETF	96.59	96.71	96.29	96.71	28200.0
2012-10-03	BMVP	ETF	16.14	16.2533	16.14	16.1968	10716.0
2012-10-03	BND	ETF	84.97	85.08	84.95	85.01	1630200.0
2012-10-03	BNO	ETF	39.62	39.705	38.895	39.0	180600.0
2012-10-03	BOIL	ETF	1071600.0	1096800.0	1036000.0	1080000.0	17.8
2012-10-03	BOND	ETF	109.08	109.15	109.0	109.1236	426061.0

> showing 50 of 939 rows — these rows as CSV

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