PREVIEW / etf_daily / 2013-06-17

all etf daily files

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

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-17	SPY	ETF	164.29	165.22	163.22	164.44	136295600.0
2013-06-17	QQQ	ETF	72.88	73.4	72.6	72.98	32443498.0
2013-06-17	IWM	ETF	98.59	98.86	97.76	98.35	33308600.0
2013-06-17	DIA	ETF	151.63	152.58	151.05	151.78	6693100.0
2013-06-17	GLD	ETF	133.89	134.06	133.52	133.77	4072300.0
2013-06-17	TLT	ETF	114.02	114.08	113.0	113.22	5982100.0
2013-06-17	AADR	ETF	33.79	34.02	33.76	33.88	2600.0
2013-06-17	AAXJ	ETF	56.39	56.69	56.17	56.38	265200.0
2013-06-17	ACTV	ETF	7.35	7.38	7.1	7.19	388804.0
2013-06-17	ACWI	ETF	52.0	52.27	51.75	52.02	542600.0
2013-06-17	ACWV	ETF	61.19	61.68	61.11	61.47	64600.0
2013-06-17	ACWX	ETF	42.97	43.17	42.74	42.96	678254.0
2013-06-17	ADRE	ETF	35.71	35.88	35.47	35.63	28290.0
2013-06-17	AFK	ETF	28.8	28.8	28.36	28.629	56222.0
2013-06-17	AGEM	ETF	21.0295	21.1082	20.8	20.8	1102.0
2013-06-17	AGG	ETF	108.85	108.94	108.68	108.7	1694700.0
2013-06-17	AGQ	ETF	85.52	86.2	84.96	85.28	261650.0
2013-06-17	AGZ	ETF	112.0701	112.31	111.96	112.109	20976.0
2013-06-17	AIA	ETF	43.47	43.69	43.33	43.47	61223.0
2013-06-17	AIQ	ETF	16.23	16.23	15.97	16.17	25265.0
2013-06-17	AIVI	ETF	43.3	43.51	42.96	43.17	53300.0
2013-06-17	AMJ	ETF	46.69	46.993	46.2	46.37	427890.0
2013-06-17	AMLP	ETF	88.4	88.55	88.05	88.4	1272880.0
2013-06-17	ANGL	ETF	27.5	27.5	26.9	26.9	2500.0
2013-06-17	AOA	ETF	40.75	40.85	40.53	40.66	51600.0
2013-06-17	AOK	ETF	31.23	31.2946	31.156	31.21	48404.0
2013-06-17	AOM	ETF	33.0	33.03	32.86	32.97	22728.0
2013-06-17	AOR	ETF	36.23	36.25	36.05	36.15	130571.0
2013-06-17	ARB	ETF	46.89	46.89	46.79	46.85	146761.0
2013-06-17	ARGT	ETF	17.03	17.07	16.95	16.95	1700.0
2013-06-17	ASEA	ETF	17.25	17.25	17.12	17.13	5800.0
2013-06-17	ATMP	ETF	25.59	25.81	25.59	25.79	3300.0
2013-06-17	AVIV	ETF	26.84	27.0	26.37	26.48	141444.0
2013-06-17	AWAY	ETF	30.34	30.34	29.16	29.87	932714.0
2013-06-17	BAB	ETF	28.76	29.07	28.61	28.87	1265235.0
2013-06-17	BAL	ETF	56.61	57.46	56.3901	56.86	32512.0
2013-06-17	BALT	ETF	3.72	3.72	3.61	3.61	59644.0
2013-06-17	BBH	ETF	69.56	69.67	68.22	68.47	63700.0
2013-06-17	BCM	ETF	40.51	40.59	40.51	40.57	7400.0
2013-06-17	BFOR	ETF	6.2925	6.3275	6.2625	6.2975	531200.0
2013-06-17	BIB	ETF	23.505	23.75	22.6675	22.9075	108580.0
2013-06-17	BICK	ETF	22.12	22.1685	22.09	22.12	79150.0
2013-06-17	BIL	ETF	91.6	91.62	91.6	91.6	105150.0
2013-06-17	BIS	ETF	1476.8	1539.2	1476.8	1537.2	132.5
2013-06-17	BIV	ETF	85.89	85.94	85.51	85.6	311000.0
2013-06-17	BIZD	ETF	19.93	20.11	19.93	19.98	8800.0
2013-06-17	BJK	ETF	42.16	42.32	42.05	42.09	6400.0
2013-06-17	BKF	ETF	35.91	36.14	35.64	35.83	337137.0
2013-06-17	BKLN	ETF	24.9	24.91	24.84	24.86	2186700.0
2013-06-17	BLV	ETF	88.28	88.65	87.65	87.75	43300.0

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

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