PREVIEW / etf_daily / 2012-09-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-10.parquet
  size:    38 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-09-10	SPY	ETF	144.19	144.44	143.46	143.51	86458500.0
2012-09-10	QQQ	ETF	69.26	69.4	68.49	68.54	25489971.0
2012-09-10	IWM	ETF	84.18	84.45	83.79	83.88	30671300.0
2012-09-10	DIA	ETF	132.77	133.16	132.42	132.48	2296800.0
2012-09-10	GLD	ETF	167.84	168.14	167.23	167.29	7760600.0
2012-09-10	TLT	ETF	123.69	124.33	123.51	124.33	4912100.0
2012-09-10	AAXJ	ETF	54.07	54.22	53.8	53.81	126900.0
2012-09-10	ACTV	ETF	12.24	12.27	12.02	12.19	210957.0
2012-09-10	ACWI	ETF	46.69	46.77	46.38	46.4	2111300.0
2012-09-10	ACWV	ETF	56.26	56.37	55.81	55.81	110400.0
2012-09-10	ACWX	ETF	39.11	39.24	38.91	38.93	235898.0
2012-09-10	ADRE	ETF	38.59	38.83	38.44	38.44	20573.0
2012-09-10	AFK	ETF	31.03	31.03	30.72	30.8	24396.0
2012-09-10	AGEM	ETF	21.93	21.9529	21.82	21.82	1500.0
2012-09-10	AGG	ETF	111.9	111.93	111.77	111.91	1303000.0
2012-09-10	AGQ	ETF	221.96	226.0	218.08	219.08	452625.0
2012-09-10	AGZ	ETF	113.75	113.88	113.7	113.79	29217.0
2012-09-10	AIA	ETF	42.54	42.75	42.3902	42.42	12905.0
2012-09-10	AIQ	ETF	6.6	7.0	6.6	7.0	47887.0
2012-09-10	AIVI	ETF	40.6	40.76	40.4	40.4	19100.0
2012-09-10	ALTL	ETF	25.78	25.78	25.683	25.683	3486.0
2012-09-10	AMJ	ETF	39.76	39.77	39.55	39.55	390073.0
2012-09-10	AMLP	ETF	81.8	82.0	81.6	81.6	380200.0
2012-09-10	ANGL	ETF	26.47	26.5	26.22	26.22	1400.0
2012-09-10	AOA	ETF	36.79	36.82	36.64	36.64	4500.0
2012-09-10	AOK	ETF	30.42	30.46	30.3972	30.3972	13941.0
2012-09-10	AOM	ETF	31.57	31.6399	31.56	31.56	21190.0
2012-09-10	AOR	ETF	33.77	33.78	33.69	33.69	7751.0
2012-09-10	ARB	ETF	38.3	38.91	38.12	38.24	106716.0
2012-09-10	ARGT	ETF	17.2	17.2	17.2	17.2	150.0
2012-09-10	ASEA	ETF	16.43	16.43	16.31	16.31	1200.0
2012-09-10	AWAY	ETF	23.0	23.185	22.64	22.88	214050.0
2012-09-10	BAB	ETF	30.07	30.23	30.07	30.22	192259.0
2012-09-10	BAL	ETF	50.15	50.4676	49.78	49.99	8624.0
2012-09-10	BALT	ETF	3.27	3.49	3.2699	3.38	211795.0
2012-09-10	BBH	ETF	53.0	53.0	52.48	52.49	12000.0
2012-09-10	BCM	ETF	46.74	46.74	46.617	46.617	1460.0
2012-09-10	BIB	ETF	15.385	15.385	15.0087	15.0702	33304.0
2012-09-10	BICK	ETF	22.93	22.9892	22.69	22.7	38155.0
2012-09-10	BIL	ETF	91.62	91.64	91.62	91.62	430700.0
2012-09-10	BIS	ETF	2624.0	2683.2	2624.0	2664.0	180.5
2012-09-10	BIV	ETF	89.58	89.65	89.5	89.65	186100.0
2012-09-10	BJK	ETF	33.02	33.03	32.85	32.85	5100.0
2012-09-10	BKF	ETF	36.88	36.99	36.56	36.58	262979.0
2012-09-10	BKLN	ETF	24.91	24.93	24.91	24.92	911300.0
2012-09-10	BLNG	ETF	52.35	52.35	52.35	52.35	700.0
2012-09-10	BLV	ETF	95.65	95.93	95.42	95.86	89600.0
2012-09-10	BMVP	ETF	16.1467	16.17	16.0987	16.0987	1736.0
2012-09-10	BND	ETF	84.74	84.77	84.65	84.76	990500.0
2012-09-10	BNO	ETF	41.125	41.35	41.06	41.27	55400.0

> showing 50 of 939 rows — these rows as CSV

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