PREVIEW / etf_daily / 2010-07-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-28.parquet
  size:    33 KB
  rows:    759

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
2010-07-28	SPY	ETF	111.32	111.66	110.46	110.83	163056200.0
2010-07-28	QQQ	ETF	46.38	46.58	45.88	46.05	51988117.0
2010-07-28	IWM	ETF	66.13	66.43	64.78	65.15	59705100.0
2010-07-28	DIA	ETF	105.24	105.55	104.69	105.09	7157900.0
2010-07-28	GLD	ETF	113.48	113.93	113.08	113.78	16071500.0
2010-07-28	TLT	ETF	98.49	99.19	98.27	98.97	5507200.0
2010-07-28	AADR	ETF	25.25	25.29	25.12	25.2	4900.0
2010-07-28	AAXJ	ETF	56.11	56.22	55.83	55.89	284900.0
2010-07-28	ACWI	ETF	41.25	41.27	40.95	40.97	154000.0
2010-07-28	ACWX	ETF	38.77	38.94	38.62	38.72	26193.0
2010-07-28	ADRE	ETF	42.2	42.5	42.1	42.34	93072.0
2010-07-28	AFK	ETF	30.58	30.78	30.4801	30.5	3660.0
2010-07-28	AGG	ETF	107.37	107.61	107.36	107.57	495000.0
2010-07-28	AGQ	ETF	109.4	110.92	108.9	110.12	151350.0
2010-07-28	AGZ	ETF	110.44	110.585	110.274	110.54	31404.0
2010-07-28	AIA	ETF	39.68	39.84	39.4501	39.53	63633.0
2010-07-28	AIQ	ETF	18.8	19.2495	18.0	18.1	43567.0
2010-07-28	AIS	ETF	1.65	1.65	1.52	1.52	889388.0
2010-07-28	AIVI	ETF	40.23	40.34	40.12	40.22	10100.0
2010-07-28	AMJ	ETF	32.57	32.79	32.51	32.73	703008.0
2010-07-28	AOA	ETF	30.28	30.39	30.21	30.21	7600.0
2010-07-28	AOK	ETF	27.87	27.89	27.81	27.854	7262.0
2010-07-28	AOM	ETF	28.45	28.4699	28.3933	28.3933	2879.0
2010-07-28	AOR	ETF	29.11	29.16	29.08	29.08	3980.0
2010-07-28	ARB	ETF	30.5	30.82	29.22	29.49	236347.0
2010-07-28	BAB	ETF	25.82	25.97	25.79	25.93	167401.0
2010-07-28	BAL	ETF	37.57	37.57	37.47	37.5	5783.0
2010-07-28	BALT	ETF	11.39	11.39	11.16	11.27	60140.0
2010-07-28	BBH	ETF	31.1767	31.34	30.7733	30.86	178500.0
2010-07-28	BIB	ETF	5.6712	5.6756	5.4863	5.4863	35192.0
2010-07-28	BICK	ETF	28.9	29.02	28.7	28.83	7302.0
2010-07-28	BIL	ETF	91.68	91.7	91.68	91.7	118150.0
2010-07-28	BIS	ETF	11492.8	11766.4	11492.8	11766.4	12.55
2010-07-28	BITS	ETF	26.64	27.12	26.44	27.12	1546.0
2010-07-28	BIV	ETF	84.04	84.3	83.81	84.22	177800.0
2010-07-28	BJK	ETF	25.02	25.02	24.73	24.84	7700.0
2010-07-28	BKF	ETF	44.5	44.776	44.3005	44.65	46742.0
2010-07-28	BLV	ETF	82.31	82.31	81.64	82.08	187600.0
2010-07-28	BMVP	ETF	12.56	12.6	12.47	12.47	6441.0
2010-07-28	BND	ETF	81.45	81.67	81.45	81.64	513600.0
2010-07-28	BNE	ETF	11.34	11.35	11.28	11.28	527073.0
2010-07-28	BNO	ETF	25.735	25.735	25.65	25.65	6000.0
2010-07-28	BRF	ETF	48.17	48.56	47.5	48.04	262193.0
2010-07-28	BSCE	ETF	20.7	20.78	20.6799	20.78	87491.0
2010-07-28	BSV	ETF	81.13	81.24	81.07	81.24	289400.0
2010-07-28	BTF	ETF	70.25	70.65	70.0	70.0495	1503.6000000000001
2010-07-28	BWX	ETF	28.045	28.195	27.82	27.89	246292.0
2010-07-28	BWZ	ETF	35.05	35.22	35.01	35.0446	19076.0
2010-07-28	BZQ	ETF	3500.8	3500.8	3395.2	3457.6	749.5
2010-07-28	CEF	ETF	14.05	14.19	14.03	14.17	639700.0

> showing 50 of 759 rows — these rows as CSV

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