PREVIEW / etf_daily / 2013-05-30

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-30.parquet
  size:    41 KB
  rows:    1,005

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-05-30	SPY	ETF	165.35	166.59	165.22	165.83	107793800.0
2013-05-30	QQQ	ETF	73.57	74.275	73.55	73.93	32390461.0
2013-05-30	IWM	ETF	98.5	99.13	98.31	98.89	30620300.0
2013-05-30	DIA	ETF	152.86	153.8	152.6	153.1	8231800.0
2013-05-30	GLD	ETF	136.67	137.11	136.26	136.7	8611700.0
2013-05-30	TLT	ETF	115.25	115.37	114.53	114.84	10011800.0
2013-05-30	AADR	ETF	34.28	34.45	34.28	34.45	700.0
2013-05-30	AAXJ	ETF	59.2	59.5	59.07	59.21	395200.0
2013-05-30	ACTV	ETF	6.82	6.84	6.71	6.77	401289.0
2013-05-30	ACWI	ETF	52.65	53.07	52.65	52.91	3091100.0
2013-05-30	ACWV	ETF	61.79	62.01	61.79	61.79	86600.0
2013-05-30	ACWX	ETF	43.71	43.96	43.655	43.86	135480.0
2013-05-30	ADRE	ETF	37.8	38.079	37.74	37.91	47936.0
2013-05-30	AFK	ETF	30.12	30.67	30.08	30.56	89912.0
2013-05-30	AGEM	ETF	21.8201	22.3	21.8201	22.08	35446.0
2013-05-30	AGG	ETF	109.36	109.48	109.29	109.32	1301000.0
2013-05-30	AGQ	ETF	94.68	95.84	92.4	92.96	436600.0
2013-05-30	AGZ	ETF	112.64	112.85	112.61	112.69	17920.0
2013-05-30	AIA	ETF	46.02	46.26	46.02	46.07	42232.0
2013-05-30	AIQ	ETF	13.63	15.82	13.61	15.3	80227.0
2013-05-30	AIVI	ETF	43.52	43.88	43.52	43.77	28500.0
2013-05-30	AMJ	ETF	46.22	46.84	44.87	45.69	1593220.0
2013-05-30	AMLP	ETF	88.85	88.85	86.95	87.75	1255200.0
2013-05-30	ANGL	ETF	27.76	28.2	27.5	27.5	9400.0
2013-05-30	AOA	ETF	41.12	41.2	41.06	41.13	52900.0
2013-05-30	AOK	ETF	31.383	31.46	31.378	31.43	40310.0
2013-05-30	AOM	ETF	33.19	33.264	33.1899	33.24	15530.0
2013-05-30	AOR	ETF	36.33	36.54	36.32	36.47	37818.0
2013-05-30	ARB	ETF	47.0	47.08	46.9	46.97	152942.0
2013-05-30	ARGT	ETF	17.78	18.05	17.78	17.96	9300.0
2013-05-30	ASEA	ETF	18.0	18.06	17.9	17.96	41900.0
2013-05-30	ATMP	ETF	26.2	26.2	25.38	25.6	127600.0
2013-05-30	AVIV	ETF	25.79	25.98	25.38	25.98	631222.0
2013-05-30	AWAY	ETF	29.84	30.24	29.72	30.19	512559.0
2013-05-30	BAB	ETF	30.06	30.15	30.02	30.07	206393.0
2013-05-30	BAL	ETF	50.7401	50.85	50.18	50.61	25690.0
2013-05-30	BALT	ETF	3.7	3.7	3.68	3.68	80758.0
2013-05-30	BBH	ETF	73.57	73.9	72.66	73.59	52000.0
2013-05-30	BCM	ETF	40.606	40.606	40.606	40.606	174.0
2013-05-30	BIB	ETF	24.9	25.625	24.9	25.4375	102864.0
2013-05-30	BICK	ETF	23.74	23.864	23.589	23.7292	2294.0
2013-05-30	BIL	ETF	91.6	91.62	91.6	91.6	92450.0
2013-05-30	BIS	ETF	1441.6	1441.6	1406.4	1406.4	53.0
2013-05-30	BIV	ETF	86.44	86.53	86.3	86.4	193900.0
2013-05-30	BIZD	ETF	20.08	20.34	20.08	20.29	9200.0
2013-05-30	BJK	ETF	42.25	42.54	42.25	42.42	13500.0
2013-05-30	BKF	ETF	38.37	38.72	38.34	38.45	377029.0
2013-05-30	BKLN	ETF	25.09	25.1	25.08	25.1	2512600.0
2013-05-30	BLV	ETF	89.85	90.18	89.6	89.68	51500.0
2013-05-30	BMVP	ETF	19.4767	19.5333	19.4767	19.4867	21366.0

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

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