PREVIEW / etf_daily / 2010-08-05

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-05.parquet
  size:    33 KB
  rows:    768

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-08-05	SPY	ETF	112.25	112.91	112.08	112.85	140473800.0
2010-08-05	QQQ	ETF	46.72	46.92	46.52	46.83	39150159.0
2010-08-05	IWM	ETF	65.66	66.21	65.46	65.53	37991000.0
2010-08-05	DIA	ETF	106.43	106.88	106.23	106.88	3631700.0
2010-08-05	GLD	ETF	117.01	117.1	116.35	116.98	7023000.0
2010-08-05	TLT	ETF	99.34	99.49	98.84	99.02	3704200.0
2010-08-05	AADR	ETF	25.91	25.91	25.91	25.91	500.0
2010-08-05	AAXJ	ETF	56.63	57.06	56.63	56.98	391800.0
2010-08-05	ACWI	ETF	41.83	42.17	41.83	42.13	159900.0
2010-08-05	ACWX	ETF	39.95	40.05	39.77	40.03	38247.0
2010-08-05	ADRE	ETF	43.22	43.5299	43.22	43.5	204271.0
2010-08-05	AFK	ETF	31.51	31.51	31.0	31.44	15281.0
2010-08-05	AGG	ETF	107.43	107.49	107.28	107.42	972200.0
2010-08-05	AGQ	ETF	120.82	120.9	118.2	120.24	70900.0
2010-08-05	AGZ	ETF	110.73	110.73	110.53	110.55	36746.0
2010-08-05	AIA	ETF	40.59	40.64	40.35	40.64	30125.0
2010-08-05	AIQ	ETF	23.05	23.05	22.5	22.6	11580.0
2010-08-05	AIS	ETF	1.63	1.71	1.59	1.69	1160861.0
2010-08-05	AIVI	ETF	41.66	41.83	41.59	41.83	4800.0
2010-08-05	AMJ	ETF	33.65	33.85	33.56	33.84	1379179.0
2010-08-05	AOA	ETF	30.62	30.76	30.62	30.68	11900.0
2010-08-05	AOK	ETF	28.03	28.05	27.98	28.0295	10470.0
2010-08-05	AOM	ETF	28.72	28.73	28.654	28.73	14658.0
2010-08-05	AOR	ETF	29.43	29.479	29.41	29.464	4200.0
2010-08-05	ARB	ETF	29.16	29.42	28.35	28.41	213934.0
2010-08-05	BAB	ETF	26.04	26.2	26.04	26.13	338032.0
2010-08-05	BAL	ETF	39.13	39.7945	39.13	39.15	6297.0
2010-08-05	BALT	ETF	11.24	11.54	11.24	11.25	55019.0
2010-08-05	BBH	ETF	31.87	32.09	31.7733	31.92	88200.0
2010-08-05	BIB	ETF	5.9688	6.0027	5.9688	6.0027	2800.0
2010-08-05	BICK	ETF	29.88	29.88	29.37	29.55	35828.0
2010-08-05	BIL	ETF	91.68	91.72	91.68	91.68	500600.0
2010-08-05	BIS	ETF	10692.8	10793.6	10692.8	10750.4	8.1
2010-08-05	BITS	ETF	27.8	27.8	27.6	27.6	600.0
2010-08-05	BIV	ETF	84.56	84.62	84.4	84.62	222800.0
2010-08-05	BJK	ETF	25.93	26.01	25.85	25.85	3900.0
2010-08-05	BKF	ETF	45.5	45.79	45.39	45.71	98041.0
2010-08-05	BLV	ETF	82.55	82.64	82.21	82.48	100600.0
2010-08-05	BMVP	ETF	12.69	12.78	12.69	12.77	5960.0
2010-08-05	BND	ETF	81.75	81.8	81.68	81.79	753400.0
2010-08-05	BNE	ETF	11.23	11.28	11.17	11.17	239842.0
2010-08-05	BNO	ETF	27.66	27.66	27.66	27.66	2800.0
2010-08-05	BRF	ETF	50.44	50.65	50.17	50.56	280751.0
2010-08-05	BSCE	ETF	20.75	20.76	20.745	20.754	14097.0
2010-08-05	BSV	ETF	81.31	81.37	81.28	81.36	299500.0
2010-08-05	BTF	ETF	70.14999999999999	70.89999999999999	70.14999999999999	70.89999999999999	1085.4
2010-08-05	BWX	ETF	29.195	29.195	28.8625	29.075	262790.0
2010-08-05	BWZ	ETF	35.78	35.78	35.6355	35.652	5262.0
2010-08-05	BZQ	ETF	3260.8	3276.8	3225.6	3225.6	329.5
2010-08-05	CEF	ETF	14.73	14.73	14.6	14.68	539900.0

> showing 50 of 768 rows — these rows as CSV

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