PREVIEW / etf_daily / 2011-02-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-02.parquet
  size:    35 KB
  rows:    820

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-02-02	SPY	ETF	130.4	130.84	130.33	130.49	118323600.0
2011-02-02	QQQ	ETF	56.92	57.17	56.84	56.955	48660951.0
2011-02-02	IWM	ETF	79.59	80.13	79.42	79.45	39937400.0
2011-02-02	DIA	ETF	119.89	120.32	119.89	120.1	4231200.0
2011-02-02	GLD	ETF	130.37	130.6	129.45	130.45	10082000.0
2011-02-02	TLT	ETF	90.9	91.0	89.9	90.47	13624600.0
2011-02-02	AADR	ETF	30.43	30.43	30.4	30.41	600.0
2011-02-02	AAXJ	ETF	62.6	62.82	62.34	62.46	574400.0
2011-02-02	ACWI	ETF	48.17	48.33	48.08	48.17	138000.0
2011-02-02	ACWX	ETF	45.28	45.4487	45.19	45.32	98769.0
2011-02-02	ADRE	ETF	47.25	47.59	47.02	47.04	41561.0
2011-02-02	AFK	ETF	33.42	33.74	33.2	33.2699	95010.0
2011-02-02	AGG	ETF	105.15	105.23	104.88	105.0	513000.0
2011-02-02	AGQ	ETF	262.6	268.16	259.0	263.4	305750.0
2011-02-02	AGZ	ETF	109.68	109.68	109.24	109.477	12097.0
2011-02-02	AIA	ETF	48.41	48.56	48.22	48.27	113662.0
2011-02-02	AIQ	ETF	21.6	21.705	21.0	21.1	7732.0
2011-02-02	AIS	ETF	1.59	1.62	1.59	1.6	223425.0
2011-02-02	AIVI	ETF	46.59	46.59	46.34	46.56	14800.0
2011-02-02	AMJ	ETF	37.65	37.73	37.503	37.68	807175.0
2011-02-02	AMLP	ETF	81.7	82.35	81.5	81.75	106120.0
2011-02-02	AOA	ETF	35.22	35.34	35.2	35.22	11500.0
2011-02-02	AOK	ETF	28.976	29.01	28.9359	28.9359	1479.0
2011-02-02	AOM	ETF	30.32	30.3473	30.25	30.2759	13592.0
2011-02-02	AOR	ETF	32.1	32.1801	32.08	32.12	11149.0
2011-02-02	ARB	ETF	43.71	44.95	43.65	44.15	228408.0
2011-02-02	BAB	ETF	25.0	25.0	24.77	24.78	170548.0
2011-02-02	BAL	ETF	88.56	90.77	88.4801	90.74	99604.0
2011-02-02	BALT	ETF	8.8	8.95	8.7	8.93	544319.0
2011-02-02	BBH	ETF	33.7933	34.2267	33.7933	34.2	8400.0
2011-02-02	BICK	ETF	31.97	32.04	31.67	31.71	28600.0
2011-02-02	BIL	ETF	91.7	91.72	91.7	91.7	283550.0
2011-02-02	BITS	ETF	28.08	28.36	27.8	28.12	325.0
2011-02-02	BIV	ETF	82.5	82.63	82.14	82.29	446200.0
2011-02-02	BJK	ETF	32.94	32.94	32.67	32.75	21900.0
2011-02-02	BKF	ETF	48.0	48.3591	47.69	47.89	179004.0
2011-02-02	BLV	ETF	77.51	77.74	77.0	77.21	23000.0
2011-02-02	BMVP	ETF	15.14	15.21	15.14	15.17	14707.0
2011-02-02	BND	ETF	80.03	80.06	79.79	79.87	810400.0
2011-02-02	BNO	ETF	33.93	34.195	33.825	34.16	92400.0
2011-02-02	BOSS	ETF	46.5	46.975	46.5	46.975	200.0
2011-02-02	BRF	ETF	53.81	53.91	52.65	52.72	296265.0
2011-02-02	BSCE	ETF	20.81	20.83	20.771	20.804	20348.0
2011-02-02	BSV	ETF	80.45	80.51	80.35	80.39	472600.0
2011-02-02	BTF	ETF	81.69999999999999	82.05	81.3005	81.99999999999999	12880.2
2011-02-02	BWX	ETF	29.95	29.95	29.5801	29.625	375648.0
2011-02-02	BWZ	ETF	40.96	40.96	37.77	37.77	11560.0
2011-02-02	BZQ	ETF	2566.4	2659.2	2540.8	2644.8	529.0
2011-02-02	CEF	ETF	19.15	19.19	18.96	19.12	695400.0
2011-02-02	CEW	ETF	22.4	22.485	22.39	22.45	107578.0

> showing 50 of 820 rows — these rows as CSV

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