PREVIEW / etf_daily / 2013-10-16

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-16.parquet
  size:    42 KB
  rows:    1,033

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-10-16	SPY	ETF	170.72	172.16	170.64	172.07	161676000.0
2013-10-16	QQQ	ETF	79.83	80.42	79.79	80.38	46735861.0
2013-10-16	IWM	ETF	107.91	108.6	107.64	108.49	34333600.0
2013-10-16	DIA	ETF	152.37	153.56	152.24	153.52	8714800.0
2013-10-16	GLD	ETF	123.52	123.89	122.51	123.54	8523400.0
2013-10-16	TLT	ETF	104.47	105.86	104.27	105.85	14460200.0
2013-10-16	AADR	ETF	35.8	36.15	35.76	36.11	40900.0
2013-10-16	AAXJ	ETF	60.75	61.05	60.6	61.0	345900.0
2013-10-16	ACTV	ETF	14.4	14.4	14.35	14.36	2273908.0
2013-10-16	ACWI	ETF	54.93	55.22	54.86	55.19	1975300.0
2013-10-16	ACWV	ETF	62.41	62.78	62.41	62.64	105200.0
2013-10-16	ACWX	ETF	45.64	45.92	45.64	45.89	118259.0
2013-10-16	ADRE	ETF	38.36	38.61	38.36	38.52	59953.0
2013-10-16	AFK	ETF	30.77	31.12	30.75	31.12	34163.0
2013-10-16	AGG	ETF	106.78	107.28	106.74	107.28	774700.0
2013-10-16	AGQ	ETF	76.88	77.8	75.8	76.76	483825.0
2013-10-16	AGZ	ETF	112.18	112.18	110.691	110.89	32915.0
2013-10-16	AIA	ETF	48.19	48.44	48.19	48.26	62293.0
2013-10-16	AIQ	ETF	28.65	29.5	28.478	29.32	28081.0
2013-10-16	AIVI	ETF	46.36	46.62	46.36	46.54	19500.0
2013-10-16	ALTL	ETF	30.57	30.74	30.5	30.71	76566.0
2013-10-16	AMJ	ETF	44.28	44.5	44.0601	44.28	544306.0
2013-10-16	AMLP	ETF	87.5	87.8	87.3	87.45	723340.0
2013-10-16	ANGL	ETF	26.33	26.72	25.97	26.72	2100.0
2013-10-16	AOA	ETF	42.43	42.67	42.42	42.67	34000.0
2013-10-16	AOK	ETF	31.43	31.58	31.43	31.55	12344.0
2013-10-16	AOM	ETF	33.45	33.6	33.45	33.6	20818.0
2013-10-16	AOR	ETF	37.1	37.29	37.0666	37.29	58599.0
2013-10-16	ARGT	ETF	20.61	20.64	20.38	20.54	10100.0
2013-10-16	ASEA	ETF	17.06	17.14	17.05	17.1	9800.0
2013-10-16	ATMP	ETF	26.07	26.1	25.99	26.06	16100.0
2013-10-16	AVIV	ETF	23.78	24.31	23.74	24.22	113690.0
2013-10-16	AWAY	ETF	28.6	28.79	28.17	28.31	612708.0
2013-10-16	BAB	ETF	27.16	27.45	27.15	27.38	162314.0
2013-10-16	BAL	ETF	53.36	53.36	53.12	53.16	2239.0
2013-10-16	BALT	ETF	5.0	5.22	4.99	5.17	780972.0
2013-10-16	BBH	ETF	79.18	80.95	79.18	80.95	80800.0
2013-10-16	BCM	ETF	40.31	40.31	40.31	40.31	400.0
2013-10-16	BFOR	ETF	6.9375	6.98	6.9325	6.975	463200.0
2013-10-16	BIB	ETF	30.05	31.58	30.05	31.55	256860.0
2013-10-16	BICK	ETF	24.88	24.88	24.88	24.88	1000.0
2013-10-16	BIL	ETF	91.54	91.58	91.54	91.56	945500.0
2013-10-16	BIS	ETF	1072.0	1072.0	1022.0	1022.0	745.0
2013-10-16	BIV	ETF	83.08	83.49	83.06	83.47	148000.0
2013-10-16	BIZD	ETF	20.27	20.27	20.19	20.19	1600.0
2013-10-16	BJK	ETF	50.0	50.04	49.69	49.83	11400.0
2013-10-16	BKF	ETF	39.01	39.204	38.86	39.03	39757.0
2013-10-16	BKLN	ETF	24.65	24.68	24.63	24.64	1711400.0
2013-10-16	BLNG	ETF	36.79	36.79	36.79	36.79	400.0
2013-10-16	BLV	ETF	82.33	83.18	82.31	83.15	39700.0

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

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