PREVIEW / etf_daily / 2011-11-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-11.parquet
  size:    37 KB
  rows:    879

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-11-11	SPY	ETF	125.83	126.99	125.79	126.66	189924400.0
2011-11-11	QQQ	ETF	57.28	58.02	57.2	57.85	54470951.0
2011-11-11	IWM	ETF	73.34	74.53	72.53	74.38	62452000.0
2011-11-11	DIA	ETF	120.24	121.71	120.22	121.53	7260300.0
2011-11-11	GLD	ETF	172.1	174.05	172.07	173.96	8727100.0
2011-11-11	TLT	ETF	115.83	116.17	115.5	115.65	2483900.0
2011-11-11	AADR	ETF	28.78	28.78	28.52	28.52	700.0
2011-11-11	AAXJ	ETF	52.78	53.63	52.78	53.38	294700.0
2011-11-11	ACTV	ETF	13.53	15.47	13.53	15.13	186978.0
2011-11-11	ACWI	ETF	43.29	43.67	43.23	43.58	272700.0
2011-11-11	ACWV	ETF	51.02	51.04	51.02	51.04	300.0
2011-11-11	ACWX	ETF	38.3	38.73	38.24	38.66	217636.0
2011-11-11	ADRE	ETF	40.77	41.282	40.77	41.18	54292.0
2011-11-11	AFK	ETF	28.38	28.69	28.38	28.58	4620.0
2011-11-11	AGEM	ETF	22.77	22.77	22.73	22.73	322.0
2011-11-11	AGG	ETF	109.8	109.87	109.69	109.79	1803400.0
2011-11-11	AGQ	ETF	263.8	275.08	263.68	272.0	317300.0
2011-11-11	AGZ	ETF	112.4	112.57	112.03	112.22	24981.0
2011-11-11	AIA	ETF	41.6	41.84	41.46	41.76	19346.0
2011-11-11	AIQ	ETF	6.55	6.65	6.25	6.55	28864.0
2011-11-11	AIS	ETF	2.3	2.33	2.28	2.32	437370.0
2011-11-11	AIVI	ETF	41.24	41.7	41.15	41.58	64700.0
2011-11-11	AMJ	ETF	37.27	37.44	36.92	37.07	1565651.0
2011-11-11	AMLP	ETF	78.9	79.85	78.6	78.95	189500.0
2011-11-11	AOA	ETF	33.24	33.6	33.24	33.44	9600.0
2011-11-11	AOK	ETF	29.28	29.4	29.28	29.39	12488.0
2011-11-11	AOM	ETF	30.15	30.159	30.0801	30.14	22485.0
2011-11-11	AOR	ETF	31.31	31.496	31.31	31.45	8812.0
2011-11-11	ARB	ETF	40.55	41.46	40.55	41.36	172296.0
2011-11-11	ARGT	ETF	23.12	23.12	23.12	23.12	100.0
2011-11-11	ASEA	ETF	14.98	15.21	14.98	15.01	1500.0
2011-11-11	AWAY	ETF	33.92	34.36	33.01	33.2	87807.0
2011-11-11	BAB	ETF	28.32	28.42	28.32	28.41	111689.0
2011-11-11	BAL	ETF	60.81	60.89	60.2507	60.67	28886.0
2011-11-11	BALT	ETF	5.6	5.65	5.55	5.58	124716.0
2011-11-11	BBH	ETF	35.3567	35.6233	35.3567	35.3967	139500.0
2011-11-11	BCM	ETF	45.09	45.34	45.08	45.34	2475.0
2011-11-11	BIB	ETF	7.2525	7.261	7.195	7.2575	41200.0
2011-11-11	BICK	ETF	25.57	25.81	25.55	25.81	3453.0
2011-11-11	BIL	ETF	91.68	91.72	91.68	91.68	344400.0
2011-11-11	BITS	ETF	24.08	25.0	21.6	21.72	124510.0
2011-11-11	BIV	ETF	87.56	87.7	87.42	87.55	85400.0
2011-11-11	BJK	ETF	31.12	31.47	31.12	31.45	9000.0
2011-11-11	BKF	ETF	39.98	40.589	39.98	40.46	43754.0
2011-11-11	BKLN	ETF	24.2	24.29	23.79	24.25	52600.0
2011-11-11	BLV	ETF	90.54	90.72	90.38	90.53	48200.0
2011-11-11	BMVP	ETF	13.853	14.004	13.853	13.96	2867.0
2011-11-11	BND	ETF	83.62	83.64	83.51	83.59	698100.0
2011-11-11	BNO	ETF	39.095	39.335	39.05	39.145	30000.0
2011-11-11	BRF	ETF	44.31	45.14	44.18	45.09	207052.0

> showing 50 of 879 rows — these rows as CSV

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