PREVIEW / etf_daily / 2013-08-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-20.parquet
  size:    42 KB
  rows:    1,017

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-08-20	SPY	ETF	165.04	166.2	164.86	165.58	89294400.0
2013-08-20	QQQ	ETF	75.49	76.03	75.43	75.68	18842747.0
2013-08-20	IWM	ETF	100.77	102.33	100.71	102.1	32450400.0
2013-08-20	DIA	ETF	149.91	150.41	149.56	149.75	3845900.0
2013-08-20	GLD	ETF	132.03	133.13	132.02	132.45	7809100.0
2013-08-20	TLT	ETF	102.89	103.36	102.85	103.26	10050100.0
2013-08-20	AAXJ	ETF	54.85	55.15	54.78	54.91	362100.0
2013-08-20	ACTV	ETF	9.08	9.45	8.88	9.41	282921.0
2013-08-20	ACWI	ETF	51.95	52.24	51.85	52.06	819700.0
2013-08-20	ACWV	ETF	60.39	60.96	60.39	60.86	140000.0
2013-08-20	ACWX	ETF	42.89	43.07	42.76	42.93	350842.0
2013-08-20	ADRE	ETF	35.0	35.28	34.89	35.0	11644.0
2013-08-20	AFK	ETF	29.3	29.44	28.98	29.29	55500.0
2013-08-20	AGEM	ETF	21.0741	21.0741	21.0741	21.0741	285.0
2013-08-20	AGG	ETF	105.75	105.84	105.7	105.81	984600.0
2013-08-20	AGQ	ETF	92.44	94.84	92.2	92.32	410025.0
2013-08-20	AGZ	ETF	110.4	110.63	110.4	110.45	11689.0
2013-08-20	AIA	ETF	43.85	44.05	43.75	43.9	43441.0
2013-08-20	AIQ	ETF	22.0	22.79	21.85	22.69	75115.0
2013-08-20	AIVI	ETF	43.0	43.25	43.0	43.06	30100.0
2013-08-20	ALTL	ETF	29.2	29.2	29.2	29.2	400.0
2013-08-20	AMJ	ETF	44.92	45.79	44.71	45.79	1615398.0
2013-08-20	AMLP	ETF	86.35	87.25	86.2	86.95	682160.0
2013-08-20	ANGL	ETF	26.24	26.34	26.2	26.33	1200.0
2013-08-20	AOA	ETF	40.72	41.0	40.71	40.95	9100.0
2013-08-20	AOK	ETF	30.81	30.93	30.81	30.92	47366.0
2013-08-20	AOM	ETF	32.58	32.73	32.58	32.7	14853.0
2013-08-20	AOR	ETF	35.95	36.09	35.95	36.04	8044.0
2013-08-20	ARB	ETF	46.03	46.56	46.03	46.49	456174.0
2013-08-20	ARGT	ETF	18.88	19.09	18.45	19.0	12200.0
2013-08-20	ASEA	ETF	16.01	16.08	15.96	16.0	28300.0
2013-08-20	ATMP	ETF	25.91	26.15	25.9	26.13	12400.0
2013-08-20	AVIV	ETF	22.7	23.94	22.7	23.18	141235.0
2013-08-20	AWAY	ETF	29.18	29.26	27.7	28.35	2248387.0
2013-08-20	BAB	ETF	27.05	27.15	27.0	27.11	233318.0
2013-08-20	BAL	ETF	59.08	59.08	56.551	56.57	62083.0
2013-08-20	BALT	ETF	4.33	4.45	4.3	4.39	127587.0
2013-08-20	BBH	ETF	74.63	76.09	74.63	75.71	55300.0
2013-08-20	BCM	ETF	41.11	41.132	41.11	41.132	3269.0
2013-08-20	BFOR	ETF	6.48	6.56	6.48	6.54	635600.0
2013-08-20	BIB	ETF	26.11	27.1725	26.11	26.865	77232.0
2013-08-20	BICK	ETF	21.57	21.615	21.54	21.59	3113.0
2013-08-20	BIL	ETF	91.6	91.6	91.58	91.6	207650.0
2013-08-20	BIS	ETF	1292.0	1296.0	1255.2	1262.4	192.0
2013-08-20	BIV	ETF	82.15	82.3	82.15	82.26	264000.0
2013-08-20	BIZD	ETF	19.54	19.94	19.54	19.87	92500.0
2013-08-20	BJK	ETF	42.5	42.86	42.48	42.75	6000.0
2013-08-20	BKF	ETF	34.42	34.71	34.412	34.5	61445.0
2013-08-20	BKLN	ETF	24.61	24.7	24.57	24.69	3840100.0
2013-08-20	BLNG	ETF	39.61	39.61	39.61	39.61	151.0

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

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