PREVIEW / etf_daily / 2011-09-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-14.parquet
  size:    36 KB
  rows:    863

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
2011-09-14	SPY	ETF	118.34	120.8	116.72	119.37	319389500.0
2011-09-14	QQQ	ETF	54.85	55.98	54.32	55.36	90757299.0
2011-09-14	IWM	ETF	69.84	71.4	68.44	70.42	77019200.0
2011-09-14	DIA	ETF	111.49	113.83	109.87	112.4	14634500.0
2011-09-14	GLD	ETF	177.55	177.78	176.05	177.21	18122800.0
2011-09-14	TLT	ETF	111.97	113.35	111.82	113.16	11948500.0
2011-09-14	AADR	ETF	27.77	28.41	27.77	28.33	3500.0
2011-09-14	AAXJ	ETF	52.58	53.13	51.72	52.76	253500.0
2011-09-14	ACTV	ETF	14.9	15.75	14.67	15.62	63761.0
2011-09-14	ACWI	ETF	41.37	42.06	40.71	41.71	1315600.0
2011-09-14	ACWX	ETF	36.98	37.58	36.31	37.22	153572.0
2011-09-14	ADRE	ETF	39.86	40.44	39.17	40.08	92910.0
2011-09-14	AFK	ETF	28.78	29.1	28.61	29.03	9115.0
2011-09-14	AGEM	ETF	22.08	22.3792	21.9	22.3792	898.0
2011-09-14	AGG	ETF	109.9	110.11	109.86	110.0	1065300.0
2011-09-14	AGQ	ETF	432.0	433.16	420.0	428.78	364250.0
2011-09-14	AGZ	ETF	112.38	112.73	112.38	112.59	7790.0
2011-09-14	AIA	ETF	39.91	40.2699	39.31	40.0	89814.0
2011-09-14	AIQ	ETF	6.55	6.9	6.25	6.7	43688.0
2011-09-14	AIS	ETF	2.29	2.32	2.239	2.27	618538.0
2011-09-14	AIVI	ETF	39.21	40.02	38.71	39.74	446100.0
2011-09-14	AMJ	ETF	34.98	35.2	34.54	34.96	482989.0
2011-09-14	AMLP	ETF	77.65	77.65	76.6	77.05	135900.0
2011-09-14	AOA	ETF	31.68	32.28	31.51	32.19	16500.0
2011-09-14	AOK	ETF	28.96	29.01	28.905	28.97	3733.0
2011-09-14	AOM	ETF	29.45	29.65	29.39	29.58	19436.0
2011-09-14	AOR	ETF	30.39	30.7081	30.2	30.7081	7380.0
2011-09-14	ARB	ETF	35.78	36.75	34.83	36.09	237225.0
2011-09-14	ARGT	ETF	22.86	23.22	22.86	23.04	11450.0
2011-09-14	ASEA	ETF	15.21	15.25	15.0	15.24	9500.0
2011-09-14	AWAY	ETF	40.73	42.44	40.51	41.97	108122.0
2011-09-14	BAB	ETF	28.09	28.4	28.0601	28.39	154421.0
2011-09-14	BAL	ETF	70.19	70.99	69.99	70.7	48918.0
2011-09-14	BALT	ETF	5.37	5.5	5.345	5.4	214825.0
2011-09-14	BBH	ETF	32.5567	33.4233	32.5567	33.14	49200.0
2011-09-14	BCM	ETF	47.17	47.25	47.15	47.19	1114.0
2011-09-14	BIB	ETF	7.51	7.8125	7.3487	7.6675	63480.0
2011-09-14	BICK	ETF	25.06	25.5043	24.75	25.35	79628.0
2011-09-14	BIL	ETF	91.7	91.7	91.68	91.68	308000.0
2011-09-14	BIS	ETF	6662.4	6662.4	6400.0	6518.4	8.45
2011-09-14	BITS	ETF	20.48	20.96	19.8	20.84	950.0
2011-09-14	BIV	ETF	88.09	88.29	87.9	88.12	121100.0
2011-09-14	BJK	ETF	31.98	32.44	31.67	32.15	190400.0
2011-09-14	BKF	ETF	38.87	39.39	38.19	39.05	303660.0
2011-09-14	BKLN	ETF	23.42	23.52	23.23	23.5	204400.0
2011-09-14	BLV	ETF	88.97	89.51	88.75	89.51	25600.0
2011-09-14	BMVP	ETF	13.22	13.49	13.2	13.34	2058.0
2011-09-14	BND	ETF	83.5	83.72	83.5	83.72	1044900.0
2011-09-14	BNO	ETF	36.97	36.97	36.47	36.885	43000.0
2011-09-14	BRF	ETF	46.98	47.26	45.71	46.57	100902.0

> showing 50 of 863 rows — these rows as CSV

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