PREVIEW / etf_daily / 2012-10-02

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-02.parquet
  size:    39 KB
  rows:    942

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-02	SPY	ETF	144.92	145.15	143.83	144.5	113422200.0
2012-10-02	QQQ	ETF	68.79	68.98	68.13	68.67	33254267.0
2012-10-02	IWM	ETF	84.15	84.24	83.37	83.88	25792500.0
2012-10-02	DIA	ETF	135.11	135.38	133.94	134.48	6269100.0
2012-10-02	GLD	ETF	172.47	172.7	171.59	172.1	7053900.0
2012-10-02	TLT	ETF	123.91	124.52	123.81	124.25	3540100.0
2012-10-02	AADR	ETF	30.05	30.05	29.71	29.71	200.0
2012-10-02	AAXJ	ETF	56.96	57.12	56.56	56.79	244800.0
2012-10-02	ACTV	ETF	12.14	12.18	11.9	11.95	715505.0
2012-10-02	ACWI	ETF	47.23	47.32	46.87	47.06	395400.0
2012-10-02	ACWV	ETF	57.19	57.19	56.65	56.71	4500.0
2012-10-02	ACWX	ETF	40.1	40.16	39.8	39.94	440646.0
2012-10-02	ADRE	ETF	39.63	39.65	39.3601	39.5	26101.0
2012-10-02	AFK	ETF	31.13	31.3432	31.06	31.16	21683.0
2012-10-02	AGEM	ETF	22.65	22.65	22.65	22.65	600.0
2012-10-02	AGG	ETF	112.16	112.29	112.11	112.29	903300.0
2012-10-02	AGQ	ETF	236.96	237.8	231.24	234.32	293825.0
2012-10-02	AGZ	ETF	114.0	114.04	113.8	113.81	14521.0
2012-10-02	AIA	ETF	45.11	45.11	44.6998	44.88	22095.0
2012-10-02	AIQ	ETF	6.85	7.15	6.75	6.75	12187.0
2012-10-02	AIVI	ETF	40.83	40.83	40.47	40.56	39400.0
2012-10-02	AMJ	ETF	40.88	40.92	40.7356	40.85	263353.0
2012-10-02	AMLP	ETF	83.65	83.75	83.4	83.4	238360.0
2012-10-02	ANGL	ETF	26.43	26.49	26.43	26.49	700.0
2012-10-02	AOA	ETF	36.9	36.9	36.69	36.78	6400.0
2012-10-02	AOK	ETF	30.582	30.582	30.488	30.52	21533.0
2012-10-02	AOM	ETF	31.64	31.669	31.606	31.66	10544.0
2012-10-02	AOR	ETF	33.84	33.876	33.7283	33.7483	24052.0
2012-10-02	ARB	ETF	38.24	38.24	37.59	37.79	95507.0
2012-10-02	ARGT	ETF	18.06	18.06	18.06	18.06	300.0
2012-10-02	ASEA	ETF	16.8	16.8	16.7	16.71	4900.0
2012-10-02	AWAY	ETF	23.89	24.94	23.3658	24.9	520192.0
2012-10-02	BAB	ETF	30.07	30.14	30.07	30.13	304722.0
2012-10-02	BAL	ETF	46.8	47.41	46.56	47.41	31644.0
2012-10-02	BALT	ETF	3.16	3.19	3.1	3.14	17652.0
2012-10-02	BBH	ETF	54.85	55.45	54.85	55.45	106500.0
2012-10-02	BIB	ETF	16.3388	16.4037	16.245	16.3313	59496.0
2012-10-02	BICK	ETF	23.97	24.0	23.8	23.869	18314.0
2012-10-02	BIL	ETF	91.62	91.64	91.62	91.64	92950.0
2012-10-02	BIS	ETF	2489.6	2489.6	2457.6	2457.6	46.55
2012-10-02	BIV	ETF	90.15	90.28	90.09	90.23	189200.0
2012-10-02	BJK	ETF	34.42	34.42	34.17	34.28	2900.0
2012-10-02	BKF	ETF	38.33	38.37	38.016	38.15	52808.0
2012-10-02	BKLN	ETF	24.97	25.0	24.94	24.97	536200.0
2012-10-02	BLNG	ETF	53.73	53.73	53.73	53.73	1600.0
2012-10-02	BLV	ETF	96.43	96.75	96.43	96.6	20900.0
2012-10-02	BMVP	ETF	16.12	16.17	16.11	16.17	2630.0
2012-10-02	BND	ETF	84.99	85.05	84.97	85.04	771000.0
2012-10-02	BNO	ETF	40.47	40.565	40.215	40.215	44200.0
2012-10-02	BOIL	ETF	1094200.0	1157000.0	1078400.0	1143800.0	15.8

> showing 50 of 942 rows — these rows as CSV

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