PREVIEW / etf_daily / 2010-08-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-23.parquet
  size:    33 KB
  rows:    765

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-23	SPY	ETF	108.04	108.57	107.07	107.12	163490300.0
2010-08-23	QQQ	ETF	45.25	45.34	44.46	44.48	69612138.0
2010-08-23	IWM	ETF	61.6	61.92	60.28	60.32	55423700.0
2010-08-23	DIA	ETF	102.54	103.05	101.7	101.76	5552400.0
2010-08-23	GLD	ETF	119.91	120.07	119.42	119.78	4857800.0
2010-08-23	TLT	ETF	105.65	106.19	105.25	106.06	6360100.0
2010-08-23	AADR	ETF	25.33	25.33	25.33	25.33	200.0
2010-08-23	AAXJ	ETF	55.65	55.73	55.1	55.1	47800.0
2010-08-23	ACWI	ETF	40.23	40.31	39.83	39.83	329800.0
2010-08-23	ACWX	ETF	38.16	38.39	37.91	37.93	57846.0
2010-08-23	ADRE	ETF	42.17	42.17	41.48	41.53	147003.0
2010-08-23	AFK	ETF	30.4	30.4	30.1	30.23	3313.0
2010-08-23	AGG	ETF	108.31	108.41	108.2	108.41	479900.0
2010-08-23	AGQ	ETF	114.76	115.94	114.0	115.26	70850.0
2010-08-23	AGZ	ETF	111.13	111.19	111.02	111.17	25602.0
2010-08-23	AIA	ETF	39.58	39.58	39.21	39.2256	4989.0
2010-08-23	AIQ	ETF	23.6	23.8495	22.9	22.95	13277.0
2010-08-23	AIS	ETF	1.6	1.6	1.52	1.52	253003.0
2010-08-23	AIVI	ETF	39.44	39.71	39.31	39.34	9000.0
2010-08-23	AMJ	ETF	32.8	32.94	32.65	32.69	1052251.0
2010-08-23	AOA	ETF	29.5	29.55	29.23	29.23	2200.0
2010-08-23	AOK	ETF	27.7095	27.77	27.7095	27.7699	2668.0
2010-08-23	AOM	ETF	28.25	28.25	28.158	28.17	24852.0
2010-08-23	AOR	ETF	28.72	28.72	28.51	28.51	7805.0
2010-08-23	ARB	ETF	25.51	25.62	24.59	24.65	282376.0
2010-08-23	BAB	ETF	26.72	26.78	26.6	26.73	188072.0
2010-08-23	BAL	ETF	41.36	41.55	41.0	41.036	7545.0
2010-08-23	BALT	ETF	11.26	11.349	10.96	11.06	101029.0
2010-08-23	BBH	ETF	30.44	30.53	30.22	30.2433	181800.0
2010-08-23	BIB	ETF	5.6525	5.6525	5.4938	5.4938	16800.0
2010-08-23	BICK	ETF	28.88	28.89	28.5201	28.61	9109.0
2010-08-23	BIL	ETF	91.7	91.72	91.7	91.7	118600.0
2010-08-23	BIS	ETF	11259.2	11539.2	11259.2	11539.2	1.25
2010-08-23	BITS	ETF	24.84	25.72	24.16	24.52	875.0
2010-08-23	BIV	ETF	85.99	86.14	85.86	86.11	96300.0
2010-08-23	BJK	ETF	25.75	25.9	25.52	25.53	14900.0
2010-08-23	BKF	ETF	44.5	44.5	43.7	43.83	62047.0
2010-08-23	BLV	ETF	85.97	86.45	85.75	86.42	27700.0
2010-08-23	BMVP	ETF	12.2267	12.2411	12.14	12.15	10036.0
2010-08-23	BND	ETF	82.37	82.55	82.37	82.51	399200.0
2010-08-23	BNE	ETF	11.16	11.19	11.1	11.12	488952.0
2010-08-23	BNO	ETF	24.89	24.89	24.79	24.79	31200.0
2010-08-23	BRF	ETF	51.54	52.0	50.9201	50.98	295450.0
2010-08-23	BSCE	ETF	20.84	20.84	20.8205	20.8205	300.0
2010-08-23	BSV	ETF	81.59	81.61	81.52	81.61	280400.0
2010-08-23	BTF	ETF	69.19999999999999	69.85	69.14999999999999	69.25	5004.0
2010-08-23	BWX	ETF	28.485	28.995	28.45	28.45	191806.0
2010-08-23	BWZ	ETF	35.06	35.15	34.86	35.03	28751.0
2010-08-23	BZQ	ETF	3377.6	3544.0	3361.6	3544.0	762.5
2010-08-23	CEF	ETF	14.88	14.95	14.84	14.9	470300.0

> showing 50 of 765 rows — these rows as CSV

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