PREVIEW / etf_daily / 2013-06-14

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-14.parquet
  size:    41 KB
  rows:    1,004

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-06-14	SPY	ETF	164.03	164.67	162.91	163.18	141197500.0
2013-06-14	QQQ	ETF	72.76	72.84	72.171	72.28	27697014.0
2013-06-14	IWM	ETF	98.28	98.64	97.42	97.71	37838400.0
2013-06-14	DIA	ETF	151.6	152.01	150.39	150.66	4639300.0
2013-06-14	GLD	ETF	134.0	134.6	133.88	134.43	4278700.0
2013-06-14	TLT	ETF	114.1	114.66	113.82	113.82	6679100.0
2013-06-14	AADR	ETF	33.63	33.7	33.48	33.5	2500.0
2013-06-14	AAXJ	ETF	56.06	56.33	55.62	55.74	281400.0
2013-06-14	ACTV	ETF	7.46	7.58	7.2299	7.25	393804.0
2013-06-14	ACWI	ETF	51.74	51.97	51.41	51.47	820500.0
2013-06-14	ACWV	ETF	60.86	61.0	60.68	60.76	59900.0
2013-06-14	ACWX	ETF	42.55	42.7663	42.27	42.32	408837.0
2013-06-14	ADRE	ETF	35.81	35.87	35.39	35.43	30025.0
2013-06-14	AFK	ETF	28.87	28.96	28.49	28.62	102661.0
2013-06-14	AGEM	ETF	20.7899	20.7899	20.7899	20.7899	115.0
2013-06-14	AGG	ETF	108.82	109.0	108.78	108.78	1219800.0
2013-06-14	AGQ	ETF	86.96	87.88	86.2	87.0	440550.0
2013-06-14	AGZ	ETF	111.78	112.35	111.78	112.1	49048.0
2013-06-14	AIA	ETF	43.26	43.39	42.86	42.86	129260.0
2013-06-14	AIQ	ETF	16.18	16.2	15.85	15.99	15388.0
2013-06-14	AIVI	ETF	42.77	42.98	42.51	42.6	16100.0
2013-06-14	AMJ	ETF	45.88	46.51	45.4501	46.4	642378.0
2013-06-14	AMLP	ETF	88.25	88.25	86.95	87.9	630980.0
2013-06-14	ANGL	ETF	27.07	27.09	27.03	27.07	1400.0
2013-06-14	AOA	ETF	40.59	40.69	40.32	40.42	37400.0
2013-06-14	AOK	ETF	31.18	31.1931	31.08	31.09	68639.0
2013-06-14	AOM	ETF	32.92	32.94	32.77	32.78	24694.0
2013-06-14	AOR	ETF	36.02	36.15	35.89	35.97	33838.0
2013-06-14	ARB	ETF	46.95	46.95	46.79	46.82	171253.0
2013-06-14	ARGT	ETF	17.05	17.05	16.96	16.96	600.0
2013-06-14	ASEA	ETF	17.24	17.27	17.04	17.11	36000.0
2013-06-14	ATMP	ETF	25.24	25.66	25.24	25.58	9900.0
2013-06-14	AVIV	ETF	26.46	26.93	26.3801	26.75	101605.0
2013-06-14	AWAY	ETF	30.0	30.42	29.85	30.04	261479.0
2013-06-14	BAB	ETF	28.89	29.01	28.66	28.74	363328.0
2013-06-14	BAL	ETF	57.32	57.4	56.7	56.879	15293.0
2013-06-14	BALT	ETF	3.61	3.7	3.6	3.67	77637.0
2013-06-14	BBH	ETF	69.59	69.59	68.74	68.95	29400.0
2013-06-14	BCM	ETF	40.62	40.62	40.598	40.598	840.0
2013-06-14	BFOR	ETF	6.29	6.3	6.2425	6.255	515200.0
2013-06-14	BIB	ETF	23.75	23.75	23.125	23.3125	84228.0
2013-06-14	BICK	ETF	21.99	21.99	21.99	21.99	1200.0
2013-06-14	BIL	ETF	91.6	91.62	91.6	91.6	350350.0
2013-06-14	BIS	ETF	1519.2	1520.0	1494.0	1501.12	37.0
2013-06-14	BIV	ETF	85.71	85.89	85.68	85.75	218700.0
2013-06-14	BIZD	ETF	19.82	19.91	19.73	19.91	1700.0
2013-06-14	BJK	ETF	42.06	42.06	41.63	41.71	6300.0
2013-06-14	BKF	ETF	35.97	36.1	35.43	35.5	176321.0
2013-06-14	BKLN	ETF	24.87	24.87	24.85	24.86	2840400.0
2013-06-14	BLV	ETF	88.3	88.55	88.24	88.33	33000.0

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

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