PREVIEW / etf_daily / 2010-07-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-12.parquet
  size:    32 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-12	SPY	ETF	107.6	108.24	107.15	108.03	131283600.0
2010-07-12	QQQ	ETF	44.58	45.03	44.46	44.75	60934835.0
2010-07-12	IWM	ETF	62.76	63.18	61.62	62.23	43038300.0
2010-07-12	DIA	ETF	101.85	102.3	101.55	102.25	6613100.0
2010-07-12	GLD	ETF	117.83	118.2	116.97	117.34	7506700.0
2010-07-12	TLT	ETF	99.33	99.84	99.04	99.18	4062100.0
2010-07-12	AAXJ	ETF	55.06	55.11	54.58	54.84	635100.0
2010-07-12	ACWI	ETF	39.76	39.88	39.49	39.69	241400.0
2010-07-12	ACWX	ETF	37.42	37.466	37.15	37.35	73907.0
2010-07-12	ADRE	ETF	41.24	41.49	40.83	41.01	97131.0
2010-07-12	AFK	ETF	28.65	28.7	28.49	28.6	13689.0
2010-07-12	AGG	ETF	106.9	107.0	106.8	106.86	323500.0
2010-07-12	AGQ	ETF	116.86	117.68	113.72	116.26	101800.0
2010-07-12	AGZ	ETF	110.03	110.05	109.8808	109.98	8451.0
2010-07-12	AIA	ETF	38.72	38.72	38.43	38.62	12153.0
2010-07-12	AIQ	ETF	19.15	19.15	18.1	18.5	40314.0
2010-07-12	AIS	ETF	1.7401	1.75	1.63	1.65	362501.0
2010-07-12	AIVI	ETF	38.26	38.57	38.23	38.57	26600.0
2010-07-12	AMJ	ETF	32.0	32.5	31.75	31.965	1619466.0
2010-07-12	AOA	ETF	29.23	29.23	29.13	29.19	1200.0
2010-07-12	AOK	ETF	27.5228	27.58	27.49	27.56	14043.0
2010-07-12	AOM	ETF	27.9	28.02	27.9	28.0	17634.0
2010-07-12	AOR	ETF	28.47	28.48	28.4425	28.4595	763.0
2010-07-12	ARB	ETF	26.37	26.77	26.1305	26.32	112064.0
2010-07-12	BAB	ETF	25.8	25.84	25.7	25.726	122929.0
2010-07-12	BAL	ETF	36.08	36.09	35.84	35.84	2217.0
2010-07-12	BALT	ETF	10.47	10.59	10.19	10.24	141309.0
2010-07-12	BBH	ETF	29.6067	29.7767	29.5533	29.6133	168000.0
2010-07-12	BICK	ETF	27.95	28.11	27.81	28.11	10412.0
2010-07-12	BIL	ETF	91.72	91.72	91.7	91.72	979900.0
2010-07-12	BIS	ETF	12142.4	12395.2	12142.4	12395.2	1.54
2010-07-12	BITS	ETF	27.4404	29.0	27.4404	27.96	550.0
2010-07-12	BIV	ETF	83.3	83.46	83.23	83.28	274400.0
2010-07-12	BJK	ETF	23.67	23.67	23.43	23.59	9700.0
2010-07-12	BKF	ETF	43.42	43.42	42.7	43.17	101456.0
2010-07-12	BLV	ETF	80.95	81.37	80.85	80.87	47000.0
2010-07-12	BMVP	ETF	12.12	12.13	12.06	12.1	14831.0
2010-07-12	BND	ETF	81.14	81.21	81.06	81.12	425700.0
2010-07-12	BNE	ETF	11.27	11.31	11.27	11.29	277546.0
2010-07-12	BNO	ETF	25.41	25.41	25.12	25.315	95600.0
2010-07-12	BRF	ETF	46.32	46.4809	45.483	45.63	182625.0
2010-07-12	BSCE	ETF	20.43	20.43	20.41	20.427	4391.0
2010-07-12	BSV	ETF	80.93	80.93	80.86	80.91	281300.0
2010-07-12	BTF	ETF	67.94999999999999	68.2	67.82	68.15	1862.4
2010-07-12	BWX	ETF	27.44	27.44	27.255	27.275	211188.0
2010-07-12	BWZ	ETF	34.07	34.27	34.07	34.22	7236.0
2010-07-12	BZQ	ETF	3776.0	3912.0	3744.0	3878.4	1766.0
2010-07-12	CEF	ETF	14.76	14.83	14.65	14.76	676800.0
2010-07-12	CEW	ETF	21.47	21.57	21.47	21.539	119739.0
2010-07-12	CGO	ETF	12.98	13.09	12.98	13.09	8564.0

> showing 50 of 759 rows — these rows as CSV

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