PREVIEW / etf_daily / 2012-05-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-17.parquet
  size:    39 KB
  rows:    941

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
2012-05-17	SPY	ETF	132.86	133.02	130.79	130.86	247992900.0
2012-05-17	QQQ	ETF	62.94	63.06	61.6	61.61	62253439.0
2012-05-17	IWM	ETF	77.22	77.35	75.36	75.4	71665100.0
2012-05-17	DIA	ETF	126.21	126.25	124.55	124.57	8985300.0
2012-05-17	GLD	ETF	150.83	153.4	150.38	152.8	18080700.0
2012-05-17	TLT	ETF	122.03	124.28	122.02	124.17	14863400.0
2012-05-17	AAXJ	ETF	51.3	51.41	50.74	50.74	750200.0
2012-05-17	ACTV	ETF	13.09	13.09	12.18	12.64	1373278.0
2012-05-17	ACWI	ETF	43.13	43.17	42.44	42.48	1511600.0
2012-05-17	ACWV	ETF	52.61	52.61	52.21	52.29	2023500.0
2012-05-17	ACWX	ETF	36.45	36.48	36.03	36.03	159097.0
2012-05-17	ADRE	ETF	37.11	37.11	36.42	36.44	37838.0
2012-05-17	AFK	ETF	27.93	28.03	27.48	27.48	13654.0
2012-05-17	AGEM	ETF	20.2	20.2	20.01	20.0123	3393.0
2012-05-17	AGG	ETF	110.88	111.13	110.83	111.03	1420700.0
2012-05-17	AGQ	ETF	158.64	165.08	155.88	161.84	615625.0
2012-05-17	AGZ	ETF	113.12	113.22	113.0078	113.15	13373.0
2012-05-17	AIA	ETF	40.94	40.94	40.31	40.32	32562.0
2012-05-17	AIQ	ETF	5.75	5.9	5.15	5.3	29739.0
2012-05-17	AIS	ETF	3.01	3.02	2.92	2.94	1114347.0
2012-05-17	AIVI	ETF	37.68	37.68	37.18	37.25	91700.0
2012-05-17	AMJ	ETF	38.23	38.39	37.75	37.75	2955885.0
2012-05-17	AMLP	ETF	80.2	80.35	79.55	79.55	287880.0
2012-05-17	ANGL	ETF	25.02	25.3	25.02	25.1	3800.0
2012-05-17	AOA	ETF	34.45	34.45	33.96	33.96	27600.0
2012-05-17	AOK	ETF	29.67	29.67	29.54	29.57	314358.0
2012-05-17	AOM	ETF	30.41	30.41	30.29	30.29	31321.0
2012-05-17	AOR	ETF	32.034	32.06	31.78	31.7819	27614.0
2012-05-17	ARB	ETF	35.86	35.95	34.88	34.91	184222.0
2012-05-17	ARGT	ETF	15.96	16.0	15.8	15.8	2600.0
2012-05-17	ASEA	ETF	15.3	15.41	15.18	15.18	21800.0
2012-05-17	AWAY	ETF	26.44	26.77	24.89	25.15	738121.0
2012-05-17	BAB	ETF	29.75	29.95	29.7	29.94	367348.0
2012-05-17	BAL	ETF	47.86	48.47	47.4047	47.59	44585.0
2012-05-17	BALT	ETF	3.81	3.9	3.81	3.86	107180.0
2012-05-17	BBH	ETF	46.78	46.78	45.61	45.63	11300.0
2012-05-17	BCM	ETF	41.96	41.96	41.863	41.863	1103.0
2012-05-17	BIB	ETF	12.4863	12.4863	11.753	11.753	104272.0
2012-05-17	BICK	ETF	22.32	22.32	21.9208	21.9208	34320.0
2012-05-17	BIL	ETF	91.66	91.66	91.64	91.66	346500.0
2012-05-17	BIS	ETF	3502.4	3649.6	3502.4	3649.6	32.9
2012-05-17	BIV	ETF	88.22	88.44	88.12	88.42	239100.0
2012-05-17	BJK	ETF	32.52	32.52	31.96	31.97	11300.0
2012-05-17	BKF	ETF	35.43	35.53	34.69	34.69	78899.0
2012-05-17	BKLN	ETF	24.57	24.57	24.39	24.39	610900.0
2012-05-17	BLV	ETF	93.43	94.43	93.4	94.43	119900.0
2012-05-17	BMVP	ETF	14.723	14.723	14.414	14.42	23440.0
2012-05-17	BND	ETF	84.08	84.21	83.95	84.14	1500200.0
2012-05-17	BNO	ETF	38.655	38.69	37.81	37.845	80400.0
2012-05-17	BOIL	ETF	925200.0	962000.0	863200.0	955400.0	23.6

> showing 50 of 941 rows — these rows as CSV

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