PREVIEW / etf_daily / 2010-08-31

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-31.parquet
  size:    33 KB
  rows:    775

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-31	SPY	ETF	104.92	105.98	104.49	105.31	273933100.0
2010-08-31	QQQ	ETF	43.39	43.85	43.18	43.46	72066825.0
2010-08-31	IWM	ETF	60.15	60.91	59.68	60.18	60625100.0
2010-08-31	DIA	ETF	99.89	100.85	99.52	100.2	10523400.0
2010-08-31	GLD	ETF	121.77	122.19	121.46	122.08	12249700.0
2010-08-31	TLT	ETF	108.22	108.65	107.62	108.56	8397000.0
2010-08-31	AADR	ETF	25.3	25.35	25.28	25.35	1100.0
2010-08-31	AAXJ	ETF	54.44	54.76	54.2	54.43	138000.0
2010-08-31	ACWI	ETF	39.26	39.59	39.06	39.35	148400.0
2010-08-31	ACWX	ETF	37.42	37.8201	37.36	37.54	49273.0
2010-08-31	ADRE	ETF	40.55	40.93	40.46	40.88	152942.0
2010-08-31	AFK	ETF	29.51	29.8499	29.33	29.63	30999.0
2010-08-31	AGG	ETF	108.85	108.99	108.74	108.94	737700.0
2010-08-31	AGQ	ETF	131.06	133.42	130.58	132.4	188700.0
2010-08-31	AGZ	ETF	111.38	111.6	111.265	111.6	32530.0
2010-08-31	AIA	ETF	38.55	38.6968	38.45	38.47	26499.0
2010-08-31	AIQ	ETF	21.55	21.9	20.85	21.0	23346.0
2010-08-31	AIS	ETF	1.49	1.5	1.42	1.45	599379.0
2010-08-31	AIVI	ETF	39.1	39.53	39.0	39.21	18300.0
2010-08-31	AMJ	ETF	31.95	31.99	31.64	31.84	2354695.0
2010-08-31	AMLP	ETF	75.0	75.15	74.4	74.75	68940.0
2010-08-31	AOA	ETF	28.72	29.05	28.72	28.8	22700.0
2010-08-31	AOK	ETF	27.73	27.78	27.7201	27.76	9562.0
2010-08-31	AOM	ETF	28.04	28.16	28.0205	28.06	16705.0
2010-08-31	AOR	ETF	28.38	28.4999	28.38	28.4712	17110.0
2010-08-31	ARB	ETF	25.1	25.87	25.03	25.44	226440.0
2010-08-31	BAB	ETF	27.0	27.0	26.8454	26.99	258882.0
2010-08-31	BAL	ETF	42.4634	42.719	42.16	42.26	6438.0
2010-08-31	BALT	ETF	11.09	11.28	11.02	11.18	123559.0
2010-08-31	BBH	ETF	29.89	30.0767	29.68	29.77	46200.0
2010-08-31	BIB	ETF	5.3525	5.3587	5.3525	5.3587	26400.0
2010-08-31	BICK	ETF	28.04	28.32	28.01	28.19	9120.0
2010-08-31	BIL	ETF	91.72	91.72	91.7	91.7	290200.0
2010-08-31	BIS	ETF	11876.8	11888.0	11876.8	11888.0	3.75
2010-08-31	BITS	ETF	23.76	24.84	23.76	24.64	4453.0
2010-08-31	BIV	ETF	86.55	86.57	86.33	86.5	132400.0
2010-08-31	BJK	ETF	25.51	25.65	25.2	25.31	13700.0
2010-08-31	BKF	ETF	42.89	43.46	42.76	43.08	198402.0
2010-08-31	BLV	ETF	87.63	87.63	87.0	87.54	159800.0
2010-08-31	BMVP	ETF	11.9	12.02	11.88	11.94	22696.0
2010-08-31	BND	ETF	82.81	82.92	82.8	82.89	553800.0
2010-08-31	BNE	ETF	11.1	11.12	11.05	11.07	506685.0
2010-08-31	BNO	ETF	25.755	25.84	25.1	25.1	70600.0
2010-08-31	BRF	ETF	51.22	51.91	51.13	51.51	218125.0
2010-08-31	BSCE	ETF	20.85	20.86	20.85	20.85	5300.0
2010-08-31	BSV	ETF	81.66	81.73	81.61	81.67	333800.0
2010-08-31	BTF	ETF	68.6	69.14999999999999	68.3	68.85	1813.8000000000002
2010-08-31	BWX	ETF	28.79	29.04	28.79	29.005	507130.0
2010-08-31	BWZ	ETF	35.0913	35.14	34.87	35.01	12460.0
2010-08-31	BZQ	ETF	3609.6	3616.0	3515.2	3560.0	899.0

> showing 50 of 775 rows — these rows as CSV

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