PREVIEW / etf_daily / 2013-05-14

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-14.parquet
  size:    41 KB
  rows:    998

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-05-14	SPY	ETF	163.67	165.35	163.67	165.23	119000900.0
2013-05-14	QQQ	ETF	73.13	73.74	73.13	73.52	36017631.0
2013-05-14	IWM	ETF	96.94	98.03	96.93	98.0	33539600.0
2013-05-14	DIA	ETF	150.88	152.17	150.86	152.13	5551900.0
2013-05-14	GLD	ETF	137.95	139.16	137.64	137.81	9895700.0
2013-05-14	TLT	ETF	118.35	118.44	116.54	116.56	9236100.0
2013-05-14	AADR	ETF	34.68	34.9	34.68	34.9	600.0
2013-05-14	AAXJ	ETF	60.57	60.75	60.42	60.63	371100.0
2013-05-14	ACTV	ETF	6.14	6.24	6.0	6.05	368189.0
2013-05-14	ACWI	ETF	53.11	53.45	53.1	53.43	600000.0
2013-05-14	ACWV	ETF	63.57	63.99	63.57	63.86	93400.0
2013-05-14	ACWX	ETF	44.73	44.95	44.6825	44.9	118465.0
2013-05-14	ADRE	ETF	39.29	39.46	39.2101	39.3299	21577.0
2013-05-14	AFK	ETF	30.46	30.54	30.35	30.44	80983.0
2013-05-14	AGEM	ETF	22.98	22.98	22.79	22.79	3002.0
2013-05-14	AGG	ETF	110.38	110.45	110.12	110.12	994500.0
2013-05-14	AGQ	ETF	98.24	101.08	98.08	98.64	293750.0
2013-05-14	AGZ	ETF	113.21	113.2294	113.13	113.16	20993.0
2013-05-14	AIA	ETF	46.82	47.12	46.82	46.99	43170.0
2013-05-14	AIQ	ETF	12.5	12.68	12.15	12.44	13117.0
2013-05-14	AIVI	ETF	44.07	44.38	44.07	44.35	39100.0
2013-05-14	ALTL	ETF	29.7	29.7	29.7	29.7	400.0
2013-05-14	AMJ	ETF	48.09	48.09	47.19	47.41	769965.0
2013-05-14	AMLP	ETF	89.15	89.25	88.75	88.95	664860.0
2013-05-14	ANGL	ETF	27.76	27.98	27.76	27.78	20200.0
2013-05-14	AOA	ETF	41.14	41.4	41.14	41.4	32900.0
2013-05-14	AOK	ETF	31.59	31.66	31.59	31.62	18018.0
2013-05-14	AOM	ETF	33.4	33.48	33.3101	33.47	28841.0
2013-05-14	AOR	ETF	36.55	36.724	36.55	36.71	22289.0
2013-05-14	ARB	ETF	46.77	46.85	46.76	46.85	116763.0
2013-05-14	ARGT	ETF	18.0	18.02	17.94	17.94	3200.0
2013-05-14	ASEA	ETF	18.87	18.96	18.87	18.91	63200.0
2013-05-14	ATMP	ETF	26.56	26.58	26.48	26.55	139700.0
2013-05-14	AVIV	ETF	29.58	30.23	29.5	30.12	524827.0
2013-05-14	AWAY	ETF	29.39	30.757	29.39	30.35	1439891.0
2013-05-14	BAB	ETF	30.57	30.57	30.321	30.36	164466.0
2013-05-14	BAL	ETF	54.0	54.8	53.81	54.67	26506.0
2013-05-14	BALT	ETF	3.55	3.679	3.49	3.58	77676.0
2013-05-14	BBH	ETF	73.7	74.98	73.64	74.97	163000.0
2013-05-14	BCM	ETF	40.556	40.556	40.526	40.526	244.0
2013-05-14	BIB	ETF	25.745	26.445	25.6625	26.41	410560.0
2013-05-14	BICK	ETF	24.21	24.2125	24.2	24.2	1907.0
2013-05-14	BIL	ETF	91.62	91.62	91.6	91.6	441750.0
2013-05-14	BIS	ETF	1400.0	1400.0	1365.64	1365.64	164.5
2013-05-14	BIV	ETF	87.6	87.68	87.23	87.25	337500.0
2013-05-14	BIZD	ETF	20.39	20.71	20.39	20.71	46900.0
2013-05-14	BJK	ETF	43.6	43.81	43.6	43.79	19900.0
2013-05-14	BKF	ETF	39.52	39.809	39.51	39.63	200239.0
2013-05-14	BKLN	ETF	25.29	25.3	25.29	25.3	2019500.0
2013-05-14	BLV	ETF	92.17	92.36	91.28	91.28	43200.0

> showing 50 of 998 rows — these rows as CSV

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