PREVIEW / etf_daily / 2012-07-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-19.parquet
  size:    38 KB
  rows:    928

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-07-19	SPY	ETF	137.65	138.18	137.21	137.73	129847300.0
2012-07-19	QQQ	ETF	64.84	65.31	64.72	65.1	53017702.0
2012-07-19	IWM	ETF	80.55	80.74	79.81	79.95	49405400.0
2012-07-19	DIA	ETF	129.27	129.71	128.81	129.32	3845000.0
2012-07-19	GLD	ETF	153.73	154.32	152.93	153.38	6070000.0
2012-07-19	TLT	ETF	128.46	129.1	128.11	128.49	5246300.0
2012-07-19	AAXJ	ETF	52.38	52.67	52.27	52.54	276000.0
2012-07-19	ACTV	ETF	15.0	15.1	14.92	15.0	61267.0
2012-07-19	ACWI	ETF	44.26	44.47	44.14	44.33	403300.0
2012-07-19	ACWV	ETF	55.58	56.0	55.0	55.5	32200.0
2012-07-19	ACWX	ETF	37.27	37.43	37.17	37.34	91563.0
2012-07-19	ADRE	ETF	37.59	37.7306	37.52	37.655	19031.0
2012-07-19	AFK	ETF	28.52	28.53	28.35	28.4657	25230.0
2012-07-19	AGG	ETF	112.3	112.43	112.23	112.26	901600.0
2012-07-19	AGQ	ETF	150.28	151.2	147.8	148.92	197625.0
2012-07-19	AGZ	ETF	113.94	113.94	113.83	113.84	13277.0
2012-07-19	AIA	ETF	41.2659	41.509	41.228	41.45	7898.0
2012-07-19	AIQ	ETF	4.3165	4.35	4.065	4.2055	3042.0
2012-07-19	AIVI	ETF	38.1	38.28	38.0	38.22	32400.0
2012-07-19	AMJ	ETF	39.89	40.07	39.76	39.96	709725.0
2012-07-19	AMLP	ETF	82.75	82.95	82.5	82.75	641760.0
2012-07-19	ANGL	ETF	25.75	25.8	25.75	25.8	1200.0
2012-07-19	AOA	ETF	35.32	35.36	35.28	35.33	5300.0
2012-07-19	AOK	ETF	30.07	30.09	30.03	30.04	44272.0
2012-07-19	AOM	ETF	30.91	31.0	30.91	30.9318	11638.0
2012-07-19	AOR	ETF	32.78	32.8	32.7482	32.8	3791.0
2012-07-19	ARB	ETF	34.85	37.95	34.24	35.91	250903.0
2012-07-19	ARGT	ETF	16.06	16.06	16.06	16.06	100.0
2012-07-19	ASEA	ETF	16.19	16.24	16.12	16.23	10700.0
2012-07-19	AWAY	ETF	22.14	22.609	21.65	21.85	282220.0
2012-07-19	BAB	ETF	30.22	30.25	30.1	30.2	730297.0
2012-07-19	BAL	ETF	48.0569	48.32	47.3801	47.89	13343.0
2012-07-19	BALT	ETF	3.51	3.54	3.45	3.48	36403.0
2012-07-19	BBH	ETF	49.59	49.59	48.86	49.21	24700.0
2012-07-19	BCM	ETF	44.31	44.31	44.31	44.31	650.0
2012-07-19	BIB	ETF	14.1937	14.1937	13.8491	14.0222	36728.0
2012-07-19	BICK	ETF	22.14	22.35	22.14	22.27	2938.0
2012-07-19	BIL	ETF	91.64	91.64	91.62	91.64	160350.0
2012-07-19	BIS	ETF	2899.2	2960.0	2899.2	2939.2	22.95
2012-07-19	BIV	ETF	89.97	90.01	89.85	89.88	189100.0
2012-07-19	BJK	ETF	31.3	31.79	31.25	31.75	10700.0
2012-07-19	BKF	ETF	35.73	36.07	35.73	36.03	54725.0
2012-07-19	BKLN	ETF	24.53	24.57	24.51	24.57	150400.0
2012-07-19	BLV	ETF	98.1	98.33	97.89	98.07	32500.0
2012-07-19	BMVP	ETF	15.5967	15.5967	15.417	15.4267	2452.0
2012-07-19	BND	ETF	85.0	85.11	84.99	85.0	864100.0
2012-07-19	BNO	ETF	37.965	38.43	37.925	38.285	128400.0
2012-07-19	BOIL	ETF	966600.0	1016800.0	943000.0	1009600.0	14.2
2012-07-19	BOND	ETF	106.99	107.1	106.94	107.05	843796.0
2012-07-19	BRF	ETF	35.42	35.92	35.4	35.85	74161.0

> showing 50 of 928 rows — these rows as CSV

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