PREVIEW / etf_daily / 2013-07-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-15.parquet
  size:    41 KB
  rows:    1,007

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-07-15	SPY	ETF	167.97	168.39	167.68	168.15	69450600.0
2013-07-15	QQQ	ETF	75.36	75.52	75.17	75.47	19790966.0
2013-07-15	IWM	ETF	102.95	103.68	102.84	103.58	30786600.0
2013-07-15	DIA	ETF	154.56	154.87	154.33	154.64	2751600.0
2013-07-15	GLD	ETF	124.08	124.39	123.84	124.18	4133200.0
2013-07-15	TLT	ETF	107.8	108.32	107.7	108.29	4574800.0
2013-07-15	AADR	ETF	34.09	34.09	34.03	34.03	200.0
2013-07-15	AAXJ	ETF	56.07	56.45	56.07	56.3	425800.0
2013-07-15	ACTV	ETF	8.52	8.85	8.51	8.77	604058.0
2013-07-15	ACWI	ETF	52.19	52.32	52.13	52.27	1651200.0
2013-07-15	ACWV	ETF	62.08	62.12	61.92	62.09	42700.0
2013-07-15	ACWX	ETF	42.48	42.63	42.38	42.61	859175.0
2013-07-15	ADRE	ETF	34.62	35.11	34.62	35.05	76280.0
2013-07-15	AFK	ETF	28.59	28.6804	28.44	28.66	44617.0
2013-07-15	AGEM	ETF	20.95	21.2	20.95	21.2	1477.0
2013-07-15	AGG	ETF	106.92	107.04	106.83	107.04	757500.0
2013-07-15	AGQ	ETF	69.44	70.6	69.4	70.36	232300.0
2013-07-15	AGZ	ETF	110.82	110.98	110.81	110.92	27065.0
2013-07-15	AIA	ETF	43.78	43.91	43.7	43.86	10307.0
2013-07-15	AIQ	ETF	16.88	16.9	16.71	16.82	37045.0
2013-07-15	AIVI	ETF	41.48	41.57	41.36	41.53	25700.0
2013-07-15	ALTL	ETF	29.71	29.74	29.71	29.74	2090.0
2013-07-15	AMJ	ETF	48.4	48.76	48.05	48.56	1229761.0
2013-07-15	AMLP	ETF	91.1	91.4	90.7	91.4	441000.0
2013-07-15	ANGL	ETF	26.42	26.64	26.42	26.64	1200.0
2013-07-15	AOA	ETF	41.05	41.19	41.03	41.18	21100.0
2013-07-15	AOK	ETF	31.1	31.12	31.05	31.1	42675.0
2013-07-15	AOM	ETF	32.88	32.94	32.86	32.9	52384.0
2013-07-15	AOR	ETF	36.25	36.34	36.24	36.33	86301.0
2013-07-15	ARB	ETF	46.37	46.49	46.37	46.45	182376.0
2013-07-15	ARGT	ETF	16.71	16.79	16.65	16.74	4400.0
2013-07-15	ASEA	ETF	17.18	17.28	17.18	17.23	8000.0
2013-07-15	ATMP	ETF	26.72	27.01	26.72	26.92	27100.0
2013-07-15	AVIV	ETF	25.98	26.172	25.76	25.95	113169.0
2013-07-15	AWAY	ETF	30.83	31.6725	30.43	31.65	945136.0
2013-07-15	BAB	ETF	27.9	28.04	27.88	28.0	193004.0
2013-07-15	BAL	ETF	54.47	54.56	54.29	54.41	16996.0
2013-07-15	BALT	ETF	3.72	3.78	3.69	3.76	174187.0
2013-07-15	BBH	ETF	77.88	77.88	76.64	77.21	210500.0
2013-07-15	BCM	ETF	39.8034	39.8034	39.78	39.78	1411.0
2013-07-15	BFOR	ETF	6.5675	6.5675	6.5225	6.545	210000.0
2013-07-15	BIB	ETF	28.305	28.305	27.5575	28.05	288528.0
2013-07-15	BICK	ETF	21.41	21.6	21.41	21.6	5170.0
2013-07-15	BIL	ETF	91.58	91.6	91.58	91.58	298700.0
2013-07-15	BIS	ETF	1236.4	1248.084	1220.44	1225.6	84.0
2013-07-15	BIV	ETF	83.34	83.51	83.34	83.47	794600.0
2013-07-15	BIZD	ETF	20.35	20.4	20.29	20.4	10200.0
2013-07-15	BJK	ETF	41.1	41.51	41.08	41.41	6200.0
2013-07-15	BKF	ETF	34.43	34.96	34.43	34.91	75444.0
2013-07-15	BKLN	ETF	24.83	24.85	24.82	24.85	2940400.0

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

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