PREVIEW / etf_daily / 2011-03-31

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-31.parquet
  size:    36 KB
  rows:    836

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-03-31	SPY	ETF	132.6	132.96	132.45	132.59	132537100.0
2011-03-31	QQQ	ETF	57.25	57.48	57.15	57.43	50143329.0
2011-03-31	IWM	ETF	83.8	84.29	83.7	84.17	41625800.0
2011-03-31	DIA	ETF	123.18	123.56	122.95	123.02	4355100.0
2011-03-31	GLD	ETF	140.08	140.4	139.78	139.86	15227300.0
2011-03-31	TLT	ETF	92.67	92.72	91.61	92.13	9654300.0
2011-03-31	AAXJ	ETF	62.96	63.28	62.85	62.98	635900.0
2011-03-31	ACWI	ETF	48.5	48.5	48.24	48.36	987900.0
2011-03-31	ACWX	ETF	45.31	45.55	45.25	45.45	49505.0
2011-03-31	ADRE	ETF	48.32	48.57	48.32	48.52	201406.0
2011-03-31	AFK	ETF	33.23	33.4199	33.18	33.4199	23677.0
2011-03-31	AGG	ETF	105.37	105.4	105.13	105.13	1014400.0
2011-03-31	AGQ	ETF	453.68	456.7	444.76	450.18	425800.0
2011-03-31	AGZ	ETF	109.52	109.52	109.23	109.35	23787.0
2011-03-31	AIA	ETF	47.76	47.94	47.71	47.84	22929.0
2011-03-31	AIQ	ETF	21.5	22.1	21.25	22.1	21021.0
2011-03-31	AIS	ETF	1.75	1.81	1.72	1.8	1026313.0
2011-03-31	AIVI	ETF	47.06	47.16	46.78	47.0	17700.0
2011-03-31	AMJ	ETF	37.88	38.1	37.81	37.97	2135727.0
2011-03-31	AMLP	ETF	81.6	81.9	81.5	81.8	104600.0
2011-03-31	AOA	ETF	35.99	36.04	35.97	36.02	8300.0
2011-03-31	AOK	ETF	29.26	29.26	29.2	29.2114	7415.0
2011-03-31	AOM	ETF	30.54	30.56	30.5001	30.514	27345.0
2011-03-31	AOR	ETF	32.55	32.59	32.53	32.574	16114.0
2011-03-31	ARB	ETF	39.26	40.24	39.22	40.03	229554.0
2011-03-31	ARGT	ETF	30.1	30.2	30.0	30.06	6050.0
2011-03-31	ASEA	ETF	15.8	15.97	15.8	15.97	6200.0
2011-03-31	BAB	ETF	25.39	25.39	25.15	25.19	109581.0
2011-03-31	BAL	ETF	101.99	104.38	101.66	104.26	137887.0
2011-03-31	BALT	ETF	9.05	9.21	9.02	9.12	128068.0
2011-03-31	BBH	ETF	35.28	35.5233	35.28	35.43	19800.0
2011-03-31	BIB	ETF	8.5288	8.5288	8.5	8.5013	10400.0
2011-03-31	BICK	ETF	33.38	33.64	33.38	33.56	11699.0
2011-03-31	BIL	ETF	91.7	91.72	91.7	91.7	145200.0
2011-03-31	BIS	ETF	7014.4	7014.4	6944.0	6944.0	3.125
2011-03-31	BITS	ETF	25.6	25.6	24.88	25.6	5075.0
2011-03-31	BIV	ETF	82.25	82.28	81.89	81.98	99700.0
2011-03-31	BJK	ETF	32.25	32.26	31.93	32.21	17200.0
2011-03-31	BKF	ETF	50.1	50.51	50.06	50.31	242882.0
2011-03-31	BKLN	ETF	25.15	25.15	25.04	25.12	238500.0
2011-03-31	BLV	ETF	78.58	78.64	78.11	78.22	35500.0
2011-03-31	BMVP	ETF	15.65	15.69	15.62	15.65	8252.0
2011-03-31	BND	ETF	80.21	80.24	80.0	80.02	717300.0
2011-03-31	BNO	ETF	38.835	38.97	38.74	38.91	94800.0
2011-03-31	BRF	ETF	56.22	56.71	56.0001	56.71	214270.0
2011-03-31	BSCE	ETF	20.84	20.93	20.84	20.909	33637.0
2011-03-31	BSV	ETF	80.29	80.3	80.16	80.16	1504100.0
2011-03-31	BTF	ETF	84.49999999999999	84.49999999999999	83.8	83.8	6448.400000000001
2011-03-31	BWX	ETF	29.94	30.0	29.91	29.915	263724.0
2011-03-31	BWZ	ETF	38.34	38.62	38.3	38.52	16064.0

> showing 50 of 836 rows — these rows as CSV

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