PREVIEW / etf_daily / 2011-03-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-03.parquet
  size:    35 KB
  rows:    834

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-03	SPY	ETF	132.4	133.62	132.39	133.47	176480100.0
2011-03-03	QQQ	ETF	57.68	58.365	57.67	58.265	64249927.0
2011-03-03	IWM	ETF	81.77	83.02	81.03	82.8	78937600.0
2011-03-03	DIA	ETF	121.44	122.66	121.43	122.36	7297200.0
2011-03-03	GLD	ETF	138.81	139.13	137.57	138.09	16485000.0
2011-03-03	TLT	ETF	90.53	90.78	89.98	90.06	10607600.0
2011-03-03	AADR	ETF	30.63	30.63	30.63	30.63	100.0
2011-03-03	AAXJ	ETF	61.17	61.62	60.92	61.5	591300.0
2011-03-03	ACWI	ETF	48.68	49.15	48.63	49.12	285300.0
2011-03-03	ACWX	ETF	45.71	46.08	45.7	46.05	269395.0
2011-03-03	ADRE	ETF	47.27	47.64	47.2412	47.62	40080.0
2011-03-03	AFK	ETF	33.2	33.35	32.886	33.34	31137.0
2011-03-03	AGG	ETF	104.91	104.92	104.68	104.74	618700.0
2011-03-03	AGQ	ETF	384.42	387.86	368.18	379.2	840800.0
2011-03-03	AGZ	ETF	109.08	109.14	108.68	109.02	6058.0
2011-03-03	AIA	ETF	45.97	46.43	45.97	46.43	37483.0
2011-03-03	AIQ	ETF	20.55	20.55	20.3	20.4	27438.0
2011-03-03	AIS	ETF	1.53	1.59	1.53	1.58	269463.0
2011-03-03	AIVI	ETF	46.66	46.93	46.58	46.87	5700.0
2011-03-03	AMJ	ETF	38.13	38.22	38.07	38.11	309622.0
2011-03-03	AMLP	ETF	82.8	82.85	82.3	82.5	169700.0
2011-03-03	AOA	ETF	35.78	36.06	35.78	36.03	6800.0
2011-03-03	AOK	ETF	29.05	29.15	29.05	29.142	31207.0
2011-03-03	AOM	ETF	30.54	30.61	30.52	30.61	22660.0
2011-03-03	AOR	ETF	32.51	32.63	32.47	32.63	16673.0
2011-03-03	ARB	ETF	39.56	40.25	39.39	39.79	182071.0
2011-03-03	ARGT	ETF	30.3	30.44	30.2432	30.38	10780.0
2011-03-03	ASEA	ETF	15.22	15.35	15.21	15.35	49700.0
2011-03-03	BAB	ETF	25.1	25.1	24.9	24.95	292433.0
2011-03-03	BAL	ETF	106.07	108.49	104.76	108.08	122287.0
2011-03-03	BALT	ETF	9.12	9.519	9.06	9.29	188709.0
2011-03-03	BBH	ETF	33.92	34.41	33.92	34.38	33900.0
2011-03-03	BICK	ETF	31.44	31.9	31.44	31.9	21279.0
2011-03-03	BIL	ETF	91.72	91.72	91.7	91.7	139950.0
2011-03-03	BIS	ETF	7728.0	7731.2	7600.016	7628.8	136.0
2011-03-03	BITS	ETF	26.28	26.72	25.64	26.24	2625.0
2011-03-03	BIV	ETF	82.03	82.03	81.72	81.78	92800.0
2011-03-03	BJK	ETF	31.89	32.21	31.89	32.13	33100.0
2011-03-03	BKF	ETF	48.62	48.92	48.59	48.86	688899.0
2011-03-03	BKLN	ETF	25.09	25.18	25.07	25.13	1511059.0
2011-03-03	BLV	ETF	77.54	77.7	77.21	77.41	21400.0
2011-03-03	BMVP	ETF	15.52	15.6705	15.52	15.6633	3610.0
2011-03-03	BND	ETF	79.77	79.79	79.58	79.62	840700.0
2011-03-03	BNO	ETF	38.075	38.24	37.75	38.165	283800.0
2011-03-03	BRF	ETF	53.45	53.66	52.86	53.54	132215.0
2011-03-03	BSCE	ETF	20.82	20.82	20.782	20.82	13684.0
2011-03-03	BSV	ETF	80.22	80.22	80.09	80.09	1243500.0
2011-03-03	BTF	ETF	84.55	86.14999999999999	84.55	85.26249999999999	8595.0
2011-03-03	BWX	ETF	29.77	29.77	29.575	29.575	341888.0
2011-03-03	BWZ	ETF	37.6901	37.8	37.6901	37.8	24252.0

> showing 50 of 834 rows — these rows as CSV

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