PREVIEW / etf_daily / 2013-07-17

all etf daily files

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

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-07-17	SPY	ETF	168.16	168.48	167.73	167.95	92873900.0
2013-07-17	QQQ	ETF	75.6	75.74	75.35	75.56	24631497.0
2013-07-17	IWM	ETF	103.64	103.95	103.24	103.46	28476600.0
2013-07-17	DIA	ETF	154.64	154.85	154.18	154.44	6504400.0
2013-07-17	GLD	ETF	125.04	125.7	122.73	123.32	10882400.0
2013-07-17	TLT	ETF	109.19	109.36	108.66	108.86	5932000.0
2013-07-17	AADR	ETF	33.95	33.95	33.95	33.95	100.0
2013-07-17	AAXJ	ETF	56.77	56.8	56.45	56.58	544800.0
2013-07-17	ACTV	ETF	8.81	8.88	8.76	8.83	528762.0
2013-07-17	ACWI	ETF	52.41	52.47	52.22	52.34	980500.0
2013-07-17	ACWV	ETF	62.23	62.29	61.92	61.94	28100.0
2013-07-17	ACWX	ETF	42.84	42.92	42.6775	42.77	595438.0
2013-07-17	ADRE	ETF	35.15	35.36	35.15	35.36	21163.0
2013-07-17	AFK	ETF	28.91	28.9799	28.83	28.89	17312.0
2013-07-17	AGEM	ETF	21.49	21.49	21.293	21.3898	1220.0
2013-07-17	AGG	ETF	107.44	107.55	107.3	107.44	693500.0
2013-07-17	AGQ	ETF	71.0	71.6	65.56	65.92	749250.0
2013-07-17	AGZ	ETF	111.26	111.32	111.166	111.2179	15925.0
2013-07-17	AIA	ETF	44.02	44.1155	43.9	43.93	24005.0
2013-07-17	AIQ	ETF	16.9	17.65	16.89	17.27	48150.0
2013-07-17	AIVI	ETF	42.09	42.09	41.76	41.89	24300.0
2013-07-17	AMJ	ETF	48.12	48.74	47.95	48.32	645584.0
2013-07-17	AMLP	ETF	90.7	91.0	90.2	90.25	461460.0
2013-07-17	ANGL	ETF	26.76	26.78	26.68	26.78	11600.0
2013-07-17	AOA	ETF	41.44	41.44	41.18	41.21	9500.0
2013-07-17	AOK	ETF	31.27	31.27	31.15	31.2	20201.0
2013-07-17	AOM	ETF	33.11	33.11	32.97	33.01	19510.0
2013-07-17	AOR	ETF	36.34	36.41	36.32	36.38	26186.0
2013-07-17	ARB	ETF	46.35	46.4	46.22	46.32	131550.0
2013-07-17	ARGT	ETF	17.16	17.16	17.06	17.15	4300.0
2013-07-17	ASEA	ETF	17.2	17.3	17.2	17.25	28300.0
2013-07-17	ATMP	ETF	26.75	26.75	26.57	26.57	23400.0
2013-07-17	AVIV	ETF	25.96	26.38	25.96	26.07	126857.0
2013-07-17	AWAY	ETF	31.58	32.23	31.55	31.67	882806.0
2013-07-17	BAB	ETF	28.14	28.25	28.03	28.23	196772.0
2013-07-17	BAL	ETF	54.15	54.15	53.5	53.55	16650.0
2013-07-17	BALT	ETF	3.76	3.79	3.7	3.74	31795.0
2013-07-17	BBH	ETF	76.7	76.98	76.56	76.79	87800.0
2013-07-17	BCM	ETF	40.12	40.12	39.87	39.8772	21343.0
2013-07-17	BFOR	ETF	6.545	6.545	6.5125	6.52	110800.0
2013-07-17	BIB	ETF	27.745	27.8775	27.6105	27.725	148144.0
2013-07-17	BICK	ETF	21.63	21.67	21.59	21.59	3036.0
2013-07-17	BIL	ETF	91.6	91.6	91.58	91.58	156600.0
2013-07-17	BIS	ETF	1237.76	1245.26	1236.16	1245.26	19.5
2013-07-17	BIV	ETF	83.97	84.06	83.84	83.93	629500.0
2013-07-17	BIZD	ETF	20.35	20.43	20.28	20.4	6500.0
2013-07-17	BJK	ETF	41.9	41.9	41.74	41.78	6200.0
2013-07-17	BKF	ETF	35.17	35.31	35.1111	35.25	57023.0
2013-07-17	BKLN	ETF	24.86	24.92	24.81	24.85	5338100.0
2013-07-17	BLV	ETF	85.21	85.36	84.76	85.0	145500.0

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

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