PREVIEW / etf_daily / 2011-04-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-25.parquet
  size:    36 KB
  rows:    848

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-04-25	SPY	ETF	133.68	133.86	133.2	133.64	65757100.0
2011-04-25	QQQ	ETF	58.4	58.52	58.28	58.49	25376716.0
2011-04-25	IWM	ETF	84.37	84.53	83.77	84.34	23441400.0
2011-04-25	DIA	ETF	124.66	124.71	124.21	124.55	4441200.0
2011-04-25	GLD	ETF	147.57	147.58	146.42	146.87	15596400.0
2011-04-25	TLT	ETF	92.63	92.97	92.5	92.95	3626900.0
2011-04-25	AAXJ	ETF	64.86	64.9	64.35	64.56	277100.0
2011-04-25	ACWI	ETF	49.47	49.5	49.17	49.37	189800.0
2011-04-25	ACWX	ETF	46.71	46.81	46.47	46.56	74285.0
2011-04-25	ADRE	ETF	48.68	48.73	48.3164	48.49	36550.0
2011-04-25	AFK	ETF	33.57	33.77	33.501	33.77	13161.0
2011-04-25	AGG	ETF	105.75	105.92	105.7	105.82	541700.0
2011-04-25	AGQ	ETF	725.24	725.28	652.54	689.5	3433350.0
2011-04-25	AGZ	ETF	109.63	109.74	109.5619	109.64	9245.0
2011-04-25	AIA	ETF	49.13	49.18	48.8	48.9571	22812.0
2011-04-25	AIQ	ETF	23.25	23.7	22.9	23.0	18269.0
2011-04-25	AIS	ETF	1.63	1.64	1.61	1.63	185983.0
2011-04-25	AIVI	ETF	48.94	48.94	48.65	48.87	10200.0
2011-04-25	AMJ	ETF	38.6	38.76	38.57	38.75	518075.0
2011-04-25	AMLP	ETF	82.9	83.15	82.75	83.05	108480.0
2011-04-25	AOA	ETF	36.45	36.45	36.3	36.4	36600.0
2011-04-25	AOK	ETF	29.35	29.41	29.35	29.41	26176.0
2011-04-25	AOM	ETF	30.8	30.85	30.7746	30.842	26920.0
2011-04-25	AOR	ETF	32.98	32.99	32.82	32.87	145054.0
2011-04-25	ARB	ETF	36.92	36.94	36.56	36.92	84077.0
2011-04-25	ARGT	ETF	30.4	30.5	30.22	30.4	2400.0
2011-04-25	ASEA	ETF	16.53	16.53	16.48	16.48	5900.0
2011-04-25	BAB	ETF	25.6	25.66	25.57	25.65	121739.0
2011-04-25	BAL	ETF	93.25	93.48	91.56	91.835	480886.0
2011-04-25	BALT	ETF	8.06	8.16	8.0072	8.06	114013.0
2011-04-25	BBH	ETF	37.4133	37.6267	37.18	37.6267	80400.0
2011-04-25	BCM	ETF	52.95	52.95	50.17	50.33	11050.0
2011-04-25	BIB	ETF	9.3788	9.3875	9.2033	9.3163	36136.0
2011-04-25	BICK	ETF	35.41	35.58	35.07	35.18	9643.0
2011-04-25	BIL	ETF	91.72	91.72	91.7	91.7	103150.0
2011-04-25	BIS	ETF	6396.8	6396.8	6387.2	6387.2	2.19
2011-04-25	BITS	ETF	24.44	24.88	24.44	24.48	912.0
2011-04-25	BIV	ETF	82.53	82.83	82.49	82.79	200700.0
2011-04-25	BJK	ETF	34.95	34.95	34.75	34.77	2900.0
2011-04-25	BKF	ETF	51.23	51.39	50.79	51.1	72673.0
2011-04-25	BKLN	ETF	25.28	25.28	25.25	25.27	65200.0
2011-04-25	BLNG	ETF	50.89	51.17	50.5699	51.03	4000.0
2011-04-25	BLV	ETF	79.09	79.23	78.99	79.14	36200.0
2011-04-25	BMVP	ETF	15.8533	15.857	15.7867	15.8434	17911.0
2011-04-25	BND	ETF	80.46	80.54	80.41	80.49	719400.0
2011-04-25	BNO	ETF	41.35	41.35	40.835	41.115	43000.0
2011-04-25	BRF	ETF	59.75	59.89	59.0696	59.42	121129.0
2011-04-25	BSCE	ETF	21.0	21.05	21.0	21.0386	7127.0
2011-04-25	BSV	ETF	80.48	80.56	80.47	80.54	281100.0
2011-04-25	BTF	ETF	83.64999999999999	84.0	83.6	83.6	1110.0

> showing 50 of 848 rows — these rows as CSV

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