PREVIEW / etf_daily / 2011-10-17

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-17.parquet
  size:    37 KB
  rows:    874

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-10-17	SPY	ETF	121.99	122.55	119.93	120.23	202311600.0
2011-10-17	QQQ	ETF	57.9	58.09	56.9716	57.28	65161278.0
2011-10-17	IWM	ETF	70.51	70.62	68.63	68.98	57529900.0
2011-10-17	DIA	ETF	115.84	115.88	113.64	113.9	8397900.0
2011-10-17	GLD	ETF	164.0	164.16	161.95	162.62	8765700.0
2011-10-17	TLT	ETF	114.3	115.97	114.22	115.92	9664000.0
2011-10-17	AADR	ETF	27.75	27.75	27.75	27.75	200.0
2011-10-17	AAXJ	ETF	51.98	51.98	50.49	50.54	905900.0
2011-10-17	ACTV	ETF	14.63	14.63	14.24	14.27	80795.0
2011-10-17	ACWI	ETF	42.65	42.65	41.9	41.96	189400.0
2011-10-17	ACWX	ETF	38.18	38.18	37.5	37.62	389660.0
2011-10-17	ADRE	ETF	39.03	39.03	38.16	38.21	69118.0
2011-10-17	AFK	ETF	27.4	27.4	26.8	26.85	33369.0
2011-10-17	AGEM	ETF	21.36	21.36	21.13	21.13	4500.0
2011-10-17	AGG	ETF	109.01	109.37	109.0	109.37	826700.0
2011-10-17	AGQ	ETF	239.84	240.2	228.72	235.04	417425.0
2011-10-17	AGZ	ETF	112.14	112.25	112.043	112.25	9530.0
2011-10-17	AIA	ETF	39.82	39.82	38.96	38.96	25185.0
2011-10-17	AIQ	ETF	6.25	6.4	5.75	5.75	17476.0
2011-10-17	AIS	ETF	2.31	2.32	2.23	2.24	504852.0
2011-10-17	AIVI	ETF	41.77	41.77	40.8	40.93	230900.0
2011-10-17	AMJ	ETF	35.64	36.06	35.5152	35.6889	3415993.0
2011-10-17	AMLP	ETF	78.8	78.9	78.0	78.05	130400.0
2011-10-17	AOA	ETF	32.43	32.43	31.9	31.9	8400.0
2011-10-17	AOK	ETF	28.9217	28.96	28.858	28.858	42080.0
2011-10-17	AOM	ETF	29.62	29.62	29.42	29.42	31711.0
2011-10-17	AOR	ETF	30.6	30.67	30.42	30.4299	12449.0
2011-10-17	ARB	ETF	37.45	37.6	36.18	36.33	214165.0
2011-10-17	ARGT	ETF	21.7	21.78	21.52	21.78	2000.0
2011-10-17	ASEA	ETF	14.8	14.8	14.7	14.75	1900.0
2011-10-17	AWAY	ETF	36.9	37.75	36.06	37.2	125034.0
2011-10-17	BAB	ETF	27.92	28.1	27.85	28.07	158141.0
2011-10-17	BAL	ETF	62.53	62.67	61.84	62.4	12732.0
2011-10-17	BALT	ETF	5.62	5.77	5.41	5.43	78572.0
2011-10-17	BBH	ETF	34.14	34.2167	33.5867	33.6533	53100.0
2011-10-17	BCM	ETF	43.76	43.76	43.49	43.73	755.0
2011-10-17	BIB	ETF	7.4575	7.5388	7.3838	7.3838	13832.0
2011-10-17	BICK	ETF	24.8	24.8	24.43	24.46	8641.0
2011-10-17	BIL	ETF	91.68	91.7	91.68	91.68	12224600.0
2011-10-17	BIS	ETF	6448.0	6584.0	6448.0	6584.0	1.875
2011-10-17	BITS	ETF	22.48	23.68	22.04	22.56	11412.0
2011-10-17	BIV	ETF	86.55	86.74	86.45	86.74	131200.0
2011-10-17	BJK	ETF	31.32	31.32	30.89	30.89	9200.0
2011-10-17	BKF	ETF	37.63	37.68	36.71	36.78	79957.0
2011-10-17	BKLN	ETF	23.41	23.67	23.29	23.41	148000.0
2011-10-17	BLNG	ETF	51.04	51.04	51.04	51.04	100.0
2011-10-17	BLV	ETF	88.88	89.86	88.88	89.7	38000.0
2011-10-17	BMVP	ETF	13.42	13.42	13.15	13.15	2327.0
2011-10-17	BND	ETF	82.85	83.15	82.85	83.14	1680700.0
2011-10-17	BNO	ETF	38.27	38.27	37.665	37.71	164800.0

> showing 50 of 874 rows — these rows as CSV

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