PREVIEW / etf_daily / 2011-04-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-08.parquet
  size:    36 KB
  rows:    840

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-08	SPY	ETF	133.91	133.99	132.31	132.86	147945400.0
2011-04-08	QQQ	ETF	57.48	57.57	56.65	56.95	42782112.0
2011-04-08	IWM	ETF	85.25	85.36	83.6	83.98	63650400.0
2011-04-08	DIA	ETF	124.29	124.35	123.05	123.65	6080300.0
2011-04-08	GLD	ETF	143.34	143.84	142.97	143.66	13128200.0
2011-04-08	TLT	ETF	89.93	90.32	89.85	89.88	7605700.0
2011-04-08	AADR	ETF	31.07	31.17	31.07	31.11	1000.0
2011-04-08	AAXJ	ETF	64.76	65.01	64.31	64.55	212600.0
2011-04-08	ACWI	ETF	49.3	49.5	48.9	49.05	287100.0
2011-04-08	ACWX	ETF	46.53	46.56	46.26	46.34	27259.0
2011-04-08	ADRE	ETF	49.78	49.78	49.25	49.47	76080.0
2011-04-08	AFK	ETF	34.54	34.7499	34.23	34.4	11801.0
2011-04-08	AGG	ETF	104.62	104.69	104.53	104.56	392900.0
2011-04-08	AGQ	ETF	512.3	527.48	507.0	526.32	791400.0
2011-04-08	AGZ	ETF	109.099	109.099	109.0	109.0	7476.0
2011-04-08	AIA	ETF	48.96	49.06	48.59	48.72	23393.0
2011-04-08	AIQ	ETF	22.05	22.2	21.4	21.4	6137.0
2011-04-08	AIS	ETF	1.75	1.76	1.6	1.68	1409151.0
2011-04-08	AIVI	ETF	48.38	48.53	48.19	48.33	27500.0
2011-04-08	AMJ	ETF	38.36	38.3897	38.0	38.135	475937.0
2011-04-08	AMLP	ETF	82.55	82.55	81.9	82.2	72180.0
2011-04-08	AOA	ETF	36.45	36.48	36.08	36.12	3300.0
2011-04-08	AOK	ETF	29.2	29.23	29.19	29.21	80565.0
2011-04-08	AOM	ETF	30.71	30.71	30.6	30.6	10079.0
2011-04-08	AOR	ETF	32.84	32.84	32.59	32.6592	9219.0
2011-04-08	ARB	ETF	39.08	39.08	37.85	37.94	62875.0
2011-04-08	ARGT	ETF	31.38	31.44	31.3	31.44	4000.0
2011-04-08	ASEA	ETF	16.39	16.39	16.21	16.25	9400.0
2011-04-08	BAB	ETF	25.1	25.157	25.06	25.14	181624.0
2011-04-08	BAL	ETF	109.06	109.31	104.0145	104.58	96952.0
2011-04-08	BALT	ETF	9.15	9.22	8.99	9.0	70907.0
2011-04-08	BBH	ETF	35.4767	35.5033	35.25	35.34	36000.0
2011-04-08	BIB	ETF	9.0388	9.0388	8.816	8.885	187416.0
2011-04-08	BICK	ETF	34.62	34.62	34.306	34.39	9963.0
2011-04-08	BIL	ETF	91.72	91.72	91.7	91.7	1310750.0
2011-04-08	BIS	ETF	6648.0	6648.0	6648.0	6648.0	0.655
2011-04-08	BITS	ETF	25.0	25.32	24.72	25.08	1275.0
2011-04-08	BIV	ETF	81.43	81.63	81.32	81.51	106400.0
2011-04-08	BJK	ETF	33.36	33.36	32.99	32.99	4800.0
2011-04-08	BKF	ETF	52.25	52.25	51.68	51.8	155406.0
2011-04-08	BKLN	ETF	25.3	25.31	25.26	25.29	158500.0
2011-04-08	BLV	ETF	77.16	77.42	77.16	77.17	27400.0
2011-04-08	BMVP	ETF	15.79	15.79	15.7	15.7	1117.0
2011-04-08	BND	ETF	79.56	79.67	79.54	79.62	687500.0
2011-04-08	BNO	ETF	41.265	42.055	41.1	42.055	117200.0
2011-04-08	BRF	ETF	59.16	59.184	58.61	58.61	170007.0
2011-04-08	BSCE	ETF	20.87	20.92	20.84	20.8976	42584.0
2011-04-08	BSV	ETF	80.0	80.06	79.95	80.03	257100.0
2011-04-08	BTF	ETF	82.85	83.24949999999998	82.7585	82.824	3171.4
2011-04-08	BWX	ETF	29.955	30.045	29.885	29.99	738910.0

> showing 50 of 840 rows — these rows as CSV

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