PREVIEW / etf_daily / 2013-08-19

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-19.parquet
  size:    41 KB
  rows:    1,023

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-19	SPY	ETF	165.64	166.21	164.76	164.77	96437600.0
2013-08-19	QQQ	ETF	75.5	76.13	75.33	75.35	29586813.0
2013-08-19	IWM	ETF	101.64	101.88	100.59	100.65	25184600.0
2013-08-19	DIA	ETF	150.3	150.72	149.66	149.74	4174100.0
2013-08-19	GLD	ETF	132.33	132.5	131.59	132.01	8118400.0
2013-08-19	TLT	ETF	102.93	103.01	102.21	102.47	9022000.0
2013-08-19	AADR	ETF	33.97	33.97	33.87	33.87	2100.0
2013-08-19	AAXJ	ETF	55.91	55.95	55.36	55.4	244700.0
2013-08-19	ACTV	ETF	9.57	9.6	9.07	9.11	745668.0
2013-08-19	ACWI	ETF	52.37	52.4	51.99	52.0	1441200.0
2013-08-19	ACWV	ETF	60.62	61.08	60.5	60.5	86300.0
2013-08-19	ACWX	ETF	43.2	43.33	42.9902	43.02	272063.0
2013-08-19	ADRE	ETF	35.4	35.426	35.069	35.12	18979.0
2013-08-19	AFK	ETF	29.43	29.43	28.951	29.07	61494.0
2013-08-19	AGEM	ETF	20.9972	20.9972	20.9972	20.9972	100.0
2013-08-19	AGG	ETF	105.79	105.79	105.47	105.5	734000.0
2013-08-19	AGQ	ETF	94.0	94.4	92.08	93.52	307400.0
2013-08-19	AGZ	ETF	110.2	110.72	110.2	110.33	12415.0
2013-08-19	AIA	ETF	44.55	44.58	44.24	44.25	8692.0
2013-08-19	AIQ	ETF	22.05	22.2575	21.79	21.99	103603.0
2013-08-19	AIVI	ETF	43.29	43.42	43.09	43.12	50100.0
2013-08-19	ALTL	ETF	29.37	29.37	29.15	29.22	2348.0
2013-08-19	AMJ	ETF	45.4	45.5	44.91	45.06	459116.0
2013-08-19	AMLP	ETF	87.0	87.0	86.2	86.2	713200.0
2013-08-19	ANGL	ETF	26.3	26.3	26.2	26.2	1500.0
2013-08-19	AOA	ETF	40.99	41.0	40.76	40.76	8800.0
2013-08-19	AOK	ETF	30.88	30.9154	30.8001	30.819	28135.0
2013-08-19	AOM	ETF	32.67	32.676	32.55	32.58	6285.0
2013-08-19	AOR	ETF	36.0799	36.0799	35.8964	35.93	46165.0
2013-08-19	ARB	ETF	45.45	46.2108	45.11	46.15	664929.0
2013-08-19	ARGT	ETF	19.01	19.01	18.81	18.87	3600.0
2013-08-19	ASEA	ETF	16.46	16.46	16.18	16.18	27500.0
2013-08-19	ATMP	ETF	25.97	26.0	25.79	25.79	16300.0
2013-08-19	AVIV	ETF	23.11	23.3	22.6	22.66	161728.0
2013-08-19	AWAY	ETF	29.49	29.82	29.09	29.16	658512.0
2013-08-19	BAB	ETF	26.97	27.1	26.941	26.99	366644.0
2013-08-19	BAL	ETF	59.98	60.06	59.586	59.64	8451.0
2013-08-19	BALT	ETF	4.37	4.47	4.18	4.31	227153.0
2013-08-19	BBH	ETF	74.8	75.6	74.65	74.66	98500.0
2013-08-19	BCM	ETF	41.2128	41.2128	41.2128	41.2128	300.0
2013-08-19	BFOR	ETF	6.5	6.525	6.47	6.4775	562400.0
2013-08-19	BIB	ETF	26.32	26.8325	26.1275	26.1275	157428.0
2013-08-19	BICK	ETF	21.85	21.86	21.71	21.712	992.0
2013-08-19	BIL	ETF	91.6	91.6	91.58	91.58	233600.0
2013-08-19	BIS	ETF	1275.596	1288.0	1273.6	1288.0	90.0
2013-08-19	BIV	ETF	82.04	82.11	81.85	81.88	352300.0
2013-08-19	BIZD	ETF	19.87	19.87	19.54	19.56	10700.0
2013-08-19	BJK	ETF	43.01	43.13	42.76	42.76	1400.0
2013-08-19	BKF	ETF	34.95	35.01	34.6101	34.62	61163.0
2013-08-19	BKLN	ETF	24.76	24.76	24.51	24.53	5667100.0

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

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