PREVIEW / etf_daily / 2013-06-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-25.parquet
  size:    41 KB
  rows:    1,005

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
2013-06-25	SPY	ETF	158.48	160.1	157.42	158.57	162262200.0
2013-06-25	QQQ	ETF	70.41	70.52	69.81	70.24	28897389.0
2013-06-25	IWM	ETF	95.59	95.84	94.87	95.62	32418400.0
2013-06-25	DIA	ETF	147.41	147.8	146.62	147.3	7592300.0
2013-06-25	GLD	ETF	123.65	123.9	122.88	123.47	9369200.0
2013-06-25	TLT	ETF	108.9	109.02	107.86	107.88	11078000.0
2013-06-25	AADR	ETF	32.24	32.24	32.06	32.11	2700.0
2013-06-25	AAXJ	ETF	52.96	53.33	52.71	53.27	468300.0
2013-06-25	ACTV	ETF	6.82	6.82	6.57	6.78	335290.0
2013-06-25	ACWI	ETF	49.79	49.94	49.34	49.82	1302700.0
2013-06-25	ACWV	ETF	59.22	59.49	59.01	59.44	37100.0
2013-06-25	ACWX	ETF	40.46	40.67	40.17	40.59	318015.0
2013-06-25	ADRE	ETF	32.99	33.151	32.7	33.12	66106.0
2013-06-25	AFK	ETF	26.26	26.5	26.05	26.3899	36264.0
2013-06-25	AGEM	ETF	19.61	19.8	19.53	19.7986	3741.0
2013-06-25	AGG	ETF	106.47	106.6	106.21	106.3	1687400.0
2013-06-25	AGQ	ETF	68.8	69.56	67.96	68.28	345775.0
2013-06-25	AGZ	ETF	110.42	110.7	110.3	110.3201	23987.0
2013-06-25	AIA	ETF	40.98	41.17	40.77	41.14	187365.0
2013-06-25	AIQ	ETF	16.0	16.16	15.79	15.95	29212.0
2013-06-25	AIVI	ETF	39.5	39.72	39.32	39.64	50200.0
2013-06-25	AMJ	ETF	44.52	44.98	43.96	44.65	1525637.0
2013-06-25	AMLP	ETF	86.75	87.05	85.95	86.95	699080.0
2013-06-25	ANGL	ETF	25.78	26.3	25.78	26.09	6400.0
2013-06-25	AOA	ETF	39.29	39.42	39.05	39.36	18900.0
2013-06-25	AOK	ETF	30.45	30.484	30.41	30.484	18711.0
2013-06-25	AOM	ETF	32.01	32.09	31.991	32.09	15904.0
2013-06-25	AOR	ETF	35.07	35.119	34.8641	35.05	29158.0
2013-06-25	ARB	ETF	46.88	46.88	46.82	46.87	77380.0
2013-06-25	ARGT	ETF	15.79	15.83	15.59	15.83	1000.0
2013-06-25	ASEA	ETF	16.23	16.32	16.08	16.3	36500.0
2013-06-25	ATMP	ETF	24.95	25.13	24.95	25.13	60800.0
2013-06-25	AVIV	ETF	24.94	25.2	24.021	24.36	517015.0
2013-06-25	AWAY	ETF	30.57	32.2099	30.24	31.96	1639660.0
2013-06-25	BAB	ETF	27.68	27.95	27.62	27.83	915872.0
2013-06-25	BAL	ETF	53.293	54.44	53.19	54.36	101441.0
2013-06-25	BALT	ETF	3.46	3.49	3.41	3.43	54470.0
2013-06-25	BBH	ETF	66.48	67.03	65.96	66.45	39100.0
2013-06-25	BCM	ETF	38.99	39.04	38.932	38.949	15880.0
2013-06-25	BFOR	ETF	6.15	6.15	6.0475	6.1	224400.0
2013-06-25	BIB	ETF	21.555	21.75	21.04	21.34	75920.0
2013-06-25	BICK	ETF	20.37	20.45	20.27	20.45	10584.0
2013-06-25	BIL	ETF	91.6	91.62	91.6	91.62	3208500.0
2013-06-25	BIS	ETF	1602.24	1640.0	1602.24	1632.0	40.0
2013-06-25	BIV	ETF	82.98	83.0	82.61	82.67	445800.0
2013-06-25	BIZD	ETF	19.23	19.28	19.16	19.25	2600.0
2013-06-25	BJK	ETF	39.18	39.3	39.03	39.29	18500.0
2013-06-25	BKF	ETF	33.56	33.75	33.241	33.71	73136.0
2013-06-25	BKLN	ETF	24.58	24.69	24.52	24.64	3866200.0
2013-06-25	BLV	ETF	83.04	83.5	82.75	83.05	74400.0

> showing 50 of 1,005 rows — these rows as CSV

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