PREVIEW / etf_daily / 2013-04-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-22.parquet
  size:    40 KB
  rows:    981

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-04-22	SPY	ETF	155.78	156.54	154.75	156.17	106553500.0
2013-04-22	QQQ	ETF	68.33	69.04	68.08	68.79	34412089.0
2013-04-22	IWM	ETF	90.7	91.07	89.2	90.87	49190300.0
2013-04-22	DIA	ETF	145.38	145.57	144.24	145.32	11711700.0
2013-04-22	GLD	ETF	138.15	138.27	137.22	137.9	16568500.0
2013-04-22	TLT	ETF	122.84	123.29	122.67	122.92	4519400.0
2013-04-22	AAXJ	ETF	58.43	58.62	58.24	58.59	225200.0
2013-04-22	ACTV	ETF	4.75	4.75	4.62	4.68	264751.0
2013-04-22	ACWI	ETF	50.44	50.67	50.13	50.58	1141700.0
2013-04-22	ACWV	ETF	62.62	62.79	62.27	62.66	54800.0
2013-04-22	ACWX	ETF	42.49	42.65	42.24	42.58	123088.0
2013-04-22	ADRE	ETF	37.8	37.85	37.58	37.82	88919.0
2013-04-22	AFK	ETF	28.7	28.9	28.5292	28.84	26118.0
2013-04-22	AGEM	ETF	21.79	21.85	21.73	21.84	3730.0
2013-04-22	AGG	ETF	111.27	111.39	111.25	111.38	1113800.0
2013-04-22	AGQ	ETF	100.76	101.12	98.56	99.44	268600.0
2013-04-22	AGZ	ETF	113.76	113.81	113.6705	113.71	7695.0
2013-04-22	AIA	ETF	45.38	45.53	45.29	45.4621	6313.0
2013-04-22	AIQ	ETF	9.6375	10.0	9.59	9.96	19908.0
2013-04-22	AIVI	ETF	42.01	42.28	41.84	42.22	22400.0
2013-04-22	AMJ	ETF	46.25	46.5999	46.14	46.45	521326.0
2013-04-22	AMLP	ETF	87.85	88.95	87.85	88.9	634220.0
2013-04-22	ANGL	ETF	27.25	28.74	26.46	27.39	27200.0
2013-04-22	AOA	ETF	39.42	39.53	39.3	39.47	18400.0
2013-04-22	AOK	ETF	31.16	31.25	31.141	31.25	22720.0
2013-04-22	AOM	ETF	32.71	32.754	32.6	32.71	18861.0
2013-04-22	AOR	ETF	35.44	35.55	35.324	35.52	34209.0
2013-04-22	ARB	ETF	46.72	46.85	46.67	46.72	162274.0
2013-04-22	ARGT	ETF	16.44	16.48	16.32	16.48	6650.0
2013-04-22	ASEA	ETF	17.97	17.98	17.9	17.96	12700.0
2013-04-22	ATMP	ETF	26.15	26.22	26.15	26.21	7700.0
2013-04-22	AVIV	ETF	25.01	25.01	24.49	24.92	280866.0
2013-04-22	AWAY	ETF	32.37	32.37	31.69	32.05	750897.0
2013-04-22	BAB	ETF	30.88	30.89	30.81	30.88	139514.0
2013-04-22	BAL	ETF	54.14	54.34	53.84	54.28	78170.0
2013-04-22	BALT	ETF	3.26	3.33	3.22	3.33	32336.0
2013-04-22	BBH	ETF	71.6	72.06	70.83	71.38	283400.0
2013-04-22	BCM	ETF	39.88	39.962	39.88	39.962	1212.0
2013-04-22	BIB	ETF	23.0625	23.5	22.705	23.0875	377288.0
2013-04-22	BICK	ETF	23.32	23.49	23.3	23.47	2700.0
2013-04-22	BIL	ETF	91.6	91.62	91.6	91.62	57250.0
2013-04-22	BIS	ETF	1590.8	1604.4	1581.2	1594.4	229.5
2013-04-22	BIV	ETF	88.48	88.55	88.43	88.47	272700.0
2013-04-22	BIZD	ETF	19.65	19.89	19.45	19.84	90800.0
2013-04-22	BJK	ETF	39.72	39.98	39.59	39.98	8500.0
2013-04-22	BKF	ETF	37.95	38.06	37.72	38.0405	108983.0
2013-04-22	BKLN	ETF	25.12	25.12	25.1	25.12	3539900.0
2013-04-22	BLNG	ETF	40.85	40.85	40.85	40.85	200.0
2013-04-22	BLV	ETF	94.42	94.61	94.32	94.48	73800.0
2013-04-22	BMVP	ETF	18.2367	18.3734	18.1533	18.366	1882.0

> showing 50 of 981 rows — these rows as CSV

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