PREVIEW / etf_daily / 2013-10-08

all etf daily files

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

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-08	SPY	ETF	167.4	167.62	165.36	165.48	178015000.0
2013-10-08	QQQ	ETF	78.76	78.81	77.19	77.22	43660689.0
2013-10-08	IWM	ETF	105.84	106.03	103.92	104.06	61365000.0
2013-10-08	DIA	ETF	149.0	149.14	147.5	147.53	10388000.0
2013-10-08	GLD	ETF	127.79	128.45	127.21	127.4	6999700.0
2013-10-08	TLT	ETF	105.98	106.51	105.83	106.17	5904000.0
2013-10-08	AADR	ETF	35.4	35.48	35.01	35.08	39100.0
2013-10-08	AAXJ	ETF	59.89	59.91	59.14	59.17	333500.0
2013-10-08	ACTV	ETF	14.37	14.38	14.36	14.36	1820257.0
2013-10-08	ACWI	ETF	53.83	53.88	53.23	53.25	981100.0
2013-10-08	ACWV	ETF	61.6	61.6	61.06	61.09	65900.0
2013-10-08	ACWX	ETF	44.74	44.84	44.36	44.37	146324.0
2013-10-08	ADRE	ETF	37.59	37.59	36.95	36.95	11306.0
2013-10-08	AFK	ETF	30.31	30.31	29.91	30.0901	7565.0
2013-10-08	AGG	ETF	107.07	107.15	106.97	106.99	407000.0
2013-10-08	AGQ	ETF	85.52	86.12	84.48	84.64	436925.0
2013-10-08	AGZ	ETF	111.3	111.405	110.946	110.946	14426.0
2013-10-08	AIA	ETF	47.59	47.59	47.1505	47.168	12434.0
2013-10-08	AIQ	ETF	30.7	31.469	28.821	29.43	50710.0
2013-10-08	AIVI	ETF	45.34	45.44	45.0	45.0	13500.0
2013-10-08	AMJ	ETF	44.17	44.2776	43.88	43.92	332449.0
2013-10-08	AMLP	ETF	87.5	87.75	86.95	87.0	400000.0
2013-10-08	ANGL	ETF	26.44	26.48	26.05	26.46	2200.0
2013-10-08	AOA	ETF	41.77	41.79	41.36	41.37	23600.0
2013-10-08	AOK	ETF	31.25	31.2605	31.18	31.18	16576.0
2013-10-08	AOM	ETF	33.18	33.18	32.96	33.0	25675.0
2013-10-08	AOR	ETF	36.67	36.7	36.36	36.4	28886.0
2013-10-08	ARGT	ETF	19.97	19.97	19.53	19.64	3100.0
2013-10-08	ASEA	ETF	16.77	16.77	16.52	16.54	15800.0
2013-10-08	ATMP	ETF	25.88	25.88	25.71	25.72	303900.0
2013-10-08	AVIV	ETF	23.1	23.25	22.7	22.8	65812.0
2013-10-08	AWAY	ETF	29.36	29.55	28.56	28.71	870176.0
2013-10-08	BAB	ETF	27.36	27.47	27.3	27.3	222169.0
2013-10-08	BAL	ETF	53.6947	53.8801	53.4009	53.4009	2531.0
2013-10-08	BALT	ETF	5.19	5.2	4.72	4.86	1091560.0
2013-10-08	BBH	ETF	81.28	81.35	77.72	77.72	189200.0
2013-10-08	BCM	ETF	40.5	40.5	40.5	40.5	824.0
2013-10-08	BFOR	ETF	6.8325	6.8325	6.6725	6.68	284800.0
2013-10-08	BIB	ETF	32.125	32.2125	29.33	29.3762	560008.0
2013-10-08	BICK	ETF	23.91	23.99	23.71	23.73	14215.0
2013-10-08	BIL	ETF	91.58	91.6	91.58	91.6	215850.0
2013-10-08	BIS	ETF	1032.0	1120.0	1032.0	1119.96	2378.0
2013-10-08	BIV	ETF	83.3	83.44	83.25	83.33	146500.0
2013-10-08	BIZD	ETF	20.08	20.12	19.89	19.94	26700.0
2013-10-08	BJK	ETF	48.46	48.46	47.56	47.71	16600.0
2013-10-08	BKF	ETF	38.29	38.29	37.7201	37.78	81989.0
2013-10-08	BKLN	ETF	24.73	24.73	24.68	24.72	2174400.0
2013-10-08	BLNG	ETF	38.22	38.22	38.22	38.22	200.0
2013-10-08	BLV	ETF	82.81	83.1	82.77	82.95	45700.0
2013-10-08	BMVP	ETF	20.26	20.26	19.99	19.99	3700.0

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

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